Fill empty pandas dataframe with data from list

Question

I want to fill an empty dataframe using a list.

Here is the empty dataframe.

old_dates= pd.date_range((today -dt.timedelta(days=2)), (today-dt.timedelta(days=1))).strftime("%d %b")
columns=old_dates
df_verif=pd.DataFrame(columns=columns)
df_verif


24 Jun  25 Jun

All of the column names are dates (and will be longer through time). I then want to fill only the first row with one value for each day. Let's say I have a list that contains two values. How would I then add those values, in the order that they appear in the list, under the corresponding date?

test=[2.5,2.5]

Expected output:

0   24 Jun  25 Jun
1   2.5     2.5

Tim J · Accepted Answer · 2020-06-26 12:50:06Z

2

If I'm not mistaken, it should be:

df_verif.loc[0] = test

This adds the elements of test to the row at index 0 in the order in which they are in test.

edited Jun 26, 2020 at 12:50

answered Jun 26, 2020 at 12:48

Tim J

5452 silver badges18 bronze badges

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

Comments

Alexey · Accepted Answer · 2020-06-26 13:18:48Z

0

if you want to add test = [2.5, 2.5] at the end of DataFrame (without explicitly set the row number):

df_verif = df_verif.append({k:v for k,v in zip(columns,test)},  ignore_index=True )

df_verif

Out[1]:

    24 Jun  25 Jun
0   2.5     2.5

edited Jun 26, 2020 at 13:18

answered Jun 26, 2020 at 13:13

Alexey

1,1268 silver badges8 bronze badges

Collectives™ on Stack Overflow

Fill empty pandas dataframe with data from list

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related