Numerical Computing with Python

How to do it...

1. Read in the college dataset with the institution name as the index, and with only the undergraduate race columns:

>>> usecol_func = lambda x: 'UGDS_' in x or x == 'INSTNM'>>> college = pd.read_csv('data/college.csv',                           index_col='INSTNM',                           usecols=usecol_func)>>> college.head()

2. Use the stack method to convert each horizontal column name into a vertical index level:

>>> college_stacked = college.stack()>>> college_stacked.head(18)INSTNM Alabama A & M University UGDS_WHITE 0.0333 UGDS_BLACK 0.9353 UGDS_HISP 0.0055 UGDS_ASIAN 0.0019 UGDS_AIAN 0.0024 UGDS_NHPI 0.0019 UGDS_2MOR 0.0000 UGDS_NRA 0.0059 UGDS_UNKN 0.0138 University ...