How to merge rows with same id in python?

Question

I have a pandas DataFrame with the following property, How Can I merge rows with same id in python?

what I want:

I think your question is something like [this](https://stackoverflow.com/q/46826773/12727539). — mo1ein, Jul 26 '22 at 21:05

score 0 · Answer 1 · answered Jul 26 '22 at 21:05

0

Here is one way:

df = df.groupby('id', sort=False).max().reset_index()

Input:

      id  test1  test2
0    one   10.0    NaN
1    one    NaN   30.0
2    two    NaN    3.0
3  three   10.0    5.0

Output:

      id  test1  test2
0    one   10.0   30.0
1    two    NaN    3.0
2  three   10.0    5.0

answered Jul 26 '22 at 21:05

constantstranger

This code deletes some columns. For example, my data has 12 columns, but now only 4 columns are displayed. @constantstranger – user12217822 Jul 26 '22 at 21:12
I'm not seeing that. Can you give an example of what's in one of the columns that is getting deleted? – constantstranger Jul 26 '22 at 21:15
It deletes all columns have number type. – user12217822 Jul 26 '22 at 21:22
Hmm, not seeing that either. I added a column with label `99` (type `int`) and it did not get deleted when I ran the code. Can you share a sample of the 12 columns? – constantstranger Jul 26 '22 at 21:27

score 0 · Answer 2 · answered Jul 27 '22 at 01:56

You can do groupby.first to merge your same id into a row.

df.groupby('id', sort=False).first()
Out[18]: 
       test1  test2
id                 
one     10.0   30.0
two      NaN    3.0
three   10.0    5.0

2 Answers2