How to merge rows and fill empty columns in python?

Question

Name	Age	Gender	Occupation
Joey	18
Joey		Male
Joey			Engineer

I tried groupby().first() but that doesn't work because it gives such a table:

Name	Age	Gender	Occupation
Joey	18

But I want a table like this:

Name	Age	Gender	Occupation
Joey	18	Male	Engineer

I have table like this, and I want to merge all the rows by name and get age, gender and occupation in the same row.

score 1 · Accepted Answer · 2022-01-24T06:36:39.987

1

You can replace '' with NaN, groupby "Name", then use first:

df = df.replace('', np.nan).groupby('Name').first().reset_index()

Output:

   Name   Age Gender Occupation
0  Joey  18.0   Male   Engineer

edited Jan 24 '22 at 06:36

answered Jan 24 '22 at 06:16

I tried but it doesnt give this output, it rather gives output of the first row – Riddhi Dua Jan 24 '22 at 06:32
@RiddhiDua I updated, see if it works now – Jan 24 '22 at 06:36
1

Works perfect, Thankyou. – Riddhi Dua Jan 24 '22 at 06:52

1 Answers1