plot histogram in python using csv file as input

Question

I have a csv file which contains two columns where first column is fruit name and second column is count and I need to plot histogram using this csv as input to the code below. How do I make it possible. I just have to show first 20 entries where fruit names will be x axis and count will be y axis from entire csv file of 100 lines.

import matplotlib.pyplot as plt
import pandas as pd

data = pd.read_csv('data.csv', header = None ,quoting=2)

data.hist(bins=10)
plt.xlim([0,100])
plt.ylim([50,500])
plt.title("Data")
plt.xlabel("fruits")
plt.ylabel("Frequency")
plt.show()

I edited the above program to plot a bar chart -

import matplotlib.pyplot as plt
import pandas as pd

data = pd.read_csv('data.csv', sep=',',header=None)
data.values
print data
plt.bar(data[:,0], data[:,1], color='g')
plt.ylabel('Frequency')
plt.xlabel('Words')
plt.title('Title')

plt.show()

but this gives me an error 'Unhashable Type '. Can anyone help on this.

you want to plot barchart not histograms. You can't put categorical data as x axis on histogram. — Sarit Adhikari
– Sarit Adhikari, Commented Jun 7, 2015 at 8:59
You never actually pass your data to the plot. See the examples here: bespokeblog.wordpress.com/2011/07/11/… and here: people.duke.edu/~ccc14/pcfb/numpympl/MatplotlibBarPlots.html — abalter
– abalter, Commented Jun 7, 2015 at 9:00
Sarit makes a good point. Are you looking at counts for different types of fruit? That is a barchart. A histogram is a plot of counts against a set of enumerable values, such as number of fruit eaten per day by your sample population--so many people eat 1 piece, so many 2 pieces, so many 3 pieces, etc. — abalter
– abalter, Commented Jun 7, 2015 at 9:03

Ed Smith · Accepted Answer · 2015-06-07 19:33:00Z

6

You can use the inbuilt plot of pandas, although you need to specify the first column is index,

import matplotlib.pyplot as plt
import pandas as pd

data = pd.read_csv('data.csv', sep=',',header=None, index_col =0)

data.plot(kind='bar')
plt.ylabel('Frequency')
plt.xlabel('Words')
plt.title('Title')

plt.show()

If you need to use matplotlib, it may be easier to convert the array to a dictionary using data.to_dict() and extract the data to numpy array or something.

answered Jun 7, 2015 at 19:33

Ed Smith

13.3k2 gold badges48 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

plot histogram in python using csv file as input

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related