Make two different dataframes using parent dataframe

Question

I want to split one dataframe into two different data frames based on one of the columns value

Eg: df(parents dataframe)

df has a column MODE with values swiggy , zomato

df1 with all the columns which has common with MODE = swiggy

df2 with all the columns which has common with MODE= Zomato

I know its simple, I am beginner, Please help. Thanks.

pelelter · Accepted Answer · 2021-05-28 16:18:43Z

1

df1 = df[df['MODE'] == 'swiggy'] and df2 = df[df['MODE'] == 'Zomato'].

This way, you will be filtering the dataframe based on the MODE column and assigning the resulting dataframe to new variables.

answered May 28, 2021 at 16:18

pelelter

6856 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1