A client of DataFoundary collected data for household Survey in the Krishna district of Andhra Pradesh. It turns out in some responses, data collectors have missed entering the Assembly Constituency Names (AC), Mandal Names and Village Names in the relevant field. Fortunately,
the client has maintained a database of all the tablets being deployed in different villages in different dates.
Attached is an excel file<Test.xlsx> containing two sheets:
Sheet 1 one contains a list of around 21,000 responses for which AC, Mandal and Village Names are missing and Sheet 2 contains a list of tablets in use in different villages in different dates.
Can you get the missing Village Names? [Hint: You may not get names of all the missing villages!]