{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Using Pandas (and IPython/Jupyter Notebooks)!" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "One of the things I like most about IPython notebooks is the amazing accesability of documentation. If you hit the tab key while typing, a great autocompletion window comes up. If you pause once the word you are typing is complete, you receive documentation on the finction in a popup window. In newer versions it seems the same functionality is acheived by hitting shift then tab instead of tab. Hitting the tab key gives even more documentation in the popup window, and hitting it once more will give all the documentation on the word you have typed in a window below the current input cell. Another great feature is the re-evaluatable cell, which is great for making mistakes and learning from them. It allows you to type something, view the output immediately, and rapidly and iteratively change the input until you finally get the desired output (if you make tons of small mistakes like me). The built in documentation features, in combination with re-evaluatable cells are extremely helpful when using a new tool or library (like Pandas)." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Code written using the Pandas Library, when compared to Python Lists or similar native container data types, is much more compact and often times can avoid loops in places where Python can't (at least in pretty or compact ways).\n", "Some of the most useful methods include reading csv files readcsv() and excel files, plotting .plot(), statistics .median(), bar graphs, slicing by columns, conditional returning of data (like SQL query), adding new columns, groupby and aggregate (like SQL versions)." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#What can you do with this tool? " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Pandas is a Python library for data exploration, manipulation, and analysis. Primarily it includes data tables and time series data structures, along with methods for manipulating them. Dataframes are the central objects in the library, which are similar to excel spreadsheets. Pandas was inspired largely by a statistical programming language called R, and maintains many of the basic data structures and methods included in R, such as data frames. The creators of Pandas are Financial Data Analysts. One of the reasons some prefer Pandas to R is the fact you're coding in Python. Another reason is that it interfaces very well with other great python packages (matplotlib, numpy, etc...); in many cases you can just drop a Pandas dataframe into your favorite matplotlib or numpy functions and get the desired behavior, which is great! It's alwo quite fast on many tasks, as it uses numpy for many basic dataframe methods. Dataframe's ability to handle missing data makes it an invaluable tool when dealing with any kind of data. " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#Getting Started" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Here are some resources for getting started:\n", "\n", "Using pip or anaconda to install pandas is the safest/best way to get started:\n", "\n", "http://pandas.pydata.org/pandas-docs/stable/install.html\n", "\n", " Pandas Website:\n", "\n", "http://pandas.pydata.org/\n", "\n", "Quick Pandas tutorial video:\n", "\n", "https://vimeo.com/59324550\n", "\n", "Julia Evans PyCon Pandas Tutorial for Data Analysis:\n", "\n", "https://www.youtube.com/watch?v=rEalbu8UGeo\n", "\n", " \n", "\n", "Tons of IPython Notebooks:\n", "\n", "http://nbviewer.ipython.org/github/twiecki/financial-analysis-python-tutorial/blob/master/1.%20Pandas%20Basics.ipynb\n", "\n", "http://nbviewer.ipython.org/github/jvns/talks/blob/master/pyconca2013/pistes-cyclables.ipynb\n", "\n", "http://nbviewer.ipython.org/gist/fonnesbeck/5850375\n", "\n", "https://github.com/ipython/ipython/wiki/A-gallery-of-interesting-IPython-Notebooks#pandas-for-data-analysis\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "It is very easy to read data (CSV, Excel, SQL, JSON, etc...) into a pandas dataframe and get started exploring. I'm going to do this for this City of Boston employee earnings dataset: https://data.cityofboston.gov/City-Services/Closed-Pothole-Cases/wivc-syw7" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NAMETITLEDEPARTMENT NAMEREGULARRETROOTHEROVERTIMEINJUREDDETAILQUINNTOTAL EARNINGSZIP
0 Adario,Anthony J Supvising Claims Agent (Asd) ASD Human Resources $98538.32 $0.00 $1842.87 $0.00 $0.00 $0.00 $0.00 $100381.19 02132
1 Baker,Katherine E. Nurse Case Manager ASD Human Resources $83942.21 $0.00 $225.00 $0.00 $0.00 $0.00 $0.00 $84167.21 02136
2 Braga,Ann Hess HumanResourcesComplianceOffcr ASD Human Resources $98538.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $98538.34 02126
3 Calobrisi,Jane Ellen Personnel Analyst ASD Human Resources $70073.81 $0.00 $225.00 $0.00 $0.00 $0.00 $0.00 $70298.81 02090
4 Castillo-Cook,Wendolyn M. Alcholism Coord I ASD Human Resources $79253.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $79253.11 02121
5 Curran,Liam Patrick Asst Corp Counsel III ASD Human Resources $69266.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69266.69 02122
6 De Jesus,Winnie Yam Affirm Action Monitor ASD Human Resources $42061.21 $0.00 $487.21 $0.00 $0.00 $0.00 $0.00 $42548.42 02458
7 Donnelly,Jennifer P. Prin Clerk ASD Human Resources $44080.61 $0.00 $300.00 $0.00 $0.00 $0.00 $0.00 $44380.61 02129
8 Donovan,Carol Anne Prin Admin Analyst ASD Human Resources $73547.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $73547.25 02127
9 Donovan,John J Exec Asst (EAP/OHR) ASD Human Resources $15019.39 $0.00 $10250.05 $0.00 $0.00 $0.00 $0.00 $25269.44 02132
10 Ettingoff,Kimberly Intern I ASD Human Resources $4960.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4960.00 02144
11 Figueroa Ortiz,Irene Intern I ASD Human Resources $4960.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4960.00 02138
12 Firicano,Frank P. Sr Admin Asst (OHR) ASD Human Resources $91743.12 $0.00 $225.00 $0.00 $0.00 $0.00 $0.00 $91968.12 02189
13 Flemming,Teresia K Head Account Clerk ASD Human Resources $47455.39 $0.00 $856.78 $0.00 $0.00 $0.00 $0.00 $48312.17 02128
14 Gee,Xing-Bing Data Proc Sys Analyst ASD Human Resources $76393.46 $0.00 $3082.44 $0.00 $0.00 $0.00 $0.00 $79475.90 02130
15 Grant,Michael Scott Sr Data Proc Sys Anl ASD Human Resources $106594.16 $0.00 $2620.06 $0.00 $0.00 $0.00 $0.00 $109214.22 02136
16 Green,Allison Camille Intern I ASD Human Resources $4960.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4960.00 02143
17 Green,Kathleen M Health Insurance Coordinator ASD Human Resources $91938.06 $0.00 $4765.38 $0.00 $0.00 $0.00 $0.00 $96703.44 02129
18 Guante,Celiana Admin Asst ASD Human Resources $23934.49 $0.00 $998.34 $0.00 $0.00 $0.00 $0.00 $24932.83 02121
19 Hanson,Sheila A Head Clerk ASD Human Resources $42311.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42311.33 02136
20 Jackson-Rodgers,Jacqueline N. Sr Admin Asst (OHR) ASD Human Resources $91744.59 $0.00 $627.00 $0.00 $0.00 $0.00 $0.00 $92371.59 02126
21 Kessler,William Asst Dir (Human Resources) ASD Human Resources $117411.06 $0.00 $4391.66 $0.00 $0.00 $0.00 $0.00 $121802.72 02132
22 Killarney,Bernard Director of Operations ASD Human Resources $9608.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9608.45 02136
23 Lanchester,Diane Office Manager ASD Human Resources $65169.15 $0.00 $787.25 $0.00 $0.00 $0.00 $0.00 $65956.40 02131
24 Lee,Winnie Sr Admin Asst ASD Human Resources $76393.49 $0.00 $1653.72 $0.00 $0.00 $0.00 $0.00 $78047.21 02170
25 Leonard,Vivian Supv of Personnel ASD Human Resources $115982.88 $0.00 $2230.44 $0.00 $0.00 $0.00 $0.00 $118213.32 02136
26 Marshall,Leah A. Human Resources Representative ASD Human Resources $46423.61 $0.00 $300.00 $0.00 $0.00 $0.00 $0.00 $46723.61 02126
27 McNeil,Jean M Supv-Management Svcs ASD Human Resources $71139.91 $0.00 $865.37 $0.00 $0.00 $0.00 $0.00 $72005.28 02136
28 Melle,Laura Intern I ASD Human Resources $5580.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5580.00 02139
29 Morant,Darius Prin Clerk ASD Human Resources $5710.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5710.80 02119
.......................................
22203 Wilson,Jeffrey Fire Fighter-AdvanceTechnician Boston Fire Department $88662.18 $12890.60 $550.00 $12730.82 $6633.81 $128.00 $0.00 $121595.41 02136
22204 Wilson,Keith Michael Fire Fighter Boston Fire Department $53235.90 $2999.38 $550.00 $5352.20 $0.00 $0.00 $0.00 $62137.48 02132
22205 Wilson,Marlon Fire Fighter Boston Fire Department $88461.02 $13602.82 $550.00 $13775.17 $4855.79 $8326.75 $0.00 $129571.55 02136
22206 Wilson,Ryan Jon Fire Fighter Boston Fire Department $21364.38 $0.00 $275.00 $0.00 $0.00 $0.00 $0.00 $21639.38 02132
22207 Wilson,Sean E Fire Fighter Boston Fire Department $78538.07 $7593.22 $550.00 $6989.46 $49.23 $8462.25 $0.00 $102182.23 02136
22208 Wilson,Wayne A Fire Fighter Boston Fire Department $96178.88 $10010.18 $2157.24 $24629.94 $4337.00 $561.00 $0.00 $137874.24 02026
22209 Wirtz,Eric M Fire Fighter Boston Fire Department $71911.66 $7198.69 $550.00 $3892.15 $7678.90 $0.00 $0.00 $91231.40 02122
22210 Wong,Connie S Dep Comm-Labor & Legal Boston Fire Department $28750.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28750.02 02111
22211 Wong,Robert Fire Fighter Boston Fire Department $15670.19 $8210.82 $11065.36 $2127.66 $84109.32 $0.00 $0.00 $121183.35 02118
22212 Wong,William Asst Prin accountant Boston Fire Department $39974.95 $0.00 $747.72 $38029.14 $0.00 $0.00 $0.00 $78751.81 02132
22213 Woodbury,Dennis A Fire Fighter Boston Fire Department $96764.06 $14814.32 $2157.24 $21890.55 $718.99 $2401.50 $0.00 $138746.66 02124
22214 Woods,Patrick J Fire Lieutenant Boston Fire Department $110597.16 $16537.28 $2451.66 $18038.47 $0.00 $0.00 $0.00 $147624.57 02129
22215 Wornum,Dwight H Fire Fighter Boston Fire Department $149.99 $6261.44 $3063.63 $0.00 $100310.76 $0.00 $0.00 $109785.82 02136
22216 Wornum,John W FF (FPDInspLevl1Certification) Boston Fire Department $98109.51 $13524.14 $6243.64 $4866.68 $0.00 $0.00 $0.00 $122743.97 02121
22217 Wornum,Phillip B. FF LEP Title 3 Inspector - ADR Boston Fire Department $1195.32 $1188.70 $85430.84 $0.00 $103564.81 $0.00 $0.00 $191379.67 02186
22218 Worrell,David E Fire Fighter Boston Fire Department $0.00 $1013.60 $0.00 $0.00 $1425.72 $0.00 $0.00 $2439.32 02121
22219 Wosny,Joseph Andrew Fire Fighter Boston Fire Department $21364.38 $0.00 $275.00 $0.00 $0.00 $0.00 $0.00 $21639.38 02132
22220 Wright,Alexander E Fire Fighter-Technician Boston Fire Department $94499.10 $14911.41 $2151.24 $19095.59 $0.00 $5132.75 $0.00 $135790.09 02072
22221 Wright,Ballin L Fire Fighter-AdvanceTechnician Boston Fire Department $84536.18 $14204.17 $3721.05 $18540.90 $13082.71 $1488.00 $0.00 $135573.01 02125
22222 Wright,Christopher D Fire Fighter-Technician Boston Fire Department $93427.63 $14077.81 $550.00 $17740.79 $448.65 $0.00 $0.00 $126244.88 02132
22223 Wright,James Fire Fighter Boston Fire Department $0.00 $6499.01 $0.00 $0.00 $0.00 $0.00 $0.00 $6499.01 02368
22224 Wuschke,Barbara Fire Alarm Operator Boston Fire Department $95154.82 $13596.87 $550.00 $9325.59 $0.00 $0.00 $0.00 $118627.28 02124
22225 Wyman,George L District Fire Chief Tech-ADR Boston Fire Department $0.00 $3699.29 $0.00 $0.00 $2845.81 $0.00 $0.00 $6545.10 02360
22226 Wyzard,Keith T Fire Fighter Boston Fire Department $94460.92 $14055.44 $1466.23 $11700.05 $0.00 $0.00 $0.00 $121682.64 02368
22227 Yanosick,Justin Timothy Fire Fighter Boston Fire Department $92646.90 $14250.84 $550.00 $28269.86 $0.00 $0.00 $0.00 $135717.60 02132
22228 Yee,Jacob Fire Fighter Boston Fire Department $80073.63 $13529.71 $550.00 $15560.09 $13353.47 $7245.75 $0.00 $130312.65 02136
22229 Yetman,Patrick Fire Fighter Boston Fire Department $69886.18 $5191.64 $550.00 $8227.25 $0.00 $0.00 $0.00 $83855.07 02127
22230 Young,Allan M Fire Fighter Boston Fire Department $97234.17 $14091.91 $3050.00 $6193.76 $0.00 $4464.00 $0.00 $125033.84 02136
22231 Young,Michael L Fire Fighter Boston Fire Department $95694.84 $13973.38 $550.00 $10678.12 $0.00 $132.00 $0.00 $121028.34 02121
22232 Zagami,Anthony J Fire Alarm Operator Boston Fire Department $0.00 $5494.93 $0.00 $0.00 $0.00 $0.00 $0.00 $5494.93 02124
\n", "

22233 rows × 12 columns

\n", "
" ], "text/plain": [ " NAME TITLE \\\n", "0 Adario,Anthony J Supvising Claims Agent (Asd) \n", "1 Baker,Katherine E. Nurse Case Manager \n", "2 Braga,Ann Hess HumanResourcesComplianceOffcr \n", "3 Calobrisi,Jane Ellen Personnel Analyst \n", "4 Castillo-Cook,Wendolyn M. Alcholism Coord I \n", "5 Curran,Liam Patrick Asst Corp Counsel III \n", "6 De Jesus,Winnie Yam Affirm Action Monitor \n", "7 Donnelly,Jennifer P. Prin Clerk \n", "8 Donovan,Carol Anne Prin Admin Analyst \n", "9 Donovan,John J Exec Asst (EAP/OHR) \n", "10 Ettingoff,Kimberly Intern I \n", "11 Figueroa Ortiz,Irene Intern I \n", "12 Firicano,Frank P. Sr Admin Asst (OHR) \n", "13 Flemming,Teresia K Head Account Clerk \n", "14 Gee,Xing-Bing Data Proc Sys Analyst \n", "15 Grant,Michael Scott Sr Data Proc Sys Anl \n", "16 Green,Allison Camille Intern I \n", "17 Green,Kathleen M Health Insurance Coordinator \n", "18 Guante,Celiana Admin Asst \n", "19 Hanson,Sheila A Head Clerk \n", "20 Jackson-Rodgers,Jacqueline N. Sr Admin Asst (OHR) \n", "21 Kessler,William Asst Dir (Human Resources) \n", "22 Killarney,Bernard Director of Operations \n", "23 Lanchester,Diane Office Manager \n", "24 Lee,Winnie Sr Admin Asst \n", "25 Leonard,Vivian Supv of Personnel \n", "26 Marshall,Leah A. Human Resources Representative \n", "27 McNeil,Jean M Supv-Management Svcs \n", "28 Melle,Laura Intern I \n", "29 Morant,Darius Prin Clerk \n", "... ... ... \n", "22203 Wilson,Jeffrey Fire Fighter-AdvanceTechnician \n", "22204 Wilson,Keith Michael Fire Fighter \n", "22205 Wilson,Marlon Fire Fighter \n", "22206 Wilson,Ryan Jon Fire Fighter \n", "22207 Wilson,Sean E Fire Fighter \n", "22208 Wilson,Wayne A Fire Fighter \n", "22209 Wirtz,Eric M Fire Fighter \n", "22210 Wong,Connie S Dep Comm-Labor & Legal \n", "22211 Wong,Robert Fire Fighter \n", "22212 Wong,William Asst Prin accountant \n", "22213 Woodbury,Dennis A Fire Fighter \n", "22214 Woods,Patrick J Fire Lieutenant \n", "22215 Wornum,Dwight H Fire Fighter \n", "22216 Wornum,John W FF (FPDInspLevl1Certification) \n", "22217 Wornum,Phillip B. FF LEP Title 3 Inspector - ADR \n", "22218 Worrell,David E Fire Fighter \n", "22219 Wosny,Joseph Andrew Fire Fighter \n", "22220 Wright,Alexander E Fire Fighter-Technician \n", "22221 Wright,Ballin L Fire Fighter-AdvanceTechnician \n", "22222 Wright,Christopher D Fire Fighter-Technician \n", "22223 Wright,James Fire Fighter \n", "22224 Wuschke,Barbara Fire Alarm Operator \n", "22225 Wyman,George L District Fire Chief Tech-ADR \n", "22226 Wyzard,Keith T Fire Fighter \n", "22227 Yanosick,Justin Timothy Fire Fighter \n", "22228 Yee,Jacob Fire Fighter \n", "22229 Yetman,Patrick Fire Fighter \n", "22230 Young,Allan M Fire Fighter \n", "22231 Young,Michael L Fire Fighter \n", "22232 Zagami,Anthony J Fire Alarm Operator \n", "\n", " DEPARTMENT NAME REGULAR RETRO OTHER OVERTIME \\\n", "0 ASD Human Resources $98538.32 $0.00 $1842.87 $0.00 \n", "1 ASD Human Resources $83942.21 $0.00 $225.00 $0.00 \n", "2 ASD Human Resources $98538.34 $0.00 $0.00 $0.00 \n", "3 ASD Human Resources $70073.81 $0.00 $225.00 $0.00 \n", "4 ASD Human Resources $79253.11 $0.00 $0.00 $0.00 \n", "5 ASD Human Resources $69266.69 $0.00 $0.00 $0.00 \n", "6 ASD Human Resources $42061.21 $0.00 $487.21 $0.00 \n", "7 ASD Human Resources $44080.61 $0.00 $300.00 $0.00 \n", "8 ASD Human Resources $73547.25 $0.00 $0.00 $0.00 \n", "9 ASD Human Resources $15019.39 $0.00 $10250.05 $0.00 \n", "10 ASD Human Resources $4960.00 $0.00 $0.00 $0.00 \n", "11 ASD Human Resources $4960.00 $0.00 $0.00 $0.00 \n", "12 ASD Human Resources $91743.12 $0.00 $225.00 $0.00 \n", "13 ASD Human Resources $47455.39 $0.00 $856.78 $0.00 \n", "14 ASD Human Resources $76393.46 $0.00 $3082.44 $0.00 \n", "15 ASD Human Resources $106594.16 $0.00 $2620.06 $0.00 \n", "16 ASD Human Resources $4960.00 $0.00 $0.00 $0.00 \n", "17 ASD Human Resources $91938.06 $0.00 $4765.38 $0.00 \n", "18 ASD Human Resources $23934.49 $0.00 $998.34 $0.00 \n", "19 ASD Human Resources $42311.33 $0.00 $0.00 $0.00 \n", "20 ASD Human Resources $91744.59 $0.00 $627.00 $0.00 \n", "21 ASD Human Resources $117411.06 $0.00 $4391.66 $0.00 \n", "22 ASD Human Resources $9608.45 $0.00 $0.00 $0.00 \n", "23 ASD Human Resources $65169.15 $0.00 $787.25 $0.00 \n", "24 ASD Human Resources $76393.49 $0.00 $1653.72 $0.00 \n", "25 ASD Human Resources $115982.88 $0.00 $2230.44 $0.00 \n", "26 ASD Human Resources $46423.61 $0.00 $300.00 $0.00 \n", "27 ASD Human Resources $71139.91 $0.00 $865.37 $0.00 \n", "28 ASD Human Resources $5580.00 $0.00 $0.00 $0.00 \n", "29 ASD Human Resources $5710.80 $0.00 $0.00 $0.00 \n", "... ... ... ... ... ... \n", "22203 Boston Fire Department $88662.18 $12890.60 $550.00 $12730.82 \n", "22204 Boston Fire Department $53235.90 $2999.38 $550.00 $5352.20 \n", "22205 Boston Fire Department $88461.02 $13602.82 $550.00 $13775.17 \n", "22206 Boston Fire Department $21364.38 $0.00 $275.00 $0.00 \n", "22207 Boston Fire Department $78538.07 $7593.22 $550.00 $6989.46 \n", "22208 Boston Fire Department $96178.88 $10010.18 $2157.24 $24629.94 \n", "22209 Boston Fire Department $71911.66 $7198.69 $550.00 $3892.15 \n", "22210 Boston Fire Department $28750.02 $0.00 $0.00 $0.00 \n", "22211 Boston Fire Department $15670.19 $8210.82 $11065.36 $2127.66 \n", "22212 Boston Fire Department $39974.95 $0.00 $747.72 $38029.14 \n", "22213 Boston Fire Department $96764.06 $14814.32 $2157.24 $21890.55 \n", "22214 Boston Fire Department $110597.16 $16537.28 $2451.66 $18038.47 \n", "22215 Boston Fire Department $149.99 $6261.44 $3063.63 $0.00 \n", "22216 Boston Fire Department $98109.51 $13524.14 $6243.64 $4866.68 \n", "22217 Boston Fire Department $1195.32 $1188.70 $85430.84 $0.00 \n", "22218 Boston Fire Department $0.00 $1013.60 $0.00 $0.00 \n", "22219 Boston Fire Department $21364.38 $0.00 $275.00 $0.00 \n", "22220 Boston Fire Department $94499.10 $14911.41 $2151.24 $19095.59 \n", "22221 Boston Fire Department $84536.18 $14204.17 $3721.05 $18540.90 \n", "22222 Boston Fire Department $93427.63 $14077.81 $550.00 $17740.79 \n", "22223 Boston Fire Department $0.00 $6499.01 $0.00 $0.00 \n", "22224 Boston Fire Department $95154.82 $13596.87 $550.00 $9325.59 \n", "22225 Boston Fire Department $0.00 $3699.29 $0.00 $0.00 \n", "22226 Boston Fire Department $94460.92 $14055.44 $1466.23 $11700.05 \n", "22227 Boston Fire Department $92646.90 $14250.84 $550.00 $28269.86 \n", "22228 Boston Fire Department $80073.63 $13529.71 $550.00 $15560.09 \n", "22229 Boston Fire Department $69886.18 $5191.64 $550.00 $8227.25 \n", "22230 Boston Fire Department $97234.17 $14091.91 $3050.00 $6193.76 \n", "22231 Boston Fire Department $95694.84 $13973.38 $550.00 $10678.12 \n", "22232 Boston Fire Department $0.00 $5494.93 $0.00 $0.00 \n", "\n", " INJURED DETAIL QUINN TOTAL EARNINGS ZIP \n", "0 $0.00 $0.00 $0.00 $100381.19 02132 \n", "1 $0.00 $0.00 $0.00 $84167.21 02136 \n", "2 $0.00 $0.00 $0.00 $98538.34 02126 \n", "3 $0.00 $0.00 $0.00 $70298.81 02090 \n", "4 $0.00 $0.00 $0.00 $79253.11 02121 \n", "5 $0.00 $0.00 $0.00 $69266.69 02122 \n", "6 $0.00 $0.00 $0.00 $42548.42 02458 \n", "7 $0.00 $0.00 $0.00 $44380.61 02129 \n", "8 $0.00 $0.00 $0.00 $73547.25 02127 \n", "9 $0.00 $0.00 $0.00 $25269.44 02132 \n", "10 $0.00 $0.00 $0.00 $4960.00 02144 \n", "11 $0.00 $0.00 $0.00 $4960.00 02138 \n", "12 $0.00 $0.00 $0.00 $91968.12 02189 \n", "13 $0.00 $0.00 $0.00 $48312.17 02128 \n", "14 $0.00 $0.00 $0.00 $79475.90 02130 \n", "15 $0.00 $0.00 $0.00 $109214.22 02136 \n", "16 $0.00 $0.00 $0.00 $4960.00 02143 \n", "17 $0.00 $0.00 $0.00 $96703.44 02129 \n", "18 $0.00 $0.00 $0.00 $24932.83 02121 \n", "19 $0.00 $0.00 $0.00 $42311.33 02136 \n", "20 $0.00 $0.00 $0.00 $92371.59 02126 \n", "21 $0.00 $0.00 $0.00 $121802.72 02132 \n", "22 $0.00 $0.00 $0.00 $9608.45 02136 \n", "23 $0.00 $0.00 $0.00 $65956.40 02131 \n", "24 $0.00 $0.00 $0.00 $78047.21 02170 \n", "25 $0.00 $0.00 $0.00 $118213.32 02136 \n", "26 $0.00 $0.00 $0.00 $46723.61 02126 \n", "27 $0.00 $0.00 $0.00 $72005.28 02136 \n", "28 $0.00 $0.00 $0.00 $5580.00 02139 \n", "29 $0.00 $0.00 $0.00 $5710.80 02119 \n", "... ... ... ... ... ... \n", "22203 $6633.81 $128.00 $0.00 $121595.41 02136 \n", "22204 $0.00 $0.00 $0.00 $62137.48 02132 \n", "22205 $4855.79 $8326.75 $0.00 $129571.55 02136 \n", "22206 $0.00 $0.00 $0.00 $21639.38 02132 \n", "22207 $49.23 $8462.25 $0.00 $102182.23 02136 \n", "22208 $4337.00 $561.00 $0.00 $137874.24 02026 \n", "22209 $7678.90 $0.00 $0.00 $91231.40 02122 \n", "22210 $0.00 $0.00 $0.00 $28750.02 02111 \n", "22211 $84109.32 $0.00 $0.00 $121183.35 02118 \n", "22212 $0.00 $0.00 $0.00 $78751.81 02132 \n", "22213 $718.99 $2401.50 $0.00 $138746.66 02124 \n", "22214 $0.00 $0.00 $0.00 $147624.57 02129 \n", "22215 $100310.76 $0.00 $0.00 $109785.82 02136 \n", "22216 $0.00 $0.00 $0.00 $122743.97 02121 \n", "22217 $103564.81 $0.00 $0.00 $191379.67 02186 \n", "22218 $1425.72 $0.00 $0.00 $2439.32 02121 \n", "22219 $0.00 $0.00 $0.00 $21639.38 02132 \n", "22220 $0.00 $5132.75 $0.00 $135790.09 02072 \n", "22221 $13082.71 $1488.00 $0.00 $135573.01 02125 \n", "22222 $448.65 $0.00 $0.00 $126244.88 02132 \n", "22223 $0.00 $0.00 $0.00 $6499.01 02368 \n", "22224 $0.00 $0.00 $0.00 $118627.28 02124 \n", "22225 $2845.81 $0.00 $0.00 $6545.10 02360 \n", "22226 $0.00 $0.00 $0.00 $121682.64 02368 \n", "22227 $0.00 $0.00 $0.00 $135717.60 02132 \n", "22228 $13353.47 $7245.75 $0.00 $130312.65 02136 \n", "22229 $0.00 $0.00 $0.00 $83855.07 02127 \n", "22230 $0.00 $4464.00 $0.00 $125033.84 02136 \n", "22231 $0.00 $132.00 $0.00 $121028.34 02121 \n", "22232 $0.00 $0.00 $0.00 $5494.93 02124 \n", "\n", "[22233 rows x 12 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = pd.read_csv(\"Employee_Earnings_Report_2014.csv\")\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We can now explore the dataset quickly and easily using the countless built in methods for dataframes. For example, which Boston employee makes the most money?" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NAMETITLEDEPARTMENT NAMEREGULARRETROOTHEROVERTIMEINJUREDDETAILQUINNTOTAL EARNINGSZIP
16758 Linnenbank,Kristen Laura Director (D) (non-ac) UP Academy Dorchester $99999.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99999.90 01970
13686 Iatrou,Kyriaki Teacher Curley K-8 $99393.58 $0.00 $600.00 $0.00 $0.00 $0.00 $0.00 $99993.58 02167
8769 Rice,Juli Teacher BPS Manning Elementary $99992.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99992.65 02130
6432 Cartagena,Angel L. Teacher BPS East Boston High $95554.68 $0.00 $4436.50 $0.00 $0.00 $0.00 $0.00 $99991.18 02149
16246 Gantt,Danielle Coordinator 7 Teaching & Learning $99989.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99989.77 02121
8179 Lonergan,Mark J Teacher BPS Human Resource Team $99989.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99989.33 02131
9637 Pinkney-Chase,LaTrelle Natosha Teacher BPS MPH\\Health Academy $94444.78 $0.00 $5537.60 $0.00 $0.00 $0.00 $0.00 $99982.38 02132
5938 O'Connell,Bebhinn Teacher BPS Cl#10 Lee Academy $98979.47 $0.00 $1000.00 $0.00 $0.00 $0.00 $0.00 $99979.47 02062
13786 McIsaac,Stephen J. Teacher Dorchester Academy $98778.83 $0.00 $1200.00 $0.00 $0.00 $0.00 $0.00 $99978.83 02155
13480 Torres-Vivas,Odalis Teacher BPS Winship Elementary $97960.72 $0.00 $2015.00 $0.00 $0.00 $0.00 $0.00 $99975.72 02135
15797 Tippett,Jodi L Nurse Lyon K-8 $99971.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99971.35 02421
9063 Holland,Mary F Teacher BPS McCormack Middle $99952.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99952.22 02072
5939 Purple,Keri L Specialist (BTU) BPS Cl#10 Lee Academy $99429.05 $0.00 $500.00 $0.00 $0.00 $0.00 $0.00 $99929.05 02131
6249 Ward-Wilson,Stephanie A School Psychologist(1) BPS Counseling Service $98778.83 $0.00 $1150.00 $0.00 $0.00 $0.00 $0.00 $99928.83 02043
17515 Burns,Nolan R Police Officer Boston Police Department $69251.35 $2936.57 $807.33 $12722.97 $0.00 $14207.00 $0.00 $99925.22 02129
16865 Peddie,Jabari Principal Elementary UP Academy Holland $99924.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99924.65 02126
6644 Galvin,Janice M. Teacher BPS Ellis Elementary $99322.59 $0.00 $600.00 $0.00 $0.00 $0.00 $0.00 $99922.59 02132
12560 Gomes,Idalina Teacher BPS Sumner Elementary $99405.43 $0.00 $500.00 $0.00 $0.00 $0.00 $0.00 $99905.43 02189
10478 Donovan,Amy M Teacher BPS Rogers Middle $98901.87 $0.00 $1000.00 $0.00 $0.00 $0.00 $0.00 $99901.87 02184
4204 McCabe,James B Workers Comp Job Classificatn Workers Compensation Service $0.00 $0.00 $0.00 $0.00 $999.31 $0.00 $0.00 $999.31 02132
4775 Hart,Allyson N. Director (Basas 10B) BPS Blackstone Elementary $99898.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99898.99 02062
10948 Couture,Aaron SpEd Support Svcs Supervisor BPS Special Education $99898.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99898.99 02081
7506 Yee,James Sen Supv Schl Bldg Electrical BPS Facility Mgmt/A & R $83106.38 $663.16 $3842.00 $12280.31 $0.00 $0.00 $0.00 $99891.85 02467
4651 Gangemi,Josephine C. Teacher BPS Bates Elementary $99886.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99886.57 02131
13448 Feuerstein,Tia Marie Teacher BPS Winship Elementary $99886.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99886.57 02124
21153 Hardy,Brett R. Fire Fighter-Technician Boston Fire Department $82685.69 $8492.91 $550.00 $8128.65 $27.31 $0.00 $0.00 $99884.56 02122
16087 Chang,Sarah Teacher Quincy Upper School $96884.16 $0.00 $3000.00 $0.00 $0.00 $0.00 $0.00 $99884.16 02118
5272 Amoroso,Rita A Nurse BPS Bradley Elementary $99883.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $99883.34 02151
15985 Adam,S.Farhan Teacher Newcomers Academy $98778.83 $0.00 $1102.80 $0.00 $0.00 $0.00 $0.00 $99881.63 02124
15315 Gallivan,Ellen E Teacher Jackson/Mann K-8 $99378.91 $0.00 $500.00 $0.00 $0.00 $0.00 $0.00 $99878.91 01746
.......................................
4855 Gonzalez,Ramiro G Teacher BPS Boston Arts Academy $70885.98 $0.00 $29248.02 $0.00 $0.00 $0.00 $0.00 $100134.00 02908
21347 Kelly,Michael Joseph Fire Fighter Boston Fire Department $65265.15 $3402.52 $550.00 $9819.90 $765.59 $20330.75 $0.00 $100133.91 02124
6091 Petruccelli,Carol A Teacher BPS Condon Elementary $99378.91 $0.00 $755.00 $0.00 $0.00 $0.00 $0.00 $100133.91 02115
4648 Fitzgerald,Christine L. Teacher BPS Bates Elementary $100128.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100128.45 02760
16089 Chen,Yuyu Teacher Quincy Upper School $87374.84 $0.00 $12750.00 $0.00 $0.00 $0.00 $0.00 $100124.84 02155
18397 Goodband,Clifford Prin Admin Asst Boston Police Department $73768.58 $0.00 $1520.58 $24831.84 $0.00 $0.00 $0.00 $100121.00 02132
15474 Moody,Kathyann R Teacher Kennedy, JF Elementary $97716.46 $0.00 $2401.00 $0.00 $0.00 $0.00 $0.00 $100117.46 02126
3428 Pham,Tan V Sr Civil Engineer Public Works Department $82568.29 $0.00 $4124.83 $13412.71 $0.00 $0.00 $0.00 $100105.83 02124
4660 Kelley,Noreen M Teacher BPS Bates Elementary $100101.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100101.93 02124
18941 Lewis,Janet P. Police Officer Boston Police Department $80225.99 $10171.54 $5164.95 $4348.43 $189.00 $0.00 $0.00 $100099.91 02131
16910 Capone-Cameron,Teresa Teacher Warren/Prescott K-8 $99348.35 $0.00 $750.00 $0.00 $0.00 $0.00 $0.00 $100098.35 02155
8283 Galac,Mitchelle A. Teacher BPS Irving Middle $99833.53 $0.00 $250.00 $0.00 $0.00 $0.00 $0.00 $100083.53 02170
6668 Murad,Lynda J. Teacher BPS Ellis Elementary $99833.53 $0.00 $250.00 $0.00 $0.00 $0.00 $0.00 $100083.53 02131
2820 Towle,David Summer Youth Worker Parks Department $10008.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10008.00 02131
4358 Jar-Curran,Lena Teacher Baldwin ELC $98078.91 $0.00 $2000.00 $0.00 $0.00 $0.00 $0.00 $100078.91 02141
21668 Moran,Patrick Fire Fighter-Technician Boston Fire Department $82668.55 $8595.18 $550.00 $8255.26 $0.00 $0.00 $0.00 $100068.99 02132
1899 Alvarez,Indira C Exec Asst (ISD) Inspectional Services Dept $99414.58 $0.00 $0.00 $641.96 $0.00 $0.00 $0.00 $100056.54 02121
13768 Fitzpatrick,Marcia E SpEd Support Svcs Coordinator Dorchester Academy $93744.08 $0.00 $6310.80 $0.00 $0.00 $0.00 $0.00 $100054.88 02122
8167 Kelley,Daniel W Teacher BPS Human Resource Team $100052.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100052.06 02122
16987 Erilus,Yves F. Teacher West Roxbury Academy $100048.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100048.89 02760
5134 Freeman,Judi H Teacher BPS Boston Latin $100048.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100048.89 02118
13942 Gothie,Megan M Teacher Edison K-8 $100048.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100048.89 02494
13978 O'Rourke,Kerry A Teacher Edison K-8 $100044.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100044.60 02122
7841 Jean,Maria T Teacher BPS Hennigan Elementary $98593.76 $0.00 $1438.98 $0.00 $0.00 $0.00 $0.00 $100032.74 02136
10523 Smith,Maya S. School Disciplinary Officer BPS Rogers Middle $96574.76 $0.00 $3450.00 $0.00 $0.00 $0.00 $0.00 $100024.76 02131
9987 Johnson,Anita Attendant BPS Office Of Budget Mgmt $7692.21 $0.00 $0.00 $0.00 $2310.00 $0.00 $0.00 $10002.21 02126
8023 Chace,Jennifer A Teacher BPS Horace Mann $100012.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100012.37 02135
5600 Scott,Tarek Over-Time Stipend Other BPS Business Service $0.00 $0.00 $1000.00 $0.00 $0.00 $0.00 $0.00 $1000.00 02119
14664 Morin,Kristen Marie Community Field Coordinator Greenwood, E Leadership Acad $0.00 $0.00 $100.00 $0.00 $0.00 $0.00 $0.00 $100.00 02130
6762 Larievy,Arthur F. Program Director (Basas 9A) BPS English High $0.00 $10.82 $0.00 $0.00 $0.00 $0.00 $0.00 $10.82 02118
\n", "

22233 rows × 12 columns

\n", "
" ], "text/plain": [ " NAME TITLE \\\n", "16758 Linnenbank,Kristen Laura Director (D) (non-ac) \n", "13686 Iatrou,Kyriaki Teacher \n", "8769 Rice,Juli Teacher \n", "6432 Cartagena,Angel L. Teacher \n", "16246 Gantt,Danielle Coordinator 7 \n", "8179 Lonergan,Mark J Teacher \n", "9637 Pinkney-Chase,LaTrelle Natosha Teacher \n", "5938 O'Connell,Bebhinn Teacher \n", "13786 McIsaac,Stephen J. Teacher \n", "13480 Torres-Vivas,Odalis Teacher \n", "15797 Tippett,Jodi L Nurse \n", "9063 Holland,Mary F Teacher \n", "5939 Purple,Keri L Specialist (BTU) \n", "6249 Ward-Wilson,Stephanie A School Psychologist(1) \n", "17515 Burns,Nolan R Police Officer \n", "16865 Peddie,Jabari Principal Elementary \n", "6644 Galvin,Janice M. Teacher \n", "12560 Gomes,Idalina Teacher \n", "10478 Donovan,Amy M Teacher \n", "4204 McCabe,James B Workers Comp Job Classificatn \n", "4775 Hart,Allyson N. Director (Basas 10B) \n", "10948 Couture,Aaron SpEd Support Svcs Supervisor \n", "7506 Yee,James Sen Supv Schl Bldg Electrical \n", "4651 Gangemi,Josephine C. Teacher \n", "13448 Feuerstein,Tia Marie Teacher \n", "21153 Hardy,Brett R. Fire Fighter-Technician \n", "16087 Chang,Sarah Teacher \n", "5272 Amoroso,Rita A Nurse \n", "15985 Adam,S.Farhan Teacher \n", "15315 Gallivan,Ellen E Teacher \n", "... ... ... \n", "4855 Gonzalez,Ramiro G Teacher \n", "21347 Kelly,Michael Joseph Fire Fighter \n", "6091 Petruccelli,Carol A Teacher \n", "4648 Fitzgerald,Christine L. Teacher \n", "16089 Chen,Yuyu Teacher \n", "18397 Goodband,Clifford Prin Admin Asst \n", "15474 Moody,Kathyann R Teacher \n", "3428 Pham,Tan V Sr Civil Engineer \n", "4660 Kelley,Noreen M Teacher \n", "18941 Lewis,Janet P. Police Officer \n", "16910 Capone-Cameron,Teresa Teacher \n", "8283 Galac,Mitchelle A. Teacher \n", "6668 Murad,Lynda J. Teacher \n", "2820 Towle,David Summer Youth Worker \n", "4358 Jar-Curran,Lena Teacher \n", "21668 Moran,Patrick Fire Fighter-Technician \n", "1899 Alvarez,Indira C Exec Asst (ISD) \n", "13768 Fitzpatrick,Marcia E SpEd Support Svcs Coordinator \n", "8167 Kelley,Daniel W Teacher \n", "16987 Erilus,Yves F. Teacher \n", "5134 Freeman,Judi H Teacher \n", "13942 Gothie,Megan M Teacher \n", "13978 O'Rourke,Kerry A Teacher \n", "7841 Jean,Maria T Teacher \n", "10523 Smith,Maya S. School Disciplinary Officer \n", "9987 Johnson,Anita Attendant \n", "8023 Chace,Jennifer A Teacher \n", "5600 Scott,Tarek Over-Time Stipend Other \n", "14664 Morin,Kristen Marie Community Field Coordinator \n", "6762 Larievy,Arthur F. Program Director (Basas 9A) \n", "\n", " DEPARTMENT NAME REGULAR RETRO OTHER \\\n", "16758 UP Academy Dorchester $99999.90 $0.00 $0.00 \n", "13686 Curley K-8 $99393.58 $0.00 $600.00 \n", "8769 BPS Manning Elementary $99992.65 $0.00 $0.00 \n", "6432 BPS East Boston High $95554.68 $0.00 $4436.50 \n", "16246 Teaching & Learning $99989.77 $0.00 $0.00 \n", "8179 BPS Human Resource Team $99989.33 $0.00 $0.00 \n", "9637 BPS MPH\\Health Academy $94444.78 $0.00 $5537.60 \n", "5938 BPS Cl#10 Lee Academy $98979.47 $0.00 $1000.00 \n", "13786 Dorchester Academy $98778.83 $0.00 $1200.00 \n", "13480 BPS Winship Elementary $97960.72 $0.00 $2015.00 \n", "15797 Lyon K-8 $99971.35 $0.00 $0.00 \n", "9063 BPS McCormack Middle $99952.22 $0.00 $0.00 \n", "5939 BPS Cl#10 Lee Academy $99429.05 $0.00 $500.00 \n", "6249 BPS Counseling Service $98778.83 $0.00 $1150.00 \n", "17515 Boston Police Department $69251.35 $2936.57 $807.33 \n", "16865 UP Academy Holland $99924.65 $0.00 $0.00 \n", "6644 BPS Ellis Elementary $99322.59 $0.00 $600.00 \n", "12560 BPS Sumner Elementary $99405.43 $0.00 $500.00 \n", "10478 BPS Rogers Middle $98901.87 $0.00 $1000.00 \n", "4204 Workers Compensation Service $0.00 $0.00 $0.00 \n", "4775 BPS Blackstone Elementary $99898.99 $0.00 $0.00 \n", "10948 BPS Special Education $99898.99 $0.00 $0.00 \n", "7506 BPS Facility Mgmt/A & R $83106.38 $663.16 $3842.00 \n", "4651 BPS Bates Elementary $99886.57 $0.00 $0.00 \n", "13448 BPS Winship Elementary $99886.57 $0.00 $0.00 \n", "21153 Boston Fire Department $82685.69 $8492.91 $550.00 \n", "16087 Quincy Upper School $96884.16 $0.00 $3000.00 \n", "5272 BPS Bradley Elementary $99883.34 $0.00 $0.00 \n", "15985 Newcomers Academy $98778.83 $0.00 $1102.80 \n", "15315 Jackson/Mann K-8 $99378.91 $0.00 $500.00 \n", "... ... ... ... ... \n", "4855 BPS Boston Arts Academy $70885.98 $0.00 $29248.02 \n", "21347 Boston Fire Department $65265.15 $3402.52 $550.00 \n", "6091 BPS Condon Elementary $99378.91 $0.00 $755.00 \n", "4648 BPS Bates Elementary $100128.45 $0.00 $0.00 \n", "16089 Quincy Upper School $87374.84 $0.00 $12750.00 \n", "18397 Boston Police Department $73768.58 $0.00 $1520.58 \n", "15474 Kennedy, JF Elementary $97716.46 $0.00 $2401.00 \n", "3428 Public Works Department $82568.29 $0.00 $4124.83 \n", "4660 BPS Bates Elementary $100101.93 $0.00 $0.00 \n", "18941 Boston Police Department $80225.99 $10171.54 $5164.95 \n", "16910 Warren/Prescott K-8 $99348.35 $0.00 $750.00 \n", "8283 BPS Irving Middle $99833.53 $0.00 $250.00 \n", "6668 BPS Ellis Elementary $99833.53 $0.00 $250.00 \n", "2820 Parks Department $10008.00 $0.00 $0.00 \n", "4358 Baldwin ELC $98078.91 $0.00 $2000.00 \n", "21668 Boston Fire Department $82668.55 $8595.18 $550.00 \n", "1899 Inspectional Services Dept $99414.58 $0.00 $0.00 \n", "13768 Dorchester Academy $93744.08 $0.00 $6310.80 \n", "8167 BPS Human Resource Team $100052.06 $0.00 $0.00 \n", "16987 West Roxbury Academy $100048.89 $0.00 $0.00 \n", "5134 BPS Boston Latin $100048.89 $0.00 $0.00 \n", "13942 Edison K-8 $100048.89 $0.00 $0.00 \n", "13978 Edison K-8 $100044.60 $0.00 $0.00 \n", "7841 BPS Hennigan Elementary $98593.76 $0.00 $1438.98 \n", "10523 BPS Rogers Middle $96574.76 $0.00 $3450.00 \n", "9987 BPS Office Of Budget Mgmt $7692.21 $0.00 $0.00 \n", "8023 BPS Horace Mann $100012.37 $0.00 $0.00 \n", "5600 BPS Business Service $0.00 $0.00 $1000.00 \n", "14664 Greenwood, E Leadership Acad $0.00 $0.00 $100.00 \n", "6762 BPS English High $0.00 $10.82 $0.00 \n", "\n", " OVERTIME INJURED DETAIL QUINN TOTAL EARNINGS ZIP \n", "16758 $0.00 $0.00 $0.00 $0.00 $99999.90 01970 \n", "13686 $0.00 $0.00 $0.00 $0.00 $99993.58 02167 \n", "8769 $0.00 $0.00 $0.00 $0.00 $99992.65 02130 \n", "6432 $0.00 $0.00 $0.00 $0.00 $99991.18 02149 \n", "16246 $0.00 $0.00 $0.00 $0.00 $99989.77 02121 \n", "8179 $0.00 $0.00 $0.00 $0.00 $99989.33 02131 \n", "9637 $0.00 $0.00 $0.00 $0.00 $99982.38 02132 \n", "5938 $0.00 $0.00 $0.00 $0.00 $99979.47 02062 \n", "13786 $0.00 $0.00 $0.00 $0.00 $99978.83 02155 \n", "13480 $0.00 $0.00 $0.00 $0.00 $99975.72 02135 \n", "15797 $0.00 $0.00 $0.00 $0.00 $99971.35 02421 \n", "9063 $0.00 $0.00 $0.00 $0.00 $99952.22 02072 \n", "5939 $0.00 $0.00 $0.00 $0.00 $99929.05 02131 \n", "6249 $0.00 $0.00 $0.00 $0.00 $99928.83 02043 \n", "17515 $12722.97 $0.00 $14207.00 $0.00 $99925.22 02129 \n", "16865 $0.00 $0.00 $0.00 $0.00 $99924.65 02126 \n", "6644 $0.00 $0.00 $0.00 $0.00 $99922.59 02132 \n", "12560 $0.00 $0.00 $0.00 $0.00 $99905.43 02189 \n", "10478 $0.00 $0.00 $0.00 $0.00 $99901.87 02184 \n", "4204 $0.00 $999.31 $0.00 $0.00 $999.31 02132 \n", "4775 $0.00 $0.00 $0.00 $0.00 $99898.99 02062 \n", "10948 $0.00 $0.00 $0.00 $0.00 $99898.99 02081 \n", "7506 $12280.31 $0.00 $0.00 $0.00 $99891.85 02467 \n", "4651 $0.00 $0.00 $0.00 $0.00 $99886.57 02131 \n", "13448 $0.00 $0.00 $0.00 $0.00 $99886.57 02124 \n", "21153 $8128.65 $27.31 $0.00 $0.00 $99884.56 02122 \n", "16087 $0.00 $0.00 $0.00 $0.00 $99884.16 02118 \n", "5272 $0.00 $0.00 $0.00 $0.00 $99883.34 02151 \n", "15985 $0.00 $0.00 $0.00 $0.00 $99881.63 02124 \n", "15315 $0.00 $0.00 $0.00 $0.00 $99878.91 01746 \n", "... ... ... ... ... ... ... \n", "4855 $0.00 $0.00 $0.00 $0.00 $100134.00 02908 \n", "21347 $9819.90 $765.59 $20330.75 $0.00 $100133.91 02124 \n", "6091 $0.00 $0.00 $0.00 $0.00 $100133.91 02115 \n", "4648 $0.00 $0.00 $0.00 $0.00 $100128.45 02760 \n", "16089 $0.00 $0.00 $0.00 $0.00 $100124.84 02155 \n", "18397 $24831.84 $0.00 $0.00 $0.00 $100121.00 02132 \n", "15474 $0.00 $0.00 $0.00 $0.00 $100117.46 02126 \n", "3428 $13412.71 $0.00 $0.00 $0.00 $100105.83 02124 \n", "4660 $0.00 $0.00 $0.00 $0.00 $100101.93 02124 \n", "18941 $4348.43 $189.00 $0.00 $0.00 $100099.91 02131 \n", "16910 $0.00 $0.00 $0.00 $0.00 $100098.35 02155 \n", "8283 $0.00 $0.00 $0.00 $0.00 $100083.53 02170 \n", "6668 $0.00 $0.00 $0.00 $0.00 $100083.53 02131 \n", "2820 $0.00 $0.00 $0.00 $0.00 $10008.00 02131 \n", "4358 $0.00 $0.00 $0.00 $0.00 $100078.91 02141 \n", "21668 $8255.26 $0.00 $0.00 $0.00 $100068.99 02132 \n", "1899 $641.96 $0.00 $0.00 $0.00 $100056.54 02121 \n", "13768 $0.00 $0.00 $0.00 $0.00 $100054.88 02122 \n", "8167 $0.00 $0.00 $0.00 $0.00 $100052.06 02122 \n", "16987 $0.00 $0.00 $0.00 $0.00 $100048.89 02760 \n", "5134 $0.00 $0.00 $0.00 $0.00 $100048.89 02118 \n", "13942 $0.00 $0.00 $0.00 $0.00 $100048.89 02494 \n", "13978 $0.00 $0.00 $0.00 $0.00 $100044.60 02122 \n", "7841 $0.00 $0.00 $0.00 $0.00 $100032.74 02136 \n", "10523 $0.00 $0.00 $0.00 $0.00 $100024.76 02131 \n", "9987 $0.00 $2310.00 $0.00 $0.00 $10002.21 02126 \n", "8023 $0.00 $0.00 $0.00 $0.00 $100012.37 02135 \n", "5600 $0.00 $0.00 $0.00 $0.00 $1000.00 02119 \n", "14664 $0.00 $0.00 $0.00 $0.00 $100.00 02130 \n", "6762 $0.00 $0.00 $0.00 $0.00 $10.82 02118 \n", "\n", "[22233 rows x 12 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.sort('TOTAL EARNINGS',ascending=0)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Cleaning the data to allow for statistical analysis is also not too bad! " ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NAMETITLEDEPARTMENT NAMEREGULARRETROOTHEROVERTIMEINJUREDDETAILQUINNTOTAL EARNINGSZIP
0 Adario,Anthony J Supvising Claims Agent (Asd) ASD Human Resources $98538.32 $0.00 $1842.87 $0.00 $0.00 $0.00 $0.00 100381.19 02132
1 Baker,Katherine E. Nurse Case Manager ASD Human Resources $83942.21 $0.00 $225.00 $0.00 $0.00 $0.00 $0.00 84167.21 02136
2 Braga,Ann Hess HumanResourcesComplianceOffcr ASD Human Resources $98538.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 98538.34 02126
3 Calobrisi,Jane Ellen Personnel Analyst ASD Human Resources $70073.81 $0.00 $225.00 $0.00 $0.00 $0.00 $0.00 70298.81 02090
4 Castillo-Cook,Wendolyn M. Alcholism Coord I ASD Human Resources $79253.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 79253.11 02121
5 Curran,Liam Patrick Asst Corp Counsel III ASD Human Resources $69266.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 69266.69 02122
6 De Jesus,Winnie Yam Affirm Action Monitor ASD Human Resources $42061.21 $0.00 $487.21 $0.00 $0.00 $0.00 $0.00 42548.42 02458
7 Donnelly,Jennifer P. Prin Clerk ASD Human Resources $44080.61 $0.00 $300.00 $0.00 $0.00 $0.00 $0.00 44380.61 02129
8 Donovan,Carol Anne Prin Admin Analyst ASD Human Resources $73547.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 73547.25 02127
9 Donovan,John J Exec Asst (EAP/OHR) ASD Human Resources $15019.39 $0.00 $10250.05 $0.00 $0.00 $0.00 $0.00 25269.44 02132
10 Ettingoff,Kimberly Intern I ASD Human Resources $4960.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4960.00 02144
11 Figueroa Ortiz,Irene Intern I ASD Human Resources $4960.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4960.00 02138
12 Firicano,Frank P. Sr Admin Asst (OHR) ASD Human Resources $91743.12 $0.00 $225.00 $0.00 $0.00 $0.00 $0.00 91968.12 02189
13 Flemming,Teresia K Head Account Clerk ASD Human Resources $47455.39 $0.00 $856.78 $0.00 $0.00 $0.00 $0.00 48312.17 02128
14 Gee,Xing-Bing Data Proc Sys Analyst ASD Human Resources $76393.46 $0.00 $3082.44 $0.00 $0.00 $0.00 $0.00 79475.90 02130
15 Grant,Michael Scott Sr Data Proc Sys Anl ASD Human Resources $106594.16 $0.00 $2620.06 $0.00 $0.00 $0.00 $0.00 109214.22 02136
16 Green,Allison Camille Intern I ASD Human Resources $4960.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4960.00 02143
17 Green,Kathleen M Health Insurance Coordinator ASD Human Resources $91938.06 $0.00 $4765.38 $0.00 $0.00 $0.00 $0.00 96703.44 02129
18 Guante,Celiana Admin Asst ASD Human Resources $23934.49 $0.00 $998.34 $0.00 $0.00 $0.00 $0.00 24932.83 02121
19 Hanson,Sheila A Head Clerk ASD Human Resources $42311.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 42311.33 02136
20 Jackson-Rodgers,Jacqueline N. Sr Admin Asst (OHR) ASD Human Resources $91744.59 $0.00 $627.00 $0.00 $0.00 $0.00 $0.00 92371.59 02126
21 Kessler,William Asst Dir (Human Resources) ASD Human Resources $117411.06 $0.00 $4391.66 $0.00 $0.00 $0.00 $0.00 121802.72 02132
22 Killarney,Bernard Director of Operations ASD Human Resources $9608.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 9608.45 02136
23 Lanchester,Diane Office Manager ASD Human Resources $65169.15 $0.00 $787.25 $0.00 $0.00 $0.00 $0.00 65956.40 02131
24 Lee,Winnie Sr Admin Asst ASD Human Resources $76393.49 $0.00 $1653.72 $0.00 $0.00 $0.00 $0.00 78047.21 02170
25 Leonard,Vivian Supv of Personnel ASD Human Resources $115982.88 $0.00 $2230.44 $0.00 $0.00 $0.00 $0.00 118213.32 02136
26 Marshall,Leah A. Human Resources Representative ASD Human Resources $46423.61 $0.00 $300.00 $0.00 $0.00 $0.00 $0.00 46723.61 02126
27 McNeil,Jean M Supv-Management Svcs ASD Human Resources $71139.91 $0.00 $865.37 $0.00 $0.00 $0.00 $0.00 72005.28 02136
28 Melle,Laura Intern I ASD Human Resources $5580.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5580.00 02139
29 Morant,Darius Prin Clerk ASD Human Resources $5710.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5710.80 02119
.......................................
22203 Wilson,Jeffrey Fire Fighter-AdvanceTechnician Boston Fire Department $88662.18 $12890.60 $550.00 $12730.82 $6633.81 $128.00 $0.00 121595.41 02136
22204 Wilson,Keith Michael Fire Fighter Boston Fire Department $53235.90 $2999.38 $550.00 $5352.20 $0.00 $0.00 $0.00 62137.48 02132
22205 Wilson,Marlon Fire Fighter Boston Fire Department $88461.02 $13602.82 $550.00 $13775.17 $4855.79 $8326.75 $0.00 129571.55 02136
22206 Wilson,Ryan Jon Fire Fighter Boston Fire Department $21364.38 $0.00 $275.00 $0.00 $0.00 $0.00 $0.00 21639.38 02132
22207 Wilson,Sean E Fire Fighter Boston Fire Department $78538.07 $7593.22 $550.00 $6989.46 $49.23 $8462.25 $0.00 102182.23 02136
22208 Wilson,Wayne A Fire Fighter Boston Fire Department $96178.88 $10010.18 $2157.24 $24629.94 $4337.00 $561.00 $0.00 137874.24 02026
22209 Wirtz,Eric M Fire Fighter Boston Fire Department $71911.66 $7198.69 $550.00 $3892.15 $7678.90 $0.00 $0.00 91231.40 02122
22210 Wong,Connie S Dep Comm-Labor & Legal Boston Fire Department $28750.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 28750.02 02111
22211 Wong,Robert Fire Fighter Boston Fire Department $15670.19 $8210.82 $11065.36 $2127.66 $84109.32 $0.00 $0.00 121183.35 02118
22212 Wong,William Asst Prin accountant Boston Fire Department $39974.95 $0.00 $747.72 $38029.14 $0.00 $0.00 $0.00 78751.81 02132
22213 Woodbury,Dennis A Fire Fighter Boston Fire Department $96764.06 $14814.32 $2157.24 $21890.55 $718.99 $2401.50 $0.00 138746.66 02124
22214 Woods,Patrick J Fire Lieutenant Boston Fire Department $110597.16 $16537.28 $2451.66 $18038.47 $0.00 $0.00 $0.00 147624.57 02129
22215 Wornum,Dwight H Fire Fighter Boston Fire Department $149.99 $6261.44 $3063.63 $0.00 $100310.76 $0.00 $0.00 109785.82 02136
22216 Wornum,John W FF (FPDInspLevl1Certification) Boston Fire Department $98109.51 $13524.14 $6243.64 $4866.68 $0.00 $0.00 $0.00 122743.97 02121
22217 Wornum,Phillip B. FF LEP Title 3 Inspector - ADR Boston Fire Department $1195.32 $1188.70 $85430.84 $0.00 $103564.81 $0.00 $0.00 191379.67 02186
22218 Worrell,David E Fire Fighter Boston Fire Department $0.00 $1013.60 $0.00 $0.00 $1425.72 $0.00 $0.00 2439.32 02121
22219 Wosny,Joseph Andrew Fire Fighter Boston Fire Department $21364.38 $0.00 $275.00 $0.00 $0.00 $0.00 $0.00 21639.38 02132
22220 Wright,Alexander E Fire Fighter-Technician Boston Fire Department $94499.10 $14911.41 $2151.24 $19095.59 $0.00 $5132.75 $0.00 135790.09 02072
22221 Wright,Ballin L Fire Fighter-AdvanceTechnician Boston Fire Department $84536.18 $14204.17 $3721.05 $18540.90 $13082.71 $1488.00 $0.00 135573.01 02125
22222 Wright,Christopher D Fire Fighter-Technician Boston Fire Department $93427.63 $14077.81 $550.00 $17740.79 $448.65 $0.00 $0.00 126244.88 02132
22223 Wright,James Fire Fighter Boston Fire Department $0.00 $6499.01 $0.00 $0.00 $0.00 $0.00 $0.00 6499.01 02368
22224 Wuschke,Barbara Fire Alarm Operator Boston Fire Department $95154.82 $13596.87 $550.00 $9325.59 $0.00 $0.00 $0.00 118627.28 02124
22225 Wyman,George L District Fire Chief Tech-ADR Boston Fire Department $0.00 $3699.29 $0.00 $0.00 $2845.81 $0.00 $0.00 6545.10 02360
22226 Wyzard,Keith T Fire Fighter Boston Fire Department $94460.92 $14055.44 $1466.23 $11700.05 $0.00 $0.00 $0.00 121682.64 02368
22227 Yanosick,Justin Timothy Fire Fighter Boston Fire Department $92646.90 $14250.84 $550.00 $28269.86 $0.00 $0.00 $0.00 135717.60 02132
22228 Yee,Jacob Fire Fighter Boston Fire Department $80073.63 $13529.71 $550.00 $15560.09 $13353.47 $7245.75 $0.00 130312.65 02136
22229 Yetman,Patrick Fire Fighter Boston Fire Department $69886.18 $5191.64 $550.00 $8227.25 $0.00 $0.00 $0.00 83855.07 02127
22230 Young,Allan M Fire Fighter Boston Fire Department $97234.17 $14091.91 $3050.00 $6193.76 $0.00 $4464.00 $0.00 125033.84 02136
22231 Young,Michael L Fire Fighter Boston Fire Department $95694.84 $13973.38 $550.00 $10678.12 $0.00 $132.00 $0.00 121028.34 02121
22232 Zagami,Anthony J Fire Alarm Operator Boston Fire Department $0.00 $5494.93 $0.00 $0.00 $0.00 $0.00 $0.00 5494.93 02124
\n", "

22233 rows × 12 columns

\n", "
" ], "text/plain": [ " NAME TITLE \\\n", "0 Adario,Anthony J Supvising Claims Agent (Asd) \n", "1 Baker,Katherine E. Nurse Case Manager \n", "2 Braga,Ann Hess HumanResourcesComplianceOffcr \n", "3 Calobrisi,Jane Ellen Personnel Analyst \n", "4 Castillo-Cook,Wendolyn M. Alcholism Coord I \n", "5 Curran,Liam Patrick Asst Corp Counsel III \n", "6 De Jesus,Winnie Yam Affirm Action Monitor \n", "7 Donnelly,Jennifer P. Prin Clerk \n", "8 Donovan,Carol Anne Prin Admin Analyst \n", "9 Donovan,John J Exec Asst (EAP/OHR) \n", "10 Ettingoff,Kimberly Intern I \n", "11 Figueroa Ortiz,Irene Intern I \n", "12 Firicano,Frank P. Sr Admin Asst (OHR) \n", "13 Flemming,Teresia K Head Account Clerk \n", "14 Gee,Xing-Bing Data Proc Sys Analyst \n", "15 Grant,Michael Scott Sr Data Proc Sys Anl \n", "16 Green,Allison Camille Intern I \n", "17 Green,Kathleen M Health Insurance Coordinator \n", "18 Guante,Celiana Admin Asst \n", "19 Hanson,Sheila A Head Clerk \n", "20 Jackson-Rodgers,Jacqueline N. Sr Admin Asst (OHR) \n", "21 Kessler,William Asst Dir (Human Resources) \n", "22 Killarney,Bernard Director of Operations \n", "23 Lanchester,Diane Office Manager \n", "24 Lee,Winnie Sr Admin Asst \n", "25 Leonard,Vivian Supv of Personnel \n", "26 Marshall,Leah A. Human Resources Representative \n", "27 McNeil,Jean M Supv-Management Svcs \n", "28 Melle,Laura Intern I \n", "29 Morant,Darius Prin Clerk \n", "... ... ... \n", "22203 Wilson,Jeffrey Fire Fighter-AdvanceTechnician \n", "22204 Wilson,Keith Michael Fire Fighter \n", "22205 Wilson,Marlon Fire Fighter \n", "22206 Wilson,Ryan Jon Fire Fighter \n", "22207 Wilson,Sean E Fire Fighter \n", "22208 Wilson,Wayne A Fire Fighter \n", "22209 Wirtz,Eric M Fire Fighter \n", "22210 Wong,Connie S Dep Comm-Labor & Legal \n", "22211 Wong,Robert Fire Fighter \n", "22212 Wong,William Asst Prin accountant \n", "22213 Woodbury,Dennis A Fire Fighter \n", "22214 Woods,Patrick J Fire Lieutenant \n", "22215 Wornum,Dwight H Fire Fighter \n", "22216 Wornum,John W FF (FPDInspLevl1Certification) \n", "22217 Wornum,Phillip B. FF LEP Title 3 Inspector - ADR \n", "22218 Worrell,David E Fire Fighter \n", "22219 Wosny,Joseph Andrew Fire Fighter \n", "22220 Wright,Alexander E Fire Fighter-Technician \n", "22221 Wright,Ballin L Fire Fighter-AdvanceTechnician \n", "22222 Wright,Christopher D Fire Fighter-Technician \n", "22223 Wright,James Fire Fighter \n", "22224 Wuschke,Barbara Fire Alarm Operator \n", "22225 Wyman,George L District Fire Chief Tech-ADR \n", "22226 Wyzard,Keith T Fire Fighter \n", "22227 Yanosick,Justin Timothy Fire Fighter \n", "22228 Yee,Jacob Fire Fighter \n", "22229 Yetman,Patrick Fire Fighter \n", "22230 Young,Allan M Fire Fighter \n", "22231 Young,Michael L Fire Fighter \n", "22232 Zagami,Anthony J Fire Alarm Operator \n", "\n", " DEPARTMENT NAME REGULAR RETRO OTHER OVERTIME \\\n", "0 ASD Human Resources $98538.32 $0.00 $1842.87 $0.00 \n", "1 ASD Human Resources $83942.21 $0.00 $225.00 $0.00 \n", "2 ASD Human Resources $98538.34 $0.00 $0.00 $0.00 \n", "3 ASD Human Resources $70073.81 $0.00 $225.00 $0.00 \n", "4 ASD Human Resources $79253.11 $0.00 $0.00 $0.00 \n", "5 ASD Human Resources $69266.69 $0.00 $0.00 $0.00 \n", "6 ASD Human Resources $42061.21 $0.00 $487.21 $0.00 \n", "7 ASD Human Resources $44080.61 $0.00 $300.00 $0.00 \n", "8 ASD Human Resources $73547.25 $0.00 $0.00 $0.00 \n", "9 ASD Human Resources $15019.39 $0.00 $10250.05 $0.00 \n", "10 ASD Human Resources $4960.00 $0.00 $0.00 $0.00 \n", "11 ASD Human Resources $4960.00 $0.00 $0.00 $0.00 \n", "12 ASD Human Resources $91743.12 $0.00 $225.00 $0.00 \n", "13 ASD Human Resources $47455.39 $0.00 $856.78 $0.00 \n", "14 ASD Human Resources $76393.46 $0.00 $3082.44 $0.00 \n", "15 ASD Human Resources $106594.16 $0.00 $2620.06 $0.00 \n", "16 ASD Human Resources $4960.00 $0.00 $0.00 $0.00 \n", "17 ASD Human Resources $91938.06 $0.00 $4765.38 $0.00 \n", "18 ASD Human Resources $23934.49 $0.00 $998.34 $0.00 \n", "19 ASD Human Resources $42311.33 $0.00 $0.00 $0.00 \n", "20 ASD Human Resources $91744.59 $0.00 $627.00 $0.00 \n", "21 ASD Human Resources $117411.06 $0.00 $4391.66 $0.00 \n", "22 ASD Human Resources $9608.45 $0.00 $0.00 $0.00 \n", "23 ASD Human Resources $65169.15 $0.00 $787.25 $0.00 \n", "24 ASD Human Resources $76393.49 $0.00 $1653.72 $0.00 \n", "25 ASD Human Resources $115982.88 $0.00 $2230.44 $0.00 \n", "26 ASD Human Resources $46423.61 $0.00 $300.00 $0.00 \n", "27 ASD Human Resources $71139.91 $0.00 $865.37 $0.00 \n", "28 ASD Human Resources $5580.00 $0.00 $0.00 $0.00 \n", "29 ASD Human Resources $5710.80 $0.00 $0.00 $0.00 \n", "... ... ... ... ... ... \n", "22203 Boston Fire Department $88662.18 $12890.60 $550.00 $12730.82 \n", "22204 Boston Fire Department $53235.90 $2999.38 $550.00 $5352.20 \n", "22205 Boston Fire Department $88461.02 $13602.82 $550.00 $13775.17 \n", "22206 Boston Fire Department $21364.38 $0.00 $275.00 $0.00 \n", "22207 Boston Fire Department $78538.07 $7593.22 $550.00 $6989.46 \n", "22208 Boston Fire Department $96178.88 $10010.18 $2157.24 $24629.94 \n", "22209 Boston Fire Department $71911.66 $7198.69 $550.00 $3892.15 \n", "22210 Boston Fire Department $28750.02 $0.00 $0.00 $0.00 \n", "22211 Boston Fire Department $15670.19 $8210.82 $11065.36 $2127.66 \n", "22212 Boston Fire Department $39974.95 $0.00 $747.72 $38029.14 \n", "22213 Boston Fire Department $96764.06 $14814.32 $2157.24 $21890.55 \n", "22214 Boston Fire Department $110597.16 $16537.28 $2451.66 $18038.47 \n", "22215 Boston Fire Department $149.99 $6261.44 $3063.63 $0.00 \n", "22216 Boston Fire Department $98109.51 $13524.14 $6243.64 $4866.68 \n", "22217 Boston Fire Department $1195.32 $1188.70 $85430.84 $0.00 \n", "22218 Boston Fire Department $0.00 $1013.60 $0.00 $0.00 \n", "22219 Boston Fire Department $21364.38 $0.00 $275.00 $0.00 \n", "22220 Boston Fire Department $94499.10 $14911.41 $2151.24 $19095.59 \n", "22221 Boston Fire Department $84536.18 $14204.17 $3721.05 $18540.90 \n", "22222 Boston Fire Department $93427.63 $14077.81 $550.00 $17740.79 \n", "22223 Boston Fire Department $0.00 $6499.01 $0.00 $0.00 \n", "22224 Boston Fire Department $95154.82 $13596.87 $550.00 $9325.59 \n", "22225 Boston Fire Department $0.00 $3699.29 $0.00 $0.00 \n", "22226 Boston Fire Department $94460.92 $14055.44 $1466.23 $11700.05 \n", "22227 Boston Fire Department $92646.90 $14250.84 $550.00 $28269.86 \n", "22228 Boston Fire Department $80073.63 $13529.71 $550.00 $15560.09 \n", "22229 Boston Fire Department $69886.18 $5191.64 $550.00 $8227.25 \n", "22230 Boston Fire Department $97234.17 $14091.91 $3050.00 $6193.76 \n", "22231 Boston Fire Department $95694.84 $13973.38 $550.00 $10678.12 \n", "22232 Boston Fire Department $0.00 $5494.93 $0.00 $0.00 \n", "\n", " INJURED DETAIL QUINN TOTAL EARNINGS ZIP \n", "0 $0.00 $0.00 $0.00 100381.19 02132 \n", "1 $0.00 $0.00 $0.00 84167.21 02136 \n", "2 $0.00 $0.00 $0.00 98538.34 02126 \n", "3 $0.00 $0.00 $0.00 70298.81 02090 \n", "4 $0.00 $0.00 $0.00 79253.11 02121 \n", "5 $0.00 $0.00 $0.00 69266.69 02122 \n", "6 $0.00 $0.00 $0.00 42548.42 02458 \n", "7 $0.00 $0.00 $0.00 44380.61 02129 \n", "8 $0.00 $0.00 $0.00 73547.25 02127 \n", "9 $0.00 $0.00 $0.00 25269.44 02132 \n", "10 $0.00 $0.00 $0.00 4960.00 02144 \n", "11 $0.00 $0.00 $0.00 4960.00 02138 \n", "12 $0.00 $0.00 $0.00 91968.12 02189 \n", "13 $0.00 $0.00 $0.00 48312.17 02128 \n", "14 $0.00 $0.00 $0.00 79475.90 02130 \n", "15 $0.00 $0.00 $0.00 109214.22 02136 \n", "16 $0.00 $0.00 $0.00 4960.00 02143 \n", "17 $0.00 $0.00 $0.00 96703.44 02129 \n", "18 $0.00 $0.00 $0.00 24932.83 02121 \n", "19 $0.00 $0.00 $0.00 42311.33 02136 \n", "20 $0.00 $0.00 $0.00 92371.59 02126 \n", "21 $0.00 $0.00 $0.00 121802.72 02132 \n", "22 $0.00 $0.00 $0.00 9608.45 02136 \n", "23 $0.00 $0.00 $0.00 65956.40 02131 \n", "24 $0.00 $0.00 $0.00 78047.21 02170 \n", "25 $0.00 $0.00 $0.00 118213.32 02136 \n", "26 $0.00 $0.00 $0.00 46723.61 02126 \n", "27 $0.00 $0.00 $0.00 72005.28 02136 \n", "28 $0.00 $0.00 $0.00 5580.00 02139 \n", "29 $0.00 $0.00 $0.00 5710.80 02119 \n", "... ... ... ... ... ... \n", "22203 $6633.81 $128.00 $0.00 121595.41 02136 \n", "22204 $0.00 $0.00 $0.00 62137.48 02132 \n", "22205 $4855.79 $8326.75 $0.00 129571.55 02136 \n", "22206 $0.00 $0.00 $0.00 21639.38 02132 \n", "22207 $49.23 $8462.25 $0.00 102182.23 02136 \n", "22208 $4337.00 $561.00 $0.00 137874.24 02026 \n", "22209 $7678.90 $0.00 $0.00 91231.40 02122 \n", "22210 $0.00 $0.00 $0.00 28750.02 02111 \n", "22211 $84109.32 $0.00 $0.00 121183.35 02118 \n", "22212 $0.00 $0.00 $0.00 78751.81 02132 \n", "22213 $718.99 $2401.50 $0.00 138746.66 02124 \n", "22214 $0.00 $0.00 $0.00 147624.57 02129 \n", "22215 $100310.76 $0.00 $0.00 109785.82 02136 \n", "22216 $0.00 $0.00 $0.00 122743.97 02121 \n", "22217 $103564.81 $0.00 $0.00 191379.67 02186 \n", "22218 $1425.72 $0.00 $0.00 2439.32 02121 \n", "22219 $0.00 $0.00 $0.00 21639.38 02132 \n", "22220 $0.00 $5132.75 $0.00 135790.09 02072 \n", "22221 $13082.71 $1488.00 $0.00 135573.01 02125 \n", "22222 $448.65 $0.00 $0.00 126244.88 02132 \n", "22223 $0.00 $0.00 $0.00 6499.01 02368 \n", "22224 $0.00 $0.00 $0.00 118627.28 02124 \n", "22225 $2845.81 $0.00 $0.00 6545.10 02360 \n", "22226 $0.00 $0.00 $0.00 121682.64 02368 \n", "22227 $0.00 $0.00 $0.00 135717.60 02132 \n", "22228 $13353.47 $7245.75 $0.00 130312.65 02136 \n", "22229 $0.00 $0.00 $0.00 83855.07 02127 \n", "22230 $0.00 $4464.00 $0.00 125033.84 02136 \n", "22231 $0.00 $132.00 $0.00 121028.34 02121 \n", "22232 $0.00 $0.00 $0.00 5494.93 02124 \n", "\n", "[22233 rows x 12 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['TOTAL EARNINGS'] = df['TOTAL EARNINGS'].replace('[\\$]', '', regex=True).astype(float)\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "There are boat loads of statistical analysis methods:" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "(61714.87, 66920.917950344083)" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['TOTAL EARNINGS'].median(),df['TOTAL EARNINGS'].mean()" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAAYwAAAEACAYAAACgS0HpAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAHnBJREFUeJzt3H+QXeV93/H3x5axDSYWqlshfrSrTuSCGjrraEBpHQ8b\n", "CrLIpMBMZ2KYCRWpxzOMgu2JZ1JJ6Q/4pxpZMxkHpmPPtNiRcINc1XEYnAhVIua4SadhE4xsYVmV\n", "5FrU2liLMTUO9bSB8O0f91nvYffs7iOx9zzPhc9r5s4+5znn3PO5Z++9z57ne+8qIjAzM1vKW0oH\n", "MDOz0eABw8zMsnjAMDOzLB4wzMwsiwcMMzPL4gHDzMyyLDlgSPp1Sc9IOirpYUlvl7RK0mFJJyQd\n", "krSytf0OSSclHZe0qdW/Id3HSUn3D+sBmZnZcCw6YEi6HPgosCEirgHeCtwObAcOR8R7gT9Ky0ha\n", "D3wIWA9sBj4tSenuPgN8OCLWAeskbR7C4zEzsyHJmZJaAVwoaQVwIfAXwC3A3rR+L3Bbat8K7IuI\n", "lyPiNHAK2ChpDXBxREym7R5q7WNmZiNg0QEjIqaA3wL+F4OB4ocRcRhYHRHTabNpYHVqXwacad3F\n", "GeDyjv6p1G9mZiNiqSmpSxhcTYwxeNN/l6RfaW8Tg/8t4v8vYmb2BrdiifU3At+JiB8ASPoS8A+B\n", "s5IujYizabrpubT9FHBla/8rGFxZTKV2u3+q64CSPPiYmZ2jiNDSW73+gyx4A64DngHeCYhBveLX\n", "gN3AtrTNdmBXaq8HjgAXAGuBbwNK654ENqb7OQBsXuCYsVimEjfgvtIZnOmNk6nWXM400pmij+Ms\n", "eoUREZOSvgh8DXgl/fz3wMXAfkkfBk4Dv5y2PyZpP3Asbb810qMBtgJ70uBzICIOLnRcST+3WK4h\n", "+euI+LMF1o31GSTTWOkAHcZKB+gwVjrAAsZKB+gwVjpAh7HSATqMlQ5QylJTUkTEfcB9c7pfYDBd\n", "1bX9TmBnR/9TwDV5sdYvOJgMx18Lvr0CuKjf45qZjY4lB4wyvvnufo/3IvC3/u8iG+zpKci52FM6\n", "QIc9pQN02FM6wAL2lA7QYU/pAB32lA7QYU/pAKVodsaoDoOid9+ZBgNGxP97Z88HNjN73SRF9FD0\n", "9v+SyiBponSGuZwpT42ZoM5czpSnxkx98YBhZmZZPCUFeErKzEaZp6TMzKwqHjAy1Dhn6Ux5aswE\n", "deZypjw1ZuqLBwwzM8viGgbgGoaZjTLXMMzMrCoeMDLUOGfpTHlqzAR15nKmPDVm6osHDDMzy+Ia\n", "BuAahpmNMtcwzMysKh4wMtQ4Z+lMeWrMBHXmcqY8NWbqiwcMMzPL4hoG4BqGmY0y1zDMzKwqHjAy\n", "1Dhn6Ux5aswEdeZypjw1ZurLkgOGpL8n6enW7UVJH5O0StJhSSckHZK0srXPDkknJR2XtKnVv0HS\n", "0bTu/mE9KDMzW37nVMOQ9BZgCrgO+CjwfETslrQNuCQitktaDzwMXAtcDjwOrIuIkDQJ3BMRk5IO\n", "AA9ExME5x3ANw8zsHNRaw7gROBUR3wVuAfam/r3Abal9K7AvIl6OiNPAKWCjpDXAxRExmbZ7qLWP\n", "mZlV7lwHjNuBfam9OiKmU3saWJ3alwFnWvucYXClMbd/KvVXr8Y5S2fKU2MmqDOXM+WpMVNfsgcM\n", "SRcA/wT4z3PXxWBeq67P55qZ2bJacQ7b3gw8FRHfT8vTki6NiLNpuum51D8FXNna7woGVxZTqd3u\n", "n+o+1F3AWGqvBMaBibTcpJ/LufzST44889dDRDTt5aXWezmaiGhqykMiaaKWPDUv+/eXv9zOVvD4\n", "E8y+UfYiu+gt6QvAYxGxNy3vBn4QEZ+UtB1YOafofR2zRe+fTkXvJ4GPAZPAH+Kit5nZ61ZV0VvS\n", "RQwK3l9qde8CbpJ0ArghLRMRx4D9wDHgMWBrzI5KW4EHgZMMiuevGSxqVeOcpTPlqTET1JnLmfLU\n", "mKkvWVNSEfF/gPfM6XuBwSDStf1OYGdH/1PANece08zMSvP/kgI8JWVmo6yqKSkzMzMPGBlqnLN0\n", "pjw1ZoI6czlTnhoz9cUDhpmZZXENA3ANw8xGmWsYZmZWFQ8YGWqcs3SmPDVmgjpzOVOeGjP1xQOG\n", "mZllcQ0DcA3DzEaZaxhmZlYVDxgZapyzdKY8NWaCOnM5U54aM/XFA4aZmWVxDQNwDcPMRplrGGZm\n", "VhUPGBlqnLN0pjw1ZoI6czlTnhoz9cUDhpmZZXENA3ANw8xGmWsYZmZWFQ8YGWqcs3SmPDVmgjpz\n", "OVOeGjP1JWvAkLRS0hclfUvSMUkbJa2SdFjSCUmHJK1sbb9D0klJxyVtavVvkHQ0rbt/GA/IzMyG\n", "I6uGIWkv8NWI+JykFcBFwL8Eno+I3ZK2AZdExHZJ64GHgWuBy4HHgXUREZImgXsiYlLSAeCBiDg4\n", "51iuYZiZnYNqahiS3g18ICI+BxARr0TEi8AtwN602V7gttS+FdgXES9HxGngFLBR0hrg4oiYTNs9\n", "1NrHzMwqlzMltRb4vqTfkfQ1Sf9B0kXA6oiYTttMA6tT+zLgTGv/MwyuNOb2T6X+6g17zlJSlLwt\n", "4+OYWK77Wi41ZoI6czlTnhoz9WVF5jY/y2Aq6c8k/Tawvb1Bmm5axnmku4Cx1F4JjAMTablJP5dz\n", "+aWfHHnmyRARTWt5fGbHBda/7uXZabjc/DN9udsvtCwkTSz346llGRiXVE2euW82teSpdZk6f39D\n", "fz/IfP5MMPtG2YslaxiSLgX+e0SsTcs/D+wA/i7wCxFxNk03PRERV0naDhARu9L2B4F7gWfTNlen\n", "/juA6yPi7jnHe9PVMMo85p8cnT7mPs1seKqpYUTEWeC7kt6bum4Evgl8GdiS+rYAj6T2o8Dtki6Q\n", "tBZYB0ym+/mRBp+wEnBna58K/NU7Rn1KyMxsmHK/h/FR4HclfR34B8C/BXYBN0k6AdyQlomIY8B+\n", "4BjwGLA1Zi9jtgIPAieBU3M/IVVeLHB7YpF1y3E7H8157jc8Nc7t1pgJ6szlTHlqzNSXnBoGEfF1\n", "Bh+TnevGBbbfCezs6H8KuOZcApqZWR38v6SAQQ1jJSXrCK5hmNn5qqaGYWZmBh4wMjWlA3RoSgeY\n", "p8a53RozQZ25nClPjZn64gHDzMyyuIYBuIbhGobZKHMNw8zMquIBI0tTOkCHpnSAeWqc260xE9SZ\n", "y5ny1JipLx4wzMwsi2sYgGsYrmGYjTLXMMzMrCoeMLI0pQN0aEoHmKfGud0aM0GduZwpT42Z+uIB\n", "w8zMsriGAbiG4RqG2ShzDcPMzKriASNLUzpAh6Z0gHlqnNutMRPUmcuZ8tSYqS8eMMzMLItrGIBr\n", "GK5hmI0y1zDMzKwqHjCyNKUDdGhKB5inxrndGjNBnbmcKU+NmfqSNWBIOi3pG5KeljSZ+lZJOizp\n", "hKRDkla2tt8h6aSk45I2tfo3SDqa1t2//A/HzMyGJauGIek7wIaIeKHVtxt4PiJ2S9oGXBIR2yWt\n", "Bx4GrgUuBx4H1kVEpMHmnoiYlHQAeCAiDs45lmsYPR/bNQyz0VZjDWNumFuAvam9F7gttW8F9kXE\n", "yxFxGjgFbJS0Brg4IibTdg+19jEzs8rlDhgBPC7pzyV9JPWtjojp1J4GVqf2ZcCZ1r5nGFxpzO2f\n", "Sv0joCkdoENTOsA8Nc7t1pgJ6szlTHlqzNSXFZnbvT8ivifpbwKHJR1vr0zTTcs4p3IXMJbaK4Fx\n", "YCItN+nnci6/1Dp21/ojQz5+27C2X2h58AKIiGamDfBGWQbGJVWTZ+6bTS15al2mzt/fOOmFVPj5\n", "M8HsG2Uvzvl7GJLuZfAO+xFgIiLOpummJyLiKknbASJiV9r+IHAv8Gza5urUfwdwfUTcPef+XcPo\n", "+diuYZiNtmpqGJIulHRxal8EbAKOAo8CW9JmW4BHUvtR4HZJF0haC6wDJiPiLPAjSRslCbiztY+Z\n", "mVUup4axGvhjSUeAJ4E/iIhDwC7gJkkngBvSMhFxDNgPHAMeA7bG7GXMVuBB4CRwau4npOrVlA7Q\n", "oSkdYJ4a53ZrzAR15nKmPDVm6suSNYyI+A6DObu5/S8ANy6wz05gZ0f/U8A15x7TzMxK8/+SAlzD\n", "cA3DbJRVU8MwMzMDDxiZmtIBOjSlA8xT49xujZmgzlzOlKfGTH3xgGFmZllcwwBcw3ANw2yUuYZh\n", "ZmZV8YCRpSkdoENTOsA8Nc7t1pgJ6szlTHlqzNQXDxhmZpbFNQzANQzXMMxGmWsYZmZWFQ8YWZrS\n", "ATo0pQPMU+Pcbo2ZoM5czpSnxkx98YBhZmZZXMMAXMNwDcNslLmGYWZmVfGAkaUpHaBDUzrAPDXO\n", "7daYCerM5Ux5aszUFw8YZmaWxTUMwDUM1zDMRplrGGZmVhUPGFma0gE6NKUDzFPj3G6NmaDOXM6U\n", "p8ZMfckaMCS9VdLTkr6clldJOizphKRDkla2tt0h6aSk45I2tfo3SDqa1t2//A/FzMyGKauGIekT\n", "wAbg4oi4RdJu4PmI2C1pG3BJRGyXtB54GLgWuBx4HFgXESFpErgnIiYlHQAeiIiDHcdyDaPnY7uG\n", "YTbaqqlhSLoC+EXgQQbvbAC3AHtTey9wW2rfCuyLiJcj4jRwCtgoaQ2DwWYybfdQax8zMxsBOVNS\n", "nwJ+A3i11bc6IqZTexpYndqXAWda251hcKUxt38q9Y+IpnSADk3pAPPUOLdbYyaoM5cz5akxU19W\n", "LLZS0i8Bz0XE0wudpDTdtMzzKXcBY6m9EhgHZg7fpJ/LufxS69hd648M+fhtw9p+oeXBCyAimpk2\n", "wBtlGRiXVE2eua+jWvLUukydv79x0gup8PNngtk3yl4sWsOQtBO4E3gFeAfwU8CXGNQoJiLibJpu\n", "eiIirpK0HSAidqX9DwL3As+mba5O/XcA10fE3R3HdA2j52O7hmE22qqoYUTEb0bElRGxFrgd+EpE\n", "3Ak8CmxJm20BHkntR4HbJV0gaS2wDpiMiLPAjyRtlCQGg9AjmJnZyDjX72HM/Bm8C7hJ0gnghrRM\n", "RBwD9gPHgMeArTF7CbOVQeH8JHCq6xNS9WpKB+jQlA4wT41zuzVmgjpzOVOeGjP1ZdEaRltEfBX4\n", "amq/ANy4wHY7gZ0d/U8B15xfTDMzK83/SwpwDcM1DLNRVkUNw8zMbIYHjCxN6QAdmtIB5qlxbrfG\n", "TFBnLmfKU2OmvnjAMDOzLK5hAK5huIZhNspcwzAzs6p4wMjSlA7QoSkdYJ4a53ZrzAR15nKmPDVm\n", "6osHDDMzy+IaBuAahmsYZqPMNQwzM6uKB4wsTekAHZrSAeapcW63xkxQZy5nylNjpr54wDAzsyyu\n", "YQCuYbiGYTbKXMMwM7OqeMDI0pQO0KEpHWCeGud2a8wEdeZypjw1ZuqLBwwzM8viGgbgGoZrGGaj\n", "zDUMMzOrigeMLE3pAB2a0gHmqXFut8ZMUGcuZ8pTY6a+LDpgSHqHpCclHZH0jKT7Uv8qSYclnZB0\n", "SNLK1j47JJ2UdFzSplb/BklH07r7h/aIzMxsKJasYUi6MCJ+LGkF8CfAx4F/CjwfEbslbQMuiYjt\n", "ktYDDwPXApcDjwPrIiIkTQL3RMSkpAPAAxFxsON4rmH0fGzXMMxGWzU1jIj4cWpeALyNwTvbLcDe\n", "1L8XuC21bwX2RcTLEXEaOAVslLQGuDgiJtN2D7X2MTOzEbDkgCHpLZKOANPAofSmvzoiptMm08Dq\n", "1L4MONPa/QyDK425/VOpf0Q0pQN0aEoHmKfGud0aM0GduZwpT42Z+rJiqQ0i4lVgXNK7gd+X9DNz\n", "1sdgGmk53QWMpfZKYByYSMtN+rmcyy+1jt21/siQj982rO0XWh68ACKimWkDvFGWGTx3q8kz982m\n", "ljy1LlPn72+c9EIq/PyZYPaNshfn9D0MSf8a+DHwEWAiIs6m6aYnIuIqSdsBImJX2v4gcC/wbNrm\n", "6tR/B3B9RNzdcQzXMHo+tmsYZqOtihqGpPfMfAJK0juBm4BvAY8CW9JmW4BHUvtR4HZJF0haC6wD\n", "JiPiLPAjSRslCbiztY+ZmY2ApWoYa4CvSPo6MMmghnEA2AXcJOkEcENaJiKOAfuBY8BjwNaYvYTZ\n", "CjwInAROdX1Cql5N6QAdmtIB5qlxbrfGTFBnLmfKU2Omvixaw4iIo8DPdvS/ANy4wD47gZ0d/U8B\n", "15xfTDMzK83/SwpwDcM1DLNRVkUNw8zMbIYHjCxN6QAdmtIB5qlxbrfGTFBnLmfKU2OmvnjAMDOz\n", "LK5hAK5huIZhNspcwzAzs6p4wMjSlA7QoSkdYJ4a53ZrzAR15nKmPDVm6osHDDMzy+IaBuAahmsY\n", "ZqPMNQwzM6uKB4wsTekAHZrSAeapcW63xkxQZy5nylNjpr54wDAzsyyuYQCuYbiGYTbKXMMwM7Oq\n", "eMDI0pQO0KEpHWCeGud2a8wEdeZypjw1ZuqLBwwzM8viGgbgGoZrGGajzDUMMzOrigeMLE3pAB2a\n", "0gHmqXFut8ZMUGcuZ8pTY6a+LDlgSLpS0hOSvinpGUkfS/2rJB2WdELSIUkrW/vskHRS0nFJm1r9\n", "GyQdTevuH85DMjOzYViyhiHpUuDSiDgi6V3AU8BtwK8Cz0fEbknbgEsiYruk9cDDwLXA5cDjwLqI\n", "CEmTwD0RMSnpAPBARBycczzXMHo+tmsYZqOtmhpGRJyNiCOp/RLwLQYDwS3A3rTZXgaDCMCtwL6I\n", "eDkiTgOngI2S1gAXR8Rk2u6h1j5mZla5c6phSBoD3gc8CayOiOm0ahpYndqXAWdau51hMMDM7Z9K\n", "/SOgKR2gQ1M6wDw1zu3WmAnqzOVMeWrM1JcVuRum6ajfAz4eEX8pzV79pOmmZZxTuQsYS+2VwDgw\n", "kZab9HM5l19qHbtr/ZEhH79tWNsvtDx4AUREM9MGeKMsA+OSqskz982mljy1LlPn72+c9EIq/PyZ\n", "YPaNshdZ38OQ9DbgD4DHIuK3U99xYCIizqbppici4ipJ2wEiYlfa7iBwL/Bs2ubq1H8HcH1E3D3n\n", "WK5h9Hxs1zDMRls1NQwNLiU+CxybGSySR4Etqb0FeKTVf7ukCyStBdYBkxFxFviRpI3pPu9s7WNm\n", "ZpXLqWG8H/gV4BckPZ1um4FdwE2STgA3pGUi4hiwHzgGPAZsjdnLmK3Ag8BJ4NTcT0jVqykdoENT\n", "OsA8Nc7t1pgJ6szlTHlqzNSXJWsYEfEnLDyw3LjAPjuBnR39TwHXnEtAMzOrg/+XFOAahmsYZqOs\n", "mhqGmZkZeMDI1JQO0KEpHWCeGud2a8wEdeZypjw1ZuqLBwwzM8viGgbgGoZrGGajzDUMMzOrigeM\n", "LE3pAB2aZbsnSVHqtmwPYuHHNjHsY5yPGnM5U54aM/XFA4YxmA5bjtsT57i9mY0S1zCAN3sNw/UT\n", "s9HmGoaZmVXFA0aWpnSADk3pAB2a0gHmqXW+ucZczpSnxkx98YBhZmZZXMMAXMNwDcNslLmGYWZm\n", "VfGAkaUpHaBDUzpAh6Z0gHlqnW+uMZcz5akxU188YJiZWRbXMADXMFzDMBtlrmGYmVlVlhwwJH1O\n", "0rSko62+VZIOSzoh6ZCkla11OySdlHRc0qZW/wZJR9O6+5f/oQxTUzpAh6Z0gA5N6QDz1DrfXGMu\n", "Z8pTY6a+5Fxh/A6weU7fduBwRLwX+KO0jKT1wIeA9WmfT0uauUz6DPDhiFgHrJM09z7NzKxiWTUM\n", "SWPAlyPimrR8HLg+IqYlXQo0EXGVpB3AqxHxybTdQeA+4FngKxFxdeq/HZiIiLs7juUaxpvo2K5h\n", "mL1+tdcwVkfEdGpPA6tT+zLgTGu7M8DlHf1Tqd/MzEbE6y56x+ASpa6PWi27pnSADk3pAB2a0gHm\n", "qXW+ucZczpSnxkx9WXGe+01LujQizkpaAzyX+qeAK1vbXcHgymIqtdv9Uwvf/V3AWGqvBMaBibTc\n", "pJ/LufxS69hd648M+fhtw9p+oeWZvvPd//Utz7z4IqIZxjIwLmlo93++yzNqyVPrMnX+/sZJT+TC\n", "z58JZt8oe3G+NYzdwA8i4pOStgMrI2J7Kno/DFzHYMrpceCnIyIkPQl8DJgE/hB4ICIOdhzLNYw3\n", "0bFdwzB7/fqqYSx5hSFpH3A98B5J3wX+DbAL2C/pw8Bp4JcBIuKYpP3AMeAVYGvMjkhbgT3AO4ED\n", "XYOFmZnVy9/0Bpa+wmh47RTOcjufv/IblifTcl5hNJxbpuFfYUiaaE1vVKPGXM6Up9JMVX9KyszM\n", "3mR8hQG4huEahtko8xWGmZlVxQNGlqZ0gA5N6QAdmtIB5qn1M/M15nKmPDVm6osHDDMzy+IaBuAa\n", "hmsYZqPMNQwzM6uKB4wsTekAHZrSATo0pQPMU+t8c425nClPjZn64gHDzMyyuIYBuIZR8tjluH5i\n", "bxTV/C8ps+F6cw5WZqPIU1JZmtIBOjSlA3RoSgfo0JQO0KnGeXBnylNjpr54wDAzsyyuYQCuYbw5\n", "j+0ahr1R+HsYZmZWFQ8YWZrSATo0pQN0aEoH6NCUDtCpxnlwZ8pTY6a+eMAwM7MsrmEArmG8OY/t\n", "Goa9UbiGYWZmVel9wJC0WdJxSSclbev7+OenKR2gQ1M6QIemdIAOTekAnWqcB3emPDVm6kuvA4ak\n", "twL/DtgMrAfukHR1nxnOz5HSATo4U56FM0mKUjdgvL9zkM2Z8tSYqRd9X2FcB5yKiNMR8TLwBeDW\n", "njOchx+WDtDBmfIslikK3YBB0aw2zpSnxky96HvAuBz4bmv5TOoze7O5t+DVjdl56fufD2Y+WW94\n", "cbgx5npZwE8tvP50X0HOwenSATqcLh2gw+nSARawBdhT4LiLfpBmrKcQ52KsdIAOY6UDlNLrx2ol\n", "/RxwX0RsTss7gFcj4pOtbfwXkJnZOerjY7V9DxgrgP8B/GPgL4BJ4I6I+FZvIczM7Lz0OiUVEa9I\n", "ugf4L8Bbgc96sDAzGw3VfdPbzMwqFRFV3Bh8N+M4cBLYNqRjnAa+ATwNTKa+VcBh4ARwCFjZ2n5H\n", "ynMc2NTq3wAcTevub/W/HfhPqf9Pgb/TkeFzwDRwtNXXSwYGldYT6fbPlsh0H4NPsT2dbjf3nOlK\n", "4Angm8AzwMdKn6tFMhU7V8A7gCcZfOHkGQY1wqLnaYlcxc5Va91b07G/XMO5WiBT8fPU+R56rm+6\n", "w7ilk3WKwacP3paeZFcP4TjfAVbN6dsN/IvU3gbsSu31KcfbUq5TzF6RTQLXpfYBYHNqbwU+ndof\n", "Ar7QkeEDwPt47Zvz0DOkF8W3GXyGfOVMe5FM9wKf6MjfV6ZLgfHUfheD2tfVJc/VIplKn6sL088V\n", "DN4QNpY8T63H35Wr6LlK6z8B/C7waA2vvwUyFT9PXbda/pdUn1/om/tJgluAvam9F7gttW8F9kXE\n", "yxFxmsEvZqOkNcDFETGZtnuotU/7vn6PQXH/NSLij4H/XSDDB4FDEfHDiPghg7+oNi+SCbo/g9lX\n", "prMRcSS1XwK+xeA7O8XO1SKZSp+rH6dtLmDwRhIlz9PMg18gV9FzJekK4BeBB1s5ip6rBTKp5Hla\n", "SC0DRl9f6AvgcUl/LukjqW91REyn9jSwOrUvSznmZprbP9XK+pPHERGvAC9KWpWRa9gZ/sYi97WY\n", "j0r6uqTPSpr5dmvvmSSNMbgCepJKzlUr05+mrmLnStJbJB1J5+NQetMofp4WyFX0XAGfAn4DeLW1\n", "vvS56soUVPL6a6tlwIilN1kW74+I9wE3A78m6QOvCTG4TusrS6caMiSfAdYy+L853wN+q0QISe9i\n", "8FfRxyPiL9vrSp2rlOmLKdNLFD5XEfFqRIwDVzD4a/Nn5qwvcp46cv19Cp4rSb8EPBcRT7PANxj7\n", "PleLZKri9TdXLQPGFIOC4owree3Itywi4nvp5/eB32cwFTYt6VKAdFn33AKZrkiZplJ7bv/MPn87\n", "3dcK4N0R8UJGtGFn+EHHfS16jiPiuUgYXCpf13cmSW9jMFh8PiIeSd1Fz1Ur03+cyVTDuUo5XmRQ\n", "lP9g6fO0QK7Nhc/VPwJukfQdYB9wg6TPFz5XXZkequU5NU+8zkLyctwYFMW+zaCIcwFDKHoDFzKY\n", "4wO4CPhvwCYGBa9tqX878wteFzAY6b/NbHHpSQYFPDG/uPSZ1L6djqJ3WjfG/KL3UDMwKHD9TwbF\n", "rUtm2otkWtNq/zrwcJ+Z0n08BHxqzrkrdq4WyVTsXAHvaZ2zdwL/lcF8eNHn1CK5Li35vGod+3pm\n", "P5FU/PXXkano62/B99HlfFN+nW/oNzP41MkpYMcQ7n9tOtEzH/Pb0Tppj9P9kbrfTHmOAx9s9c98\n", "fO0U8ECr/+3AfmY/vjbWkWMfg2+5/xWDecVf7StDOtbJdNuySKZ/zuCN8RvA14FHGMzz9pnp5xnM\n", "6R5h9qOFm0ueqwUy3VzyXAHXAF9Lxz4K/Ks+n9eL/P4WylX0edVafz2zn0gqeq5a6ydamT5fw3ma\n", "e/MX98zMLEstNQwzM6ucBwwzM8viAcPMzLJ4wDAzsyweMMzMLIsHDDMzy+IBw8zMsnjAMDOzLP8f\n", "BclnuC8CfEMAAAAASUVORK5CYII=\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "df['TOTAL EARNINGS'].hist()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#How easy or hard is it? What skills do you need to become proficient in it?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "If you are familiar with python, its pretty much just picking up a new library. It might take a while to get comfortable with the dataframe data structure (Pandas documentation is not super helpful), but once you've gotten the hang of its indexing notation and the oodles of incredibly useful methods for wrangling data its a very easy and powerful tool." ] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "#Would you recommend this to a friend? Will you consider using it for your final data story?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "If my friend knew Python or needed to do some more advanced data analysis, then yes. In my opinion, the main thing Pandas has going for it is that it is a Python library. It is easy-ish to use because Python is easy-ish to use. Its main advantages just come from its proximity to Python, and the fact that it's the only popular data analysis package out there. I'm not really a Python programmer, but I use the DataFrames and DataArrays packages in Julia for statistical analysis relatively frequently so I imagine I will use Pandas for some of the data cleaning and analysis for my final data story as well." ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 2", "language": "python", "name": "python2" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.9" } }, "nbformat": 4, "nbformat_minor": 0 }