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?

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

Collectives™ on Stack Overflow

I'm unable to plot csv data using python

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest