Error message trying to change string to year

Question

I'm trying to combine three fields to make a date, the year is currently string: code to change string to datetime:

f2[:,'frt_eli_year'] = pd.to_datetime(f2['frt_eli_year'].astype(str), format='%Y',errors='coerce',utc=True)

error message:

TypeError: unhashable type: 'slice'

Then code to join year, month, date:

f2[:,'test'] = pd.to_datetime(f2['frt_eli_year'].dt.year,f2['frt_eli_year'].dt.month,f2['frt_eli_year'].dt.day)

Appreciate the help, thanks!

score 0 · Accepted Answer · answered Jun 02 '20 at 15:20

0

The mistake is in f2[:,'frt_eli_year']. Check this this answer. Basically it'll work if you change to f2.loc[:,'frt_eli_year'], or or since you want all rows, just f2['frt_eli_year'].

In total:

f2['frt_eli_year'] = pd.to_datetime(f2['frt_eli_year'], 
                                    format='%Y', errors='coerce', utc=True)

answered Jun 02 '20 at 15:20

Bertil Johannes Ipsen

1,656
1
14
27

THank you missed loc wasnt in code: now trying to cobine 3 fields and get: – mccambe Jun 02 '20 at 15:29
AttributeError: Can only use .dt accessor with datetimelike values – mccambe Jun 02 '20 at 15:29
f2.loc[:'test'] = pd.to_datetime(f2['first_elig_year'].dt.year,f2['pol_eff_date_mth'].dt.month,f2['pol_eff_date_day'].dt.day) – mccambe Jun 02 '20 at 15:30
f2.loc[:,'pol_eff_date_mth'] = f2['pol_eff_date'].dt.month f2.loc[:,'pol_eff_date_day'] = f2['pol_eff_date'].dt.day – mccambe Jun 02 '20 at 15:31
Since this is another issue, you should ask it in a new question. – Bertil Johannes Ipsen Jun 02 '20 at 16:42

Error message trying to change string to year

1 Answers1