I have a file that contains DateTime in float format
example 14052020175648.000000 I want to convert this into 14-05-2020 and leave the timestamp value.
input ==> 14052020175648.000000
expected output ==> 14-05-2020
Asked
Active
Viewed 266 times
1
Tamil Selvan
- 1,600
- 1
- 9
- 25
qaiser
- 2,770
- 2
- 17
- 29
-
1did you read this: https://stackoverflow.com/questions/6706231/fetching-datetime-from-float-in-python ? – writer_chris Dec 14 '21 at 10:23
-
1It's not a timestamp 14052020175648.000000 -> 14/05/2020 17:56:48.000 – Corralien Dec 14 '21 at 10:25
2 Answers
2
Use pd.to_datetime:
df = pd.DataFrame({'Timestamp': ['14052020175648.000000']})
df['Date'] = pd.to_datetime(df['Timestamp'].astype(str).str[:8], format='%d%m%Y')
print(df)
# Output:
Timestamp Date
0 14052020175648.000000 2020-05-14
I used astype(str) in case where Timestamp is a float number and not a string, so it's not mandatory if your column already contains strings.
Corralien
- 109,409
- 8
- 28
- 52
1
This can solve your problem
from datetime import datetime
string = "14052020175648.000000"
yourDate = datetime.strptime(string[:8], '%d%m%Y').strftime("%d-%m-%Y")
print(yourDate)
Output:
14-05-2020
Tamil Selvan
- 1,600
- 1
- 9
- 25