KEMBAR78
100 Pandas Exercises | PDF | Computing | Data Management
Scribd
Upload
677 views6 pages

100 Pandas Exercises

This document presents a collection of 100 exercises for working with pandas, ranging from basic tasks like importing pandas and reading data files to more advanced operations like merging dataframes, filtering, grouping, and plotting. The exercises are presented as questions with annotated difficulty levels and include sample code solutions. The goal of the collection is to offer a quick reference and learning exercises for both new and experienced pandas users.

Uploaded by

Arpit Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
677 views6 pages

100 Pandas Exercises

This document presents a collection of 100 exercises for working with pandas, ranging from basic tasks like importing pandas and reading data files to more advanced operations like merging dataframes, filtering, grouping, and plotting. The exercises are presented as questions with annotated difficulty levels and include sample code solutions. The goal of the collection is to offer a quick reference and learning exercises for both new and experienced pandas users.

Uploaded by

Arpit Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 6

paper: 297 x 210 mm, cards: 91 x 59 mm

(Not yet) 100 pandas exercises Question: Question:


This is a collection of exercises that have been 1. Import the pandas package under 2. Print the pandas version and a
collected by condensing various sources like project
source code and the available documentation on the name `pd` (★☆☆) versions list of all package
pandas. The goal of this collection is to offer a quick dependancies of pandas (★☆☆)
reference for both old and new users but also to
provide a set of exercices for those who teach.
If you want to suggest another exercise or find an
error or think you've a better way to solve some of
them, feel free to open an issue or pull request at
https://github.com/deeplook/pandas-100

Question: Question: Question:

3. Read a HTML table on a webpage 50. Read a CSV file into a dataframe 51. Create a new column in a data
like http://www.lenntech.com/periodi like the tables on https://www.ssa.go frame with the same value in all
c-chart-elements/melting-point.htm v/oact/babynames/limits.html rows (★☆☆)
into a dataframe (★☆☆) (★☆☆)

Question: Question: Question:

52. Merge a list of dataframes into 53. Filter by one column (★★☆) 54. Select one column of a
one (★★☆) dataframe (★☆☆)
paper: 297 x 210 mm, cards: 91 x 59 mm

Answer 2: Answer 1:

print(pd.__version__) import pandas as pd


pd.show_versions()

Answer 5: Answer 4: Answer 3:

df['year'] = 2017 df = pd.read_csv(fn, names=['name', 'gender', basic = 'http://www.lenntech.com'


'count']) path = '/periodic-chart-elements/melting-point.htm'
df = pd.read_html(basic + path)

Answer 8: Answer 7: Answer 6:

names = df['name'] girls = df[df['gender'] == 'F'] df_list = [df1, df2, df3]


df = pd.concat(df_list)
paper: 297 x 210 mm, cards: 91 x 59 mm

Question: Question: Question:

55. Select two columns of a 56. Use a column as index (★★☆) 57. Select every 20th entry of a
dataframe (★★☆) dataframe (★☆☆)

Question: Question: Question:

58. Show summary of a dataframe 59. Show all values in one column 70. Turn a column to upper case
(★☆☆) and how often they occur (★☆☆) (★★☆)

Question: Question: Question:

71. Sum up values of one column 72. TODO melt a dataframe?? 73. Remove column from a
grouped by another (★★☆) (★★☆) dataframe CHECK (★☆☆)
paper: 297 x 210 mm, cards: 91 x 59 mm

Answer 11: Answer 10: Answer 9:

df = df[::20] by_year = df.set_index('year') names = df[['name', 'year']]

Answer 14: Answer 13: Answer 12:

def upper(s): return s.upper() df.values_counts() df.describe()

up = df['name'].apply(upper)

Answer 17: Answer 16: Answer 15:

df.drop('name') pd.melt groups = names.groupby('name')['count'].apply(sum)


paper: 297 x 210 mm, cards: 91 x 59 mm

Question: Question:

80. Plot a dataframe (★★★) 99. //Add your suggested question


including rating here// (★☆☆)
paper: 297 x 210 mm, cards: 91 x 59 mm

Answer 19: Answer 18:

# Author: import matplotlib.pyplot as plt


madonna = df[df['name'] == 'Madonna']
# your code... madonna = madonna.set_index('year')
madonna.plot()
plt.show()

You might also like