Home / Questions / 93733
Accepted
Jorge Ponti
Asked: 2020-08-09 14:31:42 +0800 CST 2020-08-09 14:31:42 +0800 CST

Problem creating Dataframe in Pandas using Python 3.x

  • 772

I have several lists and I want to create only one Dataframe to later export.

The lists are of the type:

    a=[1, 2, 3, 4, 5, 6, 7, 8]
    b=[9, 10, 11, 12, 13, 14, 15, 16]

For this I am creating 2 dataframes as follows:

    export=pd.DataFrame(a, columns=['A'])
    export2=pd.DataFrame(b, columns=['B'])

My problem is that I have many lists and I would like to make only one Dataframe like this:

    export=pd.DataFrame(a, b, columns=['A', 'B'])

But it throws me an error, of dimension:

    ValueError: Shape of passed values is (1, 600), indices imply (2, 576)
python

1 Answers

  1. Best Answer

    It doesn't work for you because you are passing a list that is somehow like a matrix of 8 columns and one row, your Dataframe has 2 columns 'A' and 'B', so there is no dimension match.

    Here are several ways to do the same:

    # Usando a y b con pandas:
pd.DataFrame([a,b],index=['A','B']).transpose()

# mediante pandas usando export y export2:
pd.concat([export,export2],axis=1,join='inner')

# mediante pandas version 2:
export.join(export2)

# mediante numpy
pd.DataFrame(np.hstack((export,export2)),columns=['A','B'])

    EDIT: proposed by @kikocorreoso.

    # mediante un dict de listas, 

pd.DataFrame(('A':a,'B':b})

    The interesting thing is if the data you have, you need to join them by some criterion of the table itself.

    • 3