ACS Data Users Group

 View Only
Back to discussions
Expand all | Collapse all

Double check number of people in household (R, PUMS)

  • 1.  Double check number of people in household (R, PUMS)

    Posted 09-17-2021 12:01 PM

    I am attempting to double-check the number of people in household for a specific PUMA.

    I am sorting(group_by) SERIALNO, once the person and household files have been merged.

    This is what I am attempting to do:

    SERIALNO NP HHSIZE CHECK
    2017000001750 1 1 TRUE
    2017000003510 4 4 TRUE
    2017000003510 4 4 TRUE
    2017000003510 4 4 TRUE
    2017000003510 4 4 TRUE

    As you can see, I am sorting by SERIAL NO. For example, 2017000001750 appears once and NP equals once which is correct as there is one person in this household. For, SERIALNO 2017000003510, it appears four times, with an NP of 4 denoting four people in the household. I want to create a variable (HHSIZE) which counts the number of times a specific SERIALNO appears (2017000001750 = 1, 2017000003510 = 4) and then run a logical test: HHSIZE minus(-) NP == 0, and return a value of "TRUE".

    So, far, this is what I have:

    df %>% group_by(SERIALNO) %>% mutate(HHSIZE = count(SERIALNO)) # I am sure this isn't quite right as I get 0s in the output

    # I also am struggling in developing code to test where NP - HHSIZE == 0 returns a value of TRUE

    Thanks as always for being patient with me.