python TypeError datetime.datetime cannot convert the series to class int

Question

Hope you can help me. I want to check if a date is valid or not. I've read that I can do this with datetime. My code is:

import pandas as pd
import datetime as dt

df = pd.read_csv("file.csv", encoding="latin1")

dfTest = pd.DataFrame()
dfTest['year'] = df.GEBURTSTAG.dt.year
dfTest['month'] = df.GEBURTSTAG.dt.month
dfTest['day'] = df.GEBURTSTAG.dt.day

dfTest['check'] = dt.datetime(dfTest.year, dfTest.month, dfTest.day)

If I run that code the following TypeError shows up:

cannot convert the series to class 'int'

I can't find the problem.

Thx

Does this answer your question? cannot convert the series to <class 'int'`> — Joshua
thx for your answer. I've already tried that but same TypError shows up. dtype in year, month and day is int64 — Chuck

Joshua Joshua · Accepted Answer · 2020-03-25T14:25:19

Use .astype(int)

dfTest['year'] = df.GEBURTSTAG.dt.year.astype(int)
dfTest['month'] = df.GEBURTSTAG.dt.month.astype(int)
dfTest['day'] = df.GEBURTSTAG.dt.day.astype(int)

To convert numpy.int64 to int:

dfTest = (pd.DataFrame()).to_dict()

.tolist() also works.

python TypeError datetime.datetime cannot convert the series to class int

1 Answers