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 [ ]:
Content source: CivicKnowledge/metatab-packages
Similar notebooks: