if str-dtype, convert. Date triggers value change in another column

Question

Trying to figure out what I'm doing wrong, new to python and not sure how to solve my AssertionError. If the date in column "sa_death_date" is less than or =to 2020, column "Final Abstraction? Change to 2 if yes." needs to be changed to 2, is greater than 2021, should be 0

Thoughts?

import pandas as pd

import datetime

df=pd.read_csv("C:\\Users\\nm236211\\Desktop\OctoberConsented.DI.REDCap_API.csv")

df.dropna(subset = ["sa_death_date"], inplace=True)
 
df["sa_death_date"] = pd.to_datetime(df['sa_death_date'])

df.sa_death_date.apply(str)

df.loc[df["sa_death_date"]<= pd.to_datetime(2020,1,1),"Final Abstraction? Change to 2 if yes."] = 2
df.loc[df["sa_death_date"]>= pd.to_datetime(2020,12,31),"Final Abstraction? Change to 2 if yes."] = 0 

print(df)

Next time please provide sample data in a [reproducible way](https://stackoverflow.com/questions/20109391). Otherwise people won't be able to test. — Bill Huang, Apr 07 '21 at 05:59

score 0 · Accepted Answer · answered Apr 07 '21 at 06:01

0

Change the two places of pd.to_datetime(y,m,d) to

pd.datetime(y,m,d)

which is the correct datetime object constructor.

answered Apr 07 '21 at 06:01

Bill Huang

4,491
2
13
31

Worked like a charm! Thank you so much – Tara R Apr 07 '21 at 19:56

if str-dtype, convert. Date triggers value change in another column

1 Answers1