Loop to split dataframe base on unique value of 2 columns individually

Asked Mar 20 '19 at 18:07

Active Mar 20 '19 at 18:28

Viewed 55 times

I have a large single dataframe that looks similar to this

How do i do a loop through this large dataframe to split it into multiple smaller dataframe base on the unique value of both column 'RESV' and column 'TYPE'.

So you would have 12 (3x4) smaller dataframes (with 3 unique values in column 'RESV' and 4 unique values in column 'TYPE'. For example. some of these dataframes would look like as follows:-

And how to name those dataframes individually?

edited Mar 20 '19 at 18:28

asked Mar 20 '19 at 18:07

ooikiam

2

Check with groupby – BENY Mar 20 '19 at 18:08
How many unique values do you have for each? – Mohit Motwani Mar 20 '19 at 18:09
3 unique values in column 'RESV' and 4 unique values in column 'TYPE' – ooikiam Mar 20 '19 at 18:13

Loop to split dataframe base on unique value of 2 columns individually

0 Answers0