Python Dataframe of array of one column need to expand in multiple rows

Question

This is my input Data frame , df=

  projectName  | Project Status  |   Data
0       ABC    |     completed   | [5ea2b44c7509725686864def,5ea2b8607509725686864f07,5ea2c3b67509725686865229]

OUTPUT I need as df=

  projectName  | Project Status  |   Data
0       ABC    |   completed     |   5ea2b44c7509725686864def
1       ABC    |     completed   |   5ea2b8607509725686864f07 
2       ABC    |     completed   |   5ea2c3b67509725686865229

Assuming Data is already a list, you can user df.explode('Data') — sanket tilekar
– sanket tilekar, Commented Mar 3, 2022 at 12:14

vovakirdan · Accepted Answer · 2022-03-03 12:19:51Z

1

Very primal solution:

d = {'projectName': ["ABC"], "Project Status":["completed"], "Data":["5ea2b44c7509725686864def, 5ea2b8607509725686864f07, 5ea2c3b67509725686865229"]}
data = pd.DataFrame(d)
tmp = ''.join(data['Data']).split(',')
first = d["projectName"]*len(tmp)
second = d["Project Status"]*len(tmp)
d = {'projectName': first, "Project Status":second, "Data":tmp}
data = pd.DataFrame(d)

answered Mar 3, 2022 at 12:19

vovakirdan

3653 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Python Dataframe of array of one column need to expand in multiple rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related