Converting list of string into dataframe row

Question

I have the following continent to country

pd.DataFrame({'asia':[['china','india','australia']],
              'europe':[['spain','uk','russia','france','germany']],
              'americas':[['canada','usa','mexico']]
            }).transpose()

How do I convert into

asia | china
asia | india
asia | australia
europe | spain
europe | uk

etc. .

wwnde · Accepted Answer · 2022-12-20 20:58:18Z

3

Explode

df = pd.DataFrame({'asia':[['china','india','australia']],
              'europe':[['spain','uk','russia','france','germany']],
              'americas':[['canada','usa','mexico']]
            }).transpose().explode(0)

answered Dec 20, 2022 at 20:58

wwnde

26.7k6 gold badges22 silver badges38 bronze badges

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

Comments

denpy · Accepted Answer · 2022-12-22 21:15:14Z

0

Without using explode (i.e. earlier version of Pandas)

(df.set_index(['index'])[0]
                    .astype(str)
                    .str.split(',', expand=True)
                    .stack()
                    .reset_index(level=-1, drop=True)
                    .reset_index(name='0')
            )

answered Dec 22, 2022 at 21:15

denpy

2791 gold badge2 silver badges12 bronze badges

Collectives™ on Stack Overflow

Converting list of string into dataframe row

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related