0

I have a dataframe df1

id    country       product_name
1     USA           product1
2     USA           product2
3     USA           product3
4     Mexico        product1
5     Mexico        product2
6     Canada        product1

How can I split the above df1 into multiple based on the country name?

Desired result

sub_df1

id    country     product_name
1     USA           product1
2     USA           product2
3     USA           product3

sub_df2

id    country     product_name
1     Mexico        product1
2     Mexico        product2

sub_df3

id    country     product_name
6     Canada        product1

How can I get these sub_dfs dynamically based on the country name?

0 Answers0