text_html_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

price = pd.read_csv('../input/price.csv')
price_per_sqft = pd.read_csv('../input/pricepersqft.csv')

flat_price = pd.melt(price, id_vars=['City Code', 'City', 'Metro', 'County', 'State', 'Population Rank'])

flat_price.dropna(inplace=True)

flat_price.sort_values(by=['City Code', 'date']).head(10)