Pandas DataFrame with row list and column list

Question

I must be missing something, but I cannot find any guides on how to construct a pandas dataframe using both list of rows and columns. The purpose is that the row_list and col_list are updated in a loop and can hold more or less strings, but will always equal each other in length.

Using transpose works on the rows, but I'm not sure how to pass the columns in.

row_list = ['a', 'b', 'c', 'd']
col_list = ['A', 'B', 'C', 'D']
df = pd.DataFrame(row_list, columns=col_list)
>>>
raise ValueError(f"Shape of passed values is {passed}, indices imply {implied}")
ValueError: Shape of passed values is (4, 1), indices imply (4, 4)

df = pd.DataFrame(row_list).T
>>>
0 1 2 3
a b c d

Expected Output:

A B C D
a b c d

mozway · Accepted Answer · 2023-04-06 16:26:54Z

1

Wrap row_list in a list:

row_list = ['a', 'b', 'c', 'd']
col_list = ['A', 'B', 'C', 'D']
df = pd.DataFrame([row_list], columns=col_list)

# or
df = pd.DataFrame([dict(zip(col_list, row_list))])

Although not recommended, the solution with the transpose would have been:

df = pd.DataFrame(row_list, index=col_list).T

Output:

   A  B  C  D
0  a  b  c  d

answered Apr 6, 2023 at 16:26

mozway

267k13 gold badges56 silver badges106 bronze badges

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

2 Comments

Binx Over a year ago

Why would you not recommend the transpose solution? Is it cumbersome with larger datasets?

mozway Over a year ago

It's less efficient and will mess up the dtypes if you have mixed dtypes (not in this case as your input is 1D).

Collectives™ on Stack Overflow

Pandas DataFrame with row list and column list

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related