How can i divide dataframe into multiple dataframes based on same values in columns

Question

In the above image, I colored some rows with the same colors, so I want to create new data frames with the values of the same color. as you can see, the values of the same color are the same as an example - 0.8 multiple and CE option type values rows, in this entire data frame these same values come in 2 times, so I want to create these 3 rows new data frame, and like the same i want to do for all rows.

ldmichae · Accepted Answer · 2022-04-25 16:07:32Z

2

Below is some code that may help you.

df_dictionary = dict(tuple(your_dataframe.groupby('columns_to_groupby')))

This will produce a dictionary whose keys are the grouped values (in your case, "CE, PE, etc...") and whose values are the dataframes split by the grouping specified. Hope this helps.

answered Apr 25, 2022 at 16:07

ldmichae

461 silver badge2 bronze badges

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

2 Comments

Krishna Gupta Over a year ago

Thank You. It's solved my problem.

ldmichae Over a year ago

Perfect, glad to hear that.

Collectives™ on Stack Overflow

How can i divide dataframe into multiple dataframes based on same values in columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related