Draw a line chart using multiple columns data (pandas)

Question

I am trying to draw a line chart from the following data. On the x-axis, I want to show the year, on the y-axis, I want to show the population of different 'Borough'. Basically, I want to draw the population of all the boroughs throughout the years. I wrote the following code to transpose the data and draw the line graph. I am getting error- "no numeric data to plot". First figure is of the transposed data, second figure is of the original data

bar_plot = bar_plot.transpose()
bar_plot
bar_plot.columns = ['NYC Total Population', 'Bronx Population', 'Brooklyn Population'   , 'Manhattan Population',   'Queens Population',    'Staten Island Population']
bar_plot.drop('Borough')
bar_plot.plot(kind = 'line', y = ['NYC Total Population',   'Bronx Population', 'Brooklyn Population'   , 'Manhattan Population',   'Queens Population',    'Staten Island Population'])

Have a look at the seaborn library which allows you to make plots easily with pandas. see: seaborn.pydata.org/generated/seaborn.lineplot.html — Antoine Dubuis
– Antoine Dubuis, Commented Nov 20, 2020 at 8:13
Could it be that your population data are in fact type category? Could you check what gives bar_plot.dtypes ? — Ruthger Righart
– Ruthger Righart, Commented Nov 20, 2020 at 8:32
@RuthgerRighart I just checked, my datatype of all columns was an object, I changed it to int and it's working fine now — SG9
– SG9, Commented Nov 20, 2020 at 8:38

Ruthger Righart · Accepted Answer · 2020-11-20 20:35:32Z

1

There are no errors in your plot code. This error occurs if data type is category. Take care to convert and verify for numeric type using for ex.:

bar_plot = bar_plot.apply(pd.to_numeric)
bar_plot.dtypes

The following simplified code gives a lineplot:

import pandas as pd

bar_plot = pd.DataFrame({'NYC Total Population': [200, 400, 600], 'Staten Island': [30, 60, 90]}, index=[1950, 1960, 1970])

bar_plot.plot(kind = 'line', y = ['NYC Total Population', 'Staten Island'])

edited Nov 20, 2020 at 20:35

answered Nov 20, 2020 at 8:21

Ruthger Righart

4,9692 gold badges32 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Draw a line chart using multiple columns data (pandas)

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