Calculating group medians in R (ACS 5yr 2018-2022)

Apologies, I should have mentioned that my extract request was filtered on California data with the “select cases” option.

I found some additional instructions working with household level data from an earlier thread:

As they suggest, I changed my filter to exclude group quarters:
image

However, I noticed the variable PERNUM is missing despite specifying it in my extract. Are there other variables one should consider with household level analysis?