CODEWITHSUNDEEP
pythonpython-3.xpandasmatplotlib
Abhinav Kumar
Abhinav Kumar

Reputation: 197

Python Pandas Matplotlib : How to Plot Graph without Numerics?

I want to plot bar graph or graphs in python using a Pandas dataframe using two columns that don't contain numeric. One column is Operating System, another is computer name, I want to plot a graph between them showing which OS is running over how many Systems, the sample data is like below.

Sample Data, Two of the many rows

How can I plot bar graph or other graphs for these two colums. When I try the code below:

ax = dfdefault[['Operating System','Computer Name']].plot(kind='bar')
ax.set_xlabel("Hour", fontsize=12)
ax.set_ylabel("V", fontsize=12)
plt.show()

I get this error:

Error: 
TypeError: Empty 'DataFrame': no numeric data to plot

Upvotes: 0

Views: 1642

Answers (1)

busybear
busybear

Reputation: 10580

You will need to count the occurrence of each operating system first and then plot using a bar graph or pie chart. bar expects numeric data already, which you don't have. Counting will take care of this. Here is an example using a pie chart:

df = pd.DataFrame(
    [['asd', 'win'],
     ['sdf', 'mac'],
     ['aww', 'win'],
     ['dd',  'linux']],
    columns=['computer', 'os']
)
df['os'].value_counts().plot.pie()

enter image description here

A bar chart would work similarly. Just change pie to bar.

Upvotes: 1

Related Questions