Convert dataframe column with values in the form of a list into a string in the same column

Question

This is how the pandas dataframe looks like:

A	B	C	D
A1	['Bb1']	[54]	[84.0]
A2	['Bb2']	[63]	[nan]

Following is how the dataframe should be:

A	B	C	D
A1	Bb1	54	84.0
A2	Bb2	63	nan

score 2 · Answer 1 · answered Oct 14 '21 at 08:49

2

As of pandas 1.3.0:

df.explode(['B', 'C', 'D'])

Or before:

df.set_index('A').apply(pd.Series.explode).reset_index()

answered Oct 14 '21 at 08:49

U13-Forward

Before solution not working on pandas `1.2.4` – Muhammad Hassan Oct 14 '21 at 08:52
1

@MuhammadHassan On `1.1.3`, you probably need to run `eval` on the dataframe. – U13-Forward Oct 14 '21 at 08:54
1

Yes got it, `eval` is what needs to be run before. Thanks – Muhammad Hassan Oct 14 '21 at 08:55

1 Answers1