I have a Dataframe that consists of 2 columns:
I want to perform some classification analysis on this dataset and I only care whether a user made a purchase or not. So I want to run through the "Dollars spent on the website" column and transform the value to "1" if the user spent over $0.00 and have the value be "0" if the user spent nothing.
What is the proper way to do this with a pandas dataframe?
df['purchase'] = 0
df.loc[df['dollars_spent'] > 0, 'purchase'] = 1
or
df['purchase'] = df['dollars_spent'].apply(lambda x: 1 if x > 0 else 0)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With