Plotting a histogram with numeric and str data?

I have some data that looks like this:

df1 = df[['Borough','Initial_Cost']]
counts = print(df1['Borough'].value_counts(dropna=False))
print(counts)


MANHATTAN 6310
BROOKLYN 2866
QUEENS 2121
BRONX 974
STATEN ISLAND 575
Name: Borough, dtype: int64


The concept seems pretty straightforward, but I keep getting an empty histogram (the data seems fine but the plot is completely blank). I am trying to make a histogram that looks something like this.

The data set was fetched from here.

https://github.com/johnashu/datacamp/blob/master/dob_job_application_filings_subset.csv

matplotlib

count

2 Answers
2

An option is this:

df['Borough'].value_counts(dropna=False).plot(kind='bar')


Example with few datas:

df = pd.DataFrame( 'Borough':['MANHATTAN','BROOKLYN','BROOKLYN','QUEENS','QUEENS','BROOKLYN','MANHATTAN','MANHATTAN','MANHATTAN'])
df['Borough'].value_counts(dropna=False).plot(kind='bar')
plt.show()


You could use plt.bar to plot your data:

plt.bar

data = 'MANHATTAN' : 6310,
'BROOKLYN' : 2866,
'QUEENS' : 2121,
'BRONX' : 974,
'STATEN ISLAND': 575
names = list(data.keys())
values = list(data.values())
plt.bar(names, values)
plt.show()


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.