'ValueError: If using all scalar values, you must pass an index' when creating dataframe

Question

I've been learning Python recently, and was working with Pandas when this error came up:

import pandas 

students = {"Adi": 32, "Ron" : 64, "Jonny": 34} 

student_dataframe = pandas.DataFrame(students) # <--- error

print(student_dataframe) # this will only print table

The error:

student_dataframe = pandas.DataFrame(students) 
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^

ValueError: If using all scalar values, you must pass an index' when creating dataframe

When I click on error location it takes me to source code of Pandas (I think?) and shows an error. It was working just fine a few days back... how do I fix it? Is the source code the problem or have I missed something?

Welcome to Stackoverflow! Please make sure you search on Google before you ask a question here. Here is a good StackOverflow post that already answers your question. stackoverflow.com/questions/18837262/… — Atalay K.
– Atalay K., Commented Sep 6, 2023 at 14:14
@Mark, it should actually be pandas.DataFrame(students.items()) — Atalay K.
– Atalay K., Commented Sep 6, 2023 at 14:15
🚫📸 Please post code, errors, sample data or textual output here as plain-text, not as images that can be hard to read, can’t be copy-pasted to help test code or use in answers, and are barrier to those who depend on screen readers or translation tools. You can edit your question to add the code in the body of your question. For easy formatting use the {} button to mark blocks of code, or indent with four spaces for the same effect. The contents of a screenshot can’t be searched, run as code, or easily copied and edited to create a solution. — tadman
– tadman, Commented Sep 6, 2023 at 14:27
The question's code is trying to create 3 columns named Adi, Ron and Jonny, with a single value in each. I doubt that's what you really wanted — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Sep 14, 2023 at 15:12

NLP from scratch · Accepted Answer · 2023-09-06 14:19:33Z

4

Traditionally, pandas is imported as pd, and DataFrame is a class, so you should be using parentheses, not brackets. It is also usually more standard to pass the different columns as arrays for each key in a dict, so that you have column names:

import pandas as pd

students = {"students":["Adi", "Ron", "Jonny"], "scores": [32,64,34]} 

student_df = pd.DataFrame(students)

print(student_df)

answered Sep 6, 2023 at 14:19

NLP from scratch

4062 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

'ValueError: If using all scalar values, you must pass an index' when creating dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related