How to convert or format date data?

Question

I have such a date format.

2013-12-11 00:00:00

Firstly, I would like to ask that although my excel file doesnt have any time information, when I import my excel file into dataframe, why does it show time and date information like above? Is this a default setting? Secondly, I tried to give %Y-%m-%d %H:%M:%SZ format but it gives;

ValueError: time data 'date' does not match format '%Y-%m-%d %H:%M:%SZ' (match)

How can I format this kind of date data in order to use it? Thanks

Edit: Ignoring time data can also be very usefull for me like below;

2013-12-11

Edit2: Here is my code;

df2['group'] = df2.groupby(pd.to_datetime(df2.loc[:,0], format='%Y-%m-%d %H:%M:%SZ').dt.to_period('M')).ngroup() + 1

Edit3: Here is my dataframe

dataframe

It still gives ValueError: time data NUMUNE doesn't match format specified error when I change my codes as

df2['group'] = df2.groupby(pd.to_datetime(df2.loc[:,0], format='%Y-%m-%d %H:%M:%S').dt.to_period('M')).ngroup() + 1

I want to use only month, year and day information, as I edited the post. — gforce
– gforce, Commented Apr 8, 2022 at 8:19
Whatever you provide as directive in format has to match the input - there is no Z in your input! — FObersteiner
– FObersteiner, Commented Apr 8, 2022 at 9:04
Also, since you have nice isoformat input, pd.to_datetime(df2.loc[:,0]) would work just fine. — FObersteiner
– FObersteiner, Commented Apr 8, 2022 at 9:05

Tristan Kleyn · Accepted Answer · 2022-04-08 08:32:58Z

3

You could try using datetime instead:

from datetime import datetime

x = '2013-12-11'
datetime.strptime(x, '%Y-%m-%d')

This will create a datetime object that you can use in operations with other datetime objects.

answered Apr 8, 2022 at 8:32

Tristan Kleyn

1315 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bruno · Accepted Answer · 2022-04-08 09:04:31Z

2

May I ask how you are saving or generating the excel file? I'm guessing that the date string in the excel file is coming from the way you are generating it.

format the date string as follows, including the time (as in you excel sheet)

from datetime import datetime

date_str = '2013-12-11 00:00:00'
date_obj = datetime.strptime(date_str, '%Y-%m-%d %H:%M:%S')
print(date_obj)

this converts the string to datetime object (that is "date_obj") that you can use in your code

edited Apr 8, 2022 at 9:04

answered Apr 8, 2022 at 8:58

Bruno

7051 gold badge10 silver badges19 bronze badges

1 Comment

gforce Over a year ago

I edited my question with your feedback, can you check?

Collectives™ on Stack Overflow

How to convert or format date data?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related