How to convert timestamp to string when using pandas

Question

I have the following code and I need the original time stamp as string (2021-02-09T12:03:40Z) in the dictionary. Please can you advise me how to do that?

import pandas as pd

def main():
        
        df1 = pd.DataFrame({'id': ['D0'],
                          'date': pd.to_datetime(pd.Series(['2021-02-09T12:03:40Z']))}
                          )
        print(df1)

        dictionary = df1.to_dict('records')
        print(dictionary)

        

if __name__ == "__main__":
        main()

Current output gives me this format, which I can not use in API method:

[{'id': 'D0', 'date': Timestamp('2021-02-09 12:03:40+0000', tz='UTC')}]

What I need is the original format 2021-02-09T12:03:40Z.

Solution:

def main():

        print(sys.version)
        
        df1 = pd.DataFrame({'id': ['D0'],
                          'date': pd.to_datetime(pd.Series(['2021-02-09T12:03:40Z']))}
                          )
        print(df1)

        df1['date']  = df1.date.dt.strftime("%Y-%m-%dT%TZ")

        dictionary = df1.to_dict('records')
        print(dictionary)

        

if __name__ == "__main__":
        main()

DeGo · Accepted Answer · 2022-05-24 06:17:56Z

2

You can use .dt.strftime for string formatting of the Timestamp

>>> df1.date.dt.strftime("%Y-%m-%dT%TZ")
0    2021-02-09T12:03:40Z
Name: date, dtype: object

answered May 24, 2022 at 6:17

DeGo

7916 silver badges15 bronze badges

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

1 Comment

Jerry Over a year ago

Its working. The VS CODE just does not recognizes the dt function and its not highlighted. Thank you.

Collectives™ on Stack Overflow

How to convert timestamp to string when using pandas

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related