Append to dataframe with for loop

Append to dataframe with for loop - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Append to dataframe with for loop (/thread-3146.html)

Append to dataframe with for loop - nocoffeenoworkee - May-01-2017

I'm trying to loop through a list(y) and output by appending a row for each item to a dataframe.

y=[datetime.datetime(2017, 3, 29), datetime.datetime(2017, 3, 30), datetime.datetime(2017, 3, 31)]

Desired Output:

Output:Index                 Mean             Last
2017-03-29        1.5              .76
2017-03-30        2.3               .4
2017-03-31        1.2               1

Here is the first and last part of the code I currently have:

df5=pd.DataFrame(columns=['Mean','Last'],index=index)
for item0 in y:
.........
.........
    df=df.rename(columns = {0:'Mean'})
    df4=pd.concat([df, df3], axis=1)
    print (df4)
    df5.append(df4)
    print (df5)

My code only puts one row into the dataframe like as opposed to a row for each item in y:

Index Mean Last
2017-03-29 1.5 .76