tushariyer tushariyer - 2 months ago 11
Python Question

split pandas dataframe into two based on day of the week

I have a data frame that looks like the image below:


the data frame is called


How do I split it so that I end up with a
which contains all the data that occurs on Saturday and Sundar, and
which contains all the data from Monday to Friday?

I originally tried using the solution found at Pandas - Split dataframe into multiple dataframes based on dates?

But I ran into a

Answer Source

Let's use boolean indexing:

mask = df_original['day'].isin(['Saturday','Sunday'])

df_weekend = df_original[mask]
df_weekday = df_original[~mask]