Weekly exercise 7: Simple Pandas exercises¶

In this exercise you will analyze some data on occupations.

In [ ]:

import pandas as pd

Task 1¶

Import the data from https://raw.githubusercontent.com/justmarkham/DAT8/master/data/u.user
Assign it to a variable called users
Output the number of variables and the number of observations
List the variables
To take a first look at the data output the first 15 observations

In [ ]:

# write your code here

Compute the mean age per occupation

In [ ]:

# write your code here

Compute the female ratio per occupation and sort it from the most to the least

Hint: write a function and use apply method to convert M/F symbols to integers, if needed.

In [ ]:

# write your code here

For each occupation, calculate the minimum and maximum ages

In [ ]:

# write your code here

For each combination of occupation and gender, calculate the mean age

In [ ]:

# write your code here

For each occupation present the percentage of women and men

Hint: you may find useful functions agg() and div()

In [ ]:

# write your code here

Special thanks to https://github.com/justmarkham for sharing the dataset and materials.