{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Profitability Analysis of Real Estates in NYC" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### ------------------------------------------------------------------------------------------------------------------------------------------------------------" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Harish Siva Subramanian" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Email: hsivasub@asu.edu or sharish2395@gmail.com" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Mobile: (480)-494-7314" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### -----------------------------------------------------------------------------------------------------------------------------------------------------------" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Problem Statement" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ " As a part of this assignment, a data product was built to assist a real estate company to understand which zip codes are profitable for short term rentals within New York City. They have already decided to invest in Two Bedroom houses as they are found to be profitable. For this purpose, publicly available data from Zillow and AirBnB were used." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Zillow Data- Contains the Time Series cost data for 2 Bedroom Apartment for different Zipcodes" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Airbnb Data- Information on the listing including location, and other relevant short term rental informations" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Assumptions" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "1.The investor will pay for the property in cash (i.e. no mortgage/interest rate will need to be accounted for).\n", "\n", " \n", "2.The time value of money discount rate is 0% (i.e 1 dollar today is worth the same 100 years from now).\n", "\n", "\n", "3.All properties and all square feet within each locale can be assumed to be homogeneous (i.e. a 1000 square foot property in a locale such as Bronx or Manhattan generates twice the revenue and costs twice as much as any other 500 square foot property within that same locale).\n", "\n", "\n", "4.The occupancy rate is assumed to be 75%.\n", "\n", "\n", "5.It was assumed that the real estate company wants to buy the property in April 2019, so I had performed time series forecasting to obtain the value of property in April 2019 considering the data from January 2010.\n", "\n", "\n", "6.Since the data before January 2010 were showing abnormal pattern and also since most of them had missing values, the data from January 2010 were used.\n", "\n", "\n", "7.Availability for 90 days was considered during the availability analysis oowing to the fact availability for 365 days were incorrect for some zipcodes.\n", "\n", "\n", "8.Time for calculating the Breakeven Period was taken as 365 days(neglecting leap year) and thus the resultant Breakeven Period will be in years.\n", "\n", "\n", "9.While performing time series analysis, models were not built step by step for each zipcodes because of obvious time constraints and considering the scope of the project. Thus AutoARIMA was used to do Model fitting and forecasting for all the individual zipcodes.\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Quality Check\n", "\n", "The project addressed the following quality checks,\n", "\n", "\n", "•\tChecking for Duplicates\n", "\n", "•\tChecking for Negative values\n", "\n", "•\tChecking the Columns with Null Values \n", "\n", "### Data Munging\n", "\n", "The project addressed the following quality checks,\n", "\n", "•\tCleaning up the Zillow Dataset.\n", "\n", "•\tCleaning up the Airbnb dataset.\n", "\n", "•\tImputing the missing values with group mean.\n", "\n", "•\tImputing some of the 0 values with the group mean.\n", "\n", "•\tFiltering the Airbnb dataset for New York and 2 Bedrooms apartment.\n", "\n", "•\tGrouping the Airbnb data by zipcode and taking mean.\n", "\n", "•\tJoining the cleaned final Airbnb and Zillow dataset based on matching Zipcodes.\n", "\n", "\n", "### Additional KPIs added\n", "\n", "•\tCurrent Month Cost-April 2019(Calculated from Time series Forecasting). Also the cost for other months preceding Current Month were also added but they were not used anywhere.\n", "\n", "•\tNeighbourhood group cleansed(Extracted from Airbnb data to add to final dataframe).\n", "\n", "•\tExpected Revenue(Calulated Field).\n", "\n", "•\tBreakeven Period(Calculated Field).\n", "\n", "\n", "### Time Series Analysis\n", "\n", "Here the Zillow dataset contains the Time series of cost data and the data from January 2010 was taken to fit the Time series model and forecast the cost values upto the Current Month Cost which is April 2019 for all the 21 Zipcodes.\n", "Here for this purpose the Pyamid ARIMA package was used to perform the AutoARIMA and get the forecast values.\n", "\n", "\n", "### Visual Analysis:\n", "\n", "The following plots and analysis was carried out in this project,\n", "\n", "•\tVisualizing the Zipcodes in Real Time.\n", "\n", "•\tPreliminary Review Analysis:\n", "\n", " Review Accuracy vs Reviews Ratings\n", "\n", " Reviews Ratings Vs No of Reviews Vs Neighbourhood\n", "\n", "•\tAnalysis of Availability:\n", "\n", " Bar plots of Availability for all Zipcodes\n", " \n", " Availability- Revenue Analysis\n", " \n", " Availability- Cost Analysis\n", " \n", "•\tCorrelation between Revenue, Cost, Reviews and Availability\n", "\n", "•\tDistribution of Revenue and Cost\n", "\n", " Violin Plot of Revenue\n", " \n", " Violin Plot of Cost\n", " \n", "•\tRevenue-Cost Analysis\n", "\n", "•\tBreak Even Analysis\n", "\n", "•\t3-D Scatter Plot Between Revenue, Cost and Breakeven period\n" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "" ], "text/vnd.plotly.v1+html": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "\n", "#Importing the Libraries\n", "\n", "import pandas as pd \n", "import numpy as np \n", "\n", "# Matplotlib is for plotting graphs\n", "import matplotlib.pyplot as plt \n", "# matplotlib inline will display the graphs right below the cell\n", "%matplotlib inline \n", "\n", "# Plotly is used for Interactive Visualization\n", "import plotly.plotly as py \n", "from plotly.offline import init_notebook_mode, iplot \n", "init_notebook_mode(connected=True) \n", "import plotly.graph_objs as go \n", "\n" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\shari\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:2698: DtypeWarning:\n", "\n", "Columns (43,88) have mixed types. Specify dtype option on import or set low_memory=False.\n", "\n" ] } ], "source": [ "# Importing the Respective Datasets\n", "\n", "airbnb = pd.read_csv(\"listings.csv\")\n", "zillow = pd.read_csv(\"Zip_Zhvi_2bedroom.csv\")" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(40753, 95)" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "airbnb.shape" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(8946, 262)" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "zillow.shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Quality Check- Phase I" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Since there are many columns in these datasets, I have created a function to display all the columns as a list. This helps us to see all the columns in the Jupyter Notebook" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# Function to return all the Columns in a List Format:\n", "\n", "def cols(dataset):\n", " return(dataset.columns.tolist())" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['id',\n", " 'listing_url',\n", " 'scrape_id',\n", " 'last_scraped',\n", " 'name',\n", " 'summary',\n", " 'space',\n", " 'description',\n", " 'experiences_offered',\n", " 'neighborhood_overview',\n", " 'notes',\n", " 'transit',\n", " 'access',\n", " 'interaction',\n", " 'house_rules',\n", " 'thumbnail_url',\n", " 'medium_url',\n", " 'picture_url',\n", " 'xl_picture_url',\n", " 'host_id',\n", " 'host_url',\n", " 'host_name',\n", " 'host_since',\n", " 'host_location',\n", " 'host_about',\n", " 'host_response_time',\n", " 'host_response_rate',\n", " 'host_acceptance_rate',\n", " 'host_is_superhost',\n", " 'host_thumbnail_url',\n", " 'host_picture_url',\n", " 'host_neighbourhood',\n", " 'host_listings_count',\n", " 'host_total_listings_count',\n", " 'host_verifications',\n", " 'host_has_profile_pic',\n", " 'host_identity_verified',\n", " 'street',\n", " 'neighbourhood',\n", " 'neighbourhood_cleansed',\n", " 'neighbourhood_group_cleansed',\n", " 'city',\n", " 'state',\n", " 'zipcode',\n", " 'market',\n", " 'smart_location',\n", " 'country_code',\n", " 'country',\n", " 'latitude',\n", " 'longitude',\n", " 'is_location_exact',\n", " 'property_type',\n", " 'room_type',\n", " 'accommodates',\n", " 'bathrooms',\n", " 'bedrooms',\n", " 'beds',\n", " 'bed_type',\n", " 'amenities',\n", " 'square_feet',\n", " 'price',\n", " 'weekly_price',\n", " 'monthly_price',\n", " 'security_deposit',\n", " 'cleaning_fee',\n", " 'guests_included',\n", " 'extra_people',\n", " 'minimum_nights',\n", " 'maximum_nights',\n", " 'calendar_updated',\n", " 'has_availability',\n", " 'availability_30',\n", " 'availability_60',\n", " 'availability_90',\n", " 'availability_365',\n", " 'calendar_last_scraped',\n", " 'number_of_reviews',\n", " 'first_review',\n", " 'last_review',\n", " 'review_scores_rating',\n", " 'review_scores_accuracy',\n", " 'review_scores_cleanliness',\n", " 'review_scores_checkin',\n", " 'review_scores_communication',\n", " 'review_scores_location',\n", " 'review_scores_value',\n", " 'requires_license',\n", " 'license',\n", " 'jurisdiction_names',\n", " 'instant_bookable',\n", " 'cancellation_policy',\n", " 'require_guest_profile_picture',\n", " 'require_guest_phone_verification',\n", " 'calculated_host_listings_count',\n", " 'reviews_per_month']" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols(airbnb)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['RegionID',\n", " 'RegionName',\n", " 'City',\n", " 'State',\n", " 'Metro',\n", " 'CountyName',\n", " 'SizeRank',\n", " '1996-04',\n", " '1996-05',\n", " '1996-06',\n", " '1996-07',\n", " '1996-08',\n", " '1996-09',\n", " '1996-10',\n", " '1996-11',\n", " '1996-12',\n", " '1997-01',\n", " '1997-02',\n", " '1997-03',\n", " '1997-04',\n", " '1997-05',\n", " '1997-06',\n", " '1997-07',\n", " '1997-08',\n", " '1997-09',\n", " '1997-10',\n", " '1997-11',\n", " '1997-12',\n", " '1998-01',\n", " '1998-02',\n", " '1998-03',\n", " '1998-04',\n", " '1998-05',\n", " '1998-06',\n", " '1998-07',\n", " '1998-08',\n", " '1998-09',\n", " '1998-10',\n", " '1998-11',\n", " '1998-12',\n", " '1999-01',\n", " '1999-02',\n", " '1999-03',\n", " '1999-04',\n", " '1999-05',\n", " '1999-06',\n", " '1999-07',\n", " '1999-08',\n", " '1999-09',\n", " '1999-10',\n", " '1999-11',\n", " '1999-12',\n", " '2000-01',\n", " '2000-02',\n", " '2000-03',\n", " '2000-04',\n", " '2000-05',\n", " '2000-06',\n", " '2000-07',\n", " '2000-08',\n", " '2000-09',\n", " '2000-10',\n", " '2000-11',\n", " '2000-12',\n", " '2001-01',\n", " '2001-02',\n", " '2001-03',\n", " '2001-04',\n", " '2001-05',\n", " '2001-06',\n", " '2001-07',\n", " '2001-08',\n", " '2001-09',\n", " '2001-10',\n", " '2001-11',\n", " '2001-12',\n", " '2002-01',\n", " '2002-02',\n", " '2002-03',\n", " '2002-04',\n", " '2002-05',\n", " '2002-06',\n", " '2002-07',\n", " '2002-08',\n", " '2002-09',\n", " '2002-10',\n", " '2002-11',\n", " '2002-12',\n", " '2003-01',\n", " '2003-02',\n", " '2003-03',\n", " '2003-04',\n", " '2003-05',\n", " '2003-06',\n", " '2003-07',\n", " '2003-08',\n", " '2003-09',\n", " '2003-10',\n", " '2003-11',\n", " '2003-12',\n", " '2004-01',\n", " '2004-02',\n", " '2004-03',\n", " '2004-04',\n", " '2004-05',\n", " '2004-06',\n", " '2004-07',\n", " '2004-08',\n", " '2004-09',\n", " '2004-10',\n", " '2004-11',\n", " '2004-12',\n", " '2005-01',\n", " '2005-02',\n", " '2005-03',\n", " '2005-04',\n", " '2005-05',\n", " '2005-06',\n", " '2005-07',\n", " '2005-08',\n", " '2005-09',\n", " '2005-10',\n", " '2005-11',\n", " '2005-12',\n", " '2006-01',\n", " '2006-02',\n", " '2006-03',\n", " '2006-04',\n", " '2006-05',\n", " '2006-06',\n", " '2006-07',\n", " '2006-08',\n", " '2006-09',\n", " '2006-10',\n", " '2006-11',\n", " '2006-12',\n", " '2007-01',\n", " '2007-02',\n", " '2007-03',\n", " '2007-04',\n", " '2007-05',\n", " '2007-06',\n", " '2007-07',\n", " '2007-08',\n", " '2007-09',\n", " '2007-10',\n", " '2007-11',\n", " '2007-12',\n", " '2008-01',\n", " '2008-02',\n", " '2008-03',\n", " '2008-04',\n", " '2008-05',\n", " '2008-06',\n", " '2008-07',\n", " '2008-08',\n", " '2008-09',\n", " '2008-10',\n", " '2008-11',\n", " '2008-12',\n", " '2009-01',\n", " '2009-02',\n", " '2009-03',\n", " '2009-04',\n", " '2009-05',\n", " '2009-06',\n", " '2009-07',\n", " '2009-08',\n", " '2009-09',\n", " '2009-10',\n", " '2009-11',\n", " '2009-12',\n", " '2010-01',\n", " '2010-02',\n", " '2010-03',\n", " '2010-04',\n", " '2010-05',\n", " '2010-06',\n", " '2010-07',\n", " '2010-08',\n", " '2010-09',\n", " '2010-10',\n", " '2010-11',\n", " '2010-12',\n", " '2011-01',\n", " '2011-02',\n", " '2011-03',\n", " '2011-04',\n", " '2011-05',\n", " '2011-06',\n", " '2011-07',\n", " '2011-08',\n", " '2011-09',\n", " '2011-10',\n", " '2011-11',\n", " '2011-12',\n", " '2012-01',\n", " '2012-02',\n", " '2012-03',\n", " '2012-04',\n", " '2012-05',\n", " '2012-06',\n", " '2012-07',\n", " '2012-08',\n", " '2012-09',\n", " '2012-10',\n", " '2012-11',\n", " '2012-12',\n", " '2013-01',\n", " '2013-02',\n", " '2013-03',\n", " '2013-04',\n", " '2013-05',\n", " '2013-06',\n", " '2013-07',\n", " '2013-08',\n", " '2013-09',\n", " '2013-10',\n", " '2013-11',\n", " '2013-12',\n", " '2014-01',\n", " '2014-02',\n", " '2014-03',\n", " '2014-04',\n", " '2014-05',\n", " '2014-06',\n", " '2014-07',\n", " '2014-08',\n", " '2014-09',\n", " '2014-10',\n", " '2014-11',\n", " '2014-12',\n", " '2015-01',\n", " '2015-02',\n", " '2015-03',\n", " '2015-04',\n", " '2015-05',\n", " '2015-06',\n", " '2015-07',\n", " '2015-08',\n", " '2015-09',\n", " '2015-10',\n", " '2015-11',\n", " '2015-12',\n", " '2016-01',\n", " '2016-02',\n", " '2016-03',\n", " '2016-04',\n", " '2016-05',\n", " '2016-06',\n", " '2016-07',\n", " '2016-08',\n", " '2016-09',\n", " '2016-10',\n", " '2016-11',\n", " '2016-12',\n", " '2017-01',\n", " '2017-02',\n", " '2017-03',\n", " '2017-04',\n", " '2017-05',\n", " '2017-06']" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols(zillow)" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# Function to determine the Missing Value Percent in every Column of a Dataset\n", "\n", "def mis_value_percent(dataset):\n", " return(100* dataset.isnull().sum()/ len(dataset))" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "RegionID 0.000000\n", "RegionName 0.000000\n", "City 0.000000\n", "State 0.000000\n", "Metro 2.794545\n", "CountyName 0.000000\n", "SizeRank 0.000000\n", "1996-04 29.756316\n", "1996-05 28.862061\n", "1996-06 28.862061\n", "1996-07 28.806170\n", "1996-08 28.794992\n", "1996-09 28.794992\n", "1996-10 28.794992\n", "1996-11 28.683210\n", "1996-12 28.683210\n", "1997-01 28.414934\n", "1997-02 23.619495\n", "1997-03 23.395931\n", "1997-04 23.395931\n", "1997-05 23.395931\n", "1997-06 23.373575\n", "1997-07 23.373575\n", "1997-08 22.289291\n", "1997-09 22.255757\n", "1997-10 22.255757\n", "1997-11 22.222222\n", "1997-12 22.177510\n", "1998-01 21.987480\n", "1998-02 20.366644\n", " ... \n", "2015-01 0.000000\n", "2015-02 0.000000\n", "2015-03 0.000000\n", "2015-04 0.000000\n", "2015-05 0.000000\n", "2015-06 0.000000\n", "2015-07 0.000000\n", "2015-08 0.000000\n", "2015-09 0.000000\n", "2015-10 0.000000\n", "2015-11 0.000000\n", "2015-12 0.000000\n", "2016-01 0.000000\n", "2016-02 0.201207\n", "2016-03 0.201207\n", "2016-04 0.201207\n", "2016-05 0.201207\n", "2016-06 0.000000\n", "2016-07 0.000000\n", "2016-08 0.000000\n", "2016-09 0.000000\n", "2016-10 0.000000\n", "2016-11 0.000000\n", "2016-12 0.033535\n", "2017-01 0.000000\n", "2017-02 0.000000\n", "2017-03 0.000000\n", "2017-04 0.000000\n", "2017-05 0.000000\n", "2017-06 0.000000\n", "Length: 262, dtype: float64" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mis_value_percent(zillow)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Most of the Missing values in zillow data are associated with the time series data which I had later neglected the missing columns alone while performing time series analysis for that." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Checking for Duplicates" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(40753, 95)" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "airbnb.shape" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(40753, 95)" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "airbnb.drop_duplicates().shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "No duplicates are found in AirBnB data as the dimensions didn't change" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(8946, 262)" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "zillow.shape" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(8946, 262)" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "zillow.drop_duplicates().shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Similarly no duplicate rows are found in Zillow dataset" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Check for Negative Values" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | id | \n", "listing_url | \n", "scrape_id | \n", "last_scraped | \n", "name | \n", "summary | \n", "space | \n", "description | \n", "experiences_offered | \n", "neighborhood_overview | \n", "... | \n", "review_scores_value | \n", "requires_license | \n", "license | \n", "jurisdiction_names | \n", "instant_bookable | \n", "cancellation_policy | \n", "require_guest_profile_picture | \n", "require_guest_phone_verification | \n", "calculated_host_listings_count | \n", "reviews_per_month | \n", "
---|
0 rows × 95 columns
\n", "\n", " | RegionID | \n", "RegionName | \n", "City | \n", "State | \n", "Metro | \n", "CountyName | \n", "SizeRank | \n", "1996-04 | \n", "1996-05 | \n", "1996-06 | \n", "... | \n", "2016-09 | \n", "2016-10 | \n", "2016-11 | \n", "2016-12 | \n", "2017-01 | \n", "2017-02 | \n", "2017-03 | \n", "2017-04 | \n", "2017-05 | \n", "2017-06 | \n", "
---|
0 rows × 262 columns
\n", "\n", " | zipcode | \n", "id | \n", "scrape_id | \n", "host_id | \n", "host_acceptance_rate | \n", "host_listings_count | \n", "host_total_listings_count | \n", "latitude | \n", "longitude | \n", "accommodates | \n", "... | \n", "2016-09 | \n", "2016-10 | \n", "2016-11 | \n", "2016-12 | \n", "2017-01 | \n", "2017-02 | \n", "2017-03 | \n", "2017-04 | \n", "2017-05 | \n", "2017-06 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10003 | \n", "9.124661e+06 | \n", "2.017050e+13 | \n", "2.496037e+07 | \n", "NaN | \n", "1.646018 | \n", "1.646018 | \n", "40.728902 | \n", "-73.988258 | \n", "4.566372 | \n", "... | \n", "1932800 | \n", "1930400 | \n", "1937500 | \n", "1935100.0 | \n", "1915700 | \n", "1916500 | \n", "1965700 | \n", "2045300 | \n", "2109100 | \n", "2147000 | \n", "
1 | \n", "10011 | \n", "9.889107e+06 | \n", "2.017050e+13 | \n", "3.005599e+07 | \n", "NaN | \n", "1.448276 | \n", "1.448276 | \n", "40.742371 | \n", "-73.999752 | \n", "4.517241 | \n", "... | \n", "2354000 | \n", "2355500 | \n", "2352200 | \n", "2332100.0 | \n", "2313300 | \n", "2319600 | \n", "2342100 | \n", "2365900 | \n", "2419700 | \n", "2480400 | \n", "
2 | \n", "10013 | \n", "1.054726e+07 | \n", "2.017050e+13 | \n", "2.783653e+07 | \n", "NaN | \n", "1.412698 | \n", "1.412698 | \n", "40.719555 | \n", "-74.004075 | \n", "4.281250 | \n", "... | \n", "3347100 | \n", "3305500 | \n", "3261100 | \n", "3244000.0 | \n", "3231400 | \n", "3183300 | \n", "3160200 | \n", "3193500 | \n", "3262200 | \n", "3316500 | \n", "
3 | \n", "10014 | \n", "8.654217e+06 | \n", "2.017050e+13 | \n", "2.054620e+07 | \n", "NaN | \n", "1.537634 | \n", "1.537634 | \n", "40.734209 | \n", "-74.004240 | \n", "4.344086 | \n", "... | \n", "2480800 | \n", "2443200 | \n", "2430100 | \n", "2452900.0 | \n", "2451200 | \n", "2441900 | \n", "2460900 | \n", "2494900 | \n", "2498400 | \n", "2491600 | \n", "
4 | \n", "10021 | \n", "1.022891e+07 | \n", "2.017050e+13 | \n", "3.568867e+07 | \n", "NaN | \n", "1.526316 | \n", "1.526316 | \n", "40.768441 | \n", "-73.956628 | \n", "4.263158 | \n", "... | \n", "1668300 | \n", "1664800 | \n", "1659500 | \n", "1656000.0 | \n", "1643700 | \n", "1649800 | \n", "1688500 | \n", "1731400 | \n", "1774100 | \n", "1815600 | \n", "
5 | \n", "10022 | \n", "9.963782e+06 | \n", "2.017050e+13 | \n", "4.129974e+07 | \n", "NaN | \n", "1.394737 | \n", "1.394737 | \n", "40.758886 | \n", "-73.966700 | \n", "5.447368 | \n", "... | \n", "1773200 | \n", "1760600 | \n", "1762000 | \n", "1776800.0 | \n", "1775200 | \n", "1774500 | \n", "1812700 | \n", "1914600 | \n", "1997800 | \n", "2031600 | \n", "
6 | \n", "10023 | \n", "8.424752e+06 | \n", "2.017050e+13 | \n", "3.053048e+07 | \n", "NaN | \n", "2.888889 | \n", "2.888889 | \n", "40.777581 | \n", "-73.981486 | \n", "4.666667 | \n", "... | \n", "1993500 | \n", "1980700 | \n", "1960900 | \n", "1951300.0 | \n", "1937800 | \n", "1929800 | \n", "1955000 | \n", "2022400 | \n", "2095000 | \n", "2142300 | \n", "
7 | \n", "10025 | \n", "7.849437e+06 | \n", "2.017050e+13 | \n", "2.567103e+07 | \n", "NaN | \n", "1.571429 | \n", "1.571429 | \n", "40.798025 | \n", "-73.966355 | \n", "4.821429 | \n", "... | \n", "1374400 | \n", "1364100 | \n", "1366300 | \n", "1354800.0 | \n", "1327500 | \n", "1317300 | \n", "1333700 | \n", "1352100 | \n", "1390000 | \n", "1431000 | \n", "
8 | \n", "10028 | \n", "1.038785e+07 | \n", "2.017050e+13 | \n", "3.790560e+07 | \n", "NaN | \n", "1.375000 | \n", "1.375000 | \n", "40.775367 | \n", "-73.950934 | \n", "4.281250 | \n", "... | \n", "1814600 | \n", "1820400 | \n", "1810000 | \n", "1786500.0 | \n", "1787100 | \n", "1801100 | \n", "1847900 | \n", "1922800 | \n", "2015700 | \n", "2083900 | \n", "
9 | \n", "10036 | \n", "8.401201e+06 | \n", "2.017050e+13 | \n", "3.853206e+07 | \n", "NaN | \n", "73.500000 | \n", "73.500000 | \n", "40.754810 | \n", "-73.987824 | \n", "4.750000 | \n", "... | \n", "1766400 | \n", "1749800 | \n", "1744100 | \n", "1737900.0 | \n", "1722800 | \n", "1736600 | \n", "1750100 | \n", "1735500 | \n", "1717100 | \n", "1712900 | \n", "
10 | \n", "10128 | \n", "1.079017e+07 | \n", "2.017050e+13 | \n", "2.984589e+07 | \n", "NaN | \n", "1.321429 | \n", "1.321429 | \n", "40.781842 | \n", "-73.949537 | \n", "4.357143 | \n", "... | \n", "1526000 | \n", "1523700 | \n", "1527200 | \n", "1541600.0 | \n", "1557800 | \n", "1582900 | \n", "1598900 | \n", "1646100 | \n", "1720500 | \n", "1787100 | \n", "
11 | \n", "10304 | \n", "1.590640e+06 | \n", "2.017050e+13 | \n", "7.534770e+06 | \n", "NaN | \n", "1.000000 | \n", "1.000000 | \n", "40.626721 | \n", "-74.076721 | \n", "3.500000 | \n", "... | \n", "284500 | \n", "287100 | \n", "290700 | \n", "294700.0 | \n", "299000 | \n", "303800 | \n", "308300 | \n", "313800 | \n", "321300 | \n", "328300 | \n", "
12 | \n", "10305 | \n", "1.368595e+07 | \n", "2.017050e+13 | \n", "5.535834e+07 | \n", "NaN | \n", "1.555556 | \n", "1.555556 | \n", "40.596360 | \n", "-74.077371 | \n", "4.555556 | \n", "... | \n", "373500 | \n", "378600 | \n", "382700 | \n", "385300.0 | \n", "387900 | \n", "394500 | \n", "403800 | \n", "412000 | \n", "418900 | \n", "425100 | \n", "
13 | \n", "10306 | \n", "8.328929e+06 | \n", "2.017050e+13 | \n", "5.237069e+07 | \n", "NaN | \n", "2.000000 | \n", "2.000000 | \n", "40.568879 | \n", "-74.111565 | \n", "5.500000 | \n", "... | \n", "316100 | \n", "318300 | \n", "321200 | \n", "322900.0 | \n", "325400 | \n", "331700 | \n", "339000 | \n", "343500 | \n", "347800 | \n", "352900 | \n", "
14 | \n", "10312 | \n", "1.800434e+07 | \n", "2.017050e+13 | \n", "1.197988e+08 | \n", "NaN | \n", "1.000000 | \n", "1.000000 | \n", "40.546331 | \n", "-74.183701 | \n", "2.000000 | \n", "... | \n", "325400 | \n", "326600 | \n", "328400 | \n", "330300.0 | \n", "333600 | \n", "339300 | \n", "345000 | \n", "348400 | \n", "351700 | \n", "355000 | \n", "
15 | \n", "11201 | \n", "9.298929e+06 | \n", "2.017050e+13 | \n", "2.327364e+07 | \n", "NaN | \n", "1.451613 | \n", "1.451613 | \n", "40.692611 | \n", "-73.990576 | \n", "4.451613 | \n", "... | \n", "1340200 | \n", "1338700 | \n", "1350600 | \n", "1375600.0 | \n", "1390200 | \n", "1398100 | \n", "1399900 | \n", "1400500 | \n", "1407300 | \n", "1420700 | \n", "
16 | \n", "11215 | \n", "9.035422e+06 | \n", "2.017050e+13 | \n", "2.460656e+07 | \n", "NaN | \n", "1.422764 | \n", "1.422764 | \n", "40.666241 | \n", "-73.984527 | \n", "4.266129 | \n", "... | \n", "982200 | \n", "992000 | \n", "1002600 | \n", "1021400.0 | \n", "1039300 | \n", "1040800 | \n", "1035800 | \n", "1050000 | \n", "1066200 | \n", "1070800 | \n", "
17 | \n", "11217 | \n", "6.866520e+06 | \n", "2.017050e+13 | \n", "1.988437e+07 | \n", "NaN | \n", "1.283333 | \n", "1.283333 | \n", "40.681377 | \n", "-73.979068 | \n", "3.983333 | \n", "... | \n", "1207600 | \n", "1209800 | \n", "1216200 | \n", "1221400.0 | \n", "1225600 | \n", "1225000 | \n", "1219600 | \n", "1238100 | \n", "1276400 | \n", "1302300 | \n", "
18 | \n", "11231 | \n", "7.697324e+06 | \n", "2.017050e+13 | \n", "2.171201e+07 | \n", "NaN | \n", "1.550725 | \n", "1.550725 | \n", "40.680632 | \n", "-74.000049 | \n", "4.391304 | \n", "... | \n", "1128000 | \n", "1152400 | \n", "1166000 | \n", "1166500.0 | \n", "1166600 | \n", "1182900 | \n", "1202200 | \n", "1213200 | \n", "1211700 | \n", "1202900 | \n", "
19 | \n", "11234 | \n", "1.066553e+07 | \n", "2.017050e+13 | \n", "2.752097e+07 | \n", "NaN | \n", "1.333333 | \n", "1.333333 | \n", "40.623074 | \n", "-73.925943 | \n", "4.166667 | \n", "... | \n", "448400 | \n", "452300 | \n", "457200 | \n", "461200.0 | \n", "464400 | \n", "466400 | \n", "470900 | \n", "475700 | \n", "477100 | \n", "476900 | \n", "
20 | \n", "11434 | \n", "9.374263e+06 | \n", "2.017050e+13 | \n", "4.863844e+07 | \n", "NaN | \n", "1.000000 | \n", "1.000000 | \n", "40.662033 | \n", "-73.769800 | \n", "4.000000 | \n", "... | \n", "342100 | \n", "348300 | \n", "356100 | \n", "358400.0 | \n", "357500 | \n", "361900 | \n", "370800 | \n", "377100 | \n", "380200 | \n", "382300 | \n", "
21 rows × 295 columns
\n", "\n", " | 1996-04 | \n", "1996-05 | \n", "1996-06 | \n", "1996-07 | \n", "1996-08 | \n", "1996-09 | \n", "1996-10 | \n", "1996-11 | \n", "1996-12 | \n", "1997-01 | \n", "... | \n", "2016-09 | \n", "2016-10 | \n", "2016-11 | \n", "2016-12 | \n", "2017-01 | \n", "2017-02 | \n", "2017-03 | \n", "2017-04 | \n", "2017-05 | \n", "2017-06 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "1932800 | \n", "1930400 | \n", "1937500 | \n", "1935100.0 | \n", "1915700 | \n", "1916500 | \n", "1965700 | \n", "2045300 | \n", "2109100 | \n", "2147000 | \n", "
1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2354000 | \n", "2355500 | \n", "2352200 | \n", "2332100.0 | \n", "2313300 | \n", "2319600 | \n", "2342100 | \n", "2365900 | \n", "2419700 | \n", "2480400 | \n", "
2 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "3347100 | \n", "3305500 | \n", "3261100 | \n", "3244000.0 | \n", "3231400 | \n", "3183300 | \n", "3160200 | \n", "3193500 | \n", "3262200 | \n", "3316500 | \n", "
3 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2480800 | \n", "2443200 | \n", "2430100 | \n", "2452900.0 | \n", "2451200 | \n", "2441900 | \n", "2460900 | \n", "2494900 | \n", "2498400 | \n", "2491600 | \n", "
4 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "1668300 | \n", "1664800 | \n", "1659500 | \n", "1656000.0 | \n", "1643700 | \n", "1649800 | \n", "1688500 | \n", "1731400 | \n", "1774100 | \n", "1815600 | \n", "
5 rows × 255 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "11 | \n", "12 | \n", "13 | \n", "14 | \n", "15 | \n", "16 | \n", "17 | \n", "18 | \n", "19 | \n", "20 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1996-04 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "117500.0 | \n", "131900.0 | \n", "138100.0 | \n", "153000.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-05 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "113700.0 | \n", "131900.0 | \n", "136900.0 | \n", "149800.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-06 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "111200.0 | \n", "131400.0 | \n", "135900.0 | \n", "146900.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-07 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "111100.0 | \n", "130800.0 | \n", "134500.0 | \n", "144800.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-08 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "110400.0 | \n", "130200.0 | \n", "132900.0 | \n", "143000.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
5 rows × 21 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "11 | \n", "12 | \n", "13 | \n", "14 | \n", "15 | \n", "16 | \n", "17 | \n", "18 | \n", "19 | \n", "20 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1996-04-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "117500.0 | \n", "131900.0 | \n", "138100.0 | \n", "153000.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-05-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "113700.0 | \n", "131900.0 | \n", "136900.0 | \n", "149800.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-06-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "111200.0 | \n", "131400.0 | \n", "135900.0 | \n", "146900.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-07-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "111100.0 | \n", "130800.0 | \n", "134500.0 | \n", "144800.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-08-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "110400.0 | \n", "130200.0 | \n", "132900.0 | \n", "143000.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
5 rows × 21 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "11 | \n", "12 | \n", "13 | \n", "14 | \n", "15 | \n", "16 | \n", "17 | \n", "18 | \n", "19 | \n", "20 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1996-04-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "117500.0 | \n", "131900.0 | \n", "138100.0 | \n", "153000.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-05-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "113700.0 | \n", "131900.0 | \n", "136900.0 | \n", "149800.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-06-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "111200.0 | \n", "131400.0 | \n", "135900.0 | \n", "146900.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-07-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "111100.0 | \n", "130800.0 | \n", "134500.0 | \n", "144800.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1996-08-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "110400.0 | \n", "130200.0 | \n", "132900.0 | \n", "143000.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
5 rows × 21 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "11 | \n", "12 | \n", "13 | \n", "14 | \n", "15 | \n", "16 | \n", "17 | \n", "18 | \n", "19 | \n", "20 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2010-01-01 | \n", "1227800.0 | \n", "1378600.0 | \n", "2268700.0 | \n", "1451800.0 | \n", "1163900.0 | \n", "1323000.0 | \n", "1271900.0 | \n", "813300.0 | \n", "1126000.0 | \n", "1238600.0 | \n", "... | \n", "266200.0 | \n", "331100.0 | \n", "297200.0 | \n", "296200.0 | \n", "742800.0 | \n", "529300.0 | \n", "619000.0 | \n", "591300.0 | \n", "378700.0 | \n", "315400.0 | \n", "
2010-02-01 | \n", "1202600.0 | \n", "1372300.0 | \n", "2294100.0 | \n", "1454400.0 | \n", "1176400.0 | \n", "1338500.0 | \n", "1252300.0 | \n", "821500.0 | \n", "1107300.0 | \n", "1227700.0 | \n", "... | \n", "266100.0 | \n", "330000.0 | \n", "296500.0 | \n", "296400.0 | \n", "747500.0 | \n", "544800.0 | \n", "619300.0 | \n", "589600.0 | \n", "386600.0 | \n", "320300.0 | \n", "
2010-03-01 | \n", "1207100.0 | \n", "1393100.0 | \n", "2273600.0 | \n", "1494500.0 | \n", "1184500.0 | \n", "1344600.0 | \n", "1262300.0 | \n", "831700.0 | \n", "1116100.0 | \n", "1230700.0 | \n", "... | \n", "264700.0 | \n", "328100.0 | \n", "296100.0 | \n", "296900.0 | \n", "750300.0 | \n", "540900.0 | \n", "612700.0 | \n", "589500.0 | \n", "391600.0 | \n", "315800.0 | \n", "
2010-04-01 | \n", "1220100.0 | \n", "1430000.0 | \n", "2261700.0 | \n", "1542200.0 | \n", "1192700.0 | \n", "1348300.0 | \n", "1279200.0 | \n", "845100.0 | \n", "1138500.0 | \n", "1237300.0 | \n", "... | \n", "262500.0 | \n", "327200.0 | \n", "295200.0 | \n", "296700.0 | \n", "753800.0 | \n", "538300.0 | \n", "612800.0 | \n", "589300.0 | \n", "392900.0 | \n", "314000.0 | \n", "
2010-05-01 | \n", "1252400.0 | \n", "1462100.0 | \n", "2282800.0 | \n", "1587300.0 | \n", "1203100.0 | \n", "1350800.0 | \n", "1309000.0 | \n", "854500.0 | \n", "1175900.0 | \n", "1250400.0 | \n", "... | \n", "260800.0 | \n", "324500.0 | \n", "293600.0 | \n", "295100.0 | \n", "758900.0 | \n", "536800.0 | \n", "614500.0 | \n", "590900.0 | \n", "392900.0 | \n", "311800.0 | \n", "
2010-06-01 | \n", "1285700.0 | \n", "1476800.0 | \n", "2288000.0 | \n", "1616000.0 | \n", "1203500.0 | \n", "1365100.0 | \n", "1335300.0 | \n", "858900.0 | \n", "1199700.0 | \n", "1260500.0 | \n", "... | \n", "260700.0 | \n", "321600.0 | \n", "292700.0 | \n", "293800.0 | \n", "764600.0 | \n", "539400.0 | \n", "611300.0 | \n", "595800.0 | \n", "393800.0 | \n", "312600.0 | \n", "
2010-07-01 | \n", "1278300.0 | \n", "1479000.0 | \n", "2275700.0 | \n", "1612300.0 | \n", "1200400.0 | \n", "1390900.0 | \n", "1353800.0 | \n", "859200.0 | \n", "1198700.0 | \n", "1260700.0 | \n", "... | \n", "260900.0 | \n", "321000.0 | \n", "293300.0 | \n", "294500.0 | \n", "767300.0 | \n", "546600.0 | \n", "605900.0 | \n", "599000.0 | \n", "392800.0 | \n", "313100.0 | \n", "
2010-08-01 | \n", "1279100.0 | \n", "1476600.0 | \n", "2281300.0 | \n", "1605800.0 | \n", "1202900.0 | \n", "1402700.0 | \n", "1366400.0 | \n", "863500.0 | \n", "1205000.0 | \n", "1257300.0 | \n", "... | \n", "259900.0 | \n", "320600.0 | \n", "294400.0 | \n", "295600.0 | \n", "769400.0 | \n", "553100.0 | \n", "604400.0 | \n", "600500.0 | \n", "390800.0 | \n", "307000.0 | \n", "
2010-09-01 | \n", "1326700.0 | \n", "1461200.0 | \n", "2302800.0 | \n", "1592500.0 | \n", "1210100.0 | \n", "1403700.0 | \n", "1372100.0 | \n", "876000.0 | \n", "1237500.0 | \n", "1249000.0 | \n", "... | \n", "259200.0 | \n", "318900.0 | \n", "294600.0 | \n", "295300.0 | \n", "772400.0 | \n", "553900.0 | \n", "610100.0 | \n", "602700.0 | \n", "390400.0 | \n", "298200.0 | \n", "
2010-10-01 | \n", "1376500.0 | \n", "1448300.0 | \n", "2290900.0 | \n", "1584200.0 | \n", "1210300.0 | \n", "1404900.0 | \n", "1381300.0 | \n", "886100.0 | \n", "1276200.0 | \n", "1234500.0 | \n", "... | \n", "258000.0 | \n", "316500.0 | \n", "293100.0 | \n", "292900.0 | \n", "779100.0 | \n", "559000.0 | \n", "618000.0 | \n", "607600.0 | \n", "390000.0 | \n", "293200.0 | \n", "
2010-11-01 | \n", "1368900.0 | \n", "1441600.0 | \n", "2267800.0 | \n", "1587600.0 | \n", "1211700.0 | \n", "1403500.0 | \n", "1385000.0 | \n", "890000.0 | \n", "1304400.0 | \n", "1231800.0 | \n", "... | \n", "256600.0 | \n", "315700.0 | \n", "291800.0 | \n", "291900.0 | \n", "785600.0 | \n", "569100.0 | \n", "624400.0 | \n", "617100.0 | \n", "389900.0 | \n", "290400.0 | \n", "
2010-12-01 | \n", "1366000.0 | \n", "1444300.0 | \n", "2253600.0 | \n", "1594300.0 | \n", "1219100.0 | \n", "1390200.0 | \n", "1388100.0 | \n", "894200.0 | \n", "1310800.0 | \n", "1244100.0 | \n", "... | \n", "255100.0 | \n", "316200.0 | \n", "290800.0 | \n", "292800.0 | \n", "786700.0 | \n", "573200.0 | \n", "627300.0 | \n", "632300.0 | \n", "388400.0 | \n", "286000.0 | \n", "
2011-01-01 | \n", "1381300.0 | \n", "1438600.0 | \n", "2245300.0 | \n", "1611700.0 | \n", "1222500.0 | \n", "1376600.0 | \n", "1399100.0 | \n", "901800.0 | \n", "1310700.0 | \n", "1255300.0 | \n", "... | \n", "254000.0 | \n", "316400.0 | \n", "289400.0 | \n", "293900.0 | \n", "782000.0 | \n", "573100.0 | \n", "628500.0 | \n", "642900.0 | \n", "387100.0 | \n", "276800.0 | \n", "
2011-02-01 | \n", "1380700.0 | \n", "1434100.0 | \n", "2264200.0 | \n", "1631800.0 | \n", "1230600.0 | \n", "1372400.0 | \n", "1399800.0 | \n", "909500.0 | \n", "1318200.0 | \n", "1260500.0 | \n", "... | \n", "253700.0 | \n", "315400.0 | \n", "288400.0 | \n", "293500.0 | \n", "782700.0 | \n", "579600.0 | \n", "630900.0 | \n", "642800.0 | \n", "385300.0 | \n", "263700.0 | \n", "
2011-03-01 | \n", "1368500.0 | \n", "1439300.0 | \n", "2301000.0 | \n", "1648800.0 | \n", "1247400.0 | \n", "1378100.0 | \n", "1389300.0 | \n", "913300.0 | \n", "1321900.0 | \n", "1257500.0 | \n", "... | \n", "253000.0 | \n", "313000.0 | \n", "288200.0 | \n", "291700.0 | \n", "785800.0 | \n", "588800.0 | \n", "635000.0 | \n", "643000.0 | \n", "380700.0 | \n", "251400.0 | \n", "
2011-04-01 | \n", "1372700.0 | \n", "1437700.0 | \n", "2328600.0 | \n", "1670500.0 | \n", "1258000.0 | \n", "1384600.0 | \n", "1384700.0 | \n", "907400.0 | \n", "1309200.0 | \n", "1246800.0 | \n", "... | \n", "251400.0 | \n", "308700.0 | \n", "285700.0 | \n", "289300.0 | \n", "784600.0 | \n", "592200.0 | \n", "636700.0 | \n", "646800.0 | \n", "377000.0 | \n", "245500.0 | \n", "
2011-05-01 | \n", "1378000.0 | \n", "1430300.0 | \n", "2337000.0 | \n", "1674300.0 | \n", "1250800.0 | \n", "1389600.0 | \n", "1380900.0 | \n", "900000.0 | \n", "1298700.0 | \n", "1231400.0 | \n", "... | \n", "250100.0 | \n", "306000.0 | \n", "281900.0 | \n", "287400.0 | \n", "785100.0 | \n", "592700.0 | \n", "635600.0 | \n", "651700.0 | \n", "377900.0 | \n", "243900.0 | \n", "
2011-06-01 | \n", "1361700.0 | \n", "1426800.0 | \n", "2341500.0 | \n", "1657100.0 | \n", "1251500.0 | \n", "1390200.0 | \n", "1367900.0 | \n", "897700.0 | \n", "1289000.0 | \n", "1229400.0 | \n", "... | \n", "248900.0 | \n", "305400.0 | \n", "279900.0 | \n", "285900.0 | \n", "795300.0 | \n", "600100.0 | \n", "640300.0 | \n", "656400.0 | \n", "377200.0 | \n", "242100.0 | \n", "
2011-07-01 | \n", "1357800.0 | \n", "1427800.0 | \n", "2335200.0 | \n", "1659200.0 | \n", "1253100.0 | \n", "1386600.0 | \n", "1365400.0 | \n", "896300.0 | \n", "1258400.0 | \n", "1247200.0 | \n", "... | \n", "247400.0 | \n", "304900.0 | \n", "280600.0 | \n", "284700.0 | \n", "799300.0 | \n", "610400.0 | \n", "648100.0 | \n", "665800.0 | \n", "373100.0 | \n", "242000.0 | \n", "
2011-08-01 | \n", "1364400.0 | \n", "1424600.0 | \n", "2316700.0 | \n", "1661800.0 | \n", "1252000.0 | \n", "1393100.0 | \n", "1375100.0 | \n", "892300.0 | \n", "1238900.0 | \n", "1272200.0 | \n", "... | \n", "245700.0 | \n", "304600.0 | \n", "280700.0 | \n", "283100.0 | \n", "798000.0 | \n", "616600.0 | \n", "652400.0 | \n", "671300.0 | \n", "371400.0 | \n", "245200.0 | \n", "
2011-09-01 | \n", "1358000.0 | \n", "1432800.0 | \n", "2299900.0 | \n", "1641600.0 | \n", "1253800.0 | \n", "1399900.0 | \n", "1380400.0 | \n", "890400.0 | \n", "1247100.0 | \n", "1287700.0 | \n", "... | \n", "242800.0 | \n", "303000.0 | \n", "279700.0 | \n", "281600.0 | \n", "801800.0 | \n", "619800.0 | \n", "654800.0 | \n", "667600.0 | \n", "370700.0 | \n", "247100.0 | \n", "
2011-10-01 | \n", "1329800.0 | \n", "1456500.0 | \n", "2318700.0 | \n", "1637800.0 | \n", "1257900.0 | \n", "1381500.0 | \n", "1377000.0 | \n", "888600.0 | \n", "1260600.0 | \n", "1296700.0 | \n", "... | \n", "240400.0 | \n", "300700.0 | \n", "278800.0 | \n", "281000.0 | \n", "808000.0 | \n", "619800.0 | \n", "657100.0 | \n", "656800.0 | \n", "368500.0 | \n", "245300.0 | \n", "
2011-11-01 | \n", "1317800.0 | \n", "1485100.0 | \n", "2396400.0 | \n", "1646600.0 | \n", "1256600.0 | \n", "1363900.0 | \n", "1375100.0 | \n", "891700.0 | \n", "1255000.0 | \n", "1302500.0 | \n", "... | \n", "238900.0 | \n", "299700.0 | \n", "277500.0 | \n", "280100.0 | \n", "808200.0 | \n", "617100.0 | \n", "655600.0 | \n", "646100.0 | \n", "366600.0 | \n", "244300.0 | \n", "
2011-12-01 | \n", "1333200.0 | \n", "1500200.0 | \n", "2479200.0 | \n", "1652100.0 | \n", "1253500.0 | \n", "1362700.0 | \n", "1379000.0 | \n", "899500.0 | \n", "1250200.0 | \n", "1301800.0 | \n", "... | \n", "237600.0 | \n", "299400.0 | \n", "276400.0 | \n", "278500.0 | \n", "805600.0 | \n", "611100.0 | \n", "653600.0 | \n", "638800.0 | \n", "365500.0 | \n", "244500.0 | \n", "
2012-01-01 | \n", "1348500.0 | \n", "1509600.0 | \n", "2490300.0 | \n", "1674800.0 | \n", "1250500.0 | \n", "1371500.0 | \n", "1395200.0 | \n", "904400.0 | \n", "1249200.0 | \n", "1298000.0 | \n", "... | \n", "235800.0 | \n", "297300.0 | \n", "275400.0 | \n", "276700.0 | \n", "805100.0 | \n", "605800.0 | \n", "650300.0 | \n", "638300.0 | \n", "362100.0 | \n", "245000.0 | \n", "
2012-02-01 | \n", "1349500.0 | \n", "1518500.0 | \n", "2466000.0 | \n", "1714300.0 | \n", "1247700.0 | \n", "1372000.0 | \n", "1414500.0 | \n", "908200.0 | \n", "1253400.0 | \n", "1292300.0 | \n", "... | \n", "233900.0 | \n", "295900.0 | \n", "274100.0 | \n", "275800.0 | \n", "813000.0 | \n", "606000.0 | \n", "650300.0 | \n", "648000.0 | \n", "360400.0 | \n", "247200.0 | \n", "
2012-03-01 | \n", "1352200.0 | \n", "1530800.0 | \n", "2492400.0 | \n", "1736800.0 | \n", "1256800.0 | \n", "1385500.0 | \n", "1419000.0 | \n", "914000.0 | \n", "1275300.0 | \n", "1288500.0 | \n", "... | \n", "232600.0 | \n", "296700.0 | \n", "273400.0 | \n", "276600.0 | \n", "825500.0 | \n", "611200.0 | \n", "652100.0 | \n", "657000.0 | \n", "361300.0 | \n", "252100.0 | \n", "
2012-04-01 | \n", "1354100.0 | \n", "1538000.0 | \n", "2542800.0 | \n", "1736800.0 | \n", "1273600.0 | \n", "1402800.0 | \n", "1403100.0 | \n", "915100.0 | \n", "1314200.0 | \n", "1286600.0 | \n", "... | \n", "231600.0 | \n", "297800.0 | \n", "273600.0 | \n", "277700.0 | \n", "835700.0 | \n", "615100.0 | \n", "653000.0 | \n", "661300.0 | \n", "362500.0 | \n", "254900.0 | \n", "
2012-05-01 | \n", "1351900.0 | \n", "1530500.0 | \n", "2585500.0 | \n", "1741200.0 | \n", "1282200.0 | \n", "1411600.0 | \n", "1383200.0 | \n", "912300.0 | \n", "1329400.0 | \n", "1288000.0 | \n", "... | \n", "230100.0 | \n", "298600.0 | \n", "273500.0 | \n", "278300.0 | \n", "839100.0 | \n", "615000.0 | \n", "654800.0 | \n", "662900.0 | \n", "363700.0 | \n", "256000.0 | \n", "
2012-06-01 | \n", "1364200.0 | \n", "1524500.0 | \n", "2618100.0 | \n", "1757700.0 | \n", "1278600.0 | \n", "1397400.0 | \n", "1376700.0 | \n", "914000.0 | \n", "1316900.0 | \n", "1290900.0 | \n", "... | \n", "229200.0 | \n", "299700.0 | \n", "273800.0 | \n", "279500.0 | \n", "836700.0 | \n", "616600.0 | \n", "666300.0 | \n", "669900.0 | \n", "365900.0 | \n", "257100.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2015-01-01 | \n", "1716300.0 | \n", "1979200.0 | \n", "3067600.0 | \n", "2082800.0 | \n", "1470700.0 | \n", "1712000.0 | \n", "1717700.0 | \n", "1189700.0 | \n", "1583200.0 | \n", "1706000.0 | \n", "... | \n", "247700.0 | \n", "316000.0 | \n", "284400.0 | \n", "305400.0 | \n", "1253600.0 | \n", "877100.0 | \n", "948800.0 | \n", "955400.0 | \n", "392500.0 | \n", "283800.0 | \n", "
2015-02-01 | \n", "1720500.0 | \n", "1982900.0 | \n", "3047400.0 | \n", "2107300.0 | \n", "1471900.0 | \n", "1706400.0 | \n", "1700100.0 | \n", "1193700.0 | \n", "1553800.0 | \n", "1691400.0 | \n", "... | \n", "249300.0 | \n", "314500.0 | \n", "283800.0 | \n", "304900.0 | \n", "1264500.0 | \n", "890000.0 | \n", "958200.0 | \n", "959400.0 | \n", "396200.0 | \n", "285900.0 | \n", "
2015-03-01 | \n", "1721800.0 | \n", "2001600.0 | \n", "3054500.0 | \n", "2142400.0 | \n", "1458700.0 | \n", "1696900.0 | \n", "1680400.0 | \n", "1199900.0 | \n", "1518000.0 | \n", "1688700.0 | \n", "... | \n", "251800.0 | \n", "312900.0 | \n", "282200.0 | \n", "304000.0 | \n", "1270500.0 | \n", "907400.0 | \n", "978600.0 | \n", "960700.0 | \n", "401200.0 | \n", "287300.0 | \n", "
2015-04-01 | \n", "1741800.0 | \n", "2014700.0 | \n", "3071700.0 | \n", "2167100.0 | \n", "1442700.0 | \n", "1672900.0 | \n", "1676400.0 | \n", "1201400.0 | \n", "1508800.0 | \n", "1694400.0 | \n", "... | \n", "254600.0 | \n", "313100.0 | \n", "283700.0 | \n", "304600.0 | \n", "1276300.0 | \n", "920600.0 | \n", "1013600.0 | \n", "969000.0 | \n", "404900.0 | \n", "287900.0 | \n", "
2015-05-01 | \n", "1775800.0 | \n", "2023500.0 | \n", "3078300.0 | \n", "2189400.0 | \n", "1436400.0 | \n", "1656300.0 | \n", "1685600.0 | \n", "1202600.0 | \n", "1515900.0 | \n", "1703200.0 | \n", "... | \n", "257700.0 | \n", "315500.0 | \n", "287800.0 | \n", "306600.0 | \n", "1289600.0 | \n", "925700.0 | \n", "1028300.0 | \n", "987700.0 | \n", "409000.0 | \n", "288800.0 | \n", "
2015-06-01 | \n", "1796500.0 | \n", "2055300.0 | \n", "3073100.0 | \n", "2220100.0 | \n", "1445800.0 | \n", "1670900.0 | \n", "1708100.0 | \n", "1214200.0 | \n", "1532800.0 | \n", "1709600.0 | \n", "... | \n", "260900.0 | \n", "318700.0 | \n", "291800.0 | \n", "308700.0 | \n", "1303800.0 | \n", "936300.0 | \n", "1020200.0 | \n", "1004400.0 | \n", "414500.0 | \n", "289900.0 | \n", "
2015-07-01 | \n", "1821500.0 | \n", "2078300.0 | \n", "3089400.0 | \n", "2250300.0 | \n", "1471800.0 | \n", "1696900.0 | \n", "1730400.0 | \n", "1235200.0 | \n", "1548500.0 | \n", "1709900.0 | \n", "... | \n", "262400.0 | \n", "322000.0 | \n", "294500.0 | \n", "310200.0 | \n", "1305300.0 | \n", "954000.0 | \n", "1024200.0 | \n", "1022900.0 | \n", "419000.0 | \n", "294300.0 | \n", "
2015-08-01 | \n", "1870100.0 | \n", "2083600.0 | \n", "3121700.0 | \n", "2275700.0 | \n", "1493700.0 | \n", "1713900.0 | \n", "1751800.0 | \n", "1258000.0 | \n", "1550500.0 | \n", "1703200.0 | \n", "... | \n", "262700.0 | \n", "324900.0 | \n", "297100.0 | \n", "311300.0 | \n", "1298900.0 | \n", "969700.0 | \n", "1052400.0 | \n", "1044200.0 | \n", "423300.0 | \n", "302500.0 | \n", "
2015-09-01 | \n", "1901000.0 | \n", "2088800.0 | \n", "3134200.0 | \n", "2301600.0 | \n", "1515100.0 | \n", "1718600.0 | \n", "1778300.0 | \n", "1287700.0 | \n", "1550200.0 | \n", "1697700.0 | \n", "... | \n", "263300.0 | \n", "326600.0 | \n", "299300.0 | \n", "312400.0 | \n", "1301000.0 | \n", "973200.0 | \n", "1090500.0 | \n", "1064800.0 | \n", "428700.0 | \n", "309300.0 | \n", "
2015-10-01 | \n", "1904900.0 | \n", "2110600.0 | \n", "3152400.0 | \n", "2314700.0 | \n", "1542600.0 | \n", "1721000.0 | \n", "1810400.0 | \n", "1307200.0 | \n", "1560600.0 | \n", "1693000.0 | \n", "... | \n", "264900.0 | \n", "328800.0 | \n", "301500.0 | \n", "313800.0 | \n", "1314200.0 | \n", "971300.0 | \n", "1113800.0 | \n", "1090400.0 | \n", "432500.0 | \n", "311600.0 | \n", "
2015-11-01 | \n", "1914000.0 | \n", "2127500.0 | \n", "3173600.0 | \n", "2322000.0 | \n", "1556500.0 | \n", "1717000.0 | \n", "1831600.0 | \n", "1313900.0 | \n", "1575700.0 | \n", "1685400.0 | \n", "... | \n", "266200.0 | \n", "332100.0 | \n", "303600.0 | \n", "315100.0 | \n", "1322800.0 | \n", "974100.0 | \n", "1123100.0 | \n", "1125400.0 | \n", "433400.0 | \n", "313100.0 | \n", "
2015-12-01 | \n", "1926400.0 | \n", "2168900.0 | \n", "3195000.0 | \n", "2334500.0 | \n", "1551500.0 | \n", "1721700.0 | \n", "1844400.0 | \n", "1317100.0 | \n", "1587100.0 | \n", "1694300.0 | \n", "... | \n", "267000.0 | \n", "336700.0 | \n", "304400.0 | \n", "315800.0 | \n", "1320500.0 | \n", "978100.0 | \n", "1137000.0 | \n", "1144400.0 | \n", "435600.0 | \n", "315500.0 | \n", "
2016-01-01 | \n", "1932200.0 | \n", "2204700.0 | \n", "3234600.0 | \n", "2360300.0 | \n", "1558800.0 | \n", "1746200.0 | \n", "1861600.0 | \n", "1327400.0 | \n", "1610900.0 | \n", "1725400.0 | \n", "... | \n", "267700.0 | \n", "341300.0 | \n", "303800.0 | \n", "316100.0 | \n", "1318800.0 | \n", "975400.0 | \n", "1161200.0 | \n", "1138100.0 | \n", "437800.0 | \n", "318200.0 | \n", "
2016-02-01 | \n", "1936700.0 | \n", "2216100.0 | \n", "3302400.0 | \n", "2384700.0 | \n", "1577200.0 | \n", "1763200.0 | \n", "1889600.0 | \n", "1338800.0 | \n", "1646100.0 | \n", "1742000.0 | \n", "... | \n", "268600.0 | \n", "344700.0 | \n", "304200.0 | \n", "316300.0 | \n", "1325600.0 | \n", "967200.0 | \n", "1179700.0 | \n", "1121800.0 | \n", "436200.0 | \n", "320800.0 | \n", "
2016-03-01 | \n", "1945200.0 | \n", "2212500.0 | \n", "3335800.0 | \n", "2388200.0 | \n", "1584500.0 | \n", "1743800.0 | \n", "1901500.0 | \n", "1350400.0 | \n", "1659500.0 | \n", "1734500.0 | \n", "... | \n", "269600.0 | \n", "347800.0 | \n", "306200.0 | \n", "316300.0 | \n", "1333000.0 | \n", "963800.0 | \n", "1192500.0 | \n", "1103900.0 | \n", "434600.0 | \n", "325400.0 | \n", "
2016-04-01 | \n", "1935600.0 | \n", "2222600.0 | \n", "3324200.0 | \n", "2358300.0 | \n", "1587300.0 | \n", "1709600.0 | \n", "1895300.0 | \n", "1356600.0 | \n", "1648100.0 | \n", "1729700.0 | \n", "... | \n", "271300.0 | \n", "351700.0 | \n", "307900.0 | \n", "317000.0 | \n", "1334800.0 | \n", "962500.0 | \n", "1194700.0 | \n", "1082200.0 | \n", "437600.0 | \n", "329400.0 | \n", "
2016-05-01 | \n", "1911200.0 | \n", "2231900.0 | \n", "3285100.0 | \n", "2345800.0 | \n", "1594100.0 | \n", "1703500.0 | \n", "1890200.0 | \n", "1358500.0 | \n", "1654800.0 | \n", "1741800.0 | \n", "... | \n", "273000.0 | \n", "356200.0 | \n", "309600.0 | \n", "318500.0 | \n", "1333100.0 | \n", "966100.0 | \n", "1198400.0 | \n", "1067000.0 | \n", "440100.0 | \n", "331700.0 | \n", "
2016-06-01 | \n", "1918700.0 | \n", "2250800.0 | \n", "3274100.0 | \n", "2381700.0 | \n", "1613000.0 | \n", "1731000.0 | \n", "1898400.0 | \n", "1364000.0 | \n", "1693800.0 | \n", "1764700.0 | \n", "... | \n", "274600.0 | \n", "359400.0 | \n", "312700.0 | \n", "320400.0 | \n", "1334600.0 | \n", "971500.0 | \n", "1203700.0 | \n", "1077200.0 | \n", "437900.0 | \n", "332700.0 | \n", "
2016-07-01 | \n", "1947600.0 | \n", "2285200.0 | \n", "3298600.0 | \n", "2439700.0 | \n", "1636600.0 | \n", "1762600.0 | \n", "1924500.0 | \n", "1373300.0 | \n", "1745600.0 | \n", "1777000.0 | \n", "... | \n", "277600.0 | \n", "363100.0 | \n", "315800.0 | \n", "322500.0 | \n", "1339000.0 | \n", "975300.0 | \n", "1206000.0 | \n", "1093200.0 | \n", "438700.0 | \n", "334900.0 | \n", "
2016-08-01 | \n", "1951300.0 | \n", "2329100.0 | \n", "3341100.0 | \n", "2483000.0 | \n", "1657500.0 | \n", "1778100.0 | \n", "1967300.0 | \n", "1382600.0 | \n", "1790400.0 | \n", "1776200.0 | \n", "... | \n", "281400.0 | \n", "367900.0 | \n", "316400.0 | \n", "324200.0 | \n", "1343000.0 | \n", "976200.0 | \n", "1206100.0 | \n", "1108300.0 | \n", "443600.0 | \n", "338000.0 | \n", "
2016-09-01 | \n", "1932800.0 | \n", "2354000.0 | \n", "3347100.0 | \n", "2480800.0 | \n", "1668300.0 | \n", "1773200.0 | \n", "1993500.0 | \n", "1374400.0 | \n", "1814600.0 | \n", "1766400.0 | \n", "... | \n", "284500.0 | \n", "373500.0 | \n", "316100.0 | \n", "325400.0 | \n", "1340200.0 | \n", "982200.0 | \n", "1207600.0 | \n", "1128000.0 | \n", "448400.0 | \n", "342100.0 | \n", "
2016-10-01 | \n", "1930400.0 | \n", "2355500.0 | \n", "3305500.0 | \n", "2443200.0 | \n", "1664800.0 | \n", "1760600.0 | \n", "1980700.0 | \n", "1364100.0 | \n", "1820400.0 | \n", "1749800.0 | \n", "... | \n", "287100.0 | \n", "378600.0 | \n", "318300.0 | \n", "326600.0 | \n", "1338700.0 | \n", "992000.0 | \n", "1209800.0 | \n", "1152400.0 | \n", "452300.0 | \n", "348300.0 | \n", "
2016-11-01 | \n", "1937500.0 | \n", "2352200.0 | \n", "3261100.0 | \n", "2430100.0 | \n", "1659500.0 | \n", "1762000.0 | \n", "1960900.0 | \n", "1366300.0 | \n", "1810000.0 | \n", "1744100.0 | \n", "... | \n", "290700.0 | \n", "382700.0 | \n", "321200.0 | \n", "328400.0 | \n", "1350600.0 | \n", "1002600.0 | \n", "1216200.0 | \n", "1166000.0 | \n", "457200.0 | \n", "356100.0 | \n", "
2016-12-01 | \n", "1935100.0 | \n", "2332100.0 | \n", "3244000.0 | \n", "2452900.0 | \n", "1656000.0 | \n", "1776800.0 | \n", "1951300.0 | \n", "1354800.0 | \n", "1786500.0 | \n", "1737900.0 | \n", "... | \n", "294700.0 | \n", "385300.0 | \n", "322900.0 | \n", "330300.0 | \n", "1375600.0 | \n", "1021400.0 | \n", "1221400.0 | \n", "1166500.0 | \n", "461200.0 | \n", "358400.0 | \n", "
2017-01-01 | \n", "1915700.0 | \n", "2313300.0 | \n", "3231400.0 | \n", "2451200.0 | \n", "1643700.0 | \n", "1775200.0 | \n", "1937800.0 | \n", "1327500.0 | \n", "1787100.0 | \n", "1722800.0 | \n", "... | \n", "299000.0 | \n", "387900.0 | \n", "325400.0 | \n", "333600.0 | \n", "1390200.0 | \n", "1039300.0 | \n", "1225600.0 | \n", "1166600.0 | \n", "464400.0 | \n", "357500.0 | \n", "
2017-02-01 | \n", "1916500.0 | \n", "2319600.0 | \n", "3183300.0 | \n", "2441900.0 | \n", "1649800.0 | \n", "1774500.0 | \n", "1929800.0 | \n", "1317300.0 | \n", "1801100.0 | \n", "1736600.0 | \n", "... | \n", "303800.0 | \n", "394500.0 | \n", "331700.0 | \n", "339300.0 | \n", "1398100.0 | \n", "1040800.0 | \n", "1225000.0 | \n", "1182900.0 | \n", "466400.0 | \n", "361900.0 | \n", "
2017-03-01 | \n", "1965700.0 | \n", "2342100.0 | \n", "3160200.0 | \n", "2460900.0 | \n", "1688500.0 | \n", "1812700.0 | \n", "1955000.0 | \n", "1333700.0 | \n", "1847900.0 | \n", "1750100.0 | \n", "... | \n", "308300.0 | \n", "403800.0 | \n", "339000.0 | \n", "345000.0 | \n", "1399900.0 | \n", "1035800.0 | \n", "1219600.0 | \n", "1202200.0 | \n", "470900.0 | \n", "370800.0 | \n", "
2017-04-01 | \n", "2045300.0 | \n", "2365900.0 | \n", "3193500.0 | \n", "2494900.0 | \n", "1731400.0 | \n", "1914600.0 | \n", "2022400.0 | \n", "1352100.0 | \n", "1922800.0 | \n", "1735500.0 | \n", "... | \n", "313800.0 | \n", "412000.0 | \n", "343500.0 | \n", "348400.0 | \n", "1400500.0 | \n", "1050000.0 | \n", "1238100.0 | \n", "1213200.0 | \n", "475700.0 | \n", "377100.0 | \n", "
2017-05-01 | \n", "2109100.0 | \n", "2419700.0 | \n", "3262200.0 | \n", "2498400.0 | \n", "1774100.0 | \n", "1997800.0 | \n", "2095000.0 | \n", "1390000.0 | \n", "2015700.0 | \n", "1717100.0 | \n", "... | \n", "321300.0 | \n", "418900.0 | \n", "347800.0 | \n", "351700.0 | \n", "1407300.0 | \n", "1066200.0 | \n", "1276400.0 | \n", "1211700.0 | \n", "477100.0 | \n", "380200.0 | \n", "
2017-06-01 | \n", "2147000.0 | \n", "2480400.0 | \n", "3316500.0 | \n", "2491600.0 | \n", "1815600.0 | \n", "2031600.0 | \n", "2142300.0 | \n", "1431000.0 | \n", "2083900.0 | \n", "1712900.0 | \n", "... | \n", "328300.0 | \n", "425100.0 | \n", "352900.0 | \n", "355000.0 | \n", "1420700.0 | \n", "1070800.0 | \n", "1302300.0 | \n", "1202900.0 | \n", "476900.0 | \n", "382300.0 | \n", "
90 rows × 21 columns
\n", "\n", " | zipcode | \n", "id | \n", "scrape_id | \n", "host_id | \n", "host_acceptance_rate | \n", "host_listings_count | \n", "host_total_listings_count | \n", "latitude | \n", "longitude | \n", "accommodates | \n", "... | \n", "2018-07-01 00:00:00 | \n", "2018-08-01 00:00:00 | \n", "2018-09-01 00:00:00 | \n", "2018-10-01 00:00:00 | \n", "2018-11-01 00:00:00 | \n", "2018-12-01 00:00:00 | \n", "2019-01-01 00:00:00 | \n", "2019-02-01 00:00:00 | \n", "2019-03-01 00:00:00 | \n", "Current Month Cost | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10003 | \n", "9.124661e+06 | \n", "2.017050e+13 | \n", "2.496037e+07 | \n", "NaN | \n", "1.646018 | \n", "1.646018 | \n", "40.728902 | \n", "-73.988258 | \n", "4.566372 | \n", "... | \n", "2.281265e+06 | \n", "2.291593e+06 | \n", "2.301921e+06 | \n", "2.312249e+06 | \n", "2.322578e+06 | \n", "2.332906e+06 | \n", "2.343234e+06 | \n", "2.353562e+06 | \n", "2.363890e+06 | \n", "2.374218e+06 | \n", "
1 | \n", "10011 | \n", "9.889107e+06 | \n", "2.017050e+13 | \n", "3.005599e+07 | \n", "NaN | \n", "1.448276 | \n", "1.448276 | \n", "40.742371 | \n", "-73.999752 | \n", "4.517241 | \n", "... | \n", "2.641337e+06 | \n", "2.653717e+06 | \n", "2.666097e+06 | \n", "2.678476e+06 | \n", "2.690856e+06 | \n", "2.703236e+06 | \n", "2.715616e+06 | \n", "2.727996e+06 | \n", "2.740375e+06 | \n", "2.752755e+06 | \n", "
2 | \n", "10013 | \n", "1.054726e+07 | \n", "2.017050e+13 | \n", "2.783653e+07 | \n", "NaN | \n", "1.412698 | \n", "1.412698 | \n", "40.719555 | \n", "-74.004075 | \n", "4.281250 | \n", "... | \n", "3.469549e+06 | \n", "3.481322e+06 | \n", "3.493096e+06 | \n", "3.504869e+06 | \n", "3.516642e+06 | \n", "3.528415e+06 | \n", "3.540188e+06 | \n", "3.551961e+06 | \n", "3.563734e+06 | \n", "3.575507e+06 | \n", "
3 | \n", "10014 | \n", "8.654217e+06 | \n", "2.017050e+13 | \n", "2.054620e+07 | \n", "NaN | \n", "1.537634 | \n", "1.537634 | \n", "40.734209 | \n", "-74.004240 | \n", "4.344086 | \n", "... | \n", "2.643481e+06 | \n", "2.655164e+06 | \n", "2.666847e+06 | \n", "2.678530e+06 | \n", "2.690213e+06 | \n", "2.701897e+06 | \n", "2.713580e+06 | \n", "2.725263e+06 | \n", "2.736946e+06 | \n", "2.748629e+06 | \n", "
4 | \n", "10021 | \n", "1.022891e+07 | \n", "2.017050e+13 | \n", "3.568867e+07 | \n", "NaN | \n", "1.526316 | \n", "1.526316 | \n", "40.768441 | \n", "-73.956628 | \n", "4.263158 | \n", "... | \n", "1.910792e+06 | \n", "1.918115e+06 | \n", "1.925437e+06 | \n", "1.932760e+06 | \n", "1.940082e+06 | \n", "1.947404e+06 | \n", "1.954727e+06 | \n", "1.962049e+06 | \n", "1.969372e+06 | \n", "1.976694e+06 | \n", "
5 | \n", "10022 | \n", "9.963782e+06 | \n", "2.017050e+13 | \n", "4.129974e+07 | \n", "NaN | \n", "1.394737 | \n", "1.394737 | \n", "40.758886 | \n", "-73.966700 | \n", "5.447368 | \n", "... | \n", "2.135103e+06 | \n", "2.143065e+06 | \n", "2.151027e+06 | \n", "2.158989e+06 | \n", "2.166951e+06 | \n", "2.174912e+06 | \n", "2.182874e+06 | \n", "2.190836e+06 | \n", "2.198798e+06 | \n", "2.206760e+06 | \n", "
6 | \n", "10023 | \n", "8.424752e+06 | \n", "2.017050e+13 | \n", "3.053048e+07 | \n", "NaN | \n", "2.888889 | \n", "2.888889 | \n", "40.777581 | \n", "-73.981486 | \n", "4.666667 | \n", "... | \n", "2.269437e+06 | \n", "2.279217e+06 | \n", "2.288997e+06 | \n", "2.298776e+06 | \n", "2.308556e+06 | \n", "2.318336e+06 | \n", "2.328116e+06 | \n", "2.337896e+06 | \n", "2.347675e+06 | \n", "2.357455e+06 | \n", "
7 | \n", "10025 | \n", "7.849437e+06 | \n", "2.017050e+13 | \n", "2.567103e+07 | \n", "NaN | \n", "1.571429 | \n", "1.571429 | \n", "40.798025 | \n", "-73.966355 | \n", "4.821429 | \n", "... | \n", "1.521226e+06 | \n", "1.528166e+06 | \n", "1.535107e+06 | \n", "1.542047e+06 | \n", "1.548988e+06 | \n", "1.555928e+06 | \n", "1.562869e+06 | \n", "1.569809e+06 | \n", "1.576749e+06 | \n", "1.583690e+06 | \n", "
8 | \n", "10028 | \n", "1.038785e+07 | \n", "2.017050e+13 | \n", "3.790560e+07 | \n", "NaN | \n", "1.375000 | \n", "1.375000 | \n", "40.775367 | \n", "-73.950934 | \n", "4.281250 | \n", "... | \n", "2.223818e+06 | \n", "2.234581e+06 | \n", "2.245344e+06 | \n", "2.256107e+06 | \n", "2.266870e+06 | \n", "2.277633e+06 | \n", "2.288396e+06 | \n", "2.299158e+06 | \n", "2.309921e+06 | \n", "2.320684e+06 | \n", "
9 | \n", "10036 | \n", "8.401201e+06 | \n", "2.017050e+13 | \n", "3.853206e+07 | \n", "NaN | \n", "73.500000 | \n", "73.500000 | \n", "40.754810 | \n", "-73.987824 | \n", "4.750000 | \n", "... | \n", "1.782180e+06 | \n", "1.787509e+06 | \n", "1.792838e+06 | \n", "1.798167e+06 | \n", "1.803497e+06 | \n", "1.808826e+06 | \n", "1.814155e+06 | \n", "1.819484e+06 | \n", "1.824813e+06 | \n", "1.830143e+06 | \n", "
10 | \n", "10128 | \n", "1.079017e+07 | \n", "2.017050e+13 | \n", "2.984589e+07 | \n", "NaN | \n", "1.321429 | \n", "1.321429 | \n", "40.781842 | \n", "-73.949537 | \n", "4.357143 | \n", "... | \n", "2.723528e+06 | \n", "2.800994e+06 | \n", "2.879236e+06 | \n", "2.958255e+06 | \n", "3.038049e+06 | \n", "3.118619e+06 | \n", "3.199966e+06 | \n", "3.282089e+06 | \n", "3.364987e+06 | \n", "3.448662e+06 | \n", "
11 | \n", "10304 | \n", "1.590640e+06 | \n", "2.017050e+13 | \n", "7.534770e+06 | \n", "NaN | \n", "1.000000 | \n", "1.000000 | \n", "40.626721 | \n", "-74.076721 | \n", "3.500000 | \n", "... | \n", "4.259331e+05 | \n", "4.339654e+05 | \n", "4.420723e+05 | \n", "4.502538e+05 | \n", "4.585099e+05 | \n", "4.668406e+05 | \n", "4.752459e+05 | \n", "4.837257e+05 | \n", "4.922802e+05 | \n", "5.009092e+05 | \n", "
12 | \n", "10305 | \n", "1.368595e+07 | \n", "2.017050e+13 | \n", "5.535834e+07 | \n", "NaN | \n", "1.555556 | \n", "1.555556 | \n", "40.596360 | \n", "-74.077371 | \n", "4.555556 | \n", "... | \n", "5.132489e+05 | \n", "5.206102e+05 | \n", "5.280545e+05 | \n", "5.355818e+05 | \n", "5.431920e+05 | \n", "5.508852e+05 | \n", "5.586614e+05 | \n", "5.665205e+05 | \n", "5.744625e+05 | \n", "5.824875e+05 | \n", "
13 | \n", "10306 | \n", "8.328929e+06 | \n", "2.017050e+13 | \n", "5.237069e+07 | \n", "NaN | \n", "2.000000 | \n", "2.000000 | \n", "40.568879 | \n", "-74.111565 | \n", "5.500000 | \n", "... | \n", "4.251977e+05 | \n", "4.312205e+05 | \n", "4.373091e+05 | \n", "4.434636e+05 | \n", "4.496841e+05 | \n", "4.559705e+05 | \n", "4.623227e+05 | \n", "4.687409e+05 | \n", "4.752250e+05 | \n", "4.817750e+05 | \n", "
14 | \n", "10312 | \n", "1.800434e+07 | \n", "2.017050e+13 | \n", "1.197988e+08 | \n", "NaN | \n", "1.000000 | \n", "1.000000 | \n", "40.546331 | \n", "-74.183701 | \n", "2.000000 | \n", "... | \n", "4.012734e+05 | \n", "4.050852e+05 | \n", "4.089326e+05 | \n", "4.128157e+05 | \n", "4.167345e+05 | \n", "4.206890e+05 | \n", "4.246794e+05 | \n", "4.287059e+05 | \n", "4.327680e+05 | \n", "4.368654e+05 | \n", "
15 | \n", "11201 | \n", "9.298929e+06 | \n", "2.017050e+13 | \n", "2.327364e+07 | \n", "NaN | \n", "1.451613 | \n", "1.451613 | \n", "40.692611 | \n", "-73.990576 | \n", "4.451613 | \n", "... | \n", "1.519719e+06 | \n", "1.527336e+06 | \n", "1.534953e+06 | \n", "1.542570e+06 | \n", "1.550187e+06 | \n", "1.557803e+06 | \n", "1.565420e+06 | \n", "1.573037e+06 | \n", "1.580654e+06 | \n", "1.588271e+06 | \n", "
16 | \n", "11215 | \n", "9.035422e+06 | \n", "2.017050e+13 | \n", "2.460656e+07 | \n", "NaN | \n", "1.422764 | \n", "1.422764 | \n", "40.666241 | \n", "-73.984527 | \n", "4.266129 | \n", "... | \n", "1.149896e+06 | \n", "1.155980e+06 | \n", "1.162064e+06 | \n", "1.168148e+06 | \n", "1.174233e+06 | \n", "1.180317e+06 | \n", "1.186401e+06 | \n", "1.192485e+06 | \n", "1.198570e+06 | \n", "1.204654e+06 | \n", "
17 | \n", "11217 | \n", "6.866520e+06 | \n", "2.017050e+13 | \n", "1.988437e+07 | \n", "NaN | \n", "1.283333 | \n", "1.283333 | \n", "40.681377 | \n", "-73.979068 | \n", "3.983333 | \n", "... | \n", "1.665473e+06 | \n", "1.695445e+06 | \n", "1.725709e+06 | \n", "1.756264e+06 | \n", "1.787109e+06 | \n", "1.818245e+06 | \n", "1.849673e+06 | \n", "1.881391e+06 | \n", "1.913400e+06 | \n", "1.945700e+06 | \n", "
18 | \n", "11231 | \n", "7.697324e+06 | \n", "2.017050e+13 | \n", "2.171201e+07 | \n", "NaN | \n", "1.550725 | \n", "1.550725 | \n", "40.680632 | \n", "-74.000049 | \n", "4.391304 | \n", "... | \n", "1.292235e+06 | \n", "1.299107e+06 | \n", "1.305979e+06 | \n", "1.312851e+06 | \n", "1.319722e+06 | \n", "1.326594e+06 | \n", "1.333466e+06 | \n", "1.340338e+06 | \n", "1.347210e+06 | \n", "1.354082e+06 | \n", "
19 | \n", "11234 | \n", "1.066553e+07 | \n", "2.017050e+13 | \n", "2.752097e+07 | \n", "NaN | \n", "1.333333 | \n", "1.333333 | \n", "40.623074 | \n", "-73.925943 | \n", "4.166667 | \n", "... | \n", "4.688470e+05 | \n", "4.678265e+05 | \n", "4.667486e+05 | \n", "4.656135e+05 | \n", "4.644211e+05 | \n", "4.631714e+05 | \n", "4.618644e+05 | \n", "4.605001e+05 | \n", "4.590786e+05 | \n", "4.575997e+05 | \n", "
20 | \n", "11434 | \n", "9.374263e+06 | \n", "2.017050e+13 | \n", "4.863844e+07 | \n", "NaN | \n", "1.000000 | \n", "1.000000 | \n", "40.662033 | \n", "-73.769800 | \n", "4.000000 | \n", "... | \n", "4.165402e+05 | \n", "4.197565e+05 | \n", "4.230561e+05 | \n", "4.264390e+05 | \n", "4.299051e+05 | \n", "4.334544e+05 | \n", "4.370870e+05 | \n", "4.408028e+05 | \n", "4.446019e+05 | \n", "4.484842e+05 | \n", "
21 rows × 317 columns
\n", "\n", " | zipcode | \n", "id | \n", "scrape_id | \n", "host_id | \n", "host_acceptance_rate | \n", "host_listings_count | \n", "host_total_listings_count | \n", "latitude | \n", "longitude | \n", "accommodates | \n", "... | \n", "2018-08-01 00:00:00 | \n", "2018-09-01 00:00:00 | \n", "2018-10-01 00:00:00 | \n", "2018-11-01 00:00:00 | \n", "2018-12-01 00:00:00 | \n", "2019-01-01 00:00:00 | \n", "2019-02-01 00:00:00 | \n", "2019-03-01 00:00:00 | \n", "Current Month Cost | \n", "neighbourhood_group_cleansed | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10003 | \n", "9.124661e+06 | \n", "2.017050e+13 | \n", "2.496037e+07 | \n", "NaN | \n", "1.646018 | \n", "1.646018 | \n", "40.728902 | \n", "-73.988258 | \n", "4.566372 | \n", "... | \n", "2.291593e+06 | \n", "2.301921e+06 | \n", "2.312249e+06 | \n", "2.322578e+06 | \n", "2.332906e+06 | \n", "2.343234e+06 | \n", "2.353562e+06 | \n", "2.363890e+06 | \n", "2.374218e+06 | \n", "Manhattan | \n", "
1 | \n", "10011 | \n", "9.889107e+06 | \n", "2.017050e+13 | \n", "3.005599e+07 | \n", "NaN | \n", "1.448276 | \n", "1.448276 | \n", "40.742371 | \n", "-73.999752 | \n", "4.517241 | \n", "... | \n", "2.653717e+06 | \n", "2.666097e+06 | \n", "2.678476e+06 | \n", "2.690856e+06 | \n", "2.703236e+06 | \n", "2.715616e+06 | \n", "2.727996e+06 | \n", "2.740375e+06 | \n", "2.752755e+06 | \n", "Manhattan | \n", "
2 | \n", "10013 | \n", "1.054726e+07 | \n", "2.017050e+13 | \n", "2.783653e+07 | \n", "NaN | \n", "1.412698 | \n", "1.412698 | \n", "40.719555 | \n", "-74.004075 | \n", "4.281250 | \n", "... | \n", "3.481322e+06 | \n", "3.493096e+06 | \n", "3.504869e+06 | \n", "3.516642e+06 | \n", "3.528415e+06 | \n", "3.540188e+06 | \n", "3.551961e+06 | \n", "3.563734e+06 | \n", "3.575507e+06 | \n", "Manhattan | \n", "
3 | \n", "10014 | \n", "8.654217e+06 | \n", "2.017050e+13 | \n", "2.054620e+07 | \n", "NaN | \n", "1.537634 | \n", "1.537634 | \n", "40.734209 | \n", "-74.004240 | \n", "4.344086 | \n", "... | \n", "2.655164e+06 | \n", "2.666847e+06 | \n", "2.678530e+06 | \n", "2.690213e+06 | \n", "2.701897e+06 | \n", "2.713580e+06 | \n", "2.725263e+06 | \n", "2.736946e+06 | \n", "2.748629e+06 | \n", "Manhattan | \n", "
4 | \n", "10021 | \n", "1.022891e+07 | \n", "2.017050e+13 | \n", "3.568867e+07 | \n", "NaN | \n", "1.526316 | \n", "1.526316 | \n", "40.768441 | \n", "-73.956628 | \n", "4.263158 | \n", "... | \n", "1.918115e+06 | \n", "1.925437e+06 | \n", "1.932760e+06 | \n", "1.940082e+06 | \n", "1.947404e+06 | \n", "1.954727e+06 | \n", "1.962049e+06 | \n", "1.969372e+06 | \n", "1.976694e+06 | \n", "Manhattan | \n", "
5 rows × 318 columns
\n", "\n", " | zipcode | \n", "review_scores_rating | \n", "number_of_reviews | \n", "
---|---|---|---|
0 | \n", "10003 | \n", "92.514445 | \n", "31.292486 | \n", "
1 | \n", "10011 | \n", "93.691141 | \n", "15.945257 | \n", "
2 | \n", "10013 | \n", "91.690927 | \n", "18.906767 | \n", "
3 | \n", "10014 | \n", "93.658104 | \n", "17.774297 | \n", "
4 | \n", "10021 | \n", "93.153286 | \n", "18.810971 | \n", "
5 | \n", "10022 | \n", "88.233652 | \n", "29.905702 | \n", "
6 | \n", "10023 | \n", "94.411979 | \n", "16.877034 | \n", "
7 | \n", "10025 | \n", "92.062500 | \n", "20.180494 | \n", "
8 | \n", "10028 | \n", "94.200047 | \n", "11.622623 | \n", "
9 | \n", "10036 | \n", "90.763228 | \n", "22.604651 | \n", "
10 | \n", "10128 | \n", "91.747068 | \n", "9.917482 | \n", "
11 | \n", "10304 | \n", "80.000000 | \n", "1.000000 | \n", "
12 | \n", "10305 | \n", "93.333333 | \n", "8.261438 | \n", "
13 | \n", "10306 | \n", "95.500000 | \n", "71.500000 | \n", "
14 | \n", "10312 | \n", "97.857143 | \n", "23.222222 | \n", "
15 | \n", "11201 | \n", "95.517568 | \n", "22.670683 | \n", "
16 | \n", "11215 | \n", "95.111842 | \n", "16.446481 | \n", "
17 | \n", "11217 | \n", "94.709933 | \n", "20.022059 | \n", "
18 | \n", "11231 | \n", "94.353986 | \n", "19.016645 | \n", "
19 | \n", "11234 | \n", "88.000000 | \n", "13.833333 | \n", "
20 | \n", "11434 | \n", "95.000000 | \n", "42.000000 | \n", "
\n", " | zipcode | \n", "id | \n", "scrape_id | \n", "host_id | \n", "host_listings_count | \n", "host_total_listings_count | \n", "latitude | \n", "longitude | \n", "accommodates | \n", "bathrooms | \n", "... | \n", "2018-08-01 00:00:00 | \n", "2018-09-01 00:00:00 | \n", "2018-10-01 00:00:00 | \n", "2018-11-01 00:00:00 | \n", "2018-12-01 00:00:00 | \n", "2019-01-01 00:00:00 | \n", "2019-02-01 00:00:00 | \n", "2019-03-01 00:00:00 | \n", "Current Month Cost | \n", "neighbourhood_group_cleansed | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10003 | \n", "9.124661e+06 | \n", "2.017050e+13 | \n", "2.496037e+07 | \n", "1.646018 | \n", "1.646018 | \n", "40.728902 | \n", "-73.988258 | \n", "4.566372 | \n", "1.225664 | \n", "... | \n", "2.291593e+06 | \n", "2.301921e+06 | \n", "2.312249e+06 | \n", "2.322578e+06 | \n", "2.332906e+06 | \n", "2.343234e+06 | \n", "2.353562e+06 | \n", "2.363890e+06 | \n", "2.374218e+06 | \n", "Manhattan | \n", "
1 | \n", "10011 | \n", "9.889107e+06 | \n", "2.017050e+13 | \n", "3.005599e+07 | \n", "1.448276 | \n", "1.448276 | \n", "40.742371 | \n", "-73.999752 | \n", "4.517241 | \n", "1.337209 | \n", "... | \n", "2.653717e+06 | \n", "2.666097e+06 | \n", "2.678476e+06 | \n", "2.690856e+06 | \n", "2.703236e+06 | \n", "2.715616e+06 | \n", "2.727996e+06 | \n", "2.740375e+06 | \n", "2.752755e+06 | \n", "Manhattan | \n", "
2 | \n", "10013 | \n", "1.054726e+07 | \n", "2.017050e+13 | \n", "2.783653e+07 | \n", "1.412698 | \n", "1.412698 | \n", "40.719555 | \n", "-74.004075 | \n", "4.281250 | \n", "1.359375 | \n", "... | \n", "3.481322e+06 | \n", "3.493096e+06 | \n", "3.504869e+06 | \n", "3.516642e+06 | \n", "3.528415e+06 | \n", "3.540188e+06 | \n", "3.551961e+06 | \n", "3.563734e+06 | \n", "3.575507e+06 | \n", "Manhattan | \n", "
3 | \n", "10014 | \n", "8.654217e+06 | \n", "2.017050e+13 | \n", "2.054620e+07 | \n", "1.537634 | \n", "1.537634 | \n", "40.734209 | \n", "-74.004240 | \n", "4.344086 | \n", "1.182796 | \n", "... | \n", "2.655164e+06 | \n", "2.666847e+06 | \n", "2.678530e+06 | \n", "2.690213e+06 | \n", "2.701897e+06 | \n", "2.713580e+06 | \n", "2.725263e+06 | \n", "2.736946e+06 | \n", "2.748629e+06 | \n", "Manhattan | \n", "
4 | \n", "10021 | \n", "1.022891e+07 | \n", "2.017050e+13 | \n", "3.568867e+07 | \n", "1.526316 | \n", "1.526316 | \n", "40.768441 | \n", "-73.956628 | \n", "4.263158 | \n", "1.052632 | \n", "... | \n", "1.918115e+06 | \n", "1.925437e+06 | \n", "1.932760e+06 | \n", "1.940082e+06 | \n", "1.947404e+06 | \n", "1.954727e+06 | \n", "1.962049e+06 | \n", "1.969372e+06 | \n", "1.976694e+06 | \n", "Manhattan | \n", "
5 rows × 174 columns
\n", "\n", " | zipcode | \n", "id | \n", "scrape_id | \n", "host_id | \n", "host_listings_count | \n", "host_total_listings_count | \n", "latitude | \n", "longitude | \n", "accommodates | \n", "bathrooms | \n", "... | \n", "2018-08-01 00:00:00 | \n", "2018-09-01 00:00:00 | \n", "2018-10-01 00:00:00 | \n", "2018-11-01 00:00:00 | \n", "2018-12-01 00:00:00 | \n", "2019-01-01 00:00:00 | \n", "2019-02-01 00:00:00 | \n", "2019-03-01 00:00:00 | \n", "Current Month Cost | \n", "neighbourhood_group_cleansed | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10003 | \n", "9.124661e+06 | \n", "2.017050e+13 | \n", "2.496037e+07 | \n", "1.646018 | \n", "1.646018 | \n", "40.728902 | \n", "-73.988258 | \n", "4.566372 | \n", "1.225664 | \n", "... | \n", "2.291593e+06 | \n", "2.301921e+06 | \n", "2.312249e+06 | \n", "2.322578e+06 | \n", "2.332906e+06 | \n", "2.343234e+06 | \n", "2.353562e+06 | \n", "2.363890e+06 | \n", "2.374218e+06 | \n", "Manhattan | \n", "
1 | \n", "10011 | \n", "9.889107e+06 | \n", "2.017050e+13 | \n", "3.005599e+07 | \n", "1.448276 | \n", "1.448276 | \n", "40.742371 | \n", "-73.999752 | \n", "4.517241 | \n", "1.337209 | \n", "... | \n", "2.653717e+06 | \n", "2.666097e+06 | \n", "2.678476e+06 | \n", "2.690856e+06 | \n", "2.703236e+06 | \n", "2.715616e+06 | \n", "2.727996e+06 | \n", "2.740375e+06 | \n", "2.752755e+06 | \n", "Manhattan | \n", "
2 | \n", "10013 | \n", "1.054726e+07 | \n", "2.017050e+13 | \n", "2.783653e+07 | \n", "1.412698 | \n", "1.412698 | \n", "40.719555 | \n", "-74.004075 | \n", "4.281250 | \n", "1.359375 | \n", "... | \n", "3.481322e+06 | \n", "3.493096e+06 | \n", "3.504869e+06 | \n", "3.516642e+06 | \n", "3.528415e+06 | \n", "3.540188e+06 | \n", "3.551961e+06 | \n", "3.563734e+06 | \n", "3.575507e+06 | \n", "Manhattan | \n", "
3 | \n", "10014 | \n", "8.654217e+06 | \n", "2.017050e+13 | \n", "2.054620e+07 | \n", "1.537634 | \n", "1.537634 | \n", "40.734209 | \n", "-74.004240 | \n", "4.344086 | \n", "1.182796 | \n", "... | \n", "2.655164e+06 | \n", "2.666847e+06 | \n", "2.678530e+06 | \n", "2.690213e+06 | \n", "2.701897e+06 | \n", "2.713580e+06 | \n", "2.725263e+06 | \n", "2.736946e+06 | \n", "2.748629e+06 | \n", "Manhattan | \n", "
4 | \n", "10021 | \n", "1.022891e+07 | \n", "2.017050e+13 | \n", "3.568867e+07 | \n", "1.526316 | \n", "1.526316 | \n", "40.768441 | \n", "-73.956628 | \n", "4.263158 | \n", "1.052632 | \n", "... | \n", "1.918115e+06 | \n", "1.925437e+06 | \n", "1.932760e+06 | \n", "1.940082e+06 | \n", "1.947404e+06 | \n", "1.954727e+06 | \n", "1.962049e+06 | \n", "1.969372e+06 | \n", "1.976694e+06 | \n", "Manhattan | \n", "
5 rows × 174 columns
\n", "\n", " | zipcode | \n", "id | \n", "scrape_id | \n", "host_id | \n", "host_listings_count | \n", "host_total_listings_count | \n", "latitude | \n", "longitude | \n", "accommodates | \n", "bathrooms | \n", "... | \n", "2018-10-01 00:00:00 | \n", "2018-11-01 00:00:00 | \n", "2018-12-01 00:00:00 | \n", "2019-01-01 00:00:00 | \n", "2019-02-01 00:00:00 | \n", "2019-03-01 00:00:00 | \n", "Current Month Cost | \n", "neighbourhood_group_cleansed | \n", "Expected Return | \n", "Breakeven Period | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10003 | \n", "9.124661e+06 | \n", "2.017050e+13 | \n", "2.496037e+07 | \n", "1.646018 | \n", "1.646018 | \n", "40.728902 | \n", "-73.988258 | \n", "4.566372 | \n", "1.225664 | \n", "... | \n", "2.312249e+06 | \n", "2.322578e+06 | \n", "2.332906e+06 | \n", "2.343234e+06 | \n", "2.353562e+06 | \n", "2.363890e+06 | \n", "2.374218e+06 | \n", "Manhattan | \n", "85085.376106 | \n", "27.903949 | \n", "
1 | \n", "10011 | \n", "9.889107e+06 | \n", "2.017050e+13 | \n", "3.005599e+07 | \n", "1.448276 | \n", "1.448276 | \n", "40.742371 | \n", "-73.999752 | \n", "4.517241 | \n", "1.337209 | \n", "... | \n", "2.678476e+06 | \n", "2.690856e+06 | \n", "2.703236e+06 | \n", "2.715616e+06 | \n", "2.727996e+06 | \n", "2.740375e+06 | \n", "2.752755e+06 | \n", "Manhattan | \n", "99531.724138 | \n", "27.657062 | \n", "
2 | \n", "10013 | \n", "1.054726e+07 | \n", "2.017050e+13 | \n", "2.783653e+07 | \n", "1.412698 | \n", "1.412698 | \n", "40.719555 | \n", "-74.004075 | \n", "4.281250 | \n", "1.359375 | \n", "... | \n", "3.504869e+06 | \n", "3.516642e+06 | \n", "3.528415e+06 | \n", "3.540188e+06 | \n", "3.551961e+06 | \n", "3.563734e+06 | \n", "3.575507e+06 | \n", "Manhattan | \n", "106719.726562 | \n", "33.503710 | \n", "
3 | \n", "10014 | \n", "8.654217e+06 | \n", "2.017050e+13 | \n", "2.054620e+07 | \n", "1.537634 | \n", "1.537634 | \n", "40.734209 | \n", "-74.004240 | \n", "4.344086 | \n", "1.182796 | \n", "... | \n", "2.678530e+06 | \n", "2.690213e+06 | \n", "2.701897e+06 | \n", "2.713580e+06 | \n", "2.725263e+06 | \n", "2.736946e+06 | \n", "2.748629e+06 | \n", "Manhattan | \n", "89048.225806 | \n", "30.866749 | \n", "
4 | \n", "10021 | \n", "1.022891e+07 | \n", "2.017050e+13 | \n", "3.568867e+07 | \n", "1.526316 | \n", "1.526316 | \n", "40.768441 | \n", "-73.956628 | \n", "4.263158 | \n", "1.052632 | \n", "... | \n", "1.932760e+06 | \n", "1.940082e+06 | \n", "1.947404e+06 | \n", "1.954727e+06 | \n", "1.962049e+06 | \n", "1.969372e+06 | \n", "1.976694e+06 | \n", "Manhattan | \n", "74964.276316 | \n", "26.368485 | \n", "
5 | \n", "10022 | \n", "9.963782e+06 | \n", "2.017050e+13 | \n", "4.129974e+07 | \n", "1.394737 | \n", "1.394737 | \n", "40.758886 | \n", "-73.966700 | \n", "5.447368 | \n", "1.276316 | \n", "... | \n", "2.158989e+06 | \n", "2.166951e+06 | \n", "2.174912e+06 | \n", "2.182874e+06 | \n", "2.190836e+06 | \n", "2.198798e+06 | \n", "2.206760e+06 | \n", "Manhattan | \n", "100545.493421 | \n", "21.947871 | \n", "
6 | \n", "10023 | \n", "8.424752e+06 | \n", "2.017050e+13 | \n", "3.053048e+07 | \n", "2.888889 | \n", "2.888889 | \n", "40.777581 | \n", "-73.981486 | \n", "4.666667 | \n", "1.349206 | \n", "... | \n", "2.298776e+06 | \n", "2.308556e+06 | \n", "2.318336e+06 | \n", "2.328116e+06 | \n", "2.337896e+06 | \n", "2.347675e+06 | \n", "2.357455e+06 | \n", "Manhattan | \n", "77936.190476 | \n", "30.248528 | \n", "
7 | \n", "10025 | \n", "7.849437e+06 | \n", "2.017050e+13 | \n", "2.567103e+07 | \n", "1.571429 | \n", "1.571429 | \n", "40.798025 | \n", "-73.966355 | \n", "4.821429 | \n", "1.232143 | \n", "... | \n", "1.542047e+06 | \n", "1.548988e+06 | \n", "1.555928e+06 | \n", "1.562869e+06 | \n", "1.569809e+06 | \n", "1.576749e+06 | \n", "1.583690e+06 | \n", "Manhattan | \n", "78292.500000 | \n", "20.227862 | \n", "
8 | \n", "10028 | \n", "1.038785e+07 | \n", "2.017050e+13 | \n", "3.790560e+07 | \n", "1.375000 | \n", "1.375000 | \n", "40.775367 | \n", "-73.950934 | \n", "4.281250 | \n", "1.258065 | \n", "... | \n", "2.256107e+06 | \n", "2.266870e+06 | \n", "2.277633e+06 | \n", "2.288396e+06 | \n", "2.299158e+06 | \n", "2.309921e+06 | \n", "2.320684e+06 | \n", "Manhattan | \n", "74040.820312 | \n", "31.343308 | \n", "
9 | \n", "10036 | \n", "8.401201e+06 | \n", "2.017050e+13 | \n", "3.853206e+07 | \n", "73.500000 | \n", "73.500000 | \n", "40.754810 | \n", "-73.987824 | \n", "4.750000 | \n", "1.416667 | \n", "... | \n", "1.798167e+06 | \n", "1.803497e+06 | \n", "1.808826e+06 | \n", "1.814155e+06 | \n", "1.819484e+06 | \n", "1.824813e+06 | \n", "1.830143e+06 | \n", "Manhattan | \n", "122001.250000 | \n", "15.001016 | \n", "
10 | \n", "10128 | \n", "1.079017e+07 | \n", "2.017050e+13 | \n", "2.984589e+07 | \n", "1.321429 | \n", "1.321429 | \n", "40.781842 | \n", "-73.949537 | \n", "4.357143 | \n", "1.232143 | \n", "... | \n", "2.958255e+06 | \n", "3.038049e+06 | \n", "3.118619e+06 | \n", "3.199966e+06 | \n", "3.282089e+06 | \n", "3.364987e+06 | \n", "3.448662e+06 | \n", "Manhattan | \n", "61696.406250 | \n", "55.897300 | \n", "
11 | \n", "10304 | \n", "1.590640e+06 | \n", "2.017050e+13 | \n", "7.534770e+06 | \n", "1.000000 | \n", "1.000000 | \n", "40.626721 | \n", "-74.076721 | \n", "3.500000 | \n", "1.250000 | \n", "... | \n", "4.502538e+05 | \n", "4.585099e+05 | \n", "4.668406e+05 | \n", "4.752459e+05 | \n", "4.837257e+05 | \n", "4.922802e+05 | \n", "5.009092e+05 | \n", "Staten Island | \n", "26553.750000 | \n", "18.863973 | \n", "
12 | \n", "10305 | \n", "1.368595e+07 | \n", "2.017050e+13 | \n", "5.535834e+07 | \n", "1.555556 | \n", "1.555556 | \n", "40.596360 | \n", "-74.077371 | \n", "4.555556 | \n", "1.111111 | \n", "... | \n", "5.355818e+05 | \n", "5.431920e+05 | \n", "5.508852e+05 | \n", "5.586614e+05 | \n", "5.665205e+05 | \n", "5.744625e+05 | \n", "5.824875e+05 | \n", "Staten Island | \n", "30447.083333 | \n", "19.131143 | \n", "
13 | \n", "10306 | \n", "8.328929e+06 | \n", "2.017050e+13 | \n", "5.237069e+07 | \n", "2.000000 | \n", "2.000000 | \n", "40.568879 | \n", "-74.111565 | \n", "5.500000 | \n", "1.250000 | \n", "... | \n", "4.434636e+05 | \n", "4.496841e+05 | \n", "4.559705e+05 | \n", "4.623227e+05 | \n", "4.687409e+05 | \n", "4.752250e+05 | \n", "4.817750e+05 | \n", "Staten Island | \n", "25458.750000 | \n", "18.923749 | \n", "
14 | \n", "10312 | \n", "1.800434e+07 | \n", "2.017050e+13 | \n", "1.197988e+08 | \n", "1.000000 | \n", "1.000000 | \n", "40.546331 | \n", "-74.183701 | \n", "2.000000 | \n", "2.000000 | \n", "... | \n", "4.128157e+05 | \n", "4.167345e+05 | \n", "4.206890e+05 | \n", "4.246794e+05 | \n", "4.287059e+05 | \n", "4.327680e+05 | \n", "4.368654e+05 | \n", "Staten Island | \n", "58856.250000 | \n", "7.422584 | \n", "
15 | \n", "11201 | \n", "9.298929e+06 | \n", "2.017050e+13 | \n", "2.327364e+07 | \n", "1.451613 | \n", "1.451613 | \n", "40.692611 | \n", "-73.990576 | \n", "4.451613 | \n", "1.250000 | \n", "... | \n", "1.542570e+06 | \n", "1.550187e+06 | \n", "1.557803e+06 | \n", "1.565420e+06 | \n", "1.573037e+06 | \n", "1.580654e+06 | \n", "1.588271e+06 | \n", "Brooklyn | \n", "57112.197581 | \n", "27.809660 | \n", "
16 | \n", "11215 | \n", "9.035422e+06 | \n", "2.017050e+13 | \n", "2.460656e+07 | \n", "1.422764 | \n", "1.422764 | \n", "40.666241 | \n", "-73.984527 | \n", "4.266129 | \n", "1.189516 | \n", "... | \n", "1.168148e+06 | \n", "1.174233e+06 | \n", "1.180317e+06 | \n", "1.186401e+06 | \n", "1.192485e+06 | \n", "1.198570e+06 | \n", "1.204654e+06 | \n", "Brooklyn | \n", "48641.401210 | \n", "24.766020 | \n", "
17 | \n", "11217 | \n", "6.866520e+06 | \n", "2.017050e+13 | \n", "1.988437e+07 | \n", "1.283333 | \n", "1.283333 | \n", "40.681377 | \n", "-73.979068 | \n", "3.983333 | \n", "1.228814 | \n", "... | \n", "1.756264e+06 | \n", "1.787109e+06 | \n", "1.818245e+06 | \n", "1.849673e+06 | \n", "1.881391e+06 | \n", "1.913400e+06 | \n", "1.945700e+06 | \n", "Brooklyn | \n", "55603.187500 | \n", "34.992598 | \n", "
18 | \n", "11231 | \n", "7.697324e+06 | \n", "2.017050e+13 | \n", "2.171201e+07 | \n", "1.550725 | \n", "1.550725 | \n", "40.680632 | \n", "-74.000049 | \n", "4.391304 | \n", "1.176471 | \n", "... | \n", "1.312851e+06 | \n", "1.319722e+06 | \n", "1.326594e+06 | \n", "1.333466e+06 | \n", "1.340338e+06 | \n", "1.347210e+06 | \n", "1.354082e+06 | \n", "Brooklyn | \n", "54896.793478 | \n", "24.665958 | \n", "
19 | \n", "11234 | \n", "1.066553e+07 | \n", "2.017050e+13 | \n", "2.752097e+07 | \n", "1.333333 | \n", "1.333333 | \n", "40.623074 | \n", "-73.925943 | \n", "4.166667 | \n", "1.083333 | \n", "... | \n", "4.656135e+05 | \n", "4.644211e+05 | \n", "4.631714e+05 | \n", "4.618644e+05 | \n", "4.605001e+05 | \n", "4.590786e+05 | \n", "4.575997e+05 | \n", "Brooklyn | \n", "29382.500000 | \n", "15.573886 | \n", "
20 | \n", "11434 | \n", "9.374263e+06 | \n", "2.017050e+13 | \n", "4.863844e+07 | \n", "1.000000 | \n", "1.000000 | \n", "40.662033 | \n", "-73.769800 | \n", "4.000000 | \n", "1.000000 | \n", "... | \n", "4.264390e+05 | \n", "4.299051e+05 | \n", "4.334544e+05 | \n", "4.370870e+05 | \n", "4.408028e+05 | \n", "4.446019e+05 | \n", "4.484842e+05 | \n", "Queens | \n", "42431.250000 | \n", "10.569666 | \n", "
21 rows × 176 columns
\n", "