Plot line plot using rows of dataframe and include specific columns by position/number in python pandas

Question

df

SKU   A    B  Jan_Sales  Feb_Sales  Mar_sales Apr_sales  Dec_sales..
 A    AC   BA      122        100        50        200         300
 B    BC   BB      100        50         80        90          250
 C    CC   BC       40        30        100        10          11

and so on

Now I want a graph which will plot Jan sales, feb sales and so on till dec in one line for SKU A, Similarly one line on the same graph for SKU B and same way for SKU C. I want to drop columns A and B. I know how to do that using column name, but how can i do that using column number/position

df.set_index("SKU").drop(['A','B']).T.plot()

How to drop A and B using their position 1 and 2 in this case

Does this answer your question? How to get column by number in Pandas? — Mykola Zotko
– Mykola Zotko, Commented Jan 30, 2020 at 9:40

jezrael · Accepted Answer · 2020-01-30 09:37:18Z

1

Add DataFrame.iloc for remove first and second columns, here A and B:

df.set_index("SKU").iloc[:, 2:].T.plot()

answered Jan 30, 2020 at 9:37

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Plot line plot using rows of dataframe and include specific columns by position/number in python pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related