Data Capstone Exercise
For this capstone project we will be analyzing some 911 call data from Kaggle. The data contains the following fields:
- lat : String variable, Latitude
- lng: String variable, Longitude
- desc: String variable, Description of the Emergency Call
- zip: String variable, Zipcode
- title: String variable, Title
- timeStamp: String variable, YYYY-MM-DD HH:MM:SS
- twp: String variable, Township
- addr: String variable, Address
- e: String variable, Dummy variable (always 1)
Just go along with this notebook and try to complete the instructions or answer the questions in bold using your Python and Data Science skills!
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
Now Lets get started
Exercises
Data and Setup
** Import numpy and pandas **
import numpy as np
import pandas as pd
** Import visualization libraries and set %matplotlib inline. **
import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline
** Read in the csv file as a dataframe called df **
df = pd.read_csv("911.csv")
** Check the info() of the df **
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 99492 entries, 0 to 99491
Data columns (total 9 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 lat 99492 non-null float64
1 lng 99492 non-null float64
2 desc 99492 non-null object
3 zip 86637 non-null float64
4 title 99492 non-null object
5 timeStamp 99492 non-null object
6 twp 99449 non-null object
7 addr 98973 non-null object
8 e 99492 non-null int64
dtypes: float64(3), int64(1), object(5)
memory usage: 6.8+ MB
** Check the head of df **
df.head()
lat | lng | desc | zip | title | timeStamp | twp | addr | e | |
---|---|---|---|---|---|---|---|---|---|
0 | 40.297876 | -75.581294 | REINDEER CT & DEAD END; NEW HANOVER; Station ... | 19525.0 | EMS: BACK PAINS/INJURY | 2015-12-10 17:40:00 | NEW HANOVER | REINDEER CT & DEAD END | 1 |
1 | 40.258061 | -75.264680 | BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... | 19446.0 | EMS: DIABETIC EMERGENCY | 2015-12-10 17:40:00 | HATFIELD TOWNSHIP | BRIAR PATH & WHITEMARSH LN | 1 |
2 | 40.121182 | -75.351975 | HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... | 19401.0 | Fire: GAS-ODOR/LEAK | 2015-12-10 17:40:00 | NORRISTOWN | HAWS AVE | 1 |
3 | 40.116153 | -75.343513 | AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... | 19401.0 | EMS: CARDIAC EMERGENCY | 2015-12-10 17:40:01 | NORRISTOWN | AIRY ST & SWEDE ST | 1 |
4 | 40.251492 | -75.603350 | CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... | NaN | EMS: DIZZINESS | 2015-12-10 17:40:01 | LOWER POTTSGROVE | CHERRYWOOD CT & DEAD END | 1 |
Basic Questions
** What are the top 5 zipcodes for 911 calls? **
df["zip"].value_counts().head()
19401.0 6979
19464.0 6643
19403.0 4854
19446.0 4748
19406.0 3174
Name: zip, dtype: int64
** What are the top 5 townships (twp) for 911 calls? **
df["twp"].value_counts().head()
LOWER MERION 8443
ABINGTON 5977
NORRISTOWN 5890
UPPER MERION 5227
CHELTENHAM 4575
Name: twp, dtype: int64
** Take a look at the ‘title’ column, how many unique title codes are there? **
df["title"].nunique()
110
Creating new features
** In the titles column there are “Reasons/Departments” specified before the title code. These are EMS, Fire, and Traffic. Use .apply() with a custom lambda expression to create a new column called “Reason” that contains this string value.**
**For example, if the title column value is EMS: BACK PAINS/INJURY , the Reason column value would be EMS. **
df["Reason"] = df["title"].apply(lambda x : x.split(":")[0])
** What is the most common Reason for a 911 call based off of this new column? **
df["Reason"].value_counts()
EMS: 48877
Traffic: 35695
Fire: 14920
Name: Reason, dtype: int64
** Now use seaborn to create a countplot of 911 calls by Reason. **
sns.countplot(df["Reason"])
<AxesSubplot:xlabel='Reason', ylabel='count'>
** Now let us begin to focus on time information. What is the data type of the objects in the timeStamp column? **
print(df["timeStamp"].dtypes)
object
** You should have seen that these timestamps are still strings. Use pd.to_datetime to convert the column from strings to DateTime objects. **
df["timeStamp"] = pd.to_datetime(df["timeStamp"])
print(df["timeStamp"].dtypes)
datetime64[ns]
** You can now grab specific attributes from a Datetime object by calling them. For example:**
time = df['timeStamp'].iloc[0]
time.hour
You can use Jupyter’s tab method to explore the various attributes you can call. Now that the timestamp column are actually DateTime objects, use .apply() to create 3 new columns called Hour, Month, and Day of Week. You will create these columns based off of the timeStamp column, reference the solutions if you get stuck on this step.
df['Hour'] = df['timeStamp'].apply(lambda time: time.hour)
df['Month'] = df['timeStamp'].apply(lambda time: time.month)
df['Day of Week'] = df['timeStamp'].apply(lambda time: time.dayofweek)
** Notice how the Day of Week is an integer 0-6. Use the .map() with this dictionary to map the actual string names to the day of the week: **
dmap = {0:'Mon',1:'Tue',2:'Wed',3:'Thu',4:'Fri',5:'Sat',6:'Sun'}
dmap = {0:'Mon',1:'Tue',2:'Wed',3:'Thu',4:'Fri',5:'Sat',6:'Sun'}
df['Day of Week'] = df["Day of Week"].map(dmap)
** Now use seaborn to create a countplot of the Day of Week column with the hue based off of the Reason column. **
sns.countplot(df["Day of Week"], hue=df["Reason"])
<AxesSubplot:xlabel='Day of Week', ylabel='count'>
Now do the same for Month:
sns.countplot(df["Month"], hue=df["Reason"])
<AxesSubplot:xlabel='Month', ylabel='count'>
Did you notice something strange about the Plot?
** You should have noticed it was missing some Months, let’s see if we can maybe fill in this information by plotting the information in another way, possibly a simple line plot that fills in the missing months, in order to do this, we’ll need to do some work with pandas… **
** Now create a gropuby object called byMonth, where you group the DataFrame by the month column and use the count() method for aggregation. Use the head() method on this returned DataFrame. **
byMonth = df.groupby("Month").count()
byMonth.head()
lat | lng | desc | zip | title | timeStamp | twp | addr | e | Reason | Hour | Day of Week | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Month | ||||||||||||
1 | 13205 | 13205 | 13205 | 11527 | 13205 | 13205 | 13203 | 13096 | 13205 | 13205 | 13205 | 13205 |
2 | 11467 | 11467 | 11467 | 9930 | 11467 | 11467 | 11465 | 11396 | 11467 | 11467 | 11467 | 11467 |
3 | 11101 | 11101 | 11101 | 9755 | 11101 | 11101 | 11092 | 11059 | 11101 | 11101 | 11101 | 11101 |
4 | 11326 | 11326 | 11326 | 9895 | 11326 | 11326 | 11323 | 11283 | 11326 | 11326 | 11326 | 11326 |
5 | 11423 | 11423 | 11423 | 9946 | 11423 | 11423 | 11420 | 11378 | 11423 | 11423 | 11423 | 11423 |
** Now create a simple plot off of the dataframe indicating the count of calls per month. **
sns.lineplot(x=byMonth.index, y=byMonth["twp"])
<AxesSubplot:xlabel='Month', ylabel='twp'>
** Now see if you can use seaborn’s lmplot() to create a linear fit on the number of calls per month. Keep in mind you may need to reset the index to a column. **
sns.lmplot(data=byMonth.reset_index(), x="Month", y="twp")
<seaborn.axisgrid.FacetGrid at 0x297ed9f8670>
**Create a new column called ‘Date’ that contains the date from the timeStamp column. You’ll need to use apply along with the .date() method. **
df["Date"] = df["timeStamp"].apply(lambda x : x.date())
** Now groupby this Date column with the count() aggregate and create a plot of counts of 911 calls.**
byDate = df.groupby("Date").count()
sns.lineplot(x=byDate.index, y=byDate["twp"])
<AxesSubplot:xlabel='Date', ylabel='twp'>
** Now recreate this plot but create 3 separate plots with each plot representing a Reason for the 911 call**
byEMS = df[df["Reason"] == "EMS"].groupby("Date").count()
sns.lineplot(x=byEMS.index, y=byEMS["twp"])
plt.title('EMS')
Text(0.5, 1.0, 'EMS')
byFire = df[df["Reason"] == "Fire"].groupby("Date").count()
sns.lineplot(x=byFire.index, y=byFire["twp"])
plt.title('Fire')
Text(0.5, 1.0, 'Fire')
byTraffic = df[df["Reason"] == "Traffic"].groupby("Date").count()
sns.lineplot(x=byTraffic.index, y=byTraffic["twp"])
plt.title('Traffic')
Text(0.5, 1.0, 'Traffic')
** Now let’s move on to creating heatmaps with seaborn and our data. We’ll first need to restructure the dataframe so that the columns become the Hours and the Index becomes the Day of the Week. There are lots of ways to do this, but I would recommend trying to combine groupby with an unstack method. Reference the solutions if you get stuck on this!**
dayHour = df.groupby(by=['Day of Week','Hour']).count()["Reason"].unstack()
dayHour
Hour | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ... | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Day of Week | |||||||||||||||||||||
Fri | 275 | 235 | 191 | 175 | 201 | 194 | 372 | 598 | 742 | 752 | ... | 932 | 980 | 1039 | 980 | 820 | 696 | 667 | 559 | 514 | 474 |
Mon | 282 | 221 | 201 | 194 | 204 | 267 | 397 | 653 | 819 | 786 | ... | 869 | 913 | 989 | 997 | 885 | 746 | 613 | 497 | 472 | 325 |
Sat | 375 | 301 | 263 | 260 | 224 | 231 | 257 | 391 | 459 | 640 | ... | 789 | 796 | 848 | 757 | 778 | 696 | 628 | 572 | 506 | 467 |
Sun | 383 | 306 | 286 | 268 | 242 | 240 | 300 | 402 | 483 | 620 | ... | 684 | 691 | 663 | 714 | 670 | 655 | 537 | 461 | 415 | 330 |
Thu | 278 | 202 | 233 | 159 | 182 | 203 | 362 | 570 | 777 | 828 | ... | 876 | 969 | 935 | 1013 | 810 | 698 | 617 | 553 | 424 | 354 |
Tue | 269 | 240 | 186 | 170 | 209 | 239 | 415 | 655 | 889 | 880 | ... | 943 | 938 | 1026 | 1019 | 905 | 731 | 647 | 571 | 462 | 274 |
Wed | 250 | 216 | 189 | 209 | 156 | 255 | 410 | 701 | 875 | 808 | ... | 904 | 867 | 990 | 1037 | 894 | 686 | 668 | 575 | 490 | 335 |
7 rows × 24 columns
** Now create a HeatMap using this new DataFrame. **
sns.heatmap(dayHour)
<AxesSubplot:xlabel='Hour', ylabel='Day of Week'>
** Now create a clustermap using this DataFrame. **
sns.clustermap(dayHour)
<seaborn.matrix.ClusterGrid at 0x297f0e37970>
** Now repeat these same plots and operations, for a DataFrame that shows the Month as the column. **
dayMonth = df.groupby(by=['Day of Week','Month']).count()["Reason"].unstack()
dayMonth
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 12 |
---|---|---|---|---|---|---|---|---|---|
Day of Week | |||||||||
Fri | 1970 | 1581 | 1525 | 1958 | 1730 | 1649 | 2045 | 1310 | 1065 |
Mon | 1727 | 1964 | 1535 | 1598 | 1779 | 1617 | 1692 | 1511 | 1257 |
Sat | 2291 | 1441 | 1266 | 1734 | 1444 | 1388 | 1695 | 1099 | 978 |
Sun | 1960 | 1229 | 1102 | 1488 | 1424 | 1333 | 1672 | 1021 | 907 |
Thu | 1584 | 1596 | 1900 | 1601 | 1590 | 2065 | 1646 | 1230 | 1266 |
Tue | 1973 | 1753 | 1884 | 1430 | 1918 | 1676 | 1670 | 1612 | 1234 |
Wed | 1700 | 1903 | 1889 | 1517 | 1538 | 2058 | 1717 | 1295 | 1262 |
sns.heatmap(dayMonth)
<AxesSubplot:xlabel='Month', ylabel='Day of Week'>
sns.clustermap(dayMonth)
<seaborn.matrix.ClusterGrid at 0x297f15efe20>
Continue exploring the Data however you see fit!
Leave a comment