Explode the contents of the cell in pandas dataframe into different rows

Question

I have a pandas dataframe in which multiple(3) column contains values corresponding to the next column. I want to split each row into multiple rows accordingly and create a new row per entry. For example, 'source' should become

*source

Time (magazine)

WarnerMedia

U.S. Securities and Exchange Commission

WarnerMedia

AOL *

The dataframe is of the format

ID	source	target	type
0	["': 'Time (magazine)", "': 'WarnerMedia", "': 'WarnerMedia", "': 'WarnerMedia", "': 'U.S. Securities and Exchange Commission", "': 'WarnerMedia", "': 'AOL"]	["': 'WarnerMedia", "': 'Time (magazine)", "': 'Time (magazine)", "': 'U.S. Securities and Exchange Commission", "': 'WarnerMedia", "': 'AOL", "': 'WarnerMedia"]	["': 'owned by", "': 'subsidiary", "': 'owned by", "': 'subsidiary", "': 'subsidiary", "': 'subsidiary", "': 'subsidiary"]
1	["': 'Federal Reserve", "': 'Bank of America", "': 'London", "': 'New York (state)"]	["': 'London", "': 'New York (state)", "': 'Federal Reserve", "': 'Bank of America"]	["': 'headquarters location", "': 'headquarters location", "': 'headquarters location", "': 'headquarters location"]

I would require the data to be formatted in the following way :

source	target	type
Time (magazine)	WarnerMedia	owned by
WarnerMedia	Time (magazine)	subsidiary
WarnerMedia	Time (magazine)	owned by
WarnerMedia	U.S. Securities and Exchange Commission	subsidiary
U.S. Securities and Exchange Commission	WarnerMedia	subsidiary
WarnerMedia	AOL	subsidiary
AOL	WarnerMedia	subsidiary

and so on..

I was using pandas explode function, but I could make it work for only one column, I would like to make it work for multiple columns at the same.

Thanks in Advance

ignore my previous comment. you can do this, and pandas does enforce that each list be the same length. — Michael Delgado
– Michael Delgado, Commented Nov 9, 2022 at 19:59

Michael Delgado · Accepted Answer · 2022-11-09 20:09:08Z

2

You can pass a list to pandas.DataFrame.explode:

exploded = df.explode(["source", "target", "type"])

To explode multiple columns, each list within each cell must have an identical length to the lists in the other cells in the row.

edited Nov 9, 2022 at 20:09

answered Nov 9, 2022 at 20:00

Michael Delgado

15.7k4 gold badges39 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Explode the contents of the cell in pandas dataframe into different 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