Python Forum
Append to dataframe with for loop
Thread Rating:
  • 2 Vote(s) - 4.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Append to dataframe with for loop
#1
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Big O runtime nested for loop and append yarinsh 4 1,331 Dec-31-2022, 11:50 PM
Last Post: stevendaprano
  Using .append() with list vs dataframe Mark17 7 9,897 Jun-12-2022, 06:54 PM
Last Post: Mark17
  Increase the speed of a python loop over a pandas dataframe mcva 0 1,290 Jan-21-2022, 06:24 PM
Last Post: mcva
Question How can I merge several images via loop using the information of a dataframe? noahverner1995 1 1,396 Dec-31-2021, 05:03 AM
Last Post: noahverner1995
  For Loop Works Fine But Append For Pandas Doesn't Work knight2000 2 1,930 Dec-18-2021, 02:38 AM
Last Post: knight2000
  for loop in dataframe in pandas Paulman 7 2,673 Dec-02-2021, 12:15 AM
Last Post: bowlofred
  Add a row to a dataframe or append whole dataframe. tsurubaso 1 1,402 Jan-07-2021, 01:53 AM
Last Post: tsurubaso
  Dataframe mean calculation problem: do we have to loop? sparkt 1 2,133 Aug-28-2020, 02:41 PM
Last Post: sparkt
  Append list into list within a for loop rama27 2 2,308 Jul-21-2020, 04:49 AM
Last Post: deanhystad
  Adding loop results as rows in dataframe Shreya10o 2 2,144 May-09-2020, 11:00 AM
Last Post: Shreya10o

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020