Data Cleaning – Quiz 3

Import “Data Cleaning Session_Main Data.csv”. Drop the KEY variable. Drop the pilot surveys and the pilot survey variable. Drop the entries that are perfect duplicates of other entries. For the remaining duplicate teacher IDs, recall how in the lesson we kept the observations that had more information and dropped the duplicates that had missing data in some fields. Now suppose that the entries with missing data are the more up-to-date entries that should be retained (e.g. perhaps the teachers contacted the enumerators later and requested their info to be erased). Keep these entries and drop the duplicated entries.