Nov-06-2021, 03:26 PM
As info so dos Pandas has Time/date functionality build in.
So no need for this import
So no need for this import
import datetime as dt
import pandas as pd df1 = pd.DataFrame( data={ "fruit": ["apple", "pear", "banana", "peach"], "id": [2, 1, 3, 4], "Data": [ "20210522113347", "20210522113359", "20210522113412", "20210522113431", ], } ) df1['Data'] = pd.to_datetime(df1['Data'])
>>> df1 fruit id Data 0 apple 2 2021-05-22 11:33:47 1 pear 1 2021-05-22 11:33:59 2 banana 3 2021-05-22 11:34:12 3 peach 4 2021-05-22 11:34:31 >>> df1.Data.dt.strftime('%m/%d/%Y') 0 05/22/2021 1 05/22/2021 2 05/22/2021 3 05/22/2021 Name: Data, dtype: object >>> #Save DataFrame with a new date format >>> df1['Data'] = df1.Data.dt.strftime('%b %d, %Y') >>> df1 fruit id Data 0 apple 2 May 22, 2021 1 pear 1 May 22, 2021 2 banana 3 May 22, 2021 3 peach 4 May 22, 2021