I have a dataset where participants were sampled from multiple locations that includes several location-specific variables in addition to participant-specific test results. After merging with another results dataset, some participant IDs from the second dataset have no link in the first so they are missing the location information. However, it is obvious which location they correspond to based on their ID value. For example, ABC1002 in the table below comes from the same school/village/region as ABC1001 and 1003. id result result2 village school_id school_name geopoint_lat geopoint_lng region ABC1001 NEGATIVE 2 A 5555 School A 999 999 15 ABC1002 ABC1003 NEGATIVE 2 A 5555 School A 999 999 15 My question: is there an easy way to impute the location-specific variables for participants like this but *not* other variables like 'result' and 'result2' that are specific to each participant? I could obviously do this one at a time, but hoping there is a quicker fix.
... View more