In [1]:

    

import pandas as pd


    

In [2]:

    

data = pd.read_csv("Accidents7904.csv")


    

    




C:\st\Anaconda\lib\site-packages\pandas\io\parsers.py:1139: DtypeWarning: Columns (13,31) have mixed types. Specify dtype option on import or set low_memory=False.
  data = self._reader.read(nrows)

In [3]:

    

data_london = data[data['Police_Force'] == 1]
print data_london[:5]


    

    




  Accident_Index  Location_Easting_OSGR  Location_Northing_OSGR  Longitude  \
0   197901A11AD14                    NaN                     NaN        NaN   
1   197901A1BAW34                 198460                  894000        NaN   
2   197901A1BFD77                 406380                  307000        NaN   
3   197901A1BGC20                 281680                  440000        NaN   
4   197901A1BGF95                 153960                  795000        NaN   

   Latitude  Police_Force  Accident_Severity  Number_of_Vehicles  \
0       NaN             1                  3                   2   
1       NaN             1                  3                   1   
2       NaN             1                  3                   2   
3       NaN             1                  3                   2   
4       NaN             1                  2                   2   

   Number_of_Casualties        Date     ...      \
0                     1  18/01/1979     ...       
1                     1  01/01/1979     ...       
2                     3  01/01/1979     ...       
3                     2  01/01/1979     ...       
4                     1  01/01/1979     ...       

   Pedestrian_Crossing-Human_Control Pedestrian_Crossing-Physical_Facilities  \
0                                 -1                                      -1   
1                                 -1                                      -1   
2                                 -1                                      -1   
3                                 -1                                      -1   
4                                 -1                                      -1   

   Light_Conditions Weather_Conditions  Road_Surface_Conditions  \
0                 1                  8                        1   
1                 4                  8                        3   
2                 4                  8                        3   
3                 4                  8                        3   
4                 4                  3                        3   

   Special_Conditions_at_Site  Carriageway_Hazards  Urban_or_Rural_Area  \
0                          -1                    0                   -1   
1                          -1                    0                   -1   
2                          -1                    0                   -1   
3                          -1                    0                   -1   
4                          -1                    0                   -1   

   Did_Police_Officer_Attend_Scene_of_Accident  LSOA_of_Accident_Location  
0                                           -1                        NaN  
1                                           -1                        NaN  
2                                           -1                        NaN  
3                                           -1                        NaN  
4                                           -1                        NaN  

[5 rows x 32 columns]

In [4]:

    

data_london_new2 = data_london[['Date', 'Time', 'Number_of_Casualties']]
data_london_new2.head()


    

    
Out[4]:






  

    

      

      
Date
      
Time
      
Number_of_Casualties
    
  
  

    

      
0
      
 18/01/1979
      
 08:00
      
 1
    
    

      
1
      
 01/01/1979
      
 01:00
      
 1
    
    

      
2
      
 01/01/1979
      
 01:25
      
 3
    
    

      
3
      
 01/01/1979
      
 01:30
      
 2
    
    

      
4
      
 01/01/1979
      
 01:30
      
 1
    
  

In [5]:

    

data_london_new2.sort('Date', inplace=True)
#data_london_new2.set_index('Date', inplace=True)
data_london_new2.head()


    

    




C:\st\Anaconda\lib\site-packages\pandas\core\frame.py:2679: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame
  inplace=inplace, kind=kind, na_position=na_position)






    
Out[5]:






  

    

      

      
Date
      
Time
      
Number_of_Casualties
    
  
  

    

      
20
      
 01/01/1979
      
 12:40
      
 2
    
    

      
1 
      
 01/01/1979
      
 01:00
      
 1
    
    

      
2 
      
 01/01/1979
      
 01:25
      
 3
    
    

      
3 
      
 01/01/1979
      
 01:30
      
 2
    
    

      
4 
      
 01/01/1979
      
 01:30
      
 1
    
  

In [6]:

    

data_london_new2.sort('Time', inplace=True)
#data_london_new2.set_index('Date', inplace=True)
data_london_new2.head()


    

    
Out[6]:






  

    

      

      
Date
      
Time
      
Number_of_Casualties
    
  
  

    

      
2770115
      
 23/11/1990
      
 00:01
      
 2
    
    

      
4661940
      
 07/12/1998
      
 00:01
      
 1
    
    

      
2264722
      
 11/09/1988
      
 00:01
      
 1
    
    

      
2268405
      
 06/08/1988
      
 00:01
      
 2
    
    

      
5583244
      
 13/07/2002
      
 00:01
      
 1
    
  

In [7]:

    

writer = pd.ExcelWriter('output.xlsx')
data_london_new2.to_excel(writer,'Sheet1')
writer.save()


    

In [7]:

    




    

In [7]: