Dynamic dataframe names creation

Question

Hi I need my dataframe with different names. The dataframe is creating insde a for loop as shown below.

for lambda_ in range(0,len(tuned_parameter)-1):
    print ('....................................',lambda_)
    i=0
    for train_index, test_index in kf.split(X):

        print("Train:", train_index, "Validation:",test_index)
        X_train, X_test = X.iloc[train_index], X.iloc[test_index]
        print ('X train ............',X_train.shape)
        print ('X_test...............',X_test.shape)
        mean_returns_Train = X_train.mean()
        cov_matrix_Train=X_train.cov()
        mean_returns_Test = X_test.mean()
        cov_matrix_Test = X_test.cov()      
        max_s, min_s = display_simulated_ef_with_random(mean_returns_Train, cov_matrix_Train, num_portfolios, risk_free_rate,returns, tuned_parameter[lambda_])
        #print (max_s.T)
        appended_data.append(max_s.T)


    appended_data = pd.concat(appended_data, axis=1)   
    print (appended_data.mean(axis=1))
    i=i+1

But I need my for loop to be like, appended_data0, appended_data1,appended_data3.....

How can I create multiple dataframes where its name ending with the related 'i' value

Possible duplicate of [How do I create a variable number of variables?](https://stackoverflow.com/questions/1373164/how-do-i-create-a-variable-number-of-variables) — roganjosh, Mar 04 '19 at 19:46
The answer is: don't do this, you want a dictionary instead. — roganjosh, Mar 04 '19 at 19:46

score 0 · Accepted Answer · answered Mar 04 '19 at 20:25

The issue worked with an adjustment like below. As suggested in the comments section, used a dictionary to store the dataframes.

whole_dataframes = {}

#k = int(np.floor(float(X.shape[0]) / number_folds))
weights = np.zeros((3,num_portfolios))
for lambda_ in range(0,len(tuned_parameter)-1):
    print ('....................................',lambda_)
    i=0
    appended_data = []


    for train_index, test_index in kf.split(X):

        print("Train:", train_index, "Validation:",test_index)
        X_train, X_test = X.iloc[train_index], X.iloc[test_index]
        print ('X train ............',X_train.shape)
        print ('X_test...............',X_test.shape)
        mean_returns_Train = X_train.mean()
        cov_matrix_Train=X_train.cov()
        mean_returns_Test = X_test.mean()
        cov_matrix_Test = X_test.cov()      
        max_s, min_s = display_simulated_ef_with_random(mean_returns_Train, cov_matrix_Train, num_portfolios, risk_free_rate,returns, tuned_parameter[lambda_])
        #print (max_s.T)
        appended_data.append(max_s.T)


    appended_data = pd.concat(appended_data, axis=1)      
    whole_dataframes['Variable{}'.format(i)]=appended_data.mean(axis=1)
    print (whole_dataframes['Variable{}'.format(i)])
    i=i+1

Dynamic dataframe names creation

1 Answers1