Converting a two columns data-frame into multiple columns?

Question

I have a data frame (my_data) like this:

my_data:

          0         1
     0  name1  [2, 2, 3, 2]
     1  name2  [3, 2, 2, 2]
     2  name3  [2, 3, 2, 2]
     3  name4  [2, 2, 3, 2]
     4  name5  [0, 1, 1, 1]

And I want to convert it to a form with multiple columns like the below data frame:

        Col0, col1, col2, col3, col4
     0  name1,  2,   2,     3,   2
     1  name2,  3,   2,     2,   2
     2  name3,  2,   3,     2,   2
     3  name4,  2,   2,     3,   2
     4  name5,  0,   1,     1,   1

Possible duplicate of [How do I unnest (explode) a column in a pandas DataFrame?](https://stackoverflow.com/questions/53218931/how-do-i-unnest-explode-a-column-in-a-pandas-dataframe) — yatu, Feb 09 '19 at 19:02

score 2 · Accepted Answer · answered Feb 09 '19 at 20:54

Listify and re-convert to DataFrame:

u = pd.DataFrame(df.iloc[:,1].tolist()).rename(lambda x: f'col{x+1}', axis=1)
u

   col1  col2  col3  col4
0     2     2     3     2
1     3     2     2     2
2     2     3     2     2
3     2     2     3     2
4     0     1     1     1

df.iloc[:,[0]].join(
    pd.DataFrame(df.iloc[:,1].tolist()).rename(lambda x: f'col{x+1}', axis=1))

       0  col1  col2  col3  col4
0  name1     2     2     3     2
1  name2     3     2     2     2
2  name3     2     3     2     2
3  name4     2     2     3     2
4  name5     0     1     1     1

score 1 · Answer 2 · answered Feb 09 '19 at 21:14

my_Data = pd.DataFrame({'0':['name1','name2','name3','name4','name5'],'1':[[2, 2, 3, 2],[3, 2, 2, 2],[2, 3, 2, 2],[2, 2, 3, 2],[0, 1, 1, 1]]})
my_Data.columns = ['Col0','x']

df1=pd.DataFrame(my_Data.x.values.tolist(), index= my_Data.index, columns=['Col1','Col2','Col3','Col4'])
df=my_Data[['Col0']].merge(df1,left_index=True, right_index=True, how='inner')
print(df)

    Col0  Col1  Col2  Col3  Col4
0  name1     2     2     3     2
1  name2     3     2     2     2
2  name3     2     3     2     2
3  name4     2     2     3     2
4  name5     0     1     1     1

Converting a two columns data-frame into multiple columns?

2 Answers2