IST 718 LAB 6¶
In [0]:
# !pip install fbprophet
In [0]:
%matplotlib inline
import pandas as pd
from fbprophet import Prophet
import matplotlib.pyplot as plt
plt.style.use('fivethirtyeight')
In [0]:
df = pd.read_csv('https://raw.githubusercontent.com/danielcaraway/data/master/Zip_Zhvi_SingleFamilyResidence.csv', encoding='latin')
PART ONE: Arkansas Metro Areas¶
In [0]:
hs = df[df['Metro'].str.contains('Hot Springs', na=False)]
lr = df[df['Metro'].str.contains('Little Rock', na=False)]
f = df[df['Metro'].str.contains('Fayetteville', na=False)]
s = df[df['Metro'].str.contains('Searcy', na=False)]
In [0]:
def graph_prices_for(df, location_name):
df_t = df.loc[:, '1996-04'::].T
df_t['avg'] = df_t.mean(numeric_only=True, axis=1)
df_t.reset_index(inplace=True)
columns = ['index', 'avg']
df = pd.DataFrame(df_t, columns = columns)
df = df.rename(index=str, columns={"avg": "y", "index": "ds"})
ax = df.set_index('ds').plot(figsize=(12, 8))
ax.set_ylabel('Home Prices in ' + location_name)
ax.set_xlabel('Date')
plt.show()
In [5]:
graph_prices_for(hs, "Hot Springs")
In [6]:
graph_prices_for(lr, "Little Rock")
In [7]:
graph_prices_for(f, "Fayetteville")
In [8]:
graph_prices_for(s, "Searcy")
In [15]:
ca = df[df['State'] == 'CA']
graph_prices_for(ca, "California")
In [0]:
def transform(df, location_name):
df_t = df.loc[:, '1996-04'::].T
df_t['avg'] = df_t.mean(numeric_only=True, axis=1)
df_t.reset_index(inplace=True)
columns = ['index', 'avg']
df = pd.DataFrame(df_t, columns = columns)
df['place'] = location_name
return df
In [0]:
hs_t = transform(hs, 'Hot Springs')
lr_t = transform(lr, 'Little Rock')
f_t = transform(f, 'Fayetteville')
s_t = transform(s, 'Searcy')
In [0]:
big_df = hs_t.append([lr_t,f_t,s_t])
In [12]:
import seaborn as sns
sns.lineplot(x="index", y="avg", hue="place", data=big_df)
INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting. INFO:matplotlib.category:Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting.
Out[12]:
<matplotlib.axes._subplots.AxesSubplot at 0x7f4754c9f748>
In [0]:
big_df['year'] = big_df.apply(lambda x: x['index'].split('-')[0], axis=1)
big_df['month'] = big_df.apply(lambda x: x['index'].split('-')[1], axis=1)
big_df['day'] = '01'
big_df['Date'] = pd.to_datetime(big_df[['year','month','day']])
In [0]:
# by_place = pd.DataFrame(big_df_year.groupby(['place','year'])['avg'].mean())
# by_place.reset_index(inplace=True)
# sns.tsplot(data=by_place, time="year", condition="place", unit="place", value="avg")
In [0]:
# sns.tsplot(data=big_df, time="Date", condition="place", unit="place", value="avg")
In [17]:
for state in set(df['State']):
state_df = df[df['State'] == state]
graph_prices_for(state_df, str(state))
In [0]:
def prophet_prices_for(df, location_name):
df_t = df.loc[:, '1997-01':'2017-12'].T
df_t['avg'] = df_t.mean(numeric_only=True, axis=1)
df_t.reset_index(inplace=True)
columns = ['index', 'avg']
df = pd.DataFrame(df_t, columns = columns)
df = df.rename(index=str, columns={"avg": "y", "index": "ds"})
m = Prophet()
m.fit(df)
future = m.make_future_dataframe(periods=12, freq='M')
forecast = m.predict(future)
print("====",state,"====")
forcast_fig = m.plot(forecast)
f_axes = forcast_fig.get_axes()
f_axes[0].set_xlabel('DATE')
f_axes[0].set_ylabel(state)
components_fig = m.plot_components(forecast)
axes = components_fig.get_axes()
axes[0].set_xlabel('DATE')
axes[0].set_ylabel(state)
In [37]:
for state in set(df['State']):
state_df = df[df['State'] == state]
prophet_prices_for(state_df, str(state))
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== AR ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== DE ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== ME ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== FL ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NJ ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== GA ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== AZ ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MI ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== TX ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== OH ====
INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== IN ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NM ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== OR ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== CT ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NV ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== WV ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== AK ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NY ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== LA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== SD ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== IA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== ID ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== OK ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== ND ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== CA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== KY ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== HI ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== TN ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== SC ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== WY ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MS ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NC ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MN ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MD ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== WI ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== VA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== UT ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== PA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NE ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== DC ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MT ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== NH ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== AL ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== CO ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== IL ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== WA ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== KS ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== MO ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== VT ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). INFO:fbprophet:Disabling weekly seasonality. Run prophet with weekly_seasonality=True to override this. INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
==== RI ====
/usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:65: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`). /usr/local/lib/python3.6/dist-packages/fbprophet/plot.py:144: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`).
In [32]:
ca
Out[32]:
| RegionID | RegionName | City | State | Metro | CountyName | SizeRank | 1996-04 | 1996-05 | 1996-06 | 1996-07 | 1996-08 | 1996-09 | 1996-10 | 1996-11 | 1996-12 | 1997-01 | 1997-02 | 1997-03 | 1997-04 | 1997-05 | 1997-06 | 1997-07 | 1997-08 | 1997-09 | 1997-10 | 1997-11 | 1997-12 | 1998-01 | 1998-02 | 1998-03 | 1998-04 | 1998-05 | 1998-06 | 1998-07 | 1998-08 | 1998-09 | 1998-10 | 1998-11 | 1998-12 | ... | 2016-09 | 2016-10 | 2016-11 | 2016-12 | 2017-01 | 2017-02 | 2017-03 | 2017-04 | 2017-05 | 2017-06 | 2017-07 | 2017-08 | 2017-09 | 2017-10 | 2017-11 | 2017-12 | 2018-01 | 2018-02 | 2018-03 | 2018-04 | 2018-05 | 2018-06 | 2018-07 | 2018-08 | 2018-09 | 2018-10 | 2018-11 | 2018-12 | 2019-01 | 2019-02 | 2019-03 | 2019-04 | 2019-05 | 2019-06 | 2019-07 | 2019-08 | 2019-09 | 2019-10 | 2019-11 | 2019-12 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13 | 97564 | 94109 | San Francisco | CA | San Francisco-Oakland-Hayward | San Francisco County | 14 | 547676.0 | 547569.0 | 536539.0 | 536211.0 | 536288.0 | 544996.0 | 549733.0 | 548116.0 | 548056.0 | 556765.0 | 564078.0 | 568911.0 | 563733.0 | 567592.0 | 576927.0 | 590090.0 | 601843.0 | 607732.0 | 612399.0 | 618075.0 | 624078.0 | 619463.0 | 608251.0 | 598124.0 | 599915.0 | 605774.0 | 612060.0 | 619972.0 | 630063.0 | 639649.0 | 648839.0 | 660816.0 | 673743.0 | ... | 2076723.0 | 2089536.0 | 2116069.0 | 2126269.0 | 2136544.0 | 2130549.0 | 2125238.0 | 2136355.0 | 2157234.0 | 2183082.0 | 2201513.0 | 2223619.0 | 2242654.0 | 2262404.0 | 2273661 | 2288114 | 2296814 | 2319273 | 2340441 | 2367999 | 2377043 | 2406408 | 2437497 | 2468207 | 2497009 | 2527010 | 2560823 | 2571444 | 2588508 | 2602537 | 2603723 | 2596306 | 2594652 | 2619794 | 2639943 | 2653455 | 2659471 | 2673801 | 2688969 | 2717489 |
| 21 | 96107 | 90250 | Hawthorne | CA | Los Angeles-Long Beach-Anaheim | Los Angeles County | 22 | 174520.0 | 174451.0 | 174208.0 | 174168.0 | 174272.0 | 174236.0 | 174011.0 | 173853.0 | 173880.0 | 173809.0 | 173430.0 | 172856.0 | 172239.0 | 171385.0 | 170904.0 | 171034.0 | 171937.0 | 172959.0 | 173708.0 | 174116.0 | 174672.0 | 176446.0 | 178775.0 | 180840.0 | 181787.0 | 182670.0 | 183373.0 | 183753.0 | 184170.0 | 185105.0 | 186263.0 | 187815.0 | 188620.0 | ... | 542639.0 | 549684.0 | 554883.0 | 559601.0 | 565991.0 | 572281.0 | 577192.0 | 580694.0 | 585780.0 | 590338.0 | 592356.0 | 593805.0 | 595088.0 | 598773.0 | 604365 | 610036 | 616579 | 623096 | 630327 | 635907 | 639595 | 642727 | 642779 | 642257 | 642941 | 647773 | 652424 | 654329 | 654836 | 654122 | 653035 | 654325 | 656639 | 660217 | 657600 | 656051 | 656649 | 661550 | 665524 | 670833 |
| 39 | 97771 | 94565 | Pittsburg | CA | San Francisco-Oakland-Hayward | Contra Costa County | 40 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | 519924.0 | 520437.0 | 520271.0 | 521608.0 | 526538.0 | 534053.0 | 540373.0 | 544590.0 | 546909.0 | 545765.0 | 545227.0 | 545969.0 | 550546.0 | 552338.0 | 555309 | 559167 | 570681 | 581688 | 589077 | 588331 | 588979 | 590588 | 593489 | 591277 | 592299 | 591549 | 590131 | 585682 | 587867 | 590192 | 591096 | 588183 | 586736 | 584946 | 584380 | 582565 | 581526 | 579674 | 579779 | 582825 |
| 43 | 96027 | 90046 | Los Angeles | CA | Los Angeles-Long Beach-Anaheim | Los Angeles County | 44 | 158703.0 | 158615.0 | 158990.0 | 159599.0 | 160228.0 | 161176.0 | 162302.0 | 163102.0 | 163659.0 | 164005.0 | 164238.0 | 165215.0 | 167196.0 | 168901.0 | 170638.0 | 171418.0 | 173336.0 | 174781.0 | 176926.0 | 178643.0 | 180776.0 | 183543.0 | 186489.0 | 188650.0 | 190057.0 | 192063.0 | 194619.0 | 196076.0 | 197877.0 | 200594.0 | 203909.0 | 206660.0 | 208435.0 | ... | 1125483.0 | 1141019.0 | 1150330.0 | 1161896.0 | 1179904.0 | 1195337.0 | 1208427.0 | 1219575.0 | 1236950.0 | 1248887.0 | 1259457.0 | 1272009.0 | 1291359.0 | 1312526.0 | 1335419 | 1356609 | 1380975 | 1408153 | 1434319 | 1452009 | 1454944 | 1455943 | 1460135 | 1471859 | 1488243 | 1508333 | 1526004 | 1537515 | 1545734 | 1549924 | 1550051 | 1554922 | 1566579 | 1580344 | 1588563 | 1599202 | 1619582 | 1643242 | 1655745 | 1668029 |
| 87 | 97711 | 94501 | Alameda | CA | San Francisco-Oakland-Hayward | Alameda County | 88 | 164594.0 | 164065.0 | 163554.0 | 163687.0 | 164207.0 | 164802.0 | 164966.0 | 164895.0 | 165257.0 | 166068.0 | 167170.0 | 167651.0 | 167925.0 | 168804.0 | 170949.0 | 173937.0 | 176381.0 | 178295.0 | 179198.0 | 179969.0 | 181228.0 | 183009.0 | 185088.0 | 186707.0 | 188432.0 | 189955.0 | 191916.0 | 194937.0 | 198030.0 | 201294.0 | 202926.0 | 204314.0 | 204491.0 | ... | 823270.0 | 832964.0 | 845602.0 | 855472.0 | 862741.0 | 869135.0 | 880611.0 | 888377.0 | 892645.0 | 898715.0 | 900458.0 | 901673.0 | 907587.0 | 917554.0 | 931512 | 947430 | 962747 | 973865 | 980028 | 988153 | 995688 | 997469 | 1003458 | 1013300 | 1019174 | 1023141 | 1024986 | 1021306 | 1013708 | 1011229 | 1019833 | 1029955 | 1038937 | 1043473 | 1051026 | 1051526 | 1054081 | 1050810 | 1050477 | 1058938 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 30278 | 98009 | 95141 | San Jose | CA | San Jose-Sunnyvale-Santa Clara | Santa Clara County | 30279 | 539482.0 | 532297.0 | 529040.0 | 519340.0 | 509995.0 | 507596.0 | 513339.0 | 521067.0 | 525147.0 | 530192.0 | 533211.0 | 535826.0 | 534342.0 | 538771.0 | 548248.0 | 558472.0 | 563311.0 | 562934.0 | 559622.0 | 551968.0 | 541129.0 | 529191.0 | 523018.0 | 515872.0 | 519279.0 | 523226.0 | 530816.0 | 531179.0 | 531116.0 | 536700.0 | 544999.0 | 555692.0 | 563530.0 | ... | 1085551.0 | 1088423.0 | 1079231.0 | 1067071.0 | 1071790.0 | 1095731.0 | 1111667.0 | 1120839.0 | 1125443.0 | 1135403.0 | 1130279.0 | 1127394.0 | 1124116.0 | 1139792.0 | 1144735 | 1158909 | 1177372 | 1212086 | 1224549 | 1225179 | 1222547 | 1230885 | 1223823 | 1198951 | 1175508 | 1180208 | 1187717 | 1193934 | 1193500 | 1189134 | 1180906 | 1174429 | 1175094 | 1184333 | 1191616 | 1203807 | 1191099 | 1161763 | 1123331 | 1105216 |
| 30350 | 98059 | 95229 | Vallecito | CA | NaN | Calaveras County | 30351 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | 212889.0 | 214869.0 | 217488.0 | 217801.0 | 217860.0 | 220071.0 | 222218.0 | 222219.0 | 218200.0 | 214591.0 | 216916.0 | 220715.0 | 220659.0 | 217588.0 | 213734 | 213025 | 211969 | 212102 | 213038 | 214920 | 215538 | 215920 | 216355 | 215913 | 216553 | 217207 | 219360 | 222307 | 224479 | 226993 | 226685 | 224245 | 220362 | 219113 | 219777 | 221118 | 220298 | 220130 | 219565 | 219973 |
| 30420 | 98400 | 95721 | Twin Bridges | CA | Sacramento--Roseville--Arden-Arcade | El Dorado County | 30421 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | 221106.0 | 222405.0 | 224061.0 | 226694.0 | 229175.0 | 231062.0 | 231671.0 | 229550.0 | 229457.0 | 228371.0 | 231913.0 | 236513.0 | 241288.0 | 241506.0 | 241026 | 241606 | 242682 | 242755 | 243387 | 247102 | 250117 | 251559 | 251094 | 250609 | 251871 | 254712 | 260237 | 266705 | 272689 | 273374 | 274286 | 272306 | 277570 | 283606 | 293289 | 293416 | 288793 | 281784 | 277526 | 273191 |
| 30422 | 98152 | 95375 | Strawberry | CA | Sonora | Tuolumne County | 30423 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | 229014.0 | 230258.0 | 232993.0 | 237994.0 | 242690.0 | 245030.0 | 246624.0 | 248738.0 | 251551.0 | 254167.0 | 256218 | 257939 | 257146 | 256979 | 255471 | 255027 | 254391 | 255432 | 258595 | 262077 | 266299 | 269269 | 270577 | 270238 | 271945 | 274057 | 276549 | 276636 | 276468 | 276629 | 274957 | 272186 | 267689 | 264456 | 263067 | 263347 |
| 30428 | 97209 | 93282 | Tulare | CA | Visalia-Porterville | Tulare County | 30429 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 148858.0 | 150809.0 | 152622.0 | 155571 | 156944 | 157868 | 160666 | 163506 | 164605 | 162217 | 161130 | 160962 | 161256 | 160592 | 159573 | 159334 | 158590 | 158014 | 155349 | 153531 | 153059 | 155689 | 156909 | 157209 | 156855 | 156706 | 156429 | 155899 | 157523 |
1685 rows × 292 columns
In [33]:
len(set(ca.RegionName))
Out[33]:
1685
In [0]: