Pandas plot without specifying index

Question

Given the data:

Column1; Column2; Column3
1; 4; 6
2; 2; 6
3; 3; 8
4; 1; 1
5; 4; 2

I can plot it via:

import pandas as pd
import matplotlib.pyplot as plt

df = pd.read_csv('test0.csv',delimiter='; ', engine='python')
titles = list(df)
for title in titles:
    if title == titles[0]:
        continue
    df.plot(titles[0],title, linestyle='--', marker='o')
    plt.savefig(title+'.png')

But if, instead, data was missing Column1 like:

Column2; Column3
4; 6
2; 6
3; 8
1; 1
4; 2

How do I plot it?

May be, something like df.plot(title, linestyle='--', marker='o')?

There are lot's of ways to plot it! I need a better understanding of what you are trying to plot. — piRSquared
– piRSquared, Commented Oct 9, 2016 at 0:25
I would like to plot Column2 X index, but index is missing. — KcFnMi
– KcFnMi, Commented Oct 9, 2016 at 7:25
@KcFnMi, IIUC, you could perform reset_index to set the DF's index to the default integer index and then pass Column2 as the y arg of the plot as: df.reset_index().plot(y='Column2', linestyle='--', marker='o') — Nickil Maveli
– Nickil Maveli, Commented Oct 9, 2016 at 8:01

Steven G · Accepted Answer · 2016-10-08 21:50:09Z

2

I am not sure what you are trying to achieve but you could reset index and set it as you would like:

In[11]: df
Out[11]: 
   Column1   Column2   Column3
0        1         4         6
1        2         2         6
2        3         3         8
3        4         1         1
4        5         4         2

so if you want to plot col 2 as X axis and 3 as Y axis you could do something like:

df.set_index('Column2')['Column3'].plot()

answered Oct 8, 2016 at 21:50

Steven G

17.3k11 gold badges57 silver badges79 bronze badges

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

1 Comment

KcFnMi Over a year ago

I'll accept an answer showing how to add and index column.

Collectives™ on Stack Overflow

Pandas plot without specifying index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related