Plot column from dataframe with dates in x axis

Question

I have a dataframe with multiple attributes. I have a column amount and a column date which is of format (dd/mm/yyyy hh/mm/ss) or (dd/mm/yyyy). I would like to have the amount on axis y and the date on axis x.

My code here does not raise any errors but the plot is not what I am looking for as it seems that the date is not handled :

import pandas as pd
import matplotlib.pyplot as pplt 
    newAcc['EuroAmount']=newAcc['EuroAmount'].apply(pd.to_numeric)
    newAcc['EuroAmount'].plot(x='AccountingDataCreation')
    pplt.show()

jezrael · Accepted Answer · 2017-02-24 06:26:32Z

1

I think you need Series.plot:

newAcc.set_index('AccountingDataCreation')['EuroAmount'].plot()

Or DataFrame.plot:

newAcc.plot(x='AccountingDataCreation', y='EuroAmount')

answered Feb 24, 2017 at 6:26

jezrael

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

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

7 Comments

Mayeul sgc Over a year ago

It is weird, it is working I think but my AccountingDataCreation is ordered and my x axis is not ordered, I have 08/02 then 07/02 then 08/02 again

jezrael Over a year ago

Try convert to datetime by newAcc['AccountingDataCreation'] = pd.to_datetime(newAcc['AccountingDataCreation']) first

Mayeul sgc Over a year ago

ok i'll try, I also found I had a date in another format that might be confusing the algorithm i am changing that

jezrael Over a year ago

I see you have first days, so newAcc['AccountingDataCreation'] = pd.to_datetime(newAcc['AccountingDataCreation'], dayfirst=True) ?

Mayeul sgc Over a year ago

I finally finished formatting my string to the same format, I tried to apply the to_datetime() and i got a Keyerror :AccountingDataCreation. Is it because i am tryng to setindex() with a date ?

|

Collectives™ on Stack Overflow

Plot column from dataframe with dates in x axis

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related