text_plain_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)

top10 = flat_price[flat_price['variable'] == 'January 2017'].sort_values(by=['value'], ascending=False).head(10)

top10['City_State'] = top10['City'] + ' ' + top10['State']
ax = top10[['City_State', 'value']].plot(kind='bar', use_index=False)
ax.set_xticklabels(top10['City_State'])