Convert dataframe date row to a weekend / not weekend value

Question

I have a dataframe with a DATE row and I need to convert it to a row of value 1 if the date is a weekend day and 0 if it is not.

So far, I converted the data to weekdays

df['WEEKDAY'] = pandas.to_datetime(df['DATE']).dt.dayofweek

It's there a way to create this "WEEKEND" row without functions?

Thanks!

Answer 1

One more way of getting weekend indicator is by where function:

df['WEEKDAY'] = np.where((df['DATE']).dt.dayofweek) < 5,0,1)