[Python] python definition that use try and except loop to create a column using the apply...

def date_difference(dataframe):
dataframe['Permit Creation Date'] = dataframe['Permit Creation Date'].astype(str)
dataframe['Issued Date'] = dataframe['Issued Date'].astype(str)
dataframe['Issued Date'] = dataframe['Issued Date'].fillna(0)
dataframe['Permit Creation Date'] = dataframe['Permit Creation Date'].fillna(0)
for x, y in zip(dataframe['Issued Date'], dataframe['Permit Creation Date']):
try:
d1 = datetime.datetime.strptime(x, "%Y-%m-%d")
d2 = datetime.datetime.strptime(y, "%Y-%m-%d")
print (abs(d1-d2).days)
except Exception as e:
#pass
#print(e.args)
pass
print(e.args)


for the above code I get a

TypeError: Must provide 'func' or tuples of (column, aggfunc)
​

or a for and else loop:

def date_difference(dataframe):
dataframe['Permit Creation Date'] = dataframe['Permit Creation Date'].astype(str)
dataframe['Issued Date'] = dataframe['Issued Date'].astype(str)
dataframe['Issued Date'] = dataframe['Issued Date'].fillna(0)
dataframe['Permit Creation Date'] = dataframe['Permit Creation Date'].fillna(0)
for x, y in zip(dataframe['Issued Date'], dataframe['Permit Creation Date']):
d1 = datetime.datetime.strptime(x, "%Y-%m-%d")
d2 = datetime.datetime.strptime(y, "%Y-%m-%d")
return abs(d1-d2).days
else:
#pass
#print(e.args)
pass

Continue reading...