Plotting multiple columns in a pandas line graph [duplicate]

Question

I am trying to plot a multiple columns in a line graph with 'Month' as the X axis and each 'Count' as a new line. I want it to have 5 lines, 'Count-18..Count-14'. I tried plotting 1 line as a test but when I run the following code I get the following output with no graph. Any ideas?

ax = plt.gca()

DomReg1418.plot(kind='line',x='Month',y='Count-18',ax=ax)

Valdi_Bo · Accepted Answer · 2019-11-22 18:19:00Z

11

When you have a DataFrame with one column to be used as X axis and other as a source of lines to draw, you should:

set the index to the "X" column (in your case Month),
run plot,
terminate the command with a semicolon, to block a text message concerning the picture object.

The code to do it is:

DomReg1418.set_index('Month').plot();

For the test, I entered X and 3 Count columns, for first 6 months and executed the above command, getting the following result:

answered Nov 22, 2019 at 18:19

Valdi_Bo

31.1k4 gold badges29 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Plotting multiple columns in a pandas line graph [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related