Create new data frame with the name from loop number

Question

I tried to create the loop in python. The code can be seen below.

df=pd.DataFrame.copy(mef_list)
form=['','_M3','_M6','_M9','_M12','_LN','_C']
for i in range(0, len(form)):
    df=pd.DataFrame.copy(mef_list)
    df['Variable_new']=df['Variable']+str(form[i])

When I run the code, the result is only from the last loop, which is variable+'_C' I think it is because the data frame (df) is always replaced when the new loop start. In order to avoid the issue, I would think that if the data frame (df) could be renamed by plus the number of loop, the problem would be solved.

I used str function and hope to get df0, df1, ...,df6 but it doesn't work with the data frame name. Please suggest me how to change the name of data frame by add number of loop and also I still open for any alternative way.

Thanks!

Please don't post codes as images.

Nouman
– Nouman

2018-08-17 13:10:38 +00:00
Commented Aug 17, 2018 at 13:10 — Nouman
– Nouman, Commented Aug 17, 2018 at 13:10
@Nouman Thanks, revised

Sasiwut Chaiyadecha
– Sasiwut Chaiyadecha

2018-08-17 13:28:45 +00:00
Commented Aug 17, 2018 at 13:28 — Sasiwut Chaiyadecha
– Sasiwut Chaiyadecha, Commented Aug 17, 2018 at 13:28

TheHCA · Accepted Answer · 2018-08-17 14:16:26Z

5

This isn't a pythonic thing to do, have you thought about instead creating a list of dataframes?

df=pd.DataFrame.copy(mef_list)
form=['','_M3','_M6','_M9','_M12','_LN','_C']
list_of_df = list()
for i in range(0, len(form)):
    df=pd.DataFrame.copy(mef_list)
    df['Variable_new']=df['Variable']+str(form[i])
    list_of_df.append(df)

Then you can access 'df0' as list_of_df[0]

You also don't need to iterate through a range, you can just loop through the form list itself:

form=['','_M3','_M6','_M9','_M12','_LN','_C']
list_of_df = list()
for i in form:
    df=pd.DataFrame.copy(mef_list)
    df['Variable_new']=df['Variable']+str(i) ## You can remove str() if everything in form is already a string
    list_of_df.append(df)

edited Aug 17, 2018 at 14:16

answered Aug 17, 2018 at 14:10

TheHCA

3461 silver badge8 bronze badges

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

Comments

didadadida93 · Accepted Answer · 2018-08-17 14:06:28Z

0

mef_list = ["UR", "CPI", "CEI", "Farm", "PCI", "durable", "C_CVM"]
form = ['', '_M3', '_M6', '_M9', '_M12', '_LN', '_C']
Variable_new = []
foo = 0
for variable in form:
     Variable_new.append(mef_list[foo]+variable)
     foo += 1
print(Variable_new)

edited Aug 17, 2018 at 14:06

answered Aug 17, 2018 at 13:37

didadadida93

113 bronze badges

2 Comments

Sasiwut Chaiyadecha Over a year ago

I need in terms of data frame because there are some information that have to remain even the name are changed

didadadida93 Over a year ago

@SasiwutChaiyadecha I've modified the code, hope it help you out.

Collectives™ on Stack Overflow

Create new data frame with the name from loop number

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related