Question: Consider the following Python dictionary data and Python list labels: data = { ' animal ' : [ ' cat ' , 'cat', 'snake', 'dog',
Consider the following Python dictionary data and Python list labels:
data animal: cat 'cat', 'snake', 'dog', 'dog', 'cat', 'snake', 'cat', 'dog', 'dog'
'age': npnan, npnan,
'visits':
'priority': yes 'yes', no 'yes', nonono 'yes', nono
labels abcdefghij
Calculate the mean age for each different animal in df
Append a new row k to df with your choice of values for each column. Then delete that row to return the original DataFrame.
Count the number of each type of animal in df
Sort df first by the values in the 'age' in decending order, then by the value in the 'visits' column in ascending order so row i should be first, and row d should be last
For each animal type and each number of visits, find the mean age. In other words, each row is an animal, each column is a number of visits and the values are the mean ages hint: use a pivot table
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
