Python: Replicate rows in a dataframe by number of items in a column

Question

I have a table like this

I would like to replicate each row by the number of items in the 'Brand' column, and in the result table brand column would only have a single item, like this

How to achieve this in Python? Thanks.

Andrej Kesely · Accepted Answer · 2021-06-23 19:10:51Z

1

Try .explode:

df = df.assign(Brand=df.Brand.str.split(",")).explode("Brand")
print(df)

Prints:

        Date Brand    Cost
0  6/23/2021     A  $100.0
0  6/23/2021     B  $100.0
0  6/23/2021     C  $100.0
1  6/23/2021     A  $200.0
1  6/23/2021     B  $200.0
2  6/23/2021     A  $300.0
2  6/23/2021     B  $300.0
2  6/23/2021     C  $300.0
2  6/23/2021     D  $300.0

answered Jun 23, 2021 at 19:10

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

1 Comment

Lucy_Blah_Blah Over a year ago

Thank you so much for this clear simple solve!

Collectives™ on Stack Overflow

Python: Replicate rows in a dataframe by number of items in a column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related