How to create an array of pandas dataframe in loop

Question

Here is my code. In which CROPS & CITY are lists contains names of crops and cities in the dataframe named df. I want to divide my single dataframe 'df' into multiple dataframes for each crops and city value. and want to store them in dataframes array for that what I should put in place of XYZ?

for crop in CROPS:
  for city in CITY:

    XYZ = df.loc[(df['Commodity.Name'] == 'crops') & (df['City.Name'] == 'city')]

Zoro · Accepted Answer · 2021-06-14 04:28:48Z

1

Declare an empty list outside of the loop and keep on appending the filtered DataFrames to the list, like:

list_of_filtered_df = []
for crop in CROPS:
  for city in CITY:
    list_of_filtered_df.append(df.loc[(df['Commodity.Name'] == 'crops') & (df['City.Name'] == 'city')])

list_of_filtered contains the filtered DataFrames.

answered Jun 14, 2021 at 4:28

Zoro

4235 silver badges17 bronze badges

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

1 Comment

Darshil Shah Over a year ago

Yes, I used same concept of dictionary just used dictionary[crop + '_' + city] = .....

Collectives™ on Stack Overflow

How to create an array of pandas dataframe in loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related