Grokking Data Science

Exercises: Pandas

Explore practical Pandas exercises to test your skills in creating and manipulating DataFrames. Learn to select columns and rows, filter data by conditions, and perform grouping operations using real data, building a solid foundation in Python for data science.

We'll cover the following...

- Time to Test Your Skills!
- - - Q1. Create a DataFrame from the given dictionary data and index labels and store it in the variable called “df”.
- - - Q2. a) Select the column labelled “Listeners” and store it in the variable called “col”. b) Select the first row and store it in the variable called “row”.
- - - Q3. Select all the rows where the Genre is ‘Pop’ and store the result in the variable “pop_artists”.
- - - Q4. Select the artists who have more than 2,000,000 listeners and whose Genre is ‘Pop’ and save the output in the variable called “top_pop”.
- - - Q5. Perform a grouping by Genre using sum() as the aggregation function and store the results in the variable called “grouped”.