I'm unable to plot csv data using python

Question

I have created a csv data like:csv image link to csv data: https://1drv.ms/x/s!AiBcPojQRu1SgRw-uiiRIQ0LhXYi?e=uEU9d5

and when I print the csv data it shows like this : printed using pandas code I used

and when I plot the data using matplotlib it shows: error on plotting can anyone help me with this?

I'm a little confused as to why you call that CSV; in my browser it looks like a spreadsheet, and when I go to "save as" and choose "download a copy", the server tries to send me an .xlsx file? — SamB
– SamB, Commented Sep 12, 2022 at 16:51
Also, you should add the code as text into the body of your question; the {} icon can be used to format it as code. — SamB
– SamB, Commented Sep 12, 2022 at 16:54
yah I convert the xlsx to csv using a online converter. Ill use the '{}' next time onwards. — Abhay
– Abhay, Commented Sep 15, 2022 at 18:17

Shah · Accepted Answer · 2022-09-11 14:02:07Z

1

First Read csv file with header and here are also sub header so need both headers and delete unwanted unmamed which create onself instead of blank space. and then possible to plotting.

import pandas as pd
import matplotlib.pyplot as plt

#read csv file
covid  = pd.read_csv('D:/kerala.csv',header=[1,2],index_col=[0])
print(covid)

#use Header and Subheader
a = covid.columns.get_level_values(0).to_series()
b = a.mask(a.str.startswith('Unnamed')).ffill().fillna('')
covid.columns = [b, covid.columns.get_level_values(1)]
print (covid)

#plotting
covid.plot()
plt.show()

HOPE IT HELP YOU

edited Sep 11, 2022 at 14:02

answered Sep 10, 2022 at 15:21

Shah

1301 silver badge9 bronze badges

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

2 Comments

Abhay Over a year ago

It did worked but is it possible to the output like this?: prnt.sc/SPyJr_t9V4Xd

Shah Over a year ago

covid = pd.read_csv('D:/kerala.csv',header=[1,2],index_col=[0]),,,,Just use this statement instead of previous it will work garph with district name.

Collectives™ on Stack Overflow

I'm unable to plot csv data using python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related