How do i convert python list into pandas dataframe with predefined columns

Question

I have python string list, which i want to convert into pandas dataframe with predefined columns. I have tried following code but it shows error.

I have tried following code.

  import pandas as pd
  list = ['jack', '9860', 'datasc', 'vill','0', 'stack']
  df = pd.DataFrame(list, columns= ['name', 'no','job'])

ValueError: Shape of passed values is (1, 6), indices imply (3, 6)

jezrael · Accepted Answer · 2019-03-31 11:50:54Z

2

Dont use variable list, because python code word (builtin).

Convert list to numpy array and reshape:

L = ['jack', '9860', 'datasc', 'vill','0', 'stack']
df = pd.DataFrame(np.array(L).reshape(-1,3), columns= ['name', 'no','job'])
print (df)
   name    no     job
0  jack  9860  datasc
1  vill     0   stack

edited Mar 31, 2019 at 11:50

answered Mar 31, 2019 at 11:44

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

Coder Over a year ago

what is mean reshape(-1,3)

jezrael Over a year ago

@Coder - -1 means count number of N in shape - (Nx3) - it means it create 3 columns and counted number of rows by number of values in list.

jezrael Over a year ago

@Coder - similar solution in last paragraph in example

Collectives™ on Stack Overflow

How do i convert python list into pandas dataframe with predefined columns

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related