duplicate part of the row based on the delimiter in pandas?

Question

Is there any possibility to duplicate part of the row based on the delimiter

For example, if I have df like this:

Cars             Country       Trans                     trans_id
Alto             Australia     Automatic & Manual        auto & man

I want to convert each row on the & delimiter into 2 rows and keep the other columns same

The desired output should be:

    Cars             Country       Trans                     trans_id        New_Trans     NewTransID
    Alto             Australia     Automatic & Manual        auto & man      Automatic     auto
    Alto             Australia     Automatic & Manual        auto & man      Manual        man

score 1 · Accepted Answer · answered Mar 18 '22 at 08:31

1

Use:

df = (df.assign(new_Trans = df['Trans'].str.split(' & '),
                new_trans_id = df['trans_id'].str.split(' & '))
        .explode(['new_Trans','new_trans_id']))

answered Mar 18 '22 at 08:31

jezrael

729,927
78
1,141
1,090

duplicate part of the row based on the delimiter in pandas?

1 Answers1