Convert SQL timestamp point to datetime with python

Question

I am trying to convert a created at timestamp made in SQL to a datetime object, or therabouts, with python.

this is the dataset

<bound method NDFrame.to_clipboard of                id                       user_id  sentiment  magnitude
created                                                              
1601820360     10  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -0.1        0.1
1601820365     11  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -0.8        0.8
1601900938     12  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -0.2        0.2
1601900956     13  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -0.2        0.2
1601900971     14  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2        0.2        0.2
...           ...                           ...        ...        ...
1618553420  45024  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -1.0        1.0
1618553422  45025  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -1.0        1.0
1618553430  45026  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -1.0        1.0
1618553432  45027  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -1.0        1.0
1618883226  46022  cPL1Fg7BqRXvSFKeU1mJT7KCCTq2       -1.0        1.0

[10506 rows x 4 columns]>

With created being the timestamp in question.

Any idea on best approaches? Having a look through the python documentation i'm a bit lost. Thanks!

can you show the output of "df.head()" where df is your dataset — Shubham Periwal
– Shubham Periwal, Commented Apr 25, 2021 at 9:25
That's what I've pated above. So the index is created, then it's id, then userId, then sentiment and magnitude — LeCoda
– LeCoda, Commented Apr 25, 2021 at 9:27

Utsav · Accepted Answer · 2021-04-25 09:28:11Z

1

You might need to use unit as second.

pd.to_datetime(df.created, unit='s')

Sample from your dataset:

Input:

    created     id
0   1601820360  10
1   1601820365  11

Output

     created    id
0   2020-10-04 14:06:00 10
1   2020-10-04 14:06:05 11

answered Apr 25, 2021 at 9:28

Utsav

6,0932 gold badges36 silver badges58 bronze badges

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

3 Comments

LeCoda Over a year ago

Hmm. When i try to do the same thing it doesn't work. how odd.

LeCoda Over a year ago

OH. I had to type pd., not my dataframe. That worked! Thanks!

Utsav Over a year ago

Great, enjoy coding!

Collectives™ on Stack Overflow

Convert SQL timestamp point to datetime with python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related