TypeError on Pandas DataFrame

Asked Dec 26 '20 at 19:10

Active Dec 26 '20 at 19:10

Viewed 100 times

I have an error trying to convert integer numbers to DateTime format on a CSV file using Pandas. The code I'm using is:

import pandas as pd
from datetime import datetime,timedelta

data=pd.read_csv("Dataset.csv",low_memory=False)
data.Date = data.Date.apply(lambda x:datetime.strptime(x, '%Y-%m-%d'))

The DataFrame is:

The error is:

TypeError: strptime() argument 1 must be str, not int

Does anyone know what is wrong here?

Thank you!!

asked Dec 26 '20 at 19:10

Oswaldo Reátegui García

maybe try data.Date = data.Date.astype(str) before you execute the lambda function? – BoomBoxBoy Dec 26 '20 at 19:15
Hi @ba123nas, not working. I have this error: ValueError: time data '42737' does not match format '%Y-%m-%d' – Oswaldo Reátegui García Dec 26 '20 at 19:20
First of all, `'DataFrame' object has no attribute 'Date'` error should raise. – Barbaros Özhan Dec 26 '20 at 19:23
1

What is the int represent? Is it days after some date? Is it microseconds after 1970? – Paul Brennan Dec 26 '20 at 19:23
that looks like Excel dates - which seems to be days from some epoch. https://stackoverflow.com/questions/38454403/convert-excel-style-date-with-pandas – Asish M. Dec 26 '20 at 19:28
@AsishM. Thank you!! That's the answer! It was an epoch, now it is converted! Thanks for you help! – Oswaldo Reátegui García Dec 26 '20 at 19:35
Does this answer your question? [Convert Excel style date with pandas](https://stackoverflow.com/questions/38454403/convert-excel-style-date-with-pandas) – FObersteiner Dec 26 '20 at 20:08

TypeError on Pandas DataFrame

0 Answers0