Below is the first row of my csv DateTime column:
Mon Nov 02 20:37:10 GMT+00:00 2015
The DateTime column is currently an object and I want to convert it to datetime format so that I can get the date to appear as 2015-11-02 and I will create a separate column for the time.
The code I am using to convert the column to date time format is:
for item, frame in df['DateTime'].iteritems[]:
datetime.datetime.strptime[df['DateTime'], "%a-%b-%d-%H-%M-%S-%Z-%Y"]
I am getting this error:
> TypeError: must be str, not Series
Any help would be greatly appreciated!
asked Jul 12, 2016 at 16:04
2
Use pd.to_datetime[]
:
df['DateTime'] = pd.to_datetime[df['DateTime']]
For example,
pd.to_datetime['Mon Nov 02 20:37:10 GMT+00:00 2015']
produces Timestamp['2015-11-02 20:37:10']
.
answered Jul 12, 2016 at 16:08
1
Another solution is to pass errors parameter as per below and its application
df['DateTime'] = pd.to_datetime[df['DateTime'], errors='coerce']
errors{‘ignore’, ‘raise’, ‘coerce’}, default ‘raise’
- If ‘raise’, then invalid parsing will raise an exception.
- If ‘coerce’, then invalid parsing will be set as NaN.
- If ‘ignore’, then invalid parsing will return the input.
answered Sep 8 at 9:26
BabulalBabulal
3213 silver badges11 bronze badges
In this article, we will discuss how to convert a date to a datetime object in python.
We use the combine method from the datetime module to combine a date and time object to create a datetime object.
Syntax
The syntax of combine[] method is as follows.
datetime.combine[date,time]
Where,
- date is a date object.
- time is a time object.
This method returns a datetime object which is the combination of the above two objects[date,time].
Converting a date object to datetime object
If we have a date object and don't have a time object, then you initialize the time object to a minimum using the datetime object [Minimum means at midnight i.e 00:00:00].
Example
In the below example code, we combine a date object is retrieved by using the today[] method and we initialized the time object to minimum time[00:00:00] using the min.time[] method. And combined these two objects by applying the datetime.combine[] method.
from datetime import date from datetime import datetime my_date = date.today[] print["The date object:",my_date] my_time = datetime.min.time[] print["The time object:",my_time] my_datetime = datetime.combine[my_date, my_time] print["The combined datetime object:",my_datetime]
Output
The output of the above code is as follows.
The date object: 2022-05-19 The time object: 00:00:00 The combined datetime object: 2022-05-19 00:00:00
When both date and time objects are given
Here, we initialize both date and time objects. And combine these into a datetime object using the combine method.
Example
In this example, we will convert a datetime object when both date and time objects are given.
import datetime my_date = datetime.datetime[2012, 2, 12] print["The date object:",my_date] my_time = datetime.time[1, 30] print["The time object:",my_time] combined_datetime = my_date.combine[my_date, my_time] print["The combined datetime object:",combined_datetime]
Output
The output of the above code is as follows;
The date object: 2012-02-12 00:00:00 The time object: 01:30:00 The combined datetime object: 2012-02-12 01:30:00
Using the datetime[]
The datetime[] constructor in python accepts year, month and date values as parameters and create a datetime object.
Pass the year, month and day values of the desired date object [as my_date.year, my_date.month, my_date.day] to this constructor to convert a date object to datetime object.
Example
from datetime import date from datetime import datetime my_date = date.today[] my_datetime = datetime[my_date.year, my_date.month, my_date.day] print[my_datetime]
Output
2022-09-05 00:00:00
Updated on 08-Sep-2022 06:58:03
- Related Questions & Answers
- How to convert Python date string mm/dd/yyyy to datetime?
- How to convert JS date time to MySQL datetime?
- MySQL Query to convert from datetime to date?
- How to convert Python datetime to epoch with strftime?
- How to convert timestamp string to datetime object in Python?
- How to convert Python DateTime string into integer milliseconds?
- How to convert timestamp to datetime in MySQL?
- How to convert TimeStamp to DateTime in Kotlin?
- How to convert pandas offset to Python date?
- How to convert Python date to Unix timestamp?
- How to convert a Python date string to a date object?
- How to convert a JS Date to a Python date object?
- How to convert Python date in JSON format?
- How to convert MySQL datetime to Unix timestamp?
- Convert string to DateTime and vice-versa in Python