for i in range(0,len(final3)):
default=final3["DefaultValue"].iloc[i]
if (not(default.contains("|"))):
if(final3["DefaultValue"].iloc[i] in final3["CodedData"].iloc[i]):
final3["Condition"].iloc[i]="False"
else:
final3["Condition"].iloc[i]="True"
"DefaultValue" column contains values like "1|2|3". So, I tried to split the string using delimiter and check if it exist in the "CodedData" column in the same row. "CodedData" contains values like "3|4" But I am facing the attribute error.
The error message states that you're trying to use .contains()
on a string which is not a string function.
Try:
for i in range(0,len(final3)):
default = final3["DefaultValue"].iloc[i]
if not "|" in default:
if default in final3["CodedData"].iloc[i]:
final3["Condition"].iloc[i] = "False"
else:
final3["Condition"].iloc[i] = "True"