In [1]:
import metatab as mt
import pandas as pd

df = pd.read_csv('https://data.lacounty.gov/api/views/8rdv-6nb6/rows.csv?accessType=DOWNLOAD')

In [2]:
df.iloc[:5].T


Out[2]:
0 1 2 3 4
Year 2013 2013 2013 2013 2013
Employee Last Name ABDEL-FATAH ABHARIAN ACEVEDO ACLAN ADA
Employee First Name IBRAHIM FAKHRI IGNACIO ELVIRA ERINEO
Middle Initial M H M C L
Position Title AGRICULTURAL/WEIGHTS & MEASURES INSPECTOR III AGRICULTURAL/WEIGHTS & MEASURES INSPECTOR II AGRICULTURAL INSPECTOR AID AGRICULTURAL/WEIGHTS & MEASURES INSPECTOR II AGRICULTURAL/WEIGHTS & MEASURES INSPECTOR II
Department Agric Comm/Wts & Measures Agric Comm/Wts & Measures Agric Comm/Wts & Measures Agric Comm/Wts & Measures Agric Comm/Wts & Measures
Base Earnings $68167.65 $58991.54 $30747.79 $61780.62 $61780.62
Overtime Earnings $12323.27 $6298.07 $1511.10 $0.00 $0.00
Other Earnings $2367.37 $942.01 $1484.30 $1304.12 $991.80
Leave Time Payouts $1560.56 $0.00 $0.00 $1414.32 $0.00
Total Earnings $84418.85 $66231.62 $33743.19 $64499.06 $62772.42
Medical, Dental, Vision $16595.76 $15229.92 $16533.24 $17643.24 $7698.36
Retirement Surcharge $0.00 $0.00 $0.00 $0.00 $0.00
Pension Contributions $11458.97 $9776.82 $5087.88 $10867.49 $10159.08
Deferred Contributions $2358.99 $2043.94 $0.00 $1535.14 $2137.99
LTD Life & Medical Tax $1720.30 $1520.18 $842.36 $1183.91 $1044.71
Other Benefits $75.00 $51.00 $111.00 $66.00 $36.00
Total Benefits $32209.02 $28621.86 $22574.48 $31295.78 $21076.14
Total Compensation $116627.87 $94853.48 $56317.67 $95794.84 $83848.56
index NaN NaN NaN NaN NaN
ID Number NaN NaN NaN NaN NaN
position type NaN NaN NaN NaN NaN
Employee Name IBRAHIM ABDEL-FATAH FAKHRI ABHARIAN IGNACIO ACEVEDO ELVIRA ACLAN ERINEO ADA

In [ ]: