December 2018
Beginner to intermediate
682 pages
18h 1m
English
Content preview from Numerical Computing with Python
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
How to do it...
- 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 ...