How can I insert datetime into dataframe using panda python

Question

I have csv data as below:

x    y    date    time
2    4    4/5/2017 00:22:34
5    1    4/5/2017 00:22:50
.    .    ......    ......
.    .    .....      .....
so on

I converted date and time into one single datetime column and I want to insert that datetime back again into csv file or into dataframe.

output:

x    y    datetime
2    4    4-5-2017 00:22:34

I tried this code:

import pandas as pd
df = pd.read_csv('file.csv')
datetime = pd.to_datetime(df['date'] + ' ' + df['time'])
print(datetime)

I want to insert datetime to the df in order to write it to the csv file.

MaxU - stand with Ukraine · Accepted Answer · 2017-10-07 11:29:13Z

3

Try this:

df['datetime'] = pd.to_datetime(df.pop('date') + ' ' + df.pop('time'))

or do it on the fly:

In [51]: pd.read_csv(filename, delim_whitespace=True,
                     parse_dates={'datetime':['date','time']})
Out[51]:
             datetime  x  y
0 2017-04-05 00:22:34  2  4
1 2017-04-05 00:22:50  5  1

edited Oct 7, 2017 at 11:29

answered Oct 7, 2017 at 11:23

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Collectives™ on Stack Overflow

How can I insert datetime into dataframe using panda python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related