Chanding a dataframe values from int type to date

Question

I have the following dataframe

df = pd.DataFrame({
'date': [1988, 1988, 2000, 2005],
'value': [2100, 4568, 7896, 68909]
})

I want to make a time series based on this df. How can i change the year from int to a datetimeindex so i can plot a timeseries?

Does this answer your question? [Convert Pandas Column to DateTime](https://stackoverflow.com/questions/26763344/convert-pandas-column-to-datetime) — Pasindu Gamarachchi, Feb 20 '20 at 16:42
to convert to datetime: `df['date'] = pd.to_datetime(df['date'],format = '%Y')`. to plot `df.set_index('date')['value'].plot()` — ansev, Feb 20 '20 at 16:45

score 0 · Answer 1 · answered Feb 20 '20 at 16:46

0

df = pd.DataFrame({
'date': [1988, 1988, 2000, 2005],
'value': [2100, 4568, 7896, 68909]
}) 

date = []
for year in  df.date:
    date.append(pd.datetime(year,1,1))
df.index=date
df['value'].plot()

answered Feb 20 '20 at 16:46

Guinther Kovalski

1,629
1
7
15

for loop here is innecesary https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.to_datetime.html accept `Series` like arg – ansev Feb 20 '20 at 16:49

ansev · Accepted Answer · 2020-02-20T16:52:59.573

0

Use: pd.to_datetime to convert to datetime. DataFrame.set_index in order to get and plot the Series. You can plot it with Series.plot

(df.assign(date = pd.to_datetime(df['date'],format = '%Y'))
   .set_index('date')['value']
   .plot())

If you want keep the series use:

s = (df.assign(date = pd.to_datetime(df['date'],format = '%Y'))
       .set_index('date')['value'])

and then:

s.plot()

edited Feb 20 '20 at 16:52

answered Feb 20 '20 at 16:47

ansev

30,322
5
17
31

Chanding a dataframe values from int type to date

2 Answers2