Convert UTC format to dd/mm/yy hh:mm:ss format in pandas?
Henrietta Shalansky
I have a column of dates in the format 2019-11-04 00:33:15 UTC that I need to format into 04/11/19 hh:mm:ss. I've tried this:
df1["date"]= pd.to_datetime(df1["date"])
But it's returned NaT in all entries. I don't know what I'm doing wrong!!
Vipulw
You can use this to easily convert the format. I hope this helps you.
date = [["2019-11-04 00:33:15"],["2019-11-14 00:43:15"],["2019-11-25 06:33:15"],["2019-11-27 09:33:15"]]
df = pd.DataFrame(date, columns = ['Date'])
df['Date'] = pd.to_datetime(df['Date']).dt.strftime('%d/%m/%Y %H:%M:%S')
print(df)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Flutter: How to reference files into main.dart?
- Next: How to run a loop for a specified amount of time
Related
TOP Ranking
- 1
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 2
Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)
- 3
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 4
pump.io port in URL
- 5
Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext
- 6
BigQuery - concatenate ignoring NULL
- 7
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 8
ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements
- 9
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 10
How to remove the extra space from right in a webview?
- 11
java.lang.NullPointerException: Cannot read the array length because "<local3>" is null
- 12
Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');
- 13
flutter: dropdown item programmatically unselect problem
- 14
How to use merge windows unallocated space into Ubuntu using GParted?
- 15
Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd
- 16
Nuget add packages gives access denied errors
- 17
Svchost high CPU from Microsoft.BingWeather app errors
- 18
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 19
12.04.3--- Dconf Editor won't show com>canonical>unity option
- 20
Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?
- 21
maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class
Comments