Pandas converting column values into row values

Question

I have a dataframe that looks like this :

id, name, comment
1, 'name',['string', 'string','string','string'] 
2, 'name',['stringx', 'stringy','stringz','stringx']

I want to convert this data frame to something that looks like this:

1, 'name', 'string'
1, 'name','string'
1, 'name', 'string'
1, 'name','string'
2, 'name', 'stringx'
2, 'name','stringy'
2, 'name', 'stringz'
2, 'name','stringx'

Checkout [`df.explode()`](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.explode.html) — Ch3steR, Feb 14 '21 at 11:22
The answer is here : https://stackoverflow.com/questions/17298313/python-pandas-convert-rows-as-column-headers — StarGit, Feb 14 '21 at 11:24
Is your comment column a `list` or `str` representation of a `list`? — Sayandip Dutta, Feb 14 '21 at 11:24

score 1 · Accepted Answer · answered Feb 14 '21 at 11:22

Use DataFrame.explode

df.explode('comment')

    id  name    comment
0   1   name    string
0   1   name    string
0   1   name    string
0   1   name    string
1   2   name    stringx
1   2   name    stringy
1   2   name    stringz
1   2   name    stringx

Pandas converting column values into row values

1 Answers1