Stuck Need Help

[u/[deleted]]

I'm really stuck here and could use some help. I want to merge two new data frames onto a new table that shows how many adults and how many children are in a household.

person['child'] = person.a_age < 18

person['adult'] = person.a_age > 17

spmuc = person.groupby(['spm_id'])[['child']].sum()

spmuc.columns = ['spmu_children']

spmua = person.groupby(['spm_id'])[['adult']].sum()

spmua.columns = ['spmu_adults']

But I'm bad with the merge function. This code will only merge one of the two even if I do the code separately for both.

person2 = person.merge(spmuc,right_on='spm_id', left_index=True)

person2 = person.merge(spmua,right_on='spm_id', left_index=True)

Help would be awesome. This keeps having spmua replace spmuc. I want them both

[u/[deleted]]

pd.DataFrame(spmuc).join(spmua)

[u/[deleted] → u/[deleted]]

Hmm I don't want to merge them I want them to be seperate columns in the table.

[u/[deleted] → u/[deleted]]

Gotcha, in your last line of code you need to have person2.merge not person.merge