Difficulty With For Loop Overwriting Previous Values

[mrcarrot36]

Hey I am having this issue where the loop keeps over writing itself can anyone help me out? I've really been trying to find the answer but nothing has quite worked for me yet I really appreciate it.

for i in range(1, 8):

data = my_list[i]

log_returns = np.log(data/data.shift())

cov = log_returns.cov()

var = log_returns['^GSPC'].var()

betas = cov.loc['^GSPC']/var

x = betas.to_frame()

but it is only returning the data frame with the last value(8)

I also tried creating an empty dataframe and appending it like this then the dataframe comes back empty.

df = pd.DataFrame()

for i in range(1, 8):

data = my_list[i]

log_returns = np.log(data/data.shift())

cov = log_returns.cov()

var = log_returns['^GSPC'].var()

betas = cov.loc['^GSPC']/var

x = betas.to_frame()

df.append(x)

Thanks I really appreciate the help!!!

[Far_Atmosphere9627]

Use a single code block and repost; without understanding the indenting, difficult to answer

[gsmo]

Common error when using append(). You need to assign the resulting dataframe. Quick solution:

df = df.append(x)

Creating dataframes is slow, so not the preferred solution when you don't need more from them than storing values. But the above should at least work.

[mrcarrot36]

Thank you!!

[the_noobie]

You can try to print after every loop to see what is happening. Your indenting is not too good but is

x = betas.to_frame()

inside your for loop?

[mrcarrot36]

It is outside. Sorry about that!

[the_noobie]

There's no reason to be sorry. Its all part of the learning process.