Hi there,
Can someone help me to extract datetime from the following "data" field
Can someone help me to extract datetime from the following "data" field
import pandas as pd import datetime as dt df1 = pd.DataFrame(data={"fruit":['apple','pear','banana','peach'], 'id':[2,1,3,4], 'Data':['20210522113347','20210522113359','20210522113412','20210522113431']}) df1['Data1'] = pd.to_datetime((df1['Data'])).dt.strftime('%Y%M%D%H%M%S')
Output: fruit id Data Data1
0 apple 2 20210522113347 20213305/22/21113347
1 pear 1 20210522113359 20213305/22/21113359
2 banana 3 20210522113412 20213405/22/21113412
3 peach 4 20210522113431 20213405/22/21113431
Appreciate it if someone can help.