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
from datetime import timedelta, datetime
%matplotlib notebook
In [2]:
csos = pd.read_csv('data/merged_cso_data.csv')
csos['Open date/time'] = pd.to_datetime(csos['Open date/time'])
csos['Close date/time'] = pd.to_datetime(csos['Close date/time'])
csos['Duration'] = csos['Close date/time'] - csos['Open date/time']
csos.head()
Out[2]:
Outfall Structure
Outfall Location
Tide Gate #
Waterway Reach
Plant
Open date/time
Close date/time
Gate Open Period
Duration
0
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:54:00
2016-04-01 23:07:00
0 days 05:13:48.000000000
05:13:00
1
DS-N08
Mango Ave ext. (Leonard & Miltmore) (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:53:00
2016-04-01 19:42:00
0 days 01:48:55.000000000
01:49:00
2
DS-N10B
Imlay St & Milwaukee (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 18:10:00
2016-04-01 18:26:00
0 days 00:16:08.000000000
00:16:00
3
DS-N08
Mango Ave ext. (Leonard & Miltmore) (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:53:00
2016-04-01 19:42:00
0 days 01:48:55.000000000
01:49:00
4
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:54:00
2016-04-01 23:07:00
0 days 05:13:48.000000000
05:13:00
In [3]:
rain_df = pd.read_csv('data/ohare_hourly_20160929.csv')
rain_df['datetime'] = pd.to_datetime(rain_df['datetime'])
rain_df = rain_df.set_index(pd.DatetimeIndex(rain_df['datetime']))
rain_df = rain_df['19700101':]
chi_rain_series = rain_df['HOURLYPrecip'].resample('1H', label='right').max()
chi_rain_series.head()
Out[3]:
1970-01-01 04:00:00 0.0
1970-01-01 05:00:00 NaN
1970-01-01 06:00:00 NaN
1970-01-01 07:00:00 0.0
1970-01-01 08:00:00 NaN
Freq: H, Name: HOURLYPrecip, dtype: float64
In [4]:
def cum_rainfall(timestamps, hours_before):
results = []
for timestamp in timestamps:
top_of_hour = (timestamp + timedelta(hours=1)).replace(minute=0, second=0)
rain_start = top_of_hour - timedelta(hours=(hours_before-1))
results.append(chi_rain_series[rain_start:top_of_hour].sum())
return results
cum_rainfall(csos['Open date/time'], 24)
Out[4]:
[0.12,
0.12,
0.12,
0.12,
0.12,
0.080000000000000002,
0.080000000000000002,
0.080000000000000002,
0.12000000000000001,
0.29999999999999999,
0.29999999999999999,
0.31000000000000005,
0.29999999999999999,
0.31,
0.29999999999999999,
0.31,
0.31,
0.24000000000000002,
0.29999999999999999,
0.29999999999999999,
0.31,
0.31,
0.31,
0.39000000000000001,
0.49000000000000005,
0.35999999999999999,
0.49000000000000005,
0.089999999999999997,
0.089999999999999997,
0.089999999999999997,
0.089999999999999997,
0.089999999999999997,
0.089999999999999997,
0.089999999999999997,
0.23000000000000001,
0.23000000000000001,
0.23000000000000001,
0.23000000000000001,
0.23000000000000001,
0.23000000000000001,
0.23000000000000001,
0.27000000000000002,
0.27000000000000002,
0.27000000000000002,
0.27000000000000002,
0.23000000000000001,
0.27000000000000002,
0.23000000000000001,
0.27000000000000002,
0.27000000000000002,
0.89999999999999991,
0.89999999999999991,
0.86999999999999988,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.86999999999999988,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.96999999999999997,
0.89999999999999991,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.96999999999999997,
0.94999999999999996,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.94999999999999996,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.86999999999999988,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.96999999999999997,
0.89999999999999991,
0.94999999999999996,
0.27000000000000002,
0.94999999999999996,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.01,
0.34999999999999998,
0.60999999999999999,
0.34999999999999998,
0.62,
0.52000000000000002,
0.63,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.53000000000000003,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.63,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.53000000000000003,
0.28000000000000003,
0.28000000000000003,
0.28000000000000003,
0.28000000000000003,
0.28000000000000003,
0.41000000000000003,
0.41000000000000003,
0.41000000000000003,
0.41000000000000003,
0.41000000000000003,
0.28000000000000003,
0.41000000000000003,
0.41000000000000003,
0.41000000000000003,
0.41000000000000003,
0.41000000000000003,
0.28000000000000003,
0.41000000000000003,
0.68000000000000005,
0.68000000000000005,
0.68000000000000005,
0.68000000000000005,
0.92999999999999994,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
1.4199999999999999,
0.60000000000000009,
0.82000000000000006,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.52000000000000002,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.70999999999999996,
0.26000000000000001,
0.64000000000000012,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.71999999999999997,
0.67999999999999994,
0.67999999999999994,
0.64000000000000012,
0.67999999999999994,
0.64000000000000012,
0.67999999999999994,
0.71999999999999997,
0.67999999999999994,
0.67999999999999994,
0.64000000000000012,
0.64000000000000012,
0.64000000000000012,
0.64000000000000012,
0.67999999999999994,
0.71999999999999997,
0.71999999999999997,
0.67999999999999994,
0.67999999999999994,
0.64000000000000012,
0.71999999999999997,
0.67999999999999994,
0.64000000000000012,
0.67999999999999994,
0.67999999999999994,
0.64000000000000012,
0.72000000000000008,
0.64000000000000012,
0.67999999999999994,
0.54999999999999993,
0.72000000000000008,
0.67999999999999994,
0.67999999999999994,
0.64000000000000012,
0.72000000000000008,
0.64000000000000012,
0.64000000000000012,
0.67999999999999994,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.64000000000000012,
0.64000000000000012,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.54999999999999993,
0.72000000000000008,
0.67999999999999994,
0.72000000000000008,
0.67999999999999994,
0.64000000000000012,
0.72000000000000008,
0.67999999999999994,
0.72000000000000008,
0.72000000000000008,
0.67999999999999994,
0.72000000000000008,
0.72000000000000008,
0.67999999999999994,
0.67999999999999994,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.67999999999999994,
0.67999999999999994,
0.71999999999999997,
0.71999999999999997,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.67999999999999994,
0.64000000000000012,
0.64000000000000012,
0.70999999999999996,
0.64000000000000012,
0.71999999999999997,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.72000000000000008,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.71999999999999997,
0.64000000000000012,
0.64000000000000012,
0.64000000000000012,
0.54999999999999993,
0.040000000000000001,
0.82999999999999996,
0.82999999999999996,
0.82999999999999996,
0.82999999999999996,
0.82999999999999996,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.82999999999999996,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.82999999999999996,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.82999999999999996,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.89999999999999991,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.94999999999999996,
0.040000000000000001,
0.94999999999999996,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.82999999999999996,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.89999999999999991,
0.95999999999999996,
0.94999999999999996,
0.94999999999999996,
0.95999999999999996,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.95999999999999996,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.95999999999999996,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.95999999999999996,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.82999999999999996,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.89999999999999991,
0.89999999999999991,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.89999999999999991,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.96999999999999997,
0.040000000000000001,
0.96999999999999997,
0.96999999999999997,
0.10999999999999999,
0.11,
0.11999999999999998,
0.11999999999999998,
0.12,
0.11999999999999998,
0.12,
0.12,
0.11999999999999998,
0.11999999999999998,
0.11999999999999998,
0.11999999999999998,
0.11999999999999998,
0.12,
0.11999999999999998,
0.11999999999999998,
0.11999999999999998,
0.12999999999999998,
0.96999999999999997,
0.12,
0.11,
0.11999999999999998,
0.12,
0.54000000000000004,
0.42999999999999999,
0.0,
0.0,
0.0,
0.0,
0.95999999999999996,
0.01,
0.01,
0.01,
0.01,
0.01,
0.01,
0.01,
0.0,
0.28999999999999998,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
0.069999999999999993,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
1.3100000000000001,
0.67000000000000004,
0.67000000000000004,
0.67000000000000004,
0.67000000000000004,
0.67000000000000004,
0.67000000000000004,
1.0700000000000001,
0.83000000000000007,
0.83000000000000007,
1.0800000000000001,
1.0800000000000001,
1.0800000000000001,
0.98000000000000009,
0.98000000000000009,
0.98000000000000009,
0.98000000000000009,
0.98000000000000009,
0.98000000000000009,
0.98000000000000009,
0.98000000000000009,
0.059999999999999998,
0.059999999999999998,
0.059999999999999998,
0.35999999999999999,
0.35999999999999999,
0.35999999999999999,
0.35999999999999999,
0.28999999999999998,
0.35999999999999999,
0.35999999999999999,
1.24,
1.24,
1.24,
1.24,
1.24,
1.24,
1.24,
1.24,
1.24,
1.24,
0.01,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
0.20000000000000001,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.0900000000000001,
1.0900000000000001,
1.03,
0.20000000000000001,
1.03,
1.03,
1.03,
1.03,
1.03,
1.0900000000000001,
1.03,
1.0900000000000001,
1.0900000000000001,
1.03,
1.0999999999999999,
1.0999999999999999,
1.03,
1.03,
1.03,
1.0900000000000001,
1.03,
1.03,
1.03,
1.1000000000000001,
1.1000000000000001,
1.03,
1.1000000000000001,
1.1000000000000001,
1.03,
1.1000000000000001,
1.03,
1.03,
0.20000000000000001,
1.03,
1.1000000000000001,
1.1000000000000001,
1.03,
1.1000000000000001,
1.1000000000000001,
1.1000000000000001,
1.03,
1.03,
1.03,
1.03,
1.0900000000000001,
1.0900000000000001,
1.03,
1.03,
1.1000000000000001,
1.03,
1.03,
1.0999999999999999,
1.1000000000000001,
1.03,
1.03,
1.03,
1.03,
1.03,
1.03,
1.0900000000000001,
0.20000000000000001,
1.0999999999999999,
0.20000000000000001,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
1.29,
0.55000000000000004,
1.29,
1.29,
0.55000000000000004,
1.29,
0.55000000000000004,
0.55000000000000004,
0.55000000000000004,
0.55000000000000004,
0.55000000000000004,
0.55000000000000004,
1.29,
1.29,
1.29,
1.29,
0.55000000000000004,
0.55000000000000004,
1.29,
1.29,
1.29,
1.29,
0.46000000000000002,
0.46000000000000002,
1.29,
1.29,
1.29,
1.29,
1.29,
0.39000000000000001,
0.39000000000000001,
1.29,
1.29,
1.29,
1.29,
1.29,
0.98999999999999999,
0.98999999999999999,
0.45000000000000001,
0.71999999999999997,
0.64000000000000012,
0.70999999999999996,
1.4199999999999999,
0.41000000000000003,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.89999999999999991,
0.75000000000000011,
0.75000000000000011,
0.79000000000000004,
0.75000000000000011,
0.79000000000000004,
0.83000000000000007,
0.15000000000000002,
0.79000000000000004,
0.33000000000000007,
0.33000000000000007,
0.78000000000000003,
0.31,
0.47000000000000003,
0.78000000000000003,
0.47000000000000003,
0.73000000000000009,
0.089999999999999997,
0.0,
0.21999999999999997,
0.19000000000000003,
0.029999999999999999,
0.19000000000000003,
0.19000000000000003,
0.029999999999999999,
0.01,
1.4900000000000002,
1.4900000000000002,
1.49,
1.3999999999999999,
1.3300000000000001,
1.3999999999999999,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.52000000000000002,
0.46000000000000002,
0.52000000000000002,
0.92000000000000004,
1.05,
1.05,
0.80000000000000004,
0.78000000000000003,
0.96000000000000008,
0.78000000000000003,
0.78000000000000003,
0.78000000000000003,
0.78000000000000003,
0.89000000000000012,
0.53000000000000003,
0.77000000000000002,
0.78999999999999992,
0.65000000000000002,
0.64000000000000001,
0.64000000000000001,
0.66000000000000003,
0.64000000000000001,
0.64000000000000001,
0.64000000000000001,
0.64000000000000001,
0.65000000000000002,
0.64000000000000001,
0.65000000000000002,
0.65000000000000002,
0.65000000000000002,
0.66000000000000003,
0.65000000000000002,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
1.1800000000000002,
1.3700000000000001,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
1.3700000000000001,
2.0700000000000003,
1.3700000000000001,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
1.26,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
1.3700000000000001,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
2.0700000000000003,
...]
In [5]:
csos['24hr_rain'] = cum_rainfall(csos['Open date/time'], 24)
csos
Out[5]:
Outfall Structure
Outfall Location
Tide Gate #
Waterway Reach
Plant
Open date/time
Close date/time
Gate Open Period
Duration
24hr_rain
0
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:54:00
2016-04-01 23:07:00
0 days 05:13:48.000000000
05:13:00
0.12
1
DS-N08
Mango Ave ext. (Leonard & Miltmore) (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:53:00
2016-04-01 19:42:00
0 days 01:48:55.000000000
01:49:00
0.12
2
DS-N10B
Imlay St & Milwaukee (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 18:10:00
2016-04-01 18:26:00
0 days 00:16:08.000000000
00:16:00
0.12
3
DS-N08
Mango Ave ext. (Leonard & Miltmore) (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:53:00
2016-04-01 19:42:00
0 days 01:48:55.000000000
01:49:00
0.12
4
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-01 17:54:00
2016-04-01 23:07:00
0 days 05:13:48.000000000
05:13:00
0.12
5
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-02 10:17:00
2016-04-02 10:20:00
0 days 00:02:48.000000000
00:03:00
0.08
6
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-02 10:44:00
2016-04-02 11:58:00
0 days 01:13:52.000000000
01:14:00
0.08
7
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-02 15:40:00
2016-04-02 22:10:00
0 days 06:30:32.000000000
06:30:00
0.08
8
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-06 05:14:00
2016-04-06 06:59:00
0 days 01:44:52.000000000
01:45:00
0.12
9
DS-M84
Roscoe St (W)
TG4
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 11:48:00
2016-04-06 13:19:00
0 days 01:31:00.000000000
01:31:00
0.30
10
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 11:21:00
2016-04-06 13:45:00
0 days 02:23:56.000000000
02:24:00
0.30
11
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 13:59:00
2016-04-06 14:00:00
0 days 00:00:44.000000000
00:01:00
0.31
12
DS-N08
Mango Ave ext. (Leonard & Miltmore) (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-06 11:33:00
2016-04-06 14:17:00
0 days 02:43:24.000000000
02:44:00
0.30
13
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 14:34:00
2016-04-06 14:35:00
0 days 00:00:48.000000000
00:01:00
0.31
14
DS-M84
Roscoe St (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 11:51:00
2016-04-06 14:36:00
0 days 02:44:52.000000000
02:45:00
0.30
15
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 14:57:00
2016-04-06 14:59:00
0 days 00:01:32.000000000
00:02:00
0.31
16
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-06 16:14:00
2016-04-06 16:15:00
0 days 00:00:44.000000000
00:01:00
0.31
17
DS-N05
Forest Glen Ave (S), West of Cicero
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-06 09:11:00
2016-04-06 16:29:00
0 days 07:17:24.000000000
07:18:00
0.24
18
DS-M15
Kenton Ave (Kostner Ave Ext.) (N)
TG2
CSSC Upper (SWRP)
Stickney
2016-04-06 11:41:00
2016-04-06 16:30:00
0 days 04:49:28.000000000
04:49:00
0.30
19
DS-M03
67th St ext. (E)
TG1
CSSC Lower (SWRP)
Stickney
2016-04-06 19:15:00
2016-04-06 21:15:00
0 days 02:00:20.000000000
02:00:00
0.30
20
DS-M03
67th St ext. (E)
TG1
CSSC Lower (SWRP)
Stickney
2016-04-06 21:16:00
2016-04-06 21:18:00
0 days 00:02:20.000000000
00:02:00
0.31
21
DS-M03
67th St ext. (E)
TG1
CSSC Lower (SWRP)
Stickney
2016-04-06 21:19:00
2016-04-06 21:23:00
0 days 00:04:08.000000000
00:04:00
0.31
22
DS-M03
67th St ext. (E)
TG1
CSSC Lower (SWRP)
Stickney
2016-04-06 21:24:00
2016-04-06 21:25:00
0 days 00:01:36.000000000
00:01:00
0.31
23
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-20 22:28:00
2016-04-20 22:31:00
0 days 00:02:38.000000000
00:03:00
0.39
24
DS-M15
Kenton Ave (Kostner Ave Ext.) (N)
TG2
CSSC Upper (SWRP)
Stickney
2016-04-20 23:05:00
2016-04-20 23:11:00
0 days 00:05:14.000000000
00:06:00
0.49
25
DS-N08
Mango Ave ext. (Leonard & Miltmore) (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-20 21:51:00
2016-04-20 23:12:00
0 days 01:21:04.000000000
01:21:00
0.36
26
DS-M08
Natchez Ave ext. (S)
TG1
CSSC Lower (SWRP)
Stickney
2016-04-20 23:08:00
2016-04-20 23:14:00
0 days 00:05:44.000000000
00:06:00
0.49
27
DS-N10B
Imlay St & Milwaukee (W)
TG1
NBCR Upper (NSC Confluence)
Stickney
2016-04-25 21:56:00
2016-04-25 22:22:00
0 days 00:25:28.000000000
00:26:00
0.09
28
DS-M79
Logan Blvd (W)
TG2
NBCR Lower (NSC Confluence)
Stickney
2016-04-25 22:53:00
2016-04-25 22:55:00
0 days 00:02:44.000000000
00:02:00
0.09
29
DS-M84
Roscoe St (W)
TG4
NBCR Lower (NSC Confluence)
Stickney
2016-04-25 22:54:00
2016-04-25 23:26:00
0 days 00:31:32.000000000
00:32:00
0.09
...
...
...
...
...
...
...
...
...
...
...
10849
DS-M82
DS-M82
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-27 02:31:00
2009-08-27 11:02:00
0 days 08:31:00.000000000
08:31:00
1.17
10850
DS-M82
DS-M82
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-27 23:48:00
2009-08-27 23:59:00
0 days 00:11:00.000000000
00:11:00
0.95
10851
DS-M11
DS-M11
NaN
CSSC Lower (SWRP)
NaN
2009-08-27 05:03:00
2009-08-27 13:16:00
0 days 08:13:00.000000000
08:13:00
0.89
10852
DS-M84
DS-M84
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-27 03:03:00
2009-08-27 12:06:00
0 days 09:03:00.000000000
09:03:00
1.01
10853
DS-N16
DS-N16
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-27 08:43:00
2009-08-27 08:57:00
0 days 00:14:00.000000000
00:14:00
0.98
10854
DS-M13
DS-M13
NaN
CSSC Upper (SWRP)
NaN
2009-08-27 07:11:00
2009-08-27 07:16:00
0 days 00:05:00.000000000
00:05:00
0.98
10855
DS-N18
DS-N18
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-27 05:32:00
2009-08-27 06:14:00
0 days 00:42:00.000000000
00:42:00
0.89
10856
DS-N18
DS-N18
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-27 08:47:00
2009-08-27 09:40:00
0 days 00:53:00.000000000
00:53:00
0.98
10857
DS-M15
DS-M15
NaN
CSSC Upper (SWRP)
NaN
2009-08-27 05:30:00
2009-08-27 05:57:00
0 days 00:27:00.000000000
00:27:00
0.89
10858
DS-M15
DS-M15
NaN
CSSC Upper (SWRP)
NaN
2009-08-27 06:39:00
2009-08-27 07:34:00
0 days 00:55:00.000000000
00:55:00
0.87
10859
DS-N17
DS-N17
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-27 05:28:00
2009-08-27 06:15:00
0 days 00:47:00.000000000
00:47:00
0.89
10860
DS-N17
DS-N17
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-27 08:41:00
2009-08-27 09:35:00
0 days 00:54:00.000000000
00:54:00
0.98
10861
DS-M80
DS-M80
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-27 04:54:00
2009-08-27 13:05:00
0 days 08:11:00.000000000
08:11:00
0.93
10862
DS-M76
DS-M76
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-26 05:59:00
2009-08-26 06:36:00
0 days 00:37:00.000000000
00:37:00
0.57
10863
DS-D16
DS-D16
NaN
DesPlaines Middle
NaN
2009-08-26 16:13:00
2009-08-26 16:28:00
0 days 00:15:00.000000000
00:15:00
0.83
10864
DS-N10B
DS-N10B
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-21 17:40:00
2009-08-21 18:13:00
0 days 00:33:00.000000000
00:33:00
0.07
10865
DS-N03
DS-N03
NaN
NBCR Upper (NSC Confluence)
NaN
2009-08-21 17:59:00
2009-08-21 18:37:00
0 days 00:38:00.000000000
00:38:00
0.07
10866
DS-M85
DS-M85
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-20 10:32:00
2009-08-20 13:07:00
0 days 02:35:00.000000000
02:35:00
0.42
10867
DS-M85
DS-M85
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-19 18:10:00
2009-08-19 19:08:00
0 days 00:58:00.000000000
00:58:00
0.37
10868
DS-M76
DS-M76
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-19 17:54:00
2009-08-19 18:48:00
0 days 00:54:00.000000000
00:54:00
0.37
10869
DS-D16
DS-D16
NaN
DesPlaines Middle
NaN
2009-08-19 17:53:00
2009-08-19 18:23:00
0 days 00:30:00.000000000
00:30:00
0.37
10870
DS-M13
DS-M13
NaN
CSSC Upper (SWRP)
NaN
2009-08-19 18:18:00
2009-08-19 18:32:00
0 days 00:14:00.000000000
00:14:00
0.37
10871
DS-M08
DS-M08
NaN
CSSC Lower (SWRP)
NaN
2009-08-19 17:49:00
2009-08-19 18:30:00
0 days 00:41:00.000000000
00:41:00
0.37
10872
DS-D07
DS-D07
NaN
DesPlaines Upper
NaN
2009-08-18 10:51:00
2009-08-18 10:53:00
0 days 00:02:00.000000000
00:02:00
0.02
10873
DS-D49
DS-D49
NaN
DesPlaines Lower
NaN
2009-08-17 06:45:00
2009-08-17 07:57:00
0 days 01:12:00.000000000
01:12:00
0.99
10874
DS-M76
DS-M76
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-17 06:04:00
2009-08-17 07:11:00
0 days 01:07:00.000000000
01:07:00
0.99
10875
DS-M76
DS-M76
NaN
NBCR Lower (NSC Confluence)
NaN
2009-08-17 14:55:00
2009-08-17 15:36:00
0 days 00:41:00.000000000
00:41:00
0.37
10876
DS-D27I
DS-D27I
NaN
DesPlaines Middle
NaN
2009-08-17 06:37:00
2009-08-17 10:32:00
0 days 03:55:00.000000000
03:55:00
0.99
10877
DS-D47,50,51
DS-D47,50,51
NaN
Salt Cr
NaN
2009-08-17 06:46:00
2009-08-17 08:29:00
0 days 01:43:00.000000000
01:43:00
0.99
10878
DS-D26
DS-D26
NaN
DesPlaines Middle
NaN
2009-08-17 07:24:00
2009-08-17 09:49:00
0 days 02:25:00.000000000
02:25:00
1.00
10879 rows × 10 columns
In [7]:
# What is the least amount of rain that causes a CSO?
csos = csos.sort_values('24hr_rain')
csos
Out[7]:
Outfall Structure
Outfall Location
Tide Gate #
Waterway Reach
Plant
Open date/time
Close date/time
Gate Open Period
Duration
24hr_rain
4959
DS-D43
DS-D43
NaN
DesPlaines Lower
NaN
2013-05-30 10:16:00
2013-05-30 10:28:00
0 days 00:12:00.000000000
00:12:00
0.00
282
DS-D43
Near Burling Rd (Library)
TG1
DesPlaines Lower
Stickney
2016-05-13 03:41:00
2016-05-13 03:48:00
0 days 00:07:08.000000000
00:07:00
0.00
281
DS-D43
Near Burling Rd (Library)
TG1
DesPlaines Lower
Stickney
2016-05-13 03:34:00
2016-05-13 03:40:00
0 days 00:06:44.000000000
00:06:00
0.00
7457
DS-N08
DS-N08
NaN
NBCR Upper (NSC Confluence)
NaN
2011-05-30 14:11:00
2011-05-30 14:14:00
0 days 00:03:00.000000000
00:03:00
0.00
6750
DS-D21,25
DS-D21,25
NaN
DesPlaines Middle
NaN
2011-09-03 14:58:00
2011-09-03 15:35:00
0 days 00:37:00.000000000
00:37:00
0.00
7458
DS-N08
DS-N08
NaN
NBCR Upper (NSC Confluence)
NaN
2011-05-30 14:30:00
2011-05-30 14:33:00
0 days 00:03:00.000000000
00:03:00
0.00
7459
DS-N08
DS-N08
NaN
NBCR Upper (NSC Confluence)
NaN
2011-05-30 15:07:00
2011-05-30 15:09:00
0 days 00:02:00.000000000
00:02:00
0.00
6749
DS-D11
DS-D11
NaN
DesPlaines Middle
NaN
2011-09-03 15:33:00
2011-09-03 15:48:00
0 days 00:15:00.000000000
00:15:00
0.00
6748
DS-D11
DS-D11
NaN
DesPlaines Middle
NaN
2011-09-03 15:33:00
2011-09-03 15:48:00
0 days 00:15:00.000000000
00:15:00
0.00
8524
MWRD DS-M114N
MWRD DS-M114N
NaN
NSC Upper (NSWRP)
NaN
2010-08-07 06:49:00
2010-08-07 06:54:00
0 days 00:05:00.000000000
00:05:00
0.00
6747
DS-M80
DS-M80
NaN
NBCR Lower (NSC Confluence)
NaN
2011-09-03 15:11:00
2011-09-03 15:15:00
0 days 00:04:00.000000000
00:04:00
0.00
6746
DS-M15
DS-M15
NaN
CSSC Upper (SWRP)
NaN
2011-09-03 15:51:00
2011-09-03 17:57:00
0 days 02:06:00.000000000
02:06:00
0.00
6745
WCPS (DS-D34-AI)
WCPS (DS-D34-AI)
NaN
Addison Cr
NaN
2011-09-03 15:00:00
2011-09-03 16:30:00
0 days 01:30:00.000000000
01:30:00
0.00
6744
DS-M79
DS-M79
NaN
NBCR Lower (NSC Confluence)
NaN
2011-09-03 15:06:00
2011-09-03 16:46:00
0 days 01:40:00.000000000
01:40:00
0.00
6743
DS-N08
DS-N08
NaN
NBCR Upper (NSC Confluence)
NaN
2011-09-03 15:28:00
2011-09-03 15:30:00
0 days 00:02:00.000000000
00:02:00
0.00
8523
MWRD DS-M114N
MWRD DS-M114N
NaN
NSC Upper (NSWRP)
NaN
2010-08-08 07:16:00
2010-08-08 07:21:00
0 days 00:05:00.000000000
00:05:00
0.00
8262
CDS-21
CDS-21
NaN
Grand Cal R
NaN
2011-02-22 00:01:00
2011-02-22 05:02:00
0 days 05:01:00.000000000
05:01:00
0.00
1109
RAPS (DS-M27, DS-M28, DS-M29)
RAPS (DS-M27, DS-M28, DS-M29)
NaN
SF SB Chicago R
NaN
2015-09-12 09:20:00
2015-09-12 13:00:00
0 days 03:40:00.000000000
03:40:00
0.00
1457
RAPS (DS-M27, DS-M28, DS-M29)
RAPS (DS-M27, DS-M28, DS-M29)
NaN
SF SB Chicago R
NaN
2015-08-16 22:54:00
2015-08-17 00:00:00
0 days 01:06:00.000000000
01:06:00
0.00
1458
RAPS (DS-M27, DS-M28, DS-M29)
RAPS (DS-M27, DS-M28, DS-M29)
NaN
SF SB Chicago R
NaN
2015-08-16 22:54:00
2015-08-17 00:00:00
0 days 01:06:00.000000000
01:06:00
0.00
1459
RAPS (DS-M27, DS-M28, DS-M29)
RAPS (DS-M27, DS-M28, DS-M29)
NaN
SF SB Chicago R
NaN
2015-08-16 22:54:00
2015-08-17 00:00:00
0 days 01:06:00.000000000
01:06:00
0.00
1460
RAPS (DS-M27, DS-M28, DS-M29)
RAPS (DS-M27, DS-M28, DS-M29)
NaN
SF SB Chicago R
NaN
2015-08-16 22:54:00
2015-08-17 00:00:00
0 days 01:06:00.000000000
01:06:00
0.00
283
DS-D43
Near Burling Rd (Library)
TG1
DesPlaines Lower
Stickney
2016-05-13 03:49:00
2016-05-13 03:55:00
0 days 00:06:08.000000000
00:06:00
0.00
1461
RAPS (DS-M27, DS-M28, DS-M29)
RAPS (DS-M27, DS-M28, DS-M29)
NaN
SF SB Chicago R
NaN
2015-08-16 22:54:00
2015-08-17 00:00:00
0 days 01:06:00.000000000
01:06:00
0.00
284
DS-D43
Near Burling Rd (Library)
TG1
DesPlaines Lower
Stickney
2016-05-13 04:00:00
2016-05-13 04:03:00
0 days 00:03:04.000000000
00:03:00
0.00
286
DS-D43
Near Burling Rd (Library)
TG1
DesPlaines Lower
Stickney
2016-05-13 04:19:00
2016-05-13 04:21:00
0 days 00:02:04.000000000
00:02:00
0.00
8742
DS-M84
DS-M84
NaN
NBCR Lower (NSC Confluence)
NaN
2010-07-26 00:00:00
2010-07-26 08:58:00
0 days 08:58:00.000000000
08:58:00
0.00
8741
DS-M19
DS-M19
NaN
CSSC Upper (SWRP)
NaN
2010-07-26 00:00:00
2010-07-26 08:54:00
0 days 08:54:00.000000000
08:54:00
0.00
8740
DS-D47,50,51
DS-D47,50,51
NaN
Salt Cr
NaN
2010-07-26 00:00:00
2010-07-26 09:24:00
0 days 09:24:00.000000000
09:24:00
0.00
8739
WCPS (DS-D34-AI)
WCPS (DS-D34-AI)
NaN
Addison Cr
NaN
2010-07-26 00:00:00
2010-07-26 05:30:00
0 days 05:30:00.000000000
05:30:00
0.00
...
...
...
...
...
...
...
...
...
...
...
7072
TG-M71
TG-M71
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 02:23:00
2011-07-23 12:18:00
0 days 09:55:00.000000000
09:55:00
7.73
7133
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 02:14:00
2011-07-23 03:09:00
0 days 00:55:00.000000000
00:55:00
7.73
7063
TGNASH
TGNASH
NaN
CSSC Upper (SWRP)
NaN
2011-07-23 02:18:00
2011-07-23 02:21:00
0 days 00:03:00.000000000
00:03:00
7.73
7061
DS-M10
DS-M10
NaN
CSSC Lower (SWRP)
NaN
2011-07-23 02:06:00
2011-07-23 11:03:00
0 days 08:57:00.000000000
08:57:00
7.73
7054
DS-M82
DS-M82
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 02:39:00
2011-07-23 15:23:00
0 days 12:44:00.000000000
12:44:00
7.73
7085
WCPS (DS-D34-AI)
WCPS (DS-D34-AI)
NaN
Addison Cr
NaN
2011-07-23 02:00:00
2011-07-23 14:00:00
0 days 12:00:00.000000000
12:00:00
7.73
7075
CRCW
CRCW
NaN
NaN
NaN
2011-07-23 03:30:00
2011-07-23 12:50:00
0 days 09:20:00.000000000
09:20:00
7.84
7171
DS-D19,23
DS-D19,23
NaN
DesPlaines Middle
NaN
2011-07-23 03:08:00
2011-07-23 09:09:00
0 days 06:01:00.000000000
06:01:00
7.84
7134
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 03:28:00
2011-07-23 03:37:00
0 days 00:09:00.000000000
00:09:00
7.84
7135
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 03:45:00
2011-07-23 03:52:00
0 days 00:07:00.000000000
00:07:00
7.84
7136
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 03:57:00
2011-07-23 03:59:00
0 days 00:02:00.000000000
00:02:00
7.84
7115
DS-D15
DS-D15
NaN
DesPlaines Middle
NaN
2011-07-23 03:07:00
2011-07-23 07:08:00
0 days 04:01:00.000000000
04:01:00
7.84
7060
CDS-18
CDS-18
NaN
Little Cal R (North)
NaN
2011-07-23 05:17:00
2011-07-23 08:29:00
0 days 03:12:00.000000000
03:12:00
7.85
7053
CDS-10
CDS-10
NaN
Cal Sag Ch
NaN
2011-07-23 05:16:00
2011-07-23 07:22:00
0 days 02:06:00.000000000
02:06:00
7.85
7051
CDS-11
CDS-11
NaN
Cal Sag Ch
NaN
2011-07-23 05:19:00
2011-07-23 07:07:00
0 days 01:48:00.000000000
01:48:00
7.85
7059
CDS-12
CDS-12
NaN
Little Cal R (North)
NaN
2011-07-23 05:15:00
2011-07-23 06:09:00
0 days 00:54:00.000000000
00:54:00
7.85
7145
CDS-4
CDS-4
NaN
Cal Sag Ch
NaN
2011-07-23 05:15:00
2011-07-23 15:48:00
0 days 10:33:00.000000000
10:33:00
7.85
7097
CDS-20
CDS-20
NaN
Little Cal R (North)
NaN
2011-07-23 05:42:00
2011-07-23 07:31:00
0 days 01:49:00.000000000
01:49:00
7.85
7099
CDS-22
CDS-22
NaN
Grand Cal R
NaN
2011-07-23 05:17:00
2011-07-23 07:45:00
0 days 02:28:00.000000000
02:28:00
7.85
7125
PULASKI RD PS (18E-PS)
PULASKI RD PS (18E-PS)
NaN
Cal Sag Ch
NaN
2011-07-23 05:15:00
2011-07-23 15:48:00
0 days 10:33:00.000000000
10:33:00
7.85
7165
CDS-2
CDS-2
NaN
Cal Sag Ch
NaN
2011-07-23 05:15:00
2011-07-23 15:48:00
0 days 10:33:00.000000000
10:33:00
7.85
7096
CDS-20
CDS-20
NaN
Little Cal R (North)
NaN
2011-07-23 05:42:00
2011-07-23 07:26:00
0 days 01:44:00.000000000
01:44:00
7.85
7137
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 04:14:00
2011-07-23 07:55:00
0 days 03:41:00.000000000
03:41:00
7.85
7114
DS-M40
DS-M40
NaN
SB Chicago R
NaN
2011-07-23 04:24:00
2011-07-23 04:35:00
0 days 00:11:00.000000000
00:11:00
7.85
7186
DS-M109S
DS-M109S
NaN
NSC Upper (NSWRP)
NaN
2011-07-23 04:36:00
2011-07-23 07:47:00
0 days 03:11:00.000000000
03:11:00
7.85
7143
DS-D27I
DS-D27I
NaN
DesPlaines Middle
NaN
2011-07-23 06:15:00
2011-07-23 07:43:00
0 days 01:28:00.000000000
01:28:00
7.85
7049
TG-M81
TG-M81
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 06:08:00
2011-07-23 06:11:00
0 days 00:03:00.000000000
00:03:00
7.85
7095
TG-M94
TG-M94
NaN
NSC Lower (NSWRP)
NaN
2011-07-23 04:08:00
2011-07-23 04:15:00
0 days 00:07:00.000000000
00:07:00
7.85
7100
CDS-21
CDS-21
NaN
Grand Cal R
NaN
2011-07-23 07:10:00
2011-07-23 23:59:00
0 days 16:49:00.000000000
16:49:00
7.86
7050
TG-M81
TG-M81
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 07:56:00
2011-07-23 08:04:00
0 days 00:08:00.000000000
00:08:00
7.86
10879 rows × 10 columns
In [10]:
# How many rows are there? How many have a value of 0?
print('Total rows: %s' % len(csos))
print('Rows with 0 rain in previous 24 hours: %s' % len(csos[csos['24hr_rain'] == 0]))
Total rows: 10879
Rows with 0 rain in previous 24 hours: 357
In [11]:
csos_without_zero = csos[csos['24hr_rain'] != 0]
csos_without_zero
Out[11]:
Outfall Structure
Outfall Location
Tide Gate #
Waterway Reach
Plant
Open date/time
Close date/time
Gate Open Period
Duration
24hr_rain
3295
DS-M84
DS-M84
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 13:04:00
2014-08-25 15:08:00
0 days 02:04:00.000000000
0 days 02:04:00
0.01
3294
DS-M82
DS-M82
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 12:44:00
2014-08-25 15:13:00
0 days 02:29:00.000000000
0 days 02:29:00
0.01
3293
MWRD DS-M114N
MWRD DS-M114N
NaN
NSC Upper (NSWRP)
NaN
2014-08-25 16:28:00
2014-08-25 16:32:00
0 days 00:04:00.000000000
0 days 00:04:00
0.01
3296
DS-M84
DS-M84
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 13:20:00
2014-08-25 15:07:00
0 days 01:47:00.000000000
0 days 01:47:00
0.01
3274
CDS-43
CDS-43
NaN
Little Cal R (South)
NaN
2014-08-25 13:58:00
2014-08-25 14:39:00
0 days 00:41:00.000000000
0 days 00:41:00
0.01
3297
DS-N08
DS-N08
NaN
NBCR Upper (NSC Confluence)
NaN
2014-08-25 12:30:00
2014-08-25 12:35:00
0 days 00:05:00.000000000
0 days 00:05:00
0.01
3299
DS-M79
DS-M79
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 16:27:00
2014-08-25 16:30:00
0 days 00:03:00.000000000
0 days 00:03:00
0.01
4269
DS-M84
DS-M84
NaN
NBCR Lower (NSC Confluence)
NaN
2014-01-03 12:50:00
2014-01-03 12:58:00
0 days 00:08:00.000000000
0 days 00:08:00
0.01
4268
DS-M84
DS-M84
NaN
NBCR Lower (NSC Confluence)
NaN
2014-01-03 12:50:00
2014-01-03 12:58:00
0 days 00:08:00.000000000
0 days 00:08:00
0.01
3292
MWRD DS-M114N
MWRD DS-M114N
NaN
NSC Upper (NSWRP)
NaN
2014-08-25 16:15:00
2014-08-25 16:23:00
0 days 00:08:00.000000000
0 days 00:08:00
0.01
3300
DS-M79
DS-M79
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 12:56:00
2014-08-25 17:20:00
0 days 04:24:00.000000000
0 days 04:24:00
0.01
3301
DS-N02
DS-N02
NaN
NBCR Upper (NSC Confluence)
NaN
2014-08-25 12:30:00
2014-08-25 12:33:00
0 days 00:03:00.000000000
0 days 00:03:00
0.01
4204
DS-N06
DS-N06
NaN
NBCR Upper (NSC Confluence)
NaN
2014-01-25 07:40:00
2014-01-25 07:51:00
0 days 00:11:00.000000000
0 days 00:11:00
0.01
3275
CDS-12
CDS-12
NaN
Little Cal R (North)
NaN
2014-08-25 13:47:00
2014-08-25 15:17:00
0 days 01:30:00.000000000
0 days 01:30:00
0.01
3276
CDS-11
CDS-11
NaN
Cal Sag Ch
NaN
2014-08-25 13:47:00
2014-08-25 15:51:00
0 days 02:04:00.000000000
0 days 02:04:00
0.01
3277
CDS-10
CDS-10
NaN
Cal Sag Ch
NaN
2014-08-25 13:47:00
2014-08-25 15:48:00
0 days 02:01:00.000000000
0 days 02:01:00
0.01
3393
DS-N07
DS-N07
NaN
NBCR Upper (NSC Confluence)
NaN
2014-08-20 18:05:00
2014-08-20 18:08:00
0 days 00:03:00.000000000
0 days 00:03:00
0.01
3810
DS-D06
DS-D06
NaN
DesPlaines Upper
NaN
2014-06-23 04:15:00
2014-06-23 04:56:00
0 days 00:41:00.000000000
0 days 00:41:00
0.01
3813
MWRD DS-M114N
MWRD DS-M114N
NaN
NSC Upper (NSWRP)
NaN
2014-06-23 04:24:00
2014-06-23 06:02:00
0 days 01:38:00.000000000
0 days 01:38:00
0.01
3298
DS-M79
DS-M79
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 12:56:00
2014-08-25 16:12:00
0 days 03:16:00.000000000
0 days 03:16:00
0.01
3272
CDS-14
CDS-14
NaN
Little Cal R (North)
NaN
2014-08-25 13:53:00
2014-08-25 14:07:00
0 days 00:14:00.000000000
0 days 00:14:00
0.01
3273
CDS-14
CDS-14
NaN
Little Cal R (North)
NaN
2014-08-25 13:53:00
2014-08-25 14:07:00
0 days 00:14:00.000000000
0 days 00:14:00
0.01
3291
MWRD DS-M114N
MWRD DS-M114N
NaN
NSC Upper (NSWRP)
NaN
2014-08-25 13:25:00
2014-08-25 16:15:00
0 days 02:50:00.000000000
0 days 02:50:00
0.01
3494
TG-I28 & I29
TG-I28 & I29
NaN
SB Chicago R
NaN
2014-07-22 23:55:00
2014-07-22 23:59:00
0 days 00:04:00.000000000
0 days 00:04:00
0.01
3493
TG-I28 & I29
TG-I28 & I29
NaN
SB Chicago R
NaN
2014-07-23 00:00:00
2014-07-23 00:11:00
0 days 00:11:00.000000000
0 days 00:11:00
0.01
3287
DS-M104
DS-M104
NaN
NSC Upper (NSWRP)
NaN
2014-08-25 12:46:00
2014-08-25 12:49:00
0 days 00:03:00.000000000
0 days 00:03:00
0.01
3286
DS-M109 N
DS-M109 N
NaN
NSC Upper (NSWRP)
NaN
2014-08-25 13:34:00
2014-08-25 15:20:00
0 days 01:46:00.000000000
0 days 01:46:00
0.01
3285
CDS-4
CDS-4
NaN
Cal Sag Ch
NaN
2014-08-25 13:34:00
2014-08-25 23:59:00
0 days 10:25:00.000000000
0 days 10:25:00
0.01
4390
DS-M20
DS-M20
NaN
CSSC Upper (SWRP)
NaN
2013-11-16 00:00:00
2013-11-17 00:00:00
1 days 00:00:00.000000000
1 days 00:00:00
0.01
3288
DS-M80
DS-M80
NaN
NBCR Lower (NSC Confluence)
NaN
2014-08-25 13:11:00
2014-08-25 14:11:00
0 days 01:00:00.000000000
0 days 01:00:00
0.01
...
...
...
...
...
...
...
...
...
...
...
7072
TG-M71
TG-M71
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 02:23:00
2011-07-23 12:18:00
0 days 09:55:00.000000000
0 days 09:55:00
7.73
7133
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 02:14:00
2011-07-23 03:09:00
0 days 00:55:00.000000000
0 days 00:55:00
7.73
7063
TGNASH
TGNASH
NaN
CSSC Upper (SWRP)
NaN
2011-07-23 02:18:00
2011-07-23 02:21:00
0 days 00:03:00.000000000
0 days 00:03:00
7.73
7061
DS-M10
DS-M10
NaN
CSSC Lower (SWRP)
NaN
2011-07-23 02:06:00
2011-07-23 11:03:00
0 days 08:57:00.000000000
0 days 08:57:00
7.73
7054
DS-M82
DS-M82
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 02:39:00
2011-07-23 15:23:00
0 days 12:44:00.000000000
0 days 12:44:00
7.73
7085
WCPS (DS-D34-AI)
WCPS (DS-D34-AI)
NaN
Addison Cr
NaN
2011-07-23 02:00:00
2011-07-23 14:00:00
0 days 12:00:00.000000000
0 days 12:00:00
7.73
7075
CRCW
CRCW
NaN
NaN
NaN
2011-07-23 03:30:00
2011-07-23 12:50:00
0 days 09:20:00.000000000
0 days 09:20:00
7.84
7171
DS-D19,23
DS-D19,23
NaN
DesPlaines Middle
NaN
2011-07-23 03:08:00
2011-07-23 09:09:00
0 days 06:01:00.000000000
0 days 06:01:00
7.84
7134
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 03:28:00
2011-07-23 03:37:00
0 days 00:09:00.000000000
0 days 00:09:00
7.84
7135
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 03:45:00
2011-07-23 03:52:00
0 days 00:07:00.000000000
0 days 00:07:00
7.84
7136
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 03:57:00
2011-07-23 03:59:00
0 days 00:02:00.000000000
0 days 00:02:00
7.84
7115
DS-D15
DS-D15
NaN
DesPlaines Middle
NaN
2011-07-23 03:07:00
2011-07-23 07:08:00
0 days 04:01:00.000000000
0 days 04:01:00
7.84
7060
CDS-18
CDS-18
NaN
Little Cal R (North)
NaN
2011-07-23 05:17:00
2011-07-23 08:29:00
0 days 03:12:00.000000000
0 days 03:12:00
7.85
7053
CDS-10
CDS-10
NaN
Cal Sag Ch
NaN
2011-07-23 05:16:00
2011-07-23 07:22:00
0 days 02:06:00.000000000
0 days 02:06:00
7.85
7051
CDS-11
CDS-11
NaN
Cal Sag Ch
NaN
2011-07-23 05:19:00
2011-07-23 07:07:00
0 days 01:48:00.000000000
0 days 01:48:00
7.85
7059
CDS-12
CDS-12
NaN
Little Cal R (North)
NaN
2011-07-23 05:15:00
2011-07-23 06:09:00
0 days 00:54:00.000000000
0 days 00:54:00
7.85
7145
CDS-4
CDS-4
NaN
Cal Sag Ch
NaN
2011-07-23 05:15:00
2011-07-23 15:48:00
0 days 10:33:00.000000000
0 days 10:33:00
7.85
7097
CDS-20
CDS-20
NaN
Little Cal R (North)
NaN
2011-07-23 05:42:00
2011-07-23 07:31:00
0 days 01:49:00.000000000
0 days 01:49:00
7.85
7099
CDS-22
CDS-22
NaN
Grand Cal R
NaN
2011-07-23 05:17:00
2011-07-23 07:45:00
0 days 02:28:00.000000000
0 days 02:28:00
7.85
7125
PULASKI RD PS (18E-PS)
PULASKI RD PS (18E-PS)
NaN
Cal Sag Ch
NaN
2011-07-23 05:15:00
2011-07-23 15:48:00
0 days 10:33:00.000000000
0 days 10:33:00
7.85
7165
CDS-2
CDS-2
NaN
Cal Sag Ch
NaN
2011-07-23 05:15:00
2011-07-23 15:48:00
0 days 10:33:00.000000000
0 days 10:33:00
7.85
7096
CDS-20
CDS-20
NaN
Little Cal R (North)
NaN
2011-07-23 05:42:00
2011-07-23 07:26:00
0 days 01:44:00.000000000
0 days 01:44:00
7.85
7137
DS-M54
DS-M54
NaN
Chicago R
NaN
2011-07-23 04:14:00
2011-07-23 07:55:00
0 days 03:41:00.000000000
0 days 03:41:00
7.85
7114
DS-M40
DS-M40
NaN
SB Chicago R
NaN
2011-07-23 04:24:00
2011-07-23 04:35:00
0 days 00:11:00.000000000
0 days 00:11:00
7.85
7186
DS-M109S
DS-M109S
NaN
NSC Upper (NSWRP)
NaN
2011-07-23 04:36:00
2011-07-23 07:47:00
0 days 03:11:00.000000000
0 days 03:11:00
7.85
7143
DS-D27I
DS-D27I
NaN
DesPlaines Middle
NaN
2011-07-23 06:15:00
2011-07-23 07:43:00
0 days 01:28:00.000000000
0 days 01:28:00
7.85
7049
TG-M81
TG-M81
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 06:08:00
2011-07-23 06:11:00
0 days 00:03:00.000000000
0 days 00:03:00
7.85
7095
TG-M94
TG-M94
NaN
NSC Lower (NSWRP)
NaN
2011-07-23 04:08:00
2011-07-23 04:15:00
0 days 00:07:00.000000000
0 days 00:07:00
7.85
7100
CDS-21
CDS-21
NaN
Grand Cal R
NaN
2011-07-23 07:10:00
2011-07-23 23:59:00
0 days 16:49:00.000000000
0 days 16:49:00
7.86
7050
TG-M81
TG-M81
NaN
NBCR Lower (NSC Confluence)
NaN
2011-07-23 07:56:00
2011-07-23 08:04:00
0 days 00:08:00.000000000
0 days 00:08:00
7.86
10522 rows × 10 columns
In [ ]:
Content source: NORCatUofC/rain
Similar notebooks: