How to add rows based on values in another column

Asked May 06 '22 at 09:34

Active May 06 '22 at 09:34

Viewed 13 times

I would like to append rows based on value in another column -

fruit value
'grape' 1
'apple' 2
'peach' 3

Wanted output - I would like to append rows by *n when the value is larger than 1. 'apple' row will be populated twice, and 'grape' row will be populated three times

fruit value
'grape' 1
'apple' 2
'apple' 2
'peach' 3
'peach' 3
'peach' 3

asked May 06 '22 at 09:34

halo09876

2,725
12
51
71

`df.reindex(df.index.repeat(df['value']))` – mozway May 06 '22 at 09:37
I get the the message - 'cannot reindex from a duplicate axis' – halo09876 May 06 '22 at 09:43
can you provide a full reproducible example (with index) as DataFrame constructor? – mozway May 06 '22 at 09:45
You can also try `df.iloc[df.reset_index().index.repeat(df['value'])]` – mozway May 06 '22 at 09:46
Is there a way not to reindex, using 'df.reindex(df.index.repeat(df['value']))'? I want to preserve the previous index – halo09876 May 06 '22 at 09:52
can you provide a better example input as DataFrame constructor? This should already preserve the index – mozway May 06 '22 at 12:10

How to add rows based on values in another column

0 Answers0