In [1]:
from __future__ import absolute_import, division, print_function, unicode_literals
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline
In [2]:
rain_df = pd.read_csv('data/full_ohare_noaa.csv')
print(rain_df.dtypes)
rain_df.head()
c:\users\sier-patrick\.virtualenvs\mine\lib\site-packages\IPython\core\interactiveshell.py:2717: DtypeWarning: Columns (8,10,11,12,13,14,15,16,17,18,20,22,23,24,25,26,27,28,29,33,34,37,38,39,40,44,45,59,63,64,67,68,69,70,84,85,86,87) have mixed types. Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
STATION object
STATION_NAME object
ELEVATION float64
LATITUDE float64
LONGITUDE float64
DATE object
REPORTTPYE object
HOURLYSKYCONDITIONS object
HOURLYVISIBILITY object
HOURLYPRSENTWEATHERTYPE object
HOURLYDRYBULBTEMPF object
HOURLYDRYBULBTEMPC object
HOURLYWETBULBTEMPF object
HOURLYWETBULBTEMPC object
HOURLYDewPointTempF object
HOURLYDewPointTempC object
HOURLYRelativeHumidity object
HOURLYWindSpeed object
HOURLYWindDirection object
HOURLYWindGustSpeed float64
HOURLYStationPressure object
HOURLYPressureTendency float64
HOURLYPressureChange object
HOURLYSeaLevelPressure object
HOURLYPrecip object
HOURLYAltimeterSetting object
DAILYMaximumDryBulbTemp object
DAILYMinimumDryBulbTemp object
DAILYAverageDryBulbTemp object
DAILYDeptFromNormalAverageTemp object
...
MonthlyDeptFromNormalMaximumTemp float64
MonthlyDeptFromNormalMinimumTemp float64
MonthlyDeptFromNormalAverageTemp float64
MonthlyDeptFromNormalPrecip object
MonthlyTotalLiquidPrecip object
MonthlyGreatestPrecip float64
MonthlyGreatestPrecipDate float64
MonthlyGreatestSnowfall object
MonthlyGreatestSnowfallDate object
MonthlyGreatestSnowDepth object
MonthlyGreatestSnowDepthDate object
MonthlyDaysWithGT90Temp float64
MonthlyDaysWithLT32Temp float64
MonthlyDaysWithGT32Temp float64
MonthlyDaysWithLT0Temp float64
MonthlyDaysWithGT001Precip float64
MonthlyDaysWithGT010Precip float64
MonthlyDaysWithGT1Snow float64
MonthlyMaxSeaLevelPressureValue float64
MonthlyMaxSeaLevelPressureDate int64
MonthlyMaxSeaLevelPressureTime int64
MonthlyMinSeaLevelPressureValue float64
MonthlyMinSeaLevelPressureDate int64
MonthlyMinSeaLevelPressureTime int64
MonthlyTotalHeatingDegreeDays object
MonthlyTotalCoolingDegreeDays object
MonthlyDeptFromNormalHeatingDD object
MonthlyDeptFromNormalCoolingDD object
MonthlyTotalSeasonToDateHeatingDD float64
MonthlyTotalSeasonToDateCoolingDD float64
dtype: object
Out[2]:
STATION
STATION_NAME
ELEVATION
LATITUDE
LONGITUDE
DATE
REPORTTPYE
HOURLYSKYCONDITIONS
HOURLYVISIBILITY
HOURLYPRSENTWEATHERTYPE
...
MonthlyMaxSeaLevelPressureTime
MonthlyMinSeaLevelPressureValue
MonthlyMinSeaLevelPressureDate
MonthlyMinSeaLevelPressureTime
MonthlyTotalHeatingDegreeDays
MonthlyTotalCoolingDegreeDays
MonthlyDeptFromNormalHeatingDD
MonthlyDeptFromNormalCoolingDD
MonthlyTotalSeasonToDateHeatingDD
MonthlyTotalSeasonToDateCoolingDD
0
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
201.8
41.995
-87.9336
1946-10-01 01:00
SAO
CLR:00
1.99
||FG:11
...
-9999
NaN
-9999
-9999
NaN
NaN
NaN
NaN
NaN
NaN
1
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
201.8
41.995
-87.9336
1946-10-01 02:00
SAO
CLR:00
1.99
||FG:11
...
-9999
NaN
-9999
-9999
NaN
NaN
NaN
NaN
NaN
NaN
2
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
201.8
41.995
-87.9336
1946-10-01 03:00
SAO
CLR:00
1.99
||FG:11
...
-9999
NaN
-9999
-9999
NaN
NaN
NaN
NaN
NaN
NaN
3
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
201.8
41.995
-87.9336
1946-10-01 04:00
SAO
CLR:00
2.98
||FG:11
...
-9999
NaN
-9999
-9999
NaN
NaN
NaN
NaN
NaN
NaN
4
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
201.8
41.995
-87.9336
1946-10-01 05:00
SAO
CLR:00
2.98
||FG:11
...
-9999
NaN
-9999
-9999
NaN
NaN
NaN
NaN
NaN
NaN
5 rows × 90 columns
In [3]:
rain_df.columns.values
Out[3]:
array(['STATION', 'STATION_NAME', 'ELEVATION', 'LATITUDE', 'LONGITUDE',
'DATE', 'REPORTTPYE', 'HOURLYSKYCONDITIONS', 'HOURLYVISIBILITY',
'HOURLYPRSENTWEATHERTYPE', 'HOURLYDRYBULBTEMPF',
'HOURLYDRYBULBTEMPC', 'HOURLYWETBULBTEMPF', 'HOURLYWETBULBTEMPC',
'HOURLYDewPointTempF', 'HOURLYDewPointTempC',
'HOURLYRelativeHumidity', 'HOURLYWindSpeed', 'HOURLYWindDirection',
'HOURLYWindGustSpeed', 'HOURLYStationPressure',
'HOURLYPressureTendency', 'HOURLYPressureChange',
'HOURLYSeaLevelPressure', 'HOURLYPrecip', 'HOURLYAltimeterSetting',
'DAILYMaximumDryBulbTemp', 'DAILYMinimumDryBulbTemp',
'DAILYAverageDryBulbTemp', 'DAILYDeptFromNormalAverageTemp',
'DAILYAverageRelativeHumidity', 'DAILYAverageDewPointTemp',
'DAILYAverageWetBulbTemp', 'DAILYHeatingDegreeDays',
'DAILYCoolingDegreeDays', 'DAILYSunrise', 'DAILYSunset',
'DAILYWeather', 'DAILYPrecip', 'DAILYSnowfall', 'DAILYSnowDepth',
'DAILYAverageStationPressure', 'DAILYAverageSeaLevelPressure',
'DAILYAverageWindSpeed', 'DAILYPeakWindSpeed', 'PeakWindDirection',
'DAILYSustainedWindSpeed', 'DAILYSustainedWindDirection',
'MonthlyMaximumTemp', 'MonthlyMinimumTemp', 'MonthlyMeanTemp',
'MonthlyAverageRH', 'MonthlyDewpointTemp', 'MonthlyWetBulbTemp',
'MonthlyAvgHeatingDegreeDays', 'MonthlyAvgCoolingDegreeDays',
'MonthlyStationPressure', 'MonthlySeaLevelPressure',
'MonthlyAverageWindSpeed', 'MonthlyTotalSnowfall',
'MonthlyDeptFromNormalMaximumTemp',
'MonthlyDeptFromNormalMinimumTemp',
'MonthlyDeptFromNormalAverageTemp', 'MonthlyDeptFromNormalPrecip',
'MonthlyTotalLiquidPrecip', 'MonthlyGreatestPrecip',
'MonthlyGreatestPrecipDate', 'MonthlyGreatestSnowfall',
'MonthlyGreatestSnowfallDate', 'MonthlyGreatestSnowDepth',
'MonthlyGreatestSnowDepthDate', 'MonthlyDaysWithGT90Temp',
'MonthlyDaysWithLT32Temp', 'MonthlyDaysWithGT32Temp',
'MonthlyDaysWithLT0Temp', 'MonthlyDaysWithGT001Precip',
'MonthlyDaysWithGT010Precip', 'MonthlyDaysWithGT1Snow',
'MonthlyMaxSeaLevelPressureValue', 'MonthlyMaxSeaLevelPressureDate',
'MonthlyMaxSeaLevelPressureTime', 'MonthlyMinSeaLevelPressureValue',
'MonthlyMinSeaLevelPressureDate', 'MonthlyMinSeaLevelPressureTime',
'MonthlyTotalHeatingDegreeDays', 'MonthlyTotalCoolingDegreeDays',
'MonthlyDeptFromNormalHeatingDD', 'MonthlyDeptFromNormalCoolingDD',
'MonthlyTotalSeasonToDateHeatingDD',
'MonthlyTotalSeasonToDateCoolingDD'], dtype=object)
In [4]:
rain_df['REPORTTPYE'].unique()
Out[4]:
array(['SAO', 'SY-SA', 'SAOSP', 'FM-15', 'SY-MT', 'FM-16', 'FM-12', 'AUTO',
'SOD', 'SOM'], dtype=object)
In [13]:
# Simplifying to reduce size
ohare_rain_df = rain_df[['STATION', 'STATION_NAME', 'DATE', 'HOURLYPrecip']]
ohare_rain_df['datetime'] = pd.to_datetime(ohare_rain_df['DATE'])
ohare_rain_df = ohare_rain_df.set_index(pd.DatetimeIndex(ohare_rain_df['datetime']))
ohare_rain_df['HOURLYPrecip'] = ohare_rain_df['HOURLYPrecip'].str.replace('[^\d.]+', '')
ohare_rain_df['HOURLYPrecip'] = ohare_rain_df['HOURLYPrecip'].convert_objects(convert_numeric=True).fillna(0.0)
print(ohare_rain_df.dtypes)
ohare_rain_df.head()
c:\users\sier-patrick\.virtualenvs\mine\lib\site-packages\ipykernel\__main__.py:3: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
app.launch_new_instance()
STATION object
STATION_NAME object
DATE object
HOURLYPrecip object
datetime datetime64[ns]
dtype: object
STATION object
STATION_NAME object
DATE object
HOURLYPrecip float64
datetime datetime64[ns]
dtype: object
c:\users\sier-patrick\.virtualenvs\mine\lib\site-packages\ipykernel\__main__.py:7: FutureWarning: convert_objects is deprecated. Use the data-type specific converters pd.to_datetime, pd.to_timedelta and pd.to_numeric.
Out[13]:
STATION
STATION_NAME
DATE
HOURLYPrecip
datetime
1946-10-01 01:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1946-10-01 01:00
0.0
1946-10-01 01:00:00
1946-10-01 02:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1946-10-01 02:00
0.0
1946-10-01 02:00:00
1946-10-01 03:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1946-10-01 03:00
0.0
1946-10-01 03:00:00
1946-10-01 04:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1946-10-01 04:00
0.0
1946-10-01 04:00:00
1946-10-01 05:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1946-10-01 05:00
0.0
1946-10-01 05:00:00
In [14]:
ohare_rain_df['HOURLYPrecip'].unique()
Out[14]:
array([ 0.00000000e+00, 2.60000000e-01, 2.50000000e-01,
2.00000000e-02, 3.00000000e-02, 1.00000000e-02,
1.50000000e-01, 4.00000000e-02, 1.30000000e-01,
1.00000000e-01, 7.00000000e-02, 5.00000000e-02,
6.00000000e-02, 9.00000000e-02, 1.70000000e-01,
8.00000000e-02, 2.10000000e-01, 1.20000000e-01,
1.10000000e-01, 1.40000000e-01, 4.70000000e-01,
3.70000000e-01, 4.30000000e-01, 3.50000000e-01,
4.00000000e-01, 1.18000000e+00, 1.72000000e+00,
1.80000000e-01, 2.30000000e-01, 1.90000000e-01,
2.40000000e-01, 3.30000000e-01, 6.60000000e-01,
2.90000000e-01, 8.00000000e-01, 4.50000000e-01,
2.20000000e-01, 2.00000000e-01, 1.65000000e+00,
3.10000000e-01, 7.80000000e-01, 3.40000000e-01,
1.60000000e-01, 3.20000000e-01, 3.00000000e-01,
4.80000000e-01, 4.90000000e-01, 5.00000000e-01,
7.20000000e-01, 5.80000000e-01, 5.30000000e-01,
4.10000000e-01, 5.40000000e-01, 4.20000000e-01,
4.60000000e-01, 6.00000000e-01, 2.70000000e-01,
8.90000000e-01, 5.10000000e-01, 6.90000000e-01,
4.40000000e-01, 3.80000000e-01, 2.80000000e-01,
9.80000000e-01, 8.50000000e-01, 3.60000000e-01,
5.20000000e-01, 1.22000000e+00, 8.20000000e-01,
7.00000000e-01, 6.50000000e-01, 6.20000000e-01,
8.40000000e-01, 8.70000000e-01, 1.07000000e+00,
8.30000000e-01, 7.90000000e-01, 6.70000000e-01,
3.90000000e-01, 2.00000000e+00, 8.10000000e-01,
5.90000000e-01, 7.10000000e-01, 1.10000000e+00,
1.44000000e+00, 9.40000000e-01, 5.60000000e-01,
1.51000000e+00, 1.36000000e+00, 5.70000000e-01,
7.50000000e-01, 1.14000000e+00, 7.70000000e-01,
1.11000000e+00, 1.02000000e+00, 7.40000000e-01,
7.30000000e-01, 1.29000000e+00, 9.10000000e-01,
5.50000000e-01, 1.41000000e+00, 6.30000000e-01,
1.00000000e+00, 1.55000000e+00, 1.17000000e+00,
9.60000000e-01, 9.20000000e-01, 1.15000000e+00,
1.94000000e+00, 1.73000000e+00, 6.10000000e-01,
1.50000000e+00, 1.20000000e+00, 1.23000000e+00,
1.35000000e+00, 1.25000000e+00, 1.64000000e+00,
1.39000000e+00, 1.85000000e+00, 9.00000000e-01,
1.19000000e+00, 1.01000000e+00, 1.26000000e+00,
9.70000000e-01, 1.04000000e+00, 1.08000000e+00,
1.63000000e+00, 1.75000000e+00, 1.38000000e+00,
7.60000000e-01, 9.50000000e-01, 6.40000000e-01,
2.10000000e+00, 1.54000000e+00, 6.80000000e-01,
1.45000000e+00, 6.00000000e+00, 1.05000000e+00,
1.30000000e+00, 1.06000000e+00, 1.21000000e+00,
9.90000000e-01, 1.34000000e+00, 1.40000000e+00,
8.60000000e-01, 2.57000000e+00, 3.04000000e+00,
8.80000000e-01, 1.06100000e+01, 1.13000000e+00,
1.48000000e+00])
In [25]:
tm = (ohare_rain_df.index.astype(np.int64) // 10**9)
large_gaps = np.where(np.diff(tm) < -3601)[0]
ohare_rain_df.iloc[sorted(np.hstack((large_gaps, large_gaps+1)))]['DATE']
Out[25]:
Series([], Name: DATE, dtype: object)
In [17]:
ohare_rain_df.shape
Out[17]:
(654539, 5)
In [26]:
ohare_rain_df.to_csv('data/ohare_full_precip_hourly.csv', index=False)
In [27]:
midway_rain_df = pd.read_csv('data/full_midway_noaa.csv')
midway_rain_df = midway_rain_df[['STATION', 'STATION_NAME', 'DATE', 'HOURLYPrecip']]
midway_rain_df['datetime'] = pd.to_datetime(midway_rain_df['DATE'])
midway_rain_df = midway_rain_df.set_index(pd.DatetimeIndex(midway_rain_df['datetime']))
midway_rain_df['HOURLYPrecip'] = midway_rain_df['HOURLYPrecip'].str.replace('[^\d.]+', '')
midway_rain_df['HOURLYPrecip'] = midway_rain_df['HOURLYPrecip'].convert_objects(convert_numeric=True).fillna(0.0)
print(midway_rain_df.dtypes)
midway_rain_df.head()
c:\users\sier-patrick\.virtualenvs\mine\lib\site-packages\IPython\core\interactiveshell.py:2717: DtypeWarning: Columns (7,8,10,11,12,13,14,15,16,17,18,20,22,23,24,25,26,27,28,29,33,34,37,38,39,40,44,45,46,47,59,63,64,68,69,70,71,72,73,74,84,85,86,87) have mixed types. Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
STATION object
STATION_NAME object
DATE object
HOURLYPrecip float64
datetime datetime64[ns]
dtype: object
c:\users\sier-patrick\.virtualenvs\mine\lib\site-packages\ipykernel\__main__.py:6: FutureWarning: convert_objects is deprecated. Use the data-type specific converters pd.to_datetime, pd.to_timedelta and pd.to_numeric.
Out[27]:
STATION
STATION_NAME
DATE
HOURLYPrecip
datetime
1948-01-01 01:00:00
WBAN:14819
CHICAGO MIDWAY AIRPORT IL US
1948-01-01 01:00
0.0
1948-01-01 01:00:00
1948-01-01 02:00:00
WBAN:14819
CHICAGO MIDWAY AIRPORT IL US
1948-01-01 02:00
0.0
1948-01-01 02:00:00
1948-01-01 03:00:00
WBAN:14819
CHICAGO MIDWAY AIRPORT IL US
1948-01-01 03:00
0.0
1948-01-01 03:00:00
1948-01-01 04:00:00
WBAN:14819
CHICAGO MIDWAY AIRPORT IL US
1948-01-01 04:00
0.0
1948-01-01 04:00:00
1948-01-01 05:00:00
WBAN:14819
CHICAGO MIDWAY AIRPORT IL US
1948-01-01 05:00
0.0
1948-01-01 05:00:00
In [28]:
midway_rain_df.to_csv('data/midway_full_precip_hourly.csv', index=False)
In [29]:
tm = (midway_rain_df.index.astype(np.int64) // 10**9)
large_gaps = np.where(np.diff(tm) < -3601)[0]
midway_rain_df.iloc[sorted(np.hstack((large_gaps, large_gaps+1)))]['DATE']
Out[29]:
Series([], Name: DATE, dtype: object)
In [30]:
midway_rain_df.shape
Out[30]:
(653968, 5)
In [33]:
ohare_rain_df.loc['20160125':'20160125']
Out[33]:
STATION
STATION_NAME
DATE
HOURLYPrecip
datetime
2016-01-25 00:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 00:00
0.00
2016-01-25 00:00:00
2016-01-25 00:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 00:51
0.00
2016-01-25 00:51:00
2016-01-25 01:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 01:51
0.00
2016-01-25 01:51:00
2016-01-25 02:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 02:51
0.00
2016-01-25 02:51:00
2016-01-25 03:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 03:51
0.00
2016-01-25 03:51:00
2016-01-25 04:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 04:51
0.00
2016-01-25 04:51:00
2016-01-25 05:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 05:51
0.00
2016-01-25 05:51:00
2016-01-25 06:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 06:00
0.00
2016-01-25 06:00:00
2016-01-25 06:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 06:51
0.00
2016-01-25 06:51:00
2016-01-25 07:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 07:51
0.00
2016-01-25 07:51:00
2016-01-25 08:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 08:51
0.00
2016-01-25 08:51:00
2016-01-25 09:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 09:51
0.00
2016-01-25 09:51:00
2016-01-25 10:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 10:51
0.00
2016-01-25 10:51:00
2016-01-25 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 11:51
0.00
2016-01-25 11:51:00
2016-01-25 12:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 12:00
0.00
2016-01-25 12:00:00
2016-01-25 12:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 12:51
0.00
2016-01-25 12:51:00
2016-01-25 13:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 13:51
0.00
2016-01-25 13:51:00
2016-01-25 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 14:51
0.00
2016-01-25 14:51:00
2016-01-25 15:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 15:51
0.00
2016-01-25 15:51:00
2016-01-25 16:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 16:49
0.00
2016-01-25 16:49:00
2016-01-25 16:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 16:51
0.00
2016-01-25 16:51:00
2016-01-25 17:12:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:12
0.04
2016-01-25 17:12:00
2016-01-25 17:30:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:30
0.07
2016-01-25 17:30:00
2016-01-25 17:41:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:41
0.09
2016-01-25 17:41:00
2016-01-25 17:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:49
0.00
2016-01-25 17:49:00
2016-01-25 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:51
0.00
2016-01-25 17:51:00
2016-01-25 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 18:00
0.00
2016-01-25 18:00:00
2016-01-25 18:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 18:51
0.00
2016-01-25 18:51:00
2016-01-25 19:25:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 19:25
0.00
2016-01-25 19:25:00
2016-01-25 19:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 19:49
0.00
2016-01-25 19:49:00
2016-01-25 19:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 19:51
0.00
2016-01-25 19:51:00
2016-01-25 20:03:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 20:03
0.00
2016-01-25 20:03:00
2016-01-25 20:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 20:51
0.00
2016-01-25 20:51:00
2016-01-25 21:02:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:02
0.00
2016-01-25 21:02:00
2016-01-25 21:10:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:10
0.00
2016-01-25 21:10:00
2016-01-25 21:27:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:27
0.00
2016-01-25 21:27:00
2016-01-25 21:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:51
0.00
2016-01-25 21:51:00
2016-01-25 22:44:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 22:44
0.00
2016-01-25 22:44:00
2016-01-25 22:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 22:51
0.01
2016-01-25 22:51:00
2016-01-25 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 23:51
0.00
2016-01-25 23:51:00
2016-01-25 23:59:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 23:59
0.00
2016-01-25 23:59:00
In [44]:
ohare_rain_test = pd.read_csv('data/full_ohare_noaa.csv')
ohare_rain_test = ohare_rain_test[['STATION', 'STATION_NAME', 'DATE', 'HOURLYPrecip']]
ohare_rain_test['datetime'] = pd.to_datetime(ohare_rain_test['DATE'])
ohare_rain_test = ohare_rain_test.set_index(pd.DatetimeIndex(ohare_rain_test['datetime']))
ohare_rain_test['20160125':'20160125']
c:\users\sier-patrick\.virtualenvs\mine\lib\site-packages\IPython\core\interactiveshell.py:2717: DtypeWarning: Columns (8,10,11,12,13,14,15,16,17,18,20,22,23,24,25,26,27,28,29,33,34,37,38,39,40,44,45,59,63,64,67,68,69,70,84,85,86,87) have mixed types. Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
Out[44]:
STATION
STATION_NAME
DATE
HOURLYPrecip
datetime
2016-01-25 00:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 00:00
NaN
2016-01-25 00:00:00
2016-01-25 00:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 00:51
0.00
2016-01-25 00:51:00
2016-01-25 01:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 01:51
0.00
2016-01-25 01:51:00
2016-01-25 02:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 02:51
0.00
2016-01-25 02:51:00
2016-01-25 03:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 03:51
0.00
2016-01-25 03:51:00
2016-01-25 04:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 04:51
0.00
2016-01-25 04:51:00
2016-01-25 05:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 05:51
0.00
2016-01-25 05:51:00
2016-01-25 06:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 06:00
NaN
2016-01-25 06:00:00
2016-01-25 06:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 06:51
0.00
2016-01-25 06:51:00
2016-01-25 07:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 07:51
0.00
2016-01-25 07:51:00
2016-01-25 08:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 08:51
0.00
2016-01-25 08:51:00
2016-01-25 09:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 09:51
0.00
2016-01-25 09:51:00
2016-01-25 10:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 10:51
0.00
2016-01-25 10:51:00
2016-01-25 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 11:51
0.00
2016-01-25 11:51:00
2016-01-25 12:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 12:00
NaN
2016-01-25 12:00:00
2016-01-25 12:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 12:51
0.00
2016-01-25 12:51:00
2016-01-25 13:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 13:51
0.00
2016-01-25 13:51:00
2016-01-25 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 14:51
0.00
2016-01-25 14:51:00
2016-01-25 15:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 15:51
0.00
2016-01-25 15:51:00
2016-01-25 16:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 16:49
NaN
2016-01-25 16:49:00
2016-01-25 16:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 16:51
T
2016-01-25 16:51:00
2016-01-25 17:12:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:12
0.04
2016-01-25 17:12:00
2016-01-25 17:30:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:30
0.07
2016-01-25 17:30:00
2016-01-25 17:41:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:41
0.09
2016-01-25 17:41:00
2016-01-25 17:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:49
NaN
2016-01-25 17:49:00
2016-01-25 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 17:51
T
2016-01-25 17:51:00
2016-01-25 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 18:00
NaN
2016-01-25 18:00:00
2016-01-25 18:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 18:51
T
2016-01-25 18:51:00
2016-01-25 19:25:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 19:25
T
2016-01-25 19:25:00
2016-01-25 19:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 19:49
NaN
2016-01-25 19:49:00
2016-01-25 19:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 19:51
T
2016-01-25 19:51:00
2016-01-25 20:03:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 20:03
T
2016-01-25 20:03:00
2016-01-25 20:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 20:51
T
2016-01-25 20:51:00
2016-01-25 21:02:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:02
NaN
2016-01-25 21:02:00
2016-01-25 21:10:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:10
NaN
2016-01-25 21:10:00
2016-01-25 21:27:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:27
NaN
2016-01-25 21:27:00
2016-01-25 21:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 21:51
T
2016-01-25 21:51:00
2016-01-25 22:44:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 22:44
T
2016-01-25 22:44:00
2016-01-25 22:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 22:51
0.01
2016-01-25 22:51:00
2016-01-25 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 23:51
0.120.11s
2016-01-25 23:51:00
2016-01-25 23:59:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 23:59
NaN
2016-01-25 23:59:00
In [49]:
print(ohare_rain_test.shape)
#ohare_with_s = ohare_rain_test
#ohare_with_s['HOURLYPrecip'] = ohare_with_s['HOURLYPrecip'].fillna('fake')
#ohare_rain_test.head()
#ohare_with_s = ohare_with_s[ohare_with_s['HOURLYPrecip'].str.contains('s')]
#print(ohare_with_s.shape)
ohare_with_s['HOURLYPrecip'] = ohare_with_s['HOURLYPrecip'].astype(str)
ohare_with_s = ohare_with_s[ohare_with_s['HOURLYPrecip'].str.contains('s')]
print(ohare_with_s.shape)
(654539, 5)
(649, 5)
In [50]:
ohare_with_s
Out[50]:
STATION
STATION_NAME
DATE
HOURLYPrecip
datetime
1973-01-03 14:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 14:00
0.09s
1973-01-03 14:00:00
1973-01-03 15:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 15:00
0.26s
1973-01-03 15:00:00
1973-01-03 16:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 16:00
0.16s
1973-01-03 16:00:00
1973-01-03 17:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 17:00
0.06s
1973-01-03 17:00:00
1973-01-03 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 18:00
0.01s
1973-01-03 18:00:00
1973-01-03 19:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 19:00
0.01s
1973-01-03 19:00:00
1973-01-03 20:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 20:00
0.01s
1973-01-03 20:00:00
1973-01-03 21:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 21:00
0.01s
1973-01-03 21:00:00
1973-01-03 22:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-03 22:00
0.01s
1973-01-03 22:00:00
1973-01-19 00:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-01-19 00:00
0.01s
1973-01-19 00:00:00
1973-03-03 02:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-03-03 02:00
0.01s
1973-03-03 02:00:00
1973-03-05 00:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-03-05 00:00
0.01s
1973-03-05 00:00:00
1973-03-09 09:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-03-09 09:00
0.01s
1973-03-09 09:00:00
1973-03-10 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-03-10 18:00
0.09s
1973-03-10 18:00:00
1973-03-16 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-03-16 18:00
0.01s
1973-03-16 18:00:00
1973-03-31 21:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-03-31 21:00
0.16s
1973-03-31 21:00:00
1973-04-09 03:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-04-09 03:00
0.04s
1973-04-09 03:00:00
1973-04-11 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-04-11 18:00
0.01s
1973-04-11 18:00:00
1973-04-29 03:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-04-29 03:00
0.01s
1973-04-29 03:00:00
1973-05-14 06:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-05-14 06:00
0.13s
1973-05-14 06:00:00
1973-05-22 03:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-05-22 03:00
0.01s
1973-05-22 03:00:00
1973-05-29 21:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-05-29 21:00
0.01s
1973-05-29 21:00:00
1973-06-05 09:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-06-05 09:00
0.01s
1973-06-05 09:00:00
1973-06-05 15:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-06-05 15:00
0.17s
1973-06-05 15:00:00
1973-06-23 12:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-06-23 12:00
0.05s
1973-06-23 12:00:00
1973-06-27 21:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-06-27 21:00
0.32s
1973-06-27 21:00:00
1973-08-14 03:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-08-14 03:00
0.01s
1973-08-14 03:00:00
1973-08-23 21:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-08-23 21:00
0.01s
1973-08-23 21:00:00
1973-09-16 12:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-09-16 12:00
0.01s
1973-09-16 12:00:00
1973-09-24 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
1973-09-24 18:00
0.26s
1973-09-24 18:00:00
...
...
...
...
...
...
2015-08-17 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-08-17 14:51
0.08s
2015-08-17 14:51:00
2015-09-11 05:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-09-11 05:51
0.09s
2015-09-11 05:51:00
2015-09-17 20:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-09-17 20:51
0.03s
2015-09-17 20:51:00
2015-10-24 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-10-24 14:51
0.01s
2015-10-24 14:51:00
2015-10-27 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-10-27 11:51
0.05s
2015-10-27 11:51:00
2015-11-18 08:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-11-18 08:51
0.01s
2015-11-18 08:51:00
2015-11-21 12:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-11-21 12:51
0.31s
2015-11-21 12:51:00
2015-11-26 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-11-26 23:51
0.11s
2015-11-26 23:51:00
2015-11-30 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-11-30 17:51
0.07s
2015-11-30 17:51:00
2015-12-13 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-12-13 14:51
0.06s
2015-12-13 14:51:00
2015-12-20 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-12-20 23:51
0.03s
2015-12-20 23:51:00
2015-12-26 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-12-26 11:51
0.08s
2015-12-26 11:51:00
2015-12-26 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2015-12-26 23:51
0.07s
2015-12-26 23:51:00
2016-01-08 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-08 23:51
0.05s
2016-01-08 23:51:00
2016-01-11 21:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-11 21:51
0.020.06s
2016-01-11 21:51:00
2016-01-25 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-01-25 23:51
0.120.11s
2016-01-25 23:51:00
2016-02-15 20:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-02-15 20:51
0.01s
2016-02-15 20:51:00
2016-02-24 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-02-24 14:51
0.01Ts
2016-02-24 14:51:00
2016-02-24 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-02-24 17:51
0.02Ts
2016-02-24 17:51:00
2016-03-01 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-03-01 11:51
0.05s
2016-03-01 11:51:00
2016-03-13 08:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-03-13 08:51
0.04s
2016-03-13 08:51:00
2016-04-27 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-04-27 14:51
0.02s
2016-04-27 14:51:00
2016-04-28 20:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-04-28 20:51
0.01s
2016-04-28 20:51:00
2016-05-31 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-05-31 14:51
0.26s
2016-05-31 14:51:00
2016-07-07 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-07 17:51
0.87s
2016-07-07 17:51:00
2016-07-23 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-23 17:51
0.17s
2016-07-23 17:51:00
2016-07-28 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 11:51
0.44s
2016-07-28 11:51:00
2016-07-29 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-29 14:51
0.06s
2016-07-29 14:51:00
2016-08-19 08:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-08-19 08:51
0.04s
2016-08-19 08:51:00
2016-08-24 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-08-24 23:51
0.04s
2016-08-24 23:51:00
649 rows × 5 columns
In [52]:
ohare_rain_df['20160728':'20160728']
Out[52]:
STATION
STATION_NAME
DATE
HOURLYPrecip
datetime
2016-07-28 00:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 00:00
0.00
2016-07-28 00:00:00
2016-07-28 00:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 00:51
0.00
2016-07-28 00:51:00
2016-07-28 01:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 01:51
0.00
2016-07-28 01:51:00
2016-07-28 02:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 02:51
0.00
2016-07-28 02:51:00
2016-07-28 03:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 03:51
0.00
2016-07-28 03:51:00
2016-07-28 04:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 04:51
0.00
2016-07-28 04:51:00
2016-07-28 05:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 05:51
0.00
2016-07-28 05:51:00
2016-07-28 06:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 06:00
0.00
2016-07-28 06:00:00
2016-07-28 06:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 06:51
0.00
2016-07-28 06:51:00
2016-07-28 07:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 07:51
0.00
2016-07-28 07:51:00
2016-07-28 08:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 08:51
0.00
2016-07-28 08:51:00
2016-07-28 09:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 09:51
0.00
2016-07-28 09:51:00
2016-07-28 10:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 10:51
0.00
2016-07-28 10:51:00
2016-07-28 11:23:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 11:23
0.01
2016-07-28 11:23:00
2016-07-28 11:34:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 11:34
0.13
2016-07-28 11:34:00
2016-07-28 11:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 11:51
0.44
2016-07-28 11:51:00
2016-07-28 12:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 12:00
0.14
2016-07-28 12:00:00
2016-07-28 12:13:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 12:13
0.20
2016-07-28 12:13:00
2016-07-28 12:43:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 12:43
0.22
2016-07-28 12:43:00
2016-07-28 12:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 12:51
0.12
2016-07-28 12:51:00
2016-07-28 13:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 13:51
0.00
2016-07-28 13:51:00
2016-07-28 14:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 14:51
0.01
2016-07-28 14:51:00
2016-07-28 15:01:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 15:01
0.01
2016-07-28 15:01:00
2016-07-28 15:06:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 15:06
0.01
2016-07-28 15:06:00
2016-07-28 15:38:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 15:38
0.09
2016-07-28 15:38:00
2016-07-28 15:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 15:51
0.08
2016-07-28 15:51:00
2016-07-28 16:16:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 16:16
0.01
2016-07-28 16:16:00
2016-07-28 16:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 16:51
0.01
2016-07-28 16:51:00
2016-07-28 17:23:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 17:23
0.00
2016-07-28 17:23:00
2016-07-28 17:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 17:51
0.00
2016-07-28 17:51:00
2016-07-28 18:00:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 18:00
0.00
2016-07-28 18:00:00
2016-07-28 18:10:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 18:10
0.00
2016-07-28 18:10:00
2016-07-28 18:23:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 18:23
0.00
2016-07-28 18:23:00
2016-07-28 18:31:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 18:31
0.00
2016-07-28 18:31:00
2016-07-28 18:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 18:51
0.00
2016-07-28 18:51:00
2016-07-28 19:49:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 19:49
0.00
2016-07-28 19:49:00
2016-07-28 19:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 19:51
0.00
2016-07-28 19:51:00
2016-07-28 19:58:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 19:58
0.00
2016-07-28 19:58:00
2016-07-28 20:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 20:51
0.00
2016-07-28 20:51:00
2016-07-28 21:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 21:51
0.00
2016-07-28 21:51:00
2016-07-28 22:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 22:51
0.00
2016-07-28 22:51:00
2016-07-28 23:01:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 23:01
0.00
2016-07-28 23:01:00
2016-07-28 23:36:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 23:36
0.00
2016-07-28 23:36:00
2016-07-28 23:51:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 23:51
0.00
2016-07-28 23:51:00
2016-07-28 23:59:00
WBAN:94846
CHICAGO OHARE INTERNATIONAL AIRPORT IL US
2016-07-28 23:59
0.00
2016-07-28 23:59:00
In [ ]:
midway_series = midway_rain_df['hourly_precip'].resample('1H').max()
print(chi_rain_series.count())
chi_rain_series.head()
Content source: kbrose/rain
Similar notebooks: