Ad
Make New Dataframes From Grouped Dataframe Automatically
I have this dataframe grouped
df1 = pd.DataFrame( {
"Name" : ["Alice", "Bob", "Mallory", "Mallory", "Bob" , "Mallory"] ,
"City" : ["Seattle", "Seattle", "Portland", "Seattle", "Seattle", "Portland"] } )
group = df1.groupby('City')
for city, city_df in group:
print(city)
print(city_df)
how can I get this output into new dataframes without specifying the new dfs ? like if a got 4 groups out next time, i want to get 4 dfs automatically
Portland
Name City
2 Mallory Portland
5 Mallory Portland
Seattle
Name City
0 Alice Seattle
1 Bob Seattle
3 Mallory Seattle
4 Bob Seattle
Ad
Answer
You can use the magic method __iter__()
to get a groupby iterator and convert it into a dictionary with dict()
:
dct = dict(df.groupby('City').__iter__())
If you want to get separate dataframes from the dictionary you can use the method values()
:
df1, df2 = dct.values()
Ad
source: stackoverflow.com
Related Questions
- → What are the pluses/minuses of different ways to configure GPIOs on the Beaglebone Black?
- → Django, code inside <script> tag doesn't work in a template
- → React - Django webpack config with dynamic 'output'
- → GAE Python app - Does URL matter for SEO?
- → Put a Rendered Django Template in Json along with some other items
- → session disappears when request is sent from fetch
- → Python Shopify API output formatted datetime string in django template
- → Can't turn off Javascript using Selenium
- → WebDriver click() vs JavaScript click()
- → Shopify app: adding a new shipping address via webhook
- → Shopify + Python library: how to create new shipping address
- → shopify python api: how do add new assets to published theme?
- → Access 'HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT' with Python Shopify Module
Ad