Appending a list or series to a pandas DataFrame as a row?

Wes Field picture Wes Field · Oct 11, 2014 · Viewed 332.9k times · Source

So I have initialized an empty pandas DataFrame and I would like to iteratively append lists (or Series) as rows in this DataFrame. What is the best way of doing this?

Answer

Mike Chirico picture Mike Chirico · Feb 19, 2016

Sometimes it's easier to do all the appending outside of pandas, then, just create the DataFrame in one shot.

>>> import pandas as pd
>>> simple_list=[['a','b']]
>>> simple_list.append(['e','f'])
>>> df=pd.DataFrame(simple_list,columns=['col1','col2'])
   col1 col2
0    a    b
1    e    f