Numerical Computing with Python

How to do it...

1. Read in the men's weightlifting dataset, and identify the variables:

>>> weightlifting = pd.read_csv('data/weightlifting_men.csv')>>> weightlifting

2. The variables are the weight category, sex/age category, and the qualifying total. The age and sex variables have been concatenated together into a single cell. Before we can separate them, let's use the melt method to transpose the age and sex column names into a single vertical column:

>>> wl_melt = weightlifting.melt(id_vars='Weight Category',                                  var_name='sex_age',                                  value_name='Qual Total')>>> wl_melt.head()

3. Select the sex_age column, and use the split method available from ...