order_neighbourhood

# Plot nr neighbourhoods for top 30 cities
neighbourhood_list = listing_total.sort("total_neighbourhood", ascending=False)
neighbourhood_list_pd = neighbourhood_list.toPandas() # convert to pandas dataframe
list_neighbourhood_30 = neighbourhood_list_pd.iloc[1:31];
num = len(list_neighbourhood_30)*4
c = [i for i in range(0,num,4)]
plt.figure(figsize=(10,4))
plt.bar(c, list_neighbourhood_30['total_neighbourhood'],width=3, align='center', alpha=0.5)

plt.xticks(c,list_neighbourhood_30['city'],rotation=90)
plt.ylabel('total neighbourhood')
plt.xlabel('city')
plt.title('The total neighbourhood in top 30 cities')
plt.show()