excel column type Date format problems in pandas dataframe

Question

when i read an excel file in pandas dataframe i got this strange format date i want to get rid of the zeros

''' dataframes.append(pd.read_excel(full_excel_path,sheet_name=sheet_name,engine='openpyxl',header=header,usecols=usecols,nrows=nrows,dtype=str))

for object in json_meta_data:

    header = object['excel_header'] - 1
    excel_filename = object['excel_filename']
    sheet_name = object['excel_sheet_name']
    usecols = object['excel_usecols']
    nrows = object['excel_nrows']

'''

If you like an answer please check it and upvote it. If the answer does not work please provide more details of what your problem is. — Shane S
– Shane S, Commented Sep 9, 2021 at 2:15

Shane S · Accepted Answer · 2021-09-07 20:29:18Z

1

You need to change the dtype. Pandas has a to_datetime that is good for this. example df['time'] = pd.to_datetime(df['time']).dt.date

For your column you might use df['date_arrete'] = pd.to_datetime(df['date_arrete']).dt.date

answered Sep 7, 2021 at 20:29

Shane S

2,3633 gold badges25 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

excel column type Date format problems in pandas dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related