How to create a pandas dataframe with rows of python list data?

Question

I would like to initialize a pandas dataframe with column titles and one row of data. I would then like to append rows of data onto the end of this dataframe as I iterate through a file that I am reading the data from.

Here is an example of what I am doing and the issue that I am running into:

titles = ['a','b','c','d']
data = ['1','2','3','4']
df = pd.DataFrame(data, columns=titles)

ValueError: Shape of passed values is (4, 1), indices imply (4, 4)

I know that this is because the data is being inserted as one column instead of one row. How can I make sure the data is inserted as a row?

What is the best way to append additional rows of data onto the end of this dataframe?

df = pd.DataFrame([data], columns=titles)

Quang Hoang
– Quang Hoang

2020-07-20 16:48:47 +00:00
Commented Jul 20, 2020 at 16:48 — Quang Hoang
– Quang Hoang, Commented Jul 20, 2020 at 16:48

Sai · Accepted Answer · 2020-07-20 17:04:15Z

1

When you give a one-dimensional list, it takes as if there is only single column, but here you are having multiple columns, that is the reason you are getting error.

So when you have multiple columns we should input a two-dimensional list, as:

df = pd.DataFrame([data], columns = titles)

edited Jul 20, 2020 at 17:04

answered Jul 20, 2020 at 16:58

Sai

1,7001 gold badge9 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to create a pandas dataframe with rows of python list data?

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