How to convert a python list to pandas Dataframe in python

Question

I have this python list and I need to convert it into pandas dataframe.

This is how my list looks like:

thisdict = {}

thisdict["Column1"] = 1
thisdict["Column2"] = 2

thisdict # this print

{'Column1': 1, 'Column2': 2}

And I need to convert this to pandas dataframe.

I tried:

df = pd.DataFrame(thisdict)

and I got the error as below:

ValueError: If using all scalar values, you must pass an index

Can someone please help me?

How do you want your dataframe? One row two columns or two rows one column? — Scott Boston
– Scott Boston, Commented Jul 9, 2020 at 20:12
Assign 1 and 2 as lists thisdict["Column1"] = [1] and thisdict["Column2"] = [2] — Suraj
– Suraj, Commented Jul 9, 2020 at 20:13

Suraj · Accepted Answer · 2020-07-09 20:25:09Z

1

You are supposed to assign the column as lists in your code.

Try replacing lines 2 and 3 with :

thisdict["Column1"] = [1]
thisdict["Column2"] = [2]

Complete code :

thisdict = {}
thisdict["Column1"] = [1]
thisdict["Column2"] = [2]
df = pd.DataFrame(thisdict)

Output :

    Column1 Column2
0         1       2

edited Jul 9, 2020 at 20:25

answered Jul 9, 2020 at 20:15

Suraj

2,4874 gold badges28 silver badges64 bronze badges

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

2 Comments

user13456401 Over a year ago

Do you know how can set columns to that data frame as well? So the column names are Column1 and Column2

Suraj Over a year ago

The column names are what you are asking for.

rhug123 · Accepted Answer · 2020-07-09 20:19:50Z

1

If for some reason you didn't want to make your columns as lists, you could do this.

df = pd.DataFrame(pd.Series(thisdict)).transpose()

answered Jul 9, 2020 at 20:19

rhug123

8,8801 gold badge14 silver badges27 bronze badges

Comments

Scott Boston · Accepted Answer · 2020-07-09 20:25:17Z

1

If your dictionary is going to one row of a dataframe you need to pass in a list with a single element.

pd.DataFrame(thisdict, index=[0])

Output:

   Column1  Column2
0        1        2

answered Jul 9, 2020 at 20:25

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

Comments

a11 · Accepted Answer · 2020-07-09 20:29:17Z

1

It's not clear from your question what you want, but here are a couple options; I think you probably want the second option. To achieve it, make sure you use a list when you build your dictionary.

Option-1

thisdict = {}
thisdict["Column1"] = 1
thisdict["Column2"] = 2
print(thisdict)

print("Below is Option1:")
df = pd.DataFrame(list(thisdict.items()),columns = ['ColumnA','ColumnB'])
display(df)

Option-2

thisdict = {}
thisdict["Column1"] = [1]
thisdict["Column2"] = [2]
print(thisdict)

print("Below is Option2:")
df = pd.DataFrame(thisdict)
display(df)

answered Jul 9, 2020 at 20:29

a11

3,4768 gold badges42 silver badges91 bronze badges

1 Comment

user13456401 Over a year ago

This is quite helpful. I needed the second option. Thank you

Collectives™ on Stack Overflow

How to convert a python list to pandas Dataframe in python

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related