pandas dataframe Shape of passed values is (1, 4), indices imply (4, 4)

pandas dataframe shape
saias picture saias · Jun 15, 2018 · Viewed 14.9k times · Source

I am trying to create a pandas dataframe with one row using and ended up testing the following simple line of code:

df = pd.DataFrame([1,2,3,4], columns=['a', 'b', 'v', 'w'])

Although this seems very simple i get the following error

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

I have seen a few answers on this issues but all provide a way around it that doesn't explain why this happens and does not apply in my case.

Thanks is advance.

Answer

nimrodz picture nimrodz · Jun 15, 2018

you need to change the list of values to [[1,2,3,4]] 

df = pd.DataFrame([[1,2,3,4]], columns=['a', 'b', 'v', 'w'])

Related questions

How to select rows from a DataFrame based on column values

How can I select rows from a DataFrame based on values in some column in Pandas? In SQL, I would use: SELECT * FROM table WHERE colume_name = some_value I tried to look at Pandas' documentation, but I did not …

Read More
Renaming columns in pandas

I have a DataFrame using pandas and column labels that I need to edit to replace the original column labels. I'd like to change the column names in a DataFrame A where the original column names are: ['$a', '$…

Read More
How to iterate over rows in a DataFrame in Pandas

I have a DataFrame from Pandas: import pandas as pd inp = [{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}] df = pd.DataFrame(inp) print df Output: c1 c2 0 10 100 1 11 110 2 12 120 Now I want to iterate over the rows …

Read More