- Read in the men's weightlifting dataset, and identify the variables:
>>> weightlifting = pd.read_csv('data/weightlifting_men.csv')>>> weightlifting
- 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()
- Select the sex_age column, and use the split method available from ...
