LA Fire Department Response Metrics

Please unzip the file in the directory before running this script



In [8]:

    
import pandas as pd
import numpy as np



In [9]:

    
data = pd.read_csv("LAFD_ResponseMetrics_RawData.csv")
data.head()









    Out[9]:






  
    
      
      Randomized Incident Number
      First in District
      Emergency Dispatch Code
      Dispatch Sequence
      Dispatch Status
      Unit Type
      PPE Level
      Incident Creation Time (GMT)
      Time of Dispatch (GMT)
      En Route Time (GMT)
      On Scene Time (GMT)
    
  
  
    
      0
       201301000022
       93
       Emergency
      NaN
       NaN
                             NaN
       NaN
       23:00:39
            NaN
            NaN
            NaN
    
    
      1
       201301000022
      NaN
             NaN
        1
       QTR
                       T - Truck
       EMS
            NaN
       23:01:27
       23:01:58
       23:05:02
    
    
      2
       201301000022
      NaN
             NaN
        2
       QTR
                      E - Engine
       EMS
            NaN
       23:01:27
       23:01:58
       23:05:02
    
    
      3
       201301000022
      NaN
             NaN
        3
       RAD
       RA - ALS Rescue Ambulance
       EMS
            NaN
       23:01:27
       23:02:22
       23:06:46
    
    
      4
       201301000028
       12
       Emergency
      NaN
       NaN
                             NaN
       NaN
       23:50:43
            NaN
            NaN
            NaN



In [13]:

    
fullData = data.copy(deep=True)
fullData = fullData.dropna(how='any')
fullData









    Out[13]:






  
    
      
      Randomized Incident Number
      First in District
      Emergency Dispatch Code
      Dispatch Sequence
      Dispatch Status
      Unit Type
      PPE Level
      Incident Creation Time (GMT)
      Time of Dispatch (GMT)
      En Route Time (GMT)
      On Scene Time (GMT)

So it seems to be the case that every row has at least one missing value. sigh



In [14]:

    
fullData = data.copy(deep=True)
fullData = fullData.dropna(how='all')
len(fullData)









    Out[14]:





2739892



In [15]:

    
len(data)-len(fullData)









    Out[15]:





0

No row has completely missing data.



In [ ]:

	Randomized Incident Number	First in District	Emergency Dispatch Code	Dispatch Sequence	Dispatch Status	Unit Type	PPE Level	Incident Creation Time (GMT)	Time of Dispatch (GMT)	En Route Time (GMT)	On Scene Time (GMT)
0	201301000022	93	Emergency	NaN	NaN	NaN	NaN	23:00:39	NaN	NaN	NaN
1	201301000022	NaN	NaN	1	QTR	T - Truck	EMS	NaN	23:01:27	23:01:58	23:05:02
2	201301000022	NaN	NaN	2	QTR	E - Engine	EMS	NaN	23:01:27	23:01:58	23:05:02
3	201301000022	NaN	NaN	3	RAD	RA - ALS Rescue Ambulance	EMS	NaN	23:01:27	23:02:22	23:06:46
4	201301000028	12	Emergency	NaN	NaN	NaN	NaN	23:50:43	NaN	NaN	NaN