CPI Of New Single Family Houses Sold Based On 2005 Price

JohnSnowLabs

Files Size Format Created Updated License Source
2 144kB csv zip 2 weeks ago johnsnowlabs Data.gov
Download

Data Files

cpi-of-new-single-family-houses-sold-based-on-2005-price-csv  

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Year 1 date (%Y-%m-%d) Construction price index for the year
Average_Sales_Price_Of_Houses_Actually_Sold_In_US 2 number Average selling price of the house for the year
Percent_Change_Annual 3 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Average_Sales_Price_Of_Typical_2005_House_In_US 4 number Average sale price of similar kind of a house in the year
Percent_Change_Annual_Based_On_2005 5 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Price_Index_Annual 6 number Price index of the house sold
Average_Sales_Price_Of_Houses_Actually_Sold_In_Northeast_Region 7 number Average selling price of the house for the year in the Northeast region
Percent_Change_For_Houses_Actually_Sold_In_Northeast_Region 8 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Average_Sales_Price_Of_Typical_2005_House_In_Northeast_Region 9 number Average sale price of similar kind of a house in the year
Percent_Change_Northeast_Region_Based_On_2005 10 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Price_Index_Northeast_Region 11 number Price index of the house sold
Average_Sales_Price_Of_Houses_Actually_Sold_In_Midwest_Region 12 number Average selling price of the house for the year in the Midwest region
Percent_Change_Midwest_Region 13 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Average_Sales_Price_Of_Typical_2005_House_In_Midwest_Region 14 number Average sale price of similar kind of a house in the year
Percent_Change_Midwest_Region_Based_On_2005 15 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Price_Index_Midwest_Region 16 number Price index of the house sold
Average_Sales_Price_Of_Houses_Actually_Sold_In_South_Region 17 number Average selling price of the house for the year in the Southeast region
Percent_Change_In_South_Region 18 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Average_Sales_Price_Of_Typical_2005_House_In_South_Region 19 number Average sale price of similar kind of a house in the year
Percent_Change_In_South_Region_Based_On_2005 20 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Price_Index_In_South_Region 21 number Price index of the house sold
Average_Sales_Price_Of_Houses_Actually_Sold_In_West_Region 22 number Average selling price of the house for the year in the West region
Percent_Change_In_West_Region 23 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Average_Sales_Price_Of_Typical_2005_House_In_West_Region 24 number Average sale price of similar kind of a house in the year
Percent_Change_In_West_Region_Based_On_2005 25 number Percentage change in the price of the house for the year compared to the price of house sold in 2005
Price_Index_In_West_Region 26 number Price index of the house sold

cpi-of-new-single-family-houses-sold-based-on-2005-price_zip  

This is a preview version. There might be more data in the original version.

Read me

Import into your tool

In order to use Data Package in R follow instructions below:

install.packages("devtools")
library(devtools)
install_github("hadley/readr")
install_github("ropenscilabs/jsonvalidate")
install_github("ropenscilabs/datapkg")

#Load client
library(datapkg)

#Get Data Package
datapackage <- datapkg_read("https://pkgstore.datahub.io/JohnSnowLabs/cpi-of-new-single-family-houses-sold-based-on-2005-price/latest")

#Package info
print(datapackage)

#Open actual data in RStudio Viewer
View(datapackage$data$"cpi-of-new-single-family-houses-sold-based-on-2005-price-csv")
View(datapackage$data$"cpi-of-new-single-family-houses-sold-based-on-2005-price_zip")

Tested with Python 3.5.2

To generate Pandas data frames based on JSON Table Schema descriptors we have to install jsontableschema-pandas plugin. To load resources from a data package as Pandas data frames use datapackage.push_datapackage function. Storage works as a container for Pandas data frames.

In order to work with Data Packages in Pandas you need to install our packages:

$ pip install datapackage
$ pip install jsontableschema-pandas

To get Data Package run following code:

import datapackage

data_url = "https://pkgstore.datahub.io/JohnSnowLabs/cpi-of-new-single-family-houses-sold-based-on-2005-price/latest/datapackage.json"

# to load Data Package into storage
storage = datapackage.push_datapackage(data_url, 'pandas')

# to see datasets in this package
storage.buckets

# you can access datasets inside storage, e.g. the first one:
storage[storage.buckets[0]]

In order to work with Data Packages in Python you need to install our packages:

$ pip install datapackage

To get Data Package into your Python environment, run following code:

import datapackage

dp = datapackage.DataPackage('https://pkgstore.datahub.io/JohnSnowLabs/cpi-of-new-single-family-houses-sold-based-on-2005-price/latest/datapackage.json')

# see metadata
print(dp.descriptor)

# get list of csv files
csvList = [dp.resources[x].descriptor['name'] for x in range(0,len(dp.resources))]
print(csvList) # ["resource name", ...]

# access csv file by the index starting 0
print(dp.resources[0].data)

To use this dataset in JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use code snippet below:

  const {Dataset} = require('data.js')

  const path = 'https://pkgstore.datahub.io/JohnSnowLabs/cpi-of-new-single-family-houses-sold-based-on-2005-price/latest/datapackage.json'

  const dataset = Dataset.load(path)

  // get a data file in this dataset
  const file = dataset.resources[0]
  const data = file.stream()

In order to work with Data Packages in SQL you need to install our packages:

$ pip install datapackage
$ pip install jsontableschema-sql
$ pip install sqlalchemy

To import Data Package to your SQLite Database, run following code:

import datapackage
from sqlalchemy import create_engine

data_url = 'https://pkgstore.datahub.io/JohnSnowLabs/cpi-of-new-single-family-houses-sold-based-on-2005-price/latest/datapackage.json'
engine = create_engine('sqlite:///:memory:')

# to load Data Package into storage
storage = datapackage.push_datapackage(data_url, 'sql', engine=engine)

# to see datasets in this package
storage.buckets

# to execute sql command (assuming data is in "data" folder, name of resource is data and file name is data.csv)
storage._Storage__connection.execute('select * from data__data___data limit 1;').fetchall()

# description of the table columns
storage.describe('data__data___data')
Datapackage.json