Convert vector values in Pandas rows into new rows in python

Asked Aug 27 '19 at 20:43

Active Aug 27 '19 at 20:43

Viewed 24 times

I have a Pandas Data frame that let say col3 has a list, I need to convert each item of the list into a new row as follow:

I think I need to transpose on col1 and col2 but not sure.

# the data frame that I have:  
pd.DataFrame({"col1" : [1,2,3],
               "col2" : ['x','y','z'],
               "col3" : [['a', 'b'],['c','d','e'],['f']] })


# the output I'm expecting:
pd.DataFrame({'Sample':[1,1,2,2,2,3],
          "col2" : ['x','x', 'y','y', 'y', 'z'],
          'targets':['a', 'b','c','d','e','f']})

asked Aug 27 '19 at 20:43

st1980

1

`df.explode('col3').rename(columns={'col1': 'Sample', 'col3': 'targets'})` – piRSquared Aug 27 '19 at 20:51
`explode` is certainly trendy now.. – Mark Wang Aug 27 '19 at 20:58
Use `pandas` and `explode` is my default answer to all questions! – Trenton McKinney Aug 28 '19 at 01:39
explode was a great suggestion! it resolved the issue! THANK YOU SO MUCH everyone for your helpful comments – st1980 Aug 28 '19 at 14:02

Convert vector values in Pandas rows into new rows in python

0 Answers0