In [1]:
import pandas as pd
In [2]:
%matplotlib inline
In [3]:
pd.set_option('display.max_rows', 1000)
pd.set_option('display.max_columns', 1000)
In [4]:
df = pd.read_csv('fire-incidents.csv')
/Users/koverholt/anaconda3/lib/python3.5/site-packages/IPython/core/interactiveshell.py:2902: DtypeWarning: Columns (6,10,16,17,18,20) have mixed types. Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
In [5]:
df.head(3)
Out[5]:
INCIDENT NUMBER
EXPOSURE NUMBER
DISPATCH DATE
DISPATCH TIME
INCIDENT TYPE
INCIDENT DESCRIPTION
STREET NUMBER
STREET PREFIX
STREET NAME
STREET TYPE
STREET SUFFIX
FORMATTED STREET
CITY
STATE
ZIP
APARTMENT
CROSS STREET PREFIX
CROSS STREET NAME
CROSS STREET TYPE
CROSS STREET SUFFIX
RURAL
PROPERTY LOSS
CONTENTS LOSS
FIRE SERVICE FATALITY
FIRE SERVICE INJURY
CIVILIAN FATALITY
CIVILIAN INJURY
PROPERTY VALUE
CONTENTS VALUE
ALARMS
SUPPRESSION APPARATUS
SUPPRESSION PERSONNEL
EMS APPARATUS
EMS PERSONNEL
RESCUE APPARATUS
RESCUE PERSONNEL
OTHER APPARATUS
OTHER PERSONNEL
CONTROL DATE
CONTROL TIME
CLEAR DATE
CLEAR TIME
CAUSE OF IGNITION
CAUSE OF IGNITION DESCRIPTION
GEOLOCATION
0
16-0006576
0
03/18/2016
03:27:34
745.0
Alarm system activation, no fire - unintentional
9350
NaN
CORTANA
PL
NaN
9350 CORTANA PL
BATON ROUGE
LA
70815
NaN
NaN
NaN
NaN
NaN
NaN
0
0
0
0
0
0
0
0
1
4
0
0
0
0
0
0
0
NaN
NaN
03/18/2016
03:37:15
NaN
NaN
9350 CORTANA PL\nBATON ROUGE, LA 70815\n(30.46...
1
16-0006575
0
03/18/2016
03:16:26
321.0
EMS call, excluding vehicle accident with injury
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
NaN
NaN
03/18/2016
03:29:46
NaN
NaN
NaN
2
16-0006574
0
03/18/2016
02:45:30
700.0
False alarm or false call, Other
262
W
STATE
ST
NaN
262 W STATE ST
BATON ROUGE
LA
70802
A
NaN
NaN
NaN
NaN
NaN
0
0
0
0
0
0
0
0
1
10
0
0
0
0
0
0
0
NaN
NaN
03/18/2016
02:56:30
NaN
NaN
262 W STATE ST\nBATON ROUGE, LA 70802\n(30.418...
In [6]:
df.shape
Out[6]:
(128085, 45)
We can list the columns in the dataset:
In [7]:
df.columns
Out[7]:
Index(['INCIDENT NUMBER', 'EXPOSURE NUMBER', 'DISPATCH DATE', 'DISPATCH TIME',
'INCIDENT TYPE', 'INCIDENT DESCRIPTION', 'STREET NUMBER',
'STREET PREFIX', 'STREET NAME', 'STREET TYPE', 'STREET SUFFIX',
'FORMATTED STREET', 'CITY', 'STATE', 'ZIP', 'APARTMENT',
'CROSS STREET PREFIX', 'CROSS STREET NAME', 'CROSS STREET TYPE',
'CROSS STREET SUFFIX', 'RURAL', 'PROPERTY LOSS', 'CONTENTS LOSS',
'FIRE SERVICE FATALITY', 'FIRE SERVICE INJURY', 'CIVILIAN FATALITY',
'CIVILIAN INJURY', 'PROPERTY VALUE', 'CONTENTS VALUE', 'ALARMS',
'SUPPRESSION APPARATUS', 'SUPPRESSION PERSONNEL', 'EMS APPARATUS',
'EMS PERSONNEL', 'RESCUE APPARATUS', 'RESCUE PERSONNEL',
'OTHER APPARATUS', 'OTHER PERSONNEL', 'CONTROL DATE', 'CONTROL TIME',
'CLEAR DATE', 'CLEAR TIME', 'CAUSE OF IGNITION',
'CAUSE OF IGNITION DESCRIPTION ', 'GEOLOCATION'],
dtype='object')
In [8]:
df['DISPATCH DATE'] = pd.to_datetime(df['DISPATCH DATE'])
df['DISPATCH TIME'] = pd.to_datetime(df['DISPATCH TIME'])
In [9]:
df['DISPATCH DATE'].min()
Out[9]:
Timestamp('2012-01-01 00:00:00')
In [10]:
df['DISPATCH DATE'].max()
Out[10]:
Timestamp('2016-03-18 00:00:00')
Let's look at a sorted list of the 10 most frequent types of incidents:
In [11]:
pd.value_counts(df['INCIDENT DESCRIPTION']).head(10)
Out[11]:
Medical assist, assist EMS crew 67160
Good intent call, Other 20060
Alarm system activation, no fire - unintentional 6316
Dispatched & cancelled en route 5490
Public service 5335
Motor Vehicle Accident with no injuries 3527
EMS call, excluding vehicle accident with injury 3463
Emergency medical service, other 2754
Motor vehicle accident with injuries 1936
Building fire 1353
Name: INCIDENT DESCRIPTION, dtype: int64
In [12]:
pd.value_counts(df['INCIDENT DESCRIPTION'], normalize=True).head(10).plot(kind='bar')
Out[12]:
<matplotlib.axes._subplots.AxesSubplot at 0x116fdb240>
Let's group the incidents by year
In [13]:
incidents_by_year = df.groupby(df['DISPATCH DATE'].dt.year)
In [14]:
incidents_by_year.size().plot(kind='bar')
Out[14]:
<matplotlib.axes._subplots.AxesSubplot at 0x116fdbef0>
In [15]:
incidents_by_year.sum()
Out[15]:
EXPOSURE NUMBER
INCIDENT TYPE
CROSS STREET SUFFIX
PROPERTY LOSS
CONTENTS LOSS
FIRE SERVICE FATALITY
FIRE SERVICE INJURY
CIVILIAN FATALITY
CIVILIAN INJURY
PROPERTY VALUE
CONTENTS VALUE
ALARMS
SUPPRESSION APPARATUS
SUPPRESSION PERSONNEL
EMS APPARATUS
EMS PERSONNEL
RESCUE APPARATUS
RESCUE PERSONNEL
OTHER APPARATUS
OTHER PERSONNEL
DISPATCH DATE
2012
18
12771015.0
NaN
14156702
3716834
0
8
1
3
151371792
5021239
29934
13204
1605
22282
5254
949
130
10485
1732
2013
23
11970537.0
NaN
15103859
6719323
0
2
1
7
94803843
19080027
28923
10980
550
21541
3145
828
46
12057
825
2014
13
12255092.0
NaN
14843551
4452393
0
1
8
5
30286850
17097802
30348
11458
1035
22874
4239
920
52
12023
837
2015
37
13146490.0
NaN
12132481
3065428
0
1
6
10
67995052
1402502
32383
12487
924
24347
4201
1197
78
12788
871
2016
4
2595103.0
NaN
2387551
766247
0
0
2
1
4062500
1265701
6516
2451
132
4933
855
333
24
2808
215
We can then look at the frequency of incidents that occured per year
In [16]:
incidents_by_type = incidents_by_year['INCIDENT DESCRIPTION']
In [17]:
incidents_by_type.value_counts()
Out[17]:
DISPATCH DATE INCIDENT DESCRIPTION
2012 Medical assist, assist EMS crew 14339
Good intent call, Other 5702
Dispatched & cancelled en route 1459
Alarm system activation, no fire - unintentional 1314
EMS call, excluding vehicle accident with injury 1166
Public service 946
EMS call, party transported by non-fire agency 807
Motor Vehicle Accident with no injuries 772
Motor vehicle accident with injuries 475
Building fire 359
False alarm or false call, Other 278
Passenger vehicle fire 235
Smoke scare, odor of smoke 192
Emergency medical service, other 166
Trash or rubbish fire, contained 154
Hazardous condition, Other 137
Public service assistance, Other 112
Lock-in (if lock out , use 511 ) 94
No Incident found on arrival at dispatch address 91
Assist police or other governmental agency 64
Police matter 64
Alarm system sounded due to malfunction 58
Electrical wiring/equipment problem, Other 54
Power line down 50
System malfunction, Other 50
Cooking fire, confined to container 48
Gasoline or other flammable liquid spill 45
Motor vehicle/pedestrian accident (MV Ped) 40
Arcing, shorted electrical equipment 38
Smoke or odor removal 38
Grass fire 37
Service Call, other 31
Smoke detector activation, no fire - unintentional 30
Fire, Other 29
Malicious, mischievous false call, Other 28
Rescue, EMS incident, other 28
Outside rubbish fire, Other 24
Unauthorized burning 24
Gas leak (natural gas or LPG) 22
Dumpster or other outside trash receptacle fire 21
Assist invalid 19
Outside rubbish, trash or waste fire 18
Heat from short circuit (wiring), defective/worn 17
Lock-out 16
Person in distress, Other 14
Removal of victim(s) from stalled elevator 14
Wrong location 13
Special type of incident, Other 12
Smoke detector activation due to malfunction 10
Detector activation, no fire - unintentional 9
Unintentional transmission of alarm, Other 9
Fires in structure other than in a building 8
Overheated motor 8
Steam, Other gas mistaken for smoke, Other 8
Steam, vapor, fog or dust thought to be smoke 8
Sprinkler activation, no fire - unintentional 7
Telephone, malicious false alarm 7
Cover assignment, standby, moveup 6
Mobile property (vehicle) fire, Other 6
Road freight or transport vehicle fire 6
Accident, potential accident, Other 5
Special outside fire, Other 5
Chimney or flue fire, confined to chimney or flue 4
Extrication of victim(s) from vehicle 4
Attempted burning, illegal action, Other 3
Central station, malicious false alarm 3
Extrication, rescue, Other 3
HazMat release investigation w/no HazMat 3
Local alarm system, malicious false alarm 3
Municipal alarm system, malicious false alarm 3
Natural vegetation fire, Other 3
Off-road vehicle or heavy equipment fire 3
Outside storage fire 3
Smoke from barbecue, tar kettle 3
Building or structure weakened or collapsed 2
Combustible/flammable gas/liquid condition, other 2
Fire in portable building, fixed location 2
Forest, woods or wildland fire 2
Incinerator overload or malfunction, fire confined 2
Oil or other combustible liquid spill 2
Outside equipment fire 2
Search for lost person, other 2
Severe weather or natural disaster, Other 2
Water or steam leak 2
Wind storm, tornado/hurricane assessment 2
Attempt to burn 1
Bomb scare - no bomb 1
Breakdown of light ballast 1
Brush or brush-and-grass mixture fire 1
Camper or recreational vehicle (RV) fire 1
Chemical spill or leak 1
Citizen complaint 1
Commercial Compactor fire, confined to rubbish 1
Confined space rescue 1
Explosive, bomb removal (for bomb scare, use 721) 1
Fire in mobile home used as fixed residence 1
Fire in motor home, camper, recreational vehicle 1
Fuel burner/boiler malfunction, fire confined 1
Heat detector activation due to malfunction 1
Lightning strike (no fire) 1
Outside gas or vapor combustion explosion 1
Outside stationary compactor/compacted trash fire 1
Overpressure rupture, explosion, overheat other 1
Search for person in water 1
Self-propelled motor home or recreational vehicle 1
Swimming/recreational water areas rescue 1
Toxic condition, Other 1
Vehicle accident, general cleanup 1
Water problem, Other 1
2013 Medical assist, assist EMS crew 15183
Good intent call, Other 4747
Alarm system activation, no fire - unintentional 1465
Public service 1176
Dispatched & cancelled en route 1160
EMS call, excluding vehicle accident with injury 798
Motor Vehicle Accident with no injuries 720
Emergency medical service, other 542
Motor vehicle accident with injuries 492
EMS call, party transported by non-fire agency 367
Building fire 294
False alarm or false call, Other 236
Passenger vehicle fire 195
Smoke scare, odor of smoke 165
Trash or rubbish fire, contained 149
Hazardous condition, Other 132
Lock-in (if lock out , use 511 ) 108
Assist police or other governmental agency 79
Public service assistance, Other 66
Rescue, EMS incident, other 66
No Incident found on arrival at dispatch address 59
Motor vehicle/pedestrian accident (MV Ped) 47
Gasoline or other flammable liquid spill 39
Cooking fire, confined to container 38
System malfunction, Other 34
Smoke or odor removal 30
Grass fire 28
Police matter 28
Service Call, other 28
Alarm system sounded due to malfunction 26
Power line down 23
Arcing, shorted electrical equipment 22
Fire, Other 22
Gas leak (natural gas or LPG) 21
Electrical wiring/equipment problem, Other 19
Assist invalid 17
Person in distress, Other 17
Smoke detector activation, no fire - unintentional 16
Wrong location 16
Dumpster or other outside trash receptacle fire 14
Outside rubbish, trash or waste fire 13
Heat from short circuit (wiring), defective/worn 12
Malicious, mischievous false call, Other 12
Special type of incident, Other 12
Unauthorized burning 12
Lock-out 11
Fires in structure other than in a building 10
Outside rubbish fire, Other 10
Brush or brush-and-grass mixture fire 8
Unintentional transmission of alarm, Other 8
Mobile property (vehicle) fire, Other 7
Removal of victim(s) from stalled elevator 7
Road freight or transport vehicle fire 6
Smoke detector activation due to malfunction 6
Steam, vapor, fog or dust thought to be smoke 6
Extrication of victim(s) from vehicle 5
Natural vegetation fire, Other 5
Cover assignment, standby, moveup 4
Detector activation, no fire - unintentional 4
Excessive heat, scorch burns with no ignition 4
Incinerator overload or malfunction, fire confined 4
Steam, Other gas mistaken for smoke, Other 4
Authorized controlled burning 3
HazMat release investigation w/no HazMat 3
Local alarm system, malicious false alarm 3
Overheated motor 3
Sprinkler activation, no fire - unintentional 3
Vehicle accident, general cleanup 3
Chemical spill or leak 2
Fire in mobile home used as fixed residence 2
Off-road vehicle or heavy equipment fire 2
Outside equipment fire 2
Outside storage fire 2
Overpressure rupture from air or gas, Other 2
Ring or jewelry removal 2
Smoke from barbecue, tar kettle 2
Telephone, malicious false alarm 2
Water or steam leak 2
Water vehicle fire 2
Accident, potential accident, Other 1
Aircraft standby 1
Animal rescue 1
Breakdown of light ballast 1
CO detector activation due to malfunction 1
Camper or recreational vehicle (RV) fire 1
Carbon monoxide incident 1
Chemical hazard (no spill or leak) 1
Citizen complaint 1
Combustible/flammable gas/liquid condition, other 1
Defective elevator, no occupants 1
Direct tie to FD, malicious false alarm 1
Extinguishing system activation 1
Extrication, rescue, Other 1
Fire in portable building, fixed location 1
Heat detector activation due to malfunction 1
High-angle rescue 1
Oil or other combustible liquid spill 1
Outside gas or vapor combustion explosion 1
Rail vehicle fire 1
Search for lost person, other 1
Search for person in water 1
Severe weather or natural disaster, Other 1
Special outside fire, Other 1
Toxic condition, Other 1
2014 Medical assist, assist EMS crew 16519
Good intent call, Other 4247
Alarm system activation, no fire - unintentional 1600
Public service 1325
Dispatched & cancelled en route 1157
Motor Vehicle Accident with no injuries 823
Emergency medical service, other 734
EMS call, excluding vehicle accident with injury 695
Motor vehicle accident with injuries 456
Building fire 316
Rescue, EMS incident, other 248
False alarm or false call, Other 220
Passenger vehicle fire 204
Hazardous condition, Other 189
Trash or rubbish fire, contained 172
Smoke scare, odor of smoke 135
EMS call, party transported by non-fire agency 131
Lock-in (if lock out , use 511 ) 114
No Incident found on arrival at dispatch address 96
Grass fire 68
Public service assistance, Other 58
Motor vehicle/pedestrian accident (MV Ped) 52
Gasoline or other flammable liquid spill 49
Assist police or other governmental agency 47
Cooking fire, confined to container 42
Smoke or odor removal 40
Service Call, other 36
Power line down 31
Smoke detector activation, no fire - unintentional 31
Electrical wiring/equipment problem, Other 29
Police matter 26
Outside rubbish, trash or waste fire 25
Gas leak (natural gas or LPG) 24
Outside rubbish fire, Other 24
Fire, Other 23
Mobile property (vehicle) fire, Other 20
Assist invalid 18
System malfunction, Other 18
Alarm system sounded due to malfunction 17
Person in distress, Other 16
Unauthorized burning 16
Wrong location 16
Arcing, shorted electrical equipment 15
Dumpster or other outside trash receptacle fire 15
Special type of incident, Other 15
Malicious, mischievous false call, Other 14
Steam, Other gas mistaken for smoke, Other 11
Road freight or transport vehicle fire 9
Heat from short circuit (wiring), defective/worn 8
Lock-out 8
Steam, vapor, fog or dust thought to be smoke 8
Detector activation, no fire - unintentional 7
Unintentional transmission of alarm, Other 7
Natural vegetation fire, Other 6
Overheated motor 6
Telephone, malicious false alarm 6
Brush or brush-and-grass mixture fire 5
Excessive heat, scorch burns with no ignition 5
Extrication of victim(s) from vehicle 5
Sprinkler activation, no fire - unintentional 5
Vehicle accident, general cleanup 5
Removal of victim(s) from stalled elevator 4
Camper or recreational vehicle (RV) fire 3
Chimney or flue fire, confined to chimney or flue 3
Fires in structure other than in a building 3
HazMat release investigation w/no HazMat 3
Incinerator overload or malfunction, fire confined 3
Local alarm system, malicious false alarm 3
Overpressure rupture of air or gas pipe/pipeline 3
Smoke from barbecue, tar kettle 3
Water problem, Other 3
Direct tie to FD, malicious false alarm 2
Lightning strike (no fire) 2
Outside equipment fire 2
Outside storage fire 2
Prescribed fire 2
Smoke detector activation due to malfunction 2
Special outside fire, Other 2
Water vehicle fire 2
Accident, potential accident, Other 1
Breakdown of light ballast 1
CO detector activation due to malfunction 1
Carbon monoxide detector activation, no CO 1
Carbon monoxide incident 1
Central station, malicious false alarm 1
Chemical spill or leak 1
Citizen complaint 1
Combustible/flammable gas/liquid condition, other 1
Commercial Compactor fire, confined to rubbish 1
Construction or demolition landfill fire 1
Defective elevator, no occupants 1
Explosive, bomb removal (for bomb scare, use 721) 1
Extinguishing system activation 1
Fire in mobile home used as fixed residence 1
Fire in portable building, fixed location 1
Flood assessment 1
Fuel burner/boiler malfunction, fire confined 1
Heat detector activation due to malfunction 1
Oil or other combustible liquid spill 1
Overpressure rupture, explosion, overheat other 1
Refrigeration leak 1
Ring or jewelry removal 1
Search for person in water 1
Swimming/recreational water areas rescue 1
2015 Medical assist, assist EMS crew 17555
Good intent call, Other 4540
Alarm system activation, no fire - unintentional 1629
Public service 1598
Dispatched & cancelled en route 1426
Emergency medical service, other 1068
Motor Vehicle Accident with no injuries 998
EMS call, excluding vehicle accident with injury 633
Motor vehicle accident with injuries 413
Building fire 318
False alarm or false call, Other 267
Hazardous condition, Other 192
Passenger vehicle fire 178
Trash or rubbish fire, contained 173
Lock-in (if lock out , use 511 ) 126
No Incident found on arrival at dispatch address 115
Smoke scare, odor of smoke 103
Public service assistance, Other 74
Assist police or other governmental agency 63
Gasoline or other flammable liquid spill 56
Rescue, EMS incident, other 52
Smoke detector activation, no fire - unintentional 47
Service Call, other 46
Grass fire 45
Motor vehicle/pedestrian accident (MV Ped) 45
Cooking fire, confined to container 44
Smoke or odor removal 39
EMS call, party transported by non-fire agency 36
Fire, Other 30
Electrical wiring/equipment problem, Other 24
Outside rubbish fire, Other 24
Police matter 22
Power line down 22
System malfunction, Other 22
Gas leak (natural gas or LPG) 21
Lock-out 19
Person in distress, Other 19
Arcing, shorted electrical equipment 18
Assist invalid 17
Malicious, mischievous false call, Other 17
Wrong location 17
Alarm system sounded due to malfunction 16
Removal of victim(s) from stalled elevator 16
Mobile property (vehicle) fire, Other 15
Outside rubbish, trash or waste fire 14
Sprinkler activation, no fire - unintentional 13
Detector activation, no fire - unintentional 10
Unintentional transmission of alarm, Other 8
Dumpster or other outside trash receptacle fire 7
Fires in structure other than in a building 7
Local alarm system, malicious false alarm 7
Smoke detector activation due to malfunction 7
Water problem, Other 7
Road freight or transport vehicle fire 6
Steam, vapor, fog or dust thought to be smoke 6
Unauthorized burning 6
Heat from short circuit (wiring), defective/worn 5
Special type of incident, Other 5
Steam, Other gas mistaken for smoke, Other 5
Extrication of victim(s) from vehicle 4
Overheated motor 4
Vehicle accident, general cleanup 4
Accident, potential accident, Other 3
Brush or brush-and-grass mixture fire 3
Cultivated trees or nursery stock fire 3
Extrication, rescue, Other 3
Swift water rescue 3
Telephone, malicious false alarm 3
Authorized controlled burning 2
Camper or recreational vehicle (RV) fire 2
Excessive heat, scorch burns with no ignition 2
Fuel burner/boiler malfunction, fire confined 2
HazMat release investigation w/no HazMat 2
Municipal alarm system, malicious false alarm 2
Natural vegetation fire, Other 2
Off-road vehicle or heavy equipment fire 2
Outside storage fire 2
Special outside fire, Other 2
Water or steam leak 2
Attempt to burn 1
Attempted burning, illegal action, Other 1
Breakdown of light ballast 1
Carbon monoxide incident 1
Central station, malicious false alarm 1
Chemical spill or leak 1
Chimney or flue fire, confined to chimney or flue 1
Commercial Compactor fire, confined to rubbish 1
Defective elevator, no occupants 1
Forest, woods or wildland fire 1
Incinerator overload or malfunction, fire confined 1
Outside gas or vapor combustion explosion 1
Overpressure rupture, explosion, overheat other 1
Prescribed fire 1
Refrigeration leak 1
Severe weather or natural disaster, Other 1
Sprinkler activation due to malfunction 1
Watercraft rescue 1
2016 Medical assist, assist EMS crew 3564
Good intent call, Other 824
Alarm system activation, no fire - unintentional 308
Public service 290
Dispatched & cancelled en route 288
Emergency medical service, other 244
Motor Vehicle Accident with no injuries 214
EMS call, excluding vehicle accident with injury 171
Motor vehicle accident with injuries 100
Building fire 66
Passenger vehicle fire 51
Hazardous condition, Other 33
False alarm or false call, Other 30
Lock-in (if lock out , use 511 ) 29
Trash or rubbish fire, contained 27
Smoke scare, odor of smoke 26
No Incident found on arrival at dispatch address 24
Assist police or other governmental agency 15
Public service assistance, Other 14
Smoke or odor removal 14
Gasoline or other flammable liquid spill 13
Cooking fire, confined to container 11
Service Call, other 11
Assist invalid 9
Grass fire 9
Rescue, EMS incident, other 9
Fire, Other 8
Detector activation, no fire - unintentional 6
Electrical wiring/equipment problem, Other 6
Motor vehicle/pedestrian accident (MV Ped) 6
Outside rubbish fire, Other 6
Person in distress, Other 6
Police matter 6
Gas leak (natural gas or LPG) 5
Smoke detector activation, no fire - unintentional 5
Unintentional transmission of alarm, Other 5
EMS call, party transported by non-fire agency 4
Malicious, mischievous false call, Other 4
Mobile property (vehicle) fire, Other 4
Special type of incident, Other 4
Wrong location 4
Arcing, shorted electrical equipment 3
Power line down 3
Removal of victim(s) from stalled elevator 3
Brush or brush-and-grass mixture fire 2
Dumpster or other outside trash receptacle fire 2
Extrication of victim(s) from vehicle 2
Fires in structure other than in a building 2
Lock-out 2
Natural vegetation fire, Other 2
Road freight or transport vehicle fire 2
Sprinkler activation, no fire - unintentional 2
Telephone, malicious false alarm 2
Accident, potential accident, Other 1
Alarm system sounded due to malfunction 1
Chimney or flue fire, confined to chimney or flue 1
Extrication of victim(s) from machinery 1
Fire in mobile home used as fixed residence 1
Heat from short circuit (wiring), defective/worn 1
Incinerator overload or malfunction, fire confined 1
Outside rubbish, trash or waste fire 1
Overheated motor 1
Search for lost person, other 1
Steam, Other gas mistaken for smoke, Other 1
Steam, vapor, fog or dust thought to be smoke 1
System malfunction, Other 1
Vehicle accident, general cleanup 1
Water or steam leak 1
dtype: int64
In [18]:
incidents_by_type.value_counts(normalize=True)
Out[18]:
DISPATCH DATE INCIDENT DESCRIPTION
2012 Medical assist, assist EMS crew 0.479085
Good intent call, Other 0.190511
Dispatched & cancelled en route 0.048747
Alarm system activation, no fire - unintentional 0.043902
EMS call, excluding vehicle accident with injury 0.038958
Public service 0.031607
EMS call, party transported by non-fire agency 0.026963
Motor Vehicle Accident with no injuries 0.025794
Motor vehicle accident with injuries 0.015870
Building fire 0.011995
False alarm or false call, Other 0.009288
Passenger vehicle fire 0.007852
Smoke scare, odor of smoke 0.006415
Emergency medical service, other 0.005546
Trash or rubbish fire, contained 0.005145
Hazardous condition, Other 0.004577
Public service assistance, Other 0.003742
Lock-in (if lock out , use 511 ) 0.003141
No Incident found on arrival at dispatch address 0.003040
Assist police or other governmental agency 0.002138
Police matter 0.002138
Alarm system sounded due to malfunction 0.001938
Electrical wiring/equipment problem, Other 0.001804
Power line down 0.001671
System malfunction, Other 0.001671
Cooking fire, confined to container 0.001604
Gasoline or other flammable liquid spill 0.001504
Motor vehicle/pedestrian accident (MV Ped) 0.001336
Arcing, shorted electrical equipment 0.001270
Smoke or odor removal 0.001270
Grass fire 0.001236
Service Call, other 0.001036
Smoke detector activation, no fire - unintentional 0.001002
Fire, Other 0.000969
Malicious, mischievous false call, Other 0.000936
Rescue, EMS incident, other 0.000936
Outside rubbish fire, Other 0.000802
Unauthorized burning 0.000802
Gas leak (natural gas or LPG) 0.000735
Dumpster or other outside trash receptacle fire 0.000702
Assist invalid 0.000635
Outside rubbish, trash or waste fire 0.000601
Heat from short circuit (wiring), defective/worn 0.000568
Lock-out 0.000535
Person in distress, Other 0.000468
Removal of victim(s) from stalled elevator 0.000468
Wrong location 0.000434
Special type of incident, Other 0.000401
Smoke detector activation due to malfunction 0.000334
Detector activation, no fire - unintentional 0.000301
Unintentional transmission of alarm, Other 0.000301
Fires in structure other than in a building 0.000267
Overheated motor 0.000267
Steam, Other gas mistaken for smoke, Other 0.000267
Steam, vapor, fog or dust thought to be smoke 0.000267
Sprinkler activation, no fire - unintentional 0.000234
Telephone, malicious false alarm 0.000234
Cover assignment, standby, moveup 0.000200
Mobile property (vehicle) fire, Other 0.000200
Road freight or transport vehicle fire 0.000200
Accident, potential accident, Other 0.000167
Special outside fire, Other 0.000167
Chimney or flue fire, confined to chimney or flue 0.000134
Extrication of victim(s) from vehicle 0.000134
Attempted burning, illegal action, Other 0.000100
Central station, malicious false alarm 0.000100
Extrication, rescue, Other 0.000100
HazMat release investigation w/no HazMat 0.000100
Local alarm system, malicious false alarm 0.000100
Municipal alarm system, malicious false alarm 0.000100
Natural vegetation fire, Other 0.000100
Off-road vehicle or heavy equipment fire 0.000100
Outside storage fire 0.000100
Smoke from barbecue, tar kettle 0.000100
Building or structure weakened or collapsed 0.000067
Combustible/flammable gas/liquid condition, other 0.000067
Fire in portable building, fixed location 0.000067
Forest, woods or wildland fire 0.000067
Incinerator overload or malfunction, fire confined 0.000067
Oil or other combustible liquid spill 0.000067
Outside equipment fire 0.000067
Search for lost person, other 0.000067
Severe weather or natural disaster, Other 0.000067
Water or steam leak 0.000067
Wind storm, tornado/hurricane assessment 0.000067
Attempt to burn 0.000033
Bomb scare - no bomb 0.000033
Breakdown of light ballast 0.000033
Brush or brush-and-grass mixture fire 0.000033
Camper or recreational vehicle (RV) fire 0.000033
Chemical spill or leak 0.000033
Citizen complaint 0.000033
Commercial Compactor fire, confined to rubbish 0.000033
Confined space rescue 0.000033
Explosive, bomb removal (for bomb scare, use 721) 0.000033
Fire in mobile home used as fixed residence 0.000033
Fire in motor home, camper, recreational vehicle 0.000033
Fuel burner/boiler malfunction, fire confined 0.000033
Heat detector activation due to malfunction 0.000033
Lightning strike (no fire) 0.000033
Outside gas or vapor combustion explosion 0.000033
Outside stationary compactor/compacted trash fire 0.000033
Overpressure rupture, explosion, overheat other 0.000033
Search for person in water 0.000033
Self-propelled motor home or recreational vehicle 0.000033
Swimming/recreational water areas rescue 0.000033
Toxic condition, Other 0.000033
Vehicle accident, general cleanup 0.000033
Water problem, Other 0.000033
2013 Medical assist, assist EMS crew 0.525000
Good intent call, Other 0.164142
Alarm system activation, no fire - unintentional 0.050657
Public service 0.040664
Dispatched & cancelled en route 0.040111
EMS call, excluding vehicle accident with injury 0.027593
Motor Vehicle Accident with no injuries 0.024896
Emergency medical service, other 0.018741
Motor vehicle accident with injuries 0.017012
EMS call, party transported by non-fire agency 0.012690
Building fire 0.010166
False alarm or false call, Other 0.008160
Passenger vehicle fire 0.006743
Smoke scare, odor of smoke 0.005705
Trash or rubbish fire, contained 0.005152
Hazardous condition, Other 0.004564
Lock-in (if lock out , use 511 ) 0.003734
Assist police or other governmental agency 0.002732
Public service assistance, Other 0.002282
Rescue, EMS incident, other 0.002282
No Incident found on arrival at dispatch address 0.002040
Motor vehicle/pedestrian accident (MV Ped) 0.001625
Gasoline or other flammable liquid spill 0.001349
Cooking fire, confined to container 0.001314
System malfunction, Other 0.001176
Smoke or odor removal 0.001037
Grass fire 0.000968
Police matter 0.000968
Service Call, other 0.000968
Alarm system sounded due to malfunction 0.000899
Power line down 0.000795
Arcing, shorted electrical equipment 0.000761
Fire, Other 0.000761
Gas leak (natural gas or LPG) 0.000726
Electrical wiring/equipment problem, Other 0.000657
Assist invalid 0.000588
Person in distress, Other 0.000588
Smoke detector activation, no fire - unintentional 0.000553
Wrong location 0.000553
Dumpster or other outside trash receptacle fire 0.000484
Outside rubbish, trash or waste fire 0.000450
Heat from short circuit (wiring), defective/worn 0.000415
Malicious, mischievous false call, Other 0.000415
Special type of incident, Other 0.000415
Unauthorized burning 0.000415
Lock-out 0.000380
Fires in structure other than in a building 0.000346
Outside rubbish fire, Other 0.000346
Brush or brush-and-grass mixture fire 0.000277
Unintentional transmission of alarm, Other 0.000277
Mobile property (vehicle) fire, Other 0.000242
Removal of victim(s) from stalled elevator 0.000242
Road freight or transport vehicle fire 0.000207
Smoke detector activation due to malfunction 0.000207
Steam, vapor, fog or dust thought to be smoke 0.000207
Extrication of victim(s) from vehicle 0.000173
Natural vegetation fire, Other 0.000173
Cover assignment, standby, moveup 0.000138
Detector activation, no fire - unintentional 0.000138
Excessive heat, scorch burns with no ignition 0.000138
Incinerator overload or malfunction, fire confined 0.000138
Steam, Other gas mistaken for smoke, Other 0.000138
Authorized controlled burning 0.000104
HazMat release investigation w/no HazMat 0.000104
Local alarm system, malicious false alarm 0.000104
Overheated motor 0.000104
Sprinkler activation, no fire - unintentional 0.000104
Vehicle accident, general cleanup 0.000104
Chemical spill or leak 0.000069
Fire in mobile home used as fixed residence 0.000069
Off-road vehicle or heavy equipment fire 0.000069
Outside equipment fire 0.000069
Outside storage fire 0.000069
Overpressure rupture from air or gas, Other 0.000069
Ring or jewelry removal 0.000069
Smoke from barbecue, tar kettle 0.000069
Telephone, malicious false alarm 0.000069
Water or steam leak 0.000069
Water vehicle fire 0.000069
Accident, potential accident, Other 0.000035
Aircraft standby 0.000035
Animal rescue 0.000035
Breakdown of light ballast 0.000035
CO detector activation due to malfunction 0.000035
Camper or recreational vehicle (RV) fire 0.000035
Carbon monoxide incident 0.000035
Chemical hazard (no spill or leak) 0.000035
Citizen complaint 0.000035
Combustible/flammable gas/liquid condition, other 0.000035
Defective elevator, no occupants 0.000035
Direct tie to FD, malicious false alarm 0.000035
Extinguishing system activation 0.000035
Extrication, rescue, Other 0.000035
Fire in portable building, fixed location 0.000035
Heat detector activation due to malfunction 0.000035
High-angle rescue 0.000035
Oil or other combustible liquid spill 0.000035
Outside gas or vapor combustion explosion 0.000035
Rail vehicle fire 0.000035
Search for lost person, other 0.000035
Search for person in water 0.000035
Severe weather or natural disaster, Other 0.000035
Special outside fire, Other 0.000035
Toxic condition, Other 0.000035
2014 Medical assist, assist EMS crew 0.544481
Good intent call, Other 0.139985
Alarm system activation, no fire - unintentional 0.052737
Public service 0.043673
Dispatched & cancelled en route 0.038136
Motor Vehicle Accident with no injuries 0.027127
Emergency medical service, other 0.024193
EMS call, excluding vehicle accident with injury 0.022908
Motor vehicle accident with injuries 0.015030
Building fire 0.010416
Rescue, EMS incident, other 0.008174
False alarm or false call, Other 0.007251
Passenger vehicle fire 0.006724
Hazardous condition, Other 0.006230
Trash or rubbish fire, contained 0.005669
Smoke scare, odor of smoke 0.004450
EMS call, party transported by non-fire agency 0.004318
Lock-in (if lock out , use 511 ) 0.003758
No Incident found on arrival at dispatch address 0.003164
Grass fire 0.002241
Public service assistance, Other 0.001912
Motor vehicle/pedestrian accident (MV Ped) 0.001714
Gasoline or other flammable liquid spill 0.001615
Assist police or other governmental agency 0.001549
Cooking fire, confined to container 0.001384
Smoke or odor removal 0.001318
Service Call, other 0.001187
Power line down 0.001022
Smoke detector activation, no fire - unintentional 0.001022
Electrical wiring/equipment problem, Other 0.000956
Police matter 0.000857
Outside rubbish, trash or waste fire 0.000824
Gas leak (natural gas or LPG) 0.000791
Outside rubbish fire, Other 0.000791
Fire, Other 0.000758
Mobile property (vehicle) fire, Other 0.000659
Assist invalid 0.000593
System malfunction, Other 0.000593
Alarm system sounded due to malfunction 0.000560
Person in distress, Other 0.000527
Unauthorized burning 0.000527
Wrong location 0.000527
Arcing, shorted electrical equipment 0.000494
Dumpster or other outside trash receptacle fire 0.000494
Special type of incident, Other 0.000494
Malicious, mischievous false call, Other 0.000461
Steam, Other gas mistaken for smoke, Other 0.000363
Road freight or transport vehicle fire 0.000297
Heat from short circuit (wiring), defective/worn 0.000264
Lock-out 0.000264
Steam, vapor, fog or dust thought to be smoke 0.000264
Detector activation, no fire - unintentional 0.000231
Unintentional transmission of alarm, Other 0.000231
Natural vegetation fire, Other 0.000198
Overheated motor 0.000198
Telephone, malicious false alarm 0.000198
Brush or brush-and-grass mixture fire 0.000165
Excessive heat, scorch burns with no ignition 0.000165
Extrication of victim(s) from vehicle 0.000165
Sprinkler activation, no fire - unintentional 0.000165
Vehicle accident, general cleanup 0.000165
Removal of victim(s) from stalled elevator 0.000132
Camper or recreational vehicle (RV) fire 0.000099
Chimney or flue fire, confined to chimney or flue 0.000099
Fires in structure other than in a building 0.000099
HazMat release investigation w/no HazMat 0.000099
Incinerator overload or malfunction, fire confined 0.000099
Local alarm system, malicious false alarm 0.000099
Overpressure rupture of air or gas pipe/pipeline 0.000099
Smoke from barbecue, tar kettle 0.000099
Water problem, Other 0.000099
Direct tie to FD, malicious false alarm 0.000066
Lightning strike (no fire) 0.000066
Outside equipment fire 0.000066
Outside storage fire 0.000066
Prescribed fire 0.000066
Smoke detector activation due to malfunction 0.000066
Special outside fire, Other 0.000066
Water vehicle fire 0.000066
Accident, potential accident, Other 0.000033
Breakdown of light ballast 0.000033
CO detector activation due to malfunction 0.000033
Carbon monoxide detector activation, no CO 0.000033
Carbon monoxide incident 0.000033
Central station, malicious false alarm 0.000033
Chemical spill or leak 0.000033
Citizen complaint 0.000033
Combustible/flammable gas/liquid condition, other 0.000033
Commercial Compactor fire, confined to rubbish 0.000033
Construction or demolition landfill fire 0.000033
Defective elevator, no occupants 0.000033
Explosive, bomb removal (for bomb scare, use 721) 0.000033
Extinguishing system activation 0.000033
Fire in mobile home used as fixed residence 0.000033
Fire in portable building, fixed location 0.000033
Flood assessment 0.000033
Fuel burner/boiler malfunction, fire confined 0.000033
Heat detector activation due to malfunction 0.000033
Oil or other combustible liquid spill 0.000033
Overpressure rupture, explosion, overheat other 0.000033
Refrigeration leak 0.000033
Ring or jewelry removal 0.000033
Search for person in water 0.000033
Swimming/recreational water areas rescue 0.000033
2015 Medical assist, assist EMS crew 0.542139
Good intent call, Other 0.140206
Alarm system activation, no fire - unintentional 0.050307
Public service 0.049350
Dispatched & cancelled en route 0.044038
Emergency medical service, other 0.032982
Motor Vehicle Accident with no injuries 0.030821
EMS call, excluding vehicle accident with injury 0.019549
Motor vehicle accident with injuries 0.012754
Building fire 0.009821
False alarm or false call, Other 0.008246
Hazardous condition, Other 0.005929
Passenger vehicle fire 0.005497
Trash or rubbish fire, contained 0.005343
Lock-in (if lock out , use 511 ) 0.003891
No Incident found on arrival at dispatch address 0.003551
Smoke scare, odor of smoke 0.003181
Public service assistance, Other 0.002285
Assist police or other governmental agency 0.001946
Gasoline or other flammable liquid spill 0.001729
Rescue, EMS incident, other 0.001606
Smoke detector activation, no fire - unintentional 0.001451
Service Call, other 0.001421
Grass fire 0.001390
Motor vehicle/pedestrian accident (MV Ped) 0.001390
Cooking fire, confined to container 0.001359
Smoke or odor removal 0.001204
EMS call, party transported by non-fire agency 0.001112
Fire, Other 0.000926
Electrical wiring/equipment problem, Other 0.000741
Outside rubbish fire, Other 0.000741
Police matter 0.000679
Power line down 0.000679
System malfunction, Other 0.000679
Gas leak (natural gas or LPG) 0.000649
Lock-out 0.000587
Person in distress, Other 0.000587
Arcing, shorted electrical equipment 0.000556
Assist invalid 0.000525
Malicious, mischievous false call, Other 0.000525
Wrong location 0.000525
Alarm system sounded due to malfunction 0.000494
Removal of victim(s) from stalled elevator 0.000494
Mobile property (vehicle) fire, Other 0.000463
Outside rubbish, trash or waste fire 0.000432
Sprinkler activation, no fire - unintentional 0.000401
Detector activation, no fire - unintentional 0.000309
Unintentional transmission of alarm, Other 0.000247
Dumpster or other outside trash receptacle fire 0.000216
Fires in structure other than in a building 0.000216
Local alarm system, malicious false alarm 0.000216
Smoke detector activation due to malfunction 0.000216
Water problem, Other 0.000216
Road freight or transport vehicle fire 0.000185
Steam, vapor, fog or dust thought to be smoke 0.000185
Unauthorized burning 0.000185
Heat from short circuit (wiring), defective/worn 0.000154
Special type of incident, Other 0.000154
Steam, Other gas mistaken for smoke, Other 0.000154
Extrication of victim(s) from vehicle 0.000124
Overheated motor 0.000124
Vehicle accident, general cleanup 0.000124
Accident, potential accident, Other 0.000093
Brush or brush-and-grass mixture fire 0.000093
Cultivated trees or nursery stock fire 0.000093
Extrication, rescue, Other 0.000093
Swift water rescue 0.000093
Telephone, malicious false alarm 0.000093
Authorized controlled burning 0.000062
Camper or recreational vehicle (RV) fire 0.000062
Excessive heat, scorch burns with no ignition 0.000062
Fuel burner/boiler malfunction, fire confined 0.000062
HazMat release investigation w/no HazMat 0.000062
Municipal alarm system, malicious false alarm 0.000062
Natural vegetation fire, Other 0.000062
Off-road vehicle or heavy equipment fire 0.000062
Outside storage fire 0.000062
Special outside fire, Other 0.000062
Water or steam leak 0.000062
Attempt to burn 0.000031
Attempted burning, illegal action, Other 0.000031
Breakdown of light ballast 0.000031
Carbon monoxide incident 0.000031
Central station, malicious false alarm 0.000031
Chemical spill or leak 0.000031
Chimney or flue fire, confined to chimney or flue 0.000031
Commercial Compactor fire, confined to rubbish 0.000031
Defective elevator, no occupants 0.000031
Forest, woods or wildland fire 0.000031
Incinerator overload or malfunction, fire confined 0.000031
Outside gas or vapor combustion explosion 0.000031
Overpressure rupture, explosion, overheat other 0.000031
Prescribed fire 0.000031
Refrigeration leak 0.000031
Severe weather or natural disaster, Other 0.000031
Sprinkler activation due to malfunction 0.000031
Watercraft rescue 0.000031
2016 Medical assist, assist EMS crew 0.547045
Good intent call, Other 0.126477
Alarm system activation, no fire - unintentional 0.047276
Public service 0.044513
Dispatched & cancelled en route 0.044206
Emergency medical service, other 0.037452
Motor Vehicle Accident with no injuries 0.032847
EMS call, excluding vehicle accident with injury 0.026247
Motor vehicle accident with injuries 0.015349
Building fire 0.010130
Passenger vehicle fire 0.007828
Hazardous condition, Other 0.005065
False alarm or false call, Other 0.004605
Lock-in (if lock out , use 511 ) 0.004451
Trash or rubbish fire, contained 0.004144
Smoke scare, odor of smoke 0.003991
No Incident found on arrival at dispatch address 0.003684
Assist police or other governmental agency 0.002302
Public service assistance, Other 0.002149
Smoke or odor removal 0.002149
Gasoline or other flammable liquid spill 0.001995
Cooking fire, confined to container 0.001688
Service Call, other 0.001688
Assist invalid 0.001381
Grass fire 0.001381
Rescue, EMS incident, other 0.001381
Fire, Other 0.001228
Detector activation, no fire - unintentional 0.000921
Electrical wiring/equipment problem, Other 0.000921
Motor vehicle/pedestrian accident (MV Ped) 0.000921
Outside rubbish fire, Other 0.000921
Person in distress, Other 0.000921
Police matter 0.000921
Gas leak (natural gas or LPG) 0.000767
Smoke detector activation, no fire - unintentional 0.000767
Unintentional transmission of alarm, Other 0.000767
EMS call, party transported by non-fire agency 0.000614
Malicious, mischievous false call, Other 0.000614
Mobile property (vehicle) fire, Other 0.000614
Special type of incident, Other 0.000614
Wrong location 0.000614
Arcing, shorted electrical equipment 0.000460
Power line down 0.000460
Removal of victim(s) from stalled elevator 0.000460
Brush or brush-and-grass mixture fire 0.000307
Dumpster or other outside trash receptacle fire 0.000307
Extrication of victim(s) from vehicle 0.000307
Fires in structure other than in a building 0.000307
Lock-out 0.000307
Natural vegetation fire, Other 0.000307
Road freight or transport vehicle fire 0.000307
Sprinkler activation, no fire - unintentional 0.000307
Telephone, malicious false alarm 0.000307
Accident, potential accident, Other 0.000153
Alarm system sounded due to malfunction 0.000153
Chimney or flue fire, confined to chimney or flue 0.000153
Extrication of victim(s) from machinery 0.000153
Fire in mobile home used as fixed residence 0.000153
Heat from short circuit (wiring), defective/worn 0.000153
Incinerator overload or malfunction, fire confined 0.000153
Outside rubbish, trash or waste fire 0.000153
Overheated motor 0.000153
Search for lost person, other 0.000153
Steam, Other gas mistaken for smoke, Other 0.000153
Steam, vapor, fog or dust thought to be smoke 0.000153
System malfunction, Other 0.000153
Vehicle accident, general cleanup 0.000153
Water or steam leak 0.000153
dtype: float64
Content source: koverholt/notebooks
Similar notebooks: