Adding row to dataframe in pandas

Question

Suppose I am trying add rows to a dataframe with 40 columns. Ordinarily it would be something like this:

df = pandas.DataFrame(columns = 'row1', 'row2', ... ,'row40'))

df.loc[0] = [value1, value2, ..., value40]

(don't take the dots literally)

However let's say value1 to value10 are in list1 (i.e. list1 = [value1, value2, ..., value10]), and all the remaining values are individual elements.

I tried:

df.loc[0] = [list1, value11, value12, ..., value40]

but it doesn't work, because Python interprets the entire list as one element. So it's the wrong dimension. How can I rewrite the code to make it work?

jezrael · Accepted Answer · 2016-10-03 15:27:09Z

2

I think you need:

df.loc[0] = list1 + [value11, value12, ..., value40]

Sample:

df = pd.DataFrame(columns = ['row1', 'row2','row3', 'row4','row5', 'row6','row40'])

list1 =  ['a','b','c']
df.loc[0] = list1 + ['d','e','f', 'g']
print (df)
  row1 row2 row3 row4 row5 row6 row40
0    a    b    c    d    e    f     g

edited Oct 3, 2016 at 15:27

answered Oct 3, 2016 at 15:22

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Adding row to dataframe in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related