Merge two rows of same dataframe in pandas

Question

I have a dataframe:

I want something like:

ThePyGuy · Accepted Answer · 2022-09-07 12:39:51Z

2

Replace empty strings by NaN (no need if empty values are already NaN), then backward fill the rows, and finally drop duplicates on ID column:

>>> df.replace('', np.nan).bfill(axis=0).drop_duplicates(['ID'])

   sn    ID   Amount
0   0  10.0  3836.68
1   1  70.0  1087.63
3   3  20.0  2863.56

answered Sep 7, 2022 at 12:39

ThePyGuy

18.5k5 gold badges24 silver badges55 bronze badges

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

1 Answer 1