Numerical Computing with Python

How to do it...

1. Read in the college scoreboard dataset with the institution name as the index. Pass a college name and column name to .loc in order to select a scalar value:

>>> college = pd.read_csv('data/college.csv', index_col='INSTNM')>>> cn = 'Texas A & M University-College Station'>>> college.loc[cn, 'UGDS_WHITE'].661

2. Achieve the same result with .at:

>>> college.at[cn, 'UGDS_WHITE'].661

3. Use the %timeit magic command to find the difference in speed:

>>> %timeit college.loc[cn, 'UGDS_WHITE']8.97 µs ± 617 ns per loop (mean ± std. dev. of 7 runs, 100000 loops each)>>> %timeit college.at[cn, 'UGDS_WHITE']6.28 µs ± 214 ns per loop (mean ± std. dev. of 7 runs, 100000 loops each)

4. Find the integer locations of the preceding selections ...