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?