Grokking Data Science

Exercises: Pandas

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”.