Fixing EA ethnicities by using the EA CLUSTER number

[juamiji1]

Some EA ethnicities had NA in all motifs in the raw dataset (raw/folklore/data/Replication_Data_Folklore/Original_Files/Motifs_EA_groups.dta). I fixed them using the following algorithm:

1. For each specific ethnicity I got their respective EA cluster number code (v114) .
2. With the code, I looked other ethnicities in the same ethnic cluster.
3. If there was just one other ethnicity in the cluster, I assigned the motif values of that one to the NA one.
4. If there were more than one, then I assigned the closest one that was not in the 'others' category in the book of Murdock (1967) . Example:
5. In the case of group 369, all the other groups were in the 'others' category, so I made the imputation based on language.
6. In the case of group 120, I used the 1st other ethnicity that appeared in the book. Since it is an island in the middle of the Pacific colonized by explorers the closest ethnicity did not make sense to me.

Final result:

Atlas (v107)	EA Cluster (v114)	Berezkin code (oid)	Berezkin group name	Imputed ethnicity	Reason
BRAZILIAN	117	10017	Portuguese	PORTUGUES	Discussed with Nathan
BAGIRMI	70	674	Sara	SARA	Only other ethnicity in the EA cluster
CANTONESE	164	10024	Fujian Chinese	MINCHINES	Only other ethnicity in the EA cluster
DJUKA	369	10017	Portuguese	PORTUGUES	Language based on Portuguese according to Murdock (1967) - book
SARAMACCA	369	10017	Portuguese	PORTUGUES	Language based on Portuguese according to Murdock (1967) - book
FUR	98	NA	NA	NA	No other info available
GUATO	398	NA	NA	NA	No other info available
HUTSUL	126	195	Czech	CZECHS	closest ethnicity within EA cluster (not in 'others' category in the Book)
IDOMA	42	80	Tiv,Jukun,Mbete,Wute,Ekoi	AFO	closest ethnicity within EA cluster (not in 'others' category in the Book)
IGALA	42	80	Tiv,Jukun,Mbete,Wute,Ekoi	AFO	closest ethnicity within EA cluster (not in 'others' category in the Book)
KORO	42	80	Tiv,Jukun,Mbete,Wute,Ekoi	AFO	closest ethnicity within EA cluster (not in 'others' category in the Book)
KURAMA	63	461	Manden,Bamana,Malinke,Diula	KAGORO	closest ethnicity within EA cluster (not in 'others' category in the Book)
MBANDJA	71	66	Banda,Gbaya,Ngbandi,Manja	NGBANDI	closest ethnicity within EA cluster (not in 'others' category in the Book)
TRISTAN	120	232	England	NEWENGLAN	1st ethnicity within the EA cluster that appears in the book
YIRYORONT	233	641	Queensland	WIKMUNKAN	Only other ethnicity in the EA cluster
YUNGUR	66	80	Tiv,Jukun,Mbete,Wute,Ekoi	MUMUYE	Only other ethnicity in the EA cluster

Note: from 16 ethnicity I could only fix 14.

[juamiji1]

Nathan: Fill in the info with the most representative group (the first in the Ethnic cluster):

Atlas (v107)	EA Cluster (v114)	Berezkin code (oid)	Berezkin group name	Imputed ethnicity	Reason
BRAZILIAN	117	10017	Portuguese	PORTUGUES	Discussed with Nathan
BAGIRMI	70	674	Sara	SARA	Only other ethnicity in the EA cluster
CANTONESE	164	10024	Fujian Chinese	MINCHINES	Only other ethnicity in the EA cluster
DJUKA	369	10017	Portuguese	PORTUGUES	Language based on Portuguese according to Murdock (1967) - book
SARAMACCA	369	10017	Portuguese	PORTUGUES	Language based on Portuguese according to Murdock (1967) - book
FUR	98	NA	NA	NA	No other info available
GUATO	398	NA	NA	NA	No other info available
HUTSUL	126	195	Czech	UKRAINIANS	First ethnicity in the EA cluster
IDOMA	42	80	Tiv,Jukun,Mbete,Wute,Ekoi	NUPE	First ethnicity in the EA cluster
IGALA	42	80	Tiv,Jukun,Mbete,Wute,Ekoi	NUPE	First ethnicity in the EA cluster
KORO	42	80	Tiv,Jukun,Mbete,Wute,Ekoi	NUPE	First ethnicity in the EA cluster
KURAMA	63	461	Manden,Bamana,Malinke,Diula	KATAB	First ethnicity in the EA cluster
MBANDJA	71	66	Banda,Gbaya,Ngbandi,Manja	BWAKA	First ethnicity in the EA cluster
TRISTAN	120	232	England	NEWENGLAN	First ethnicity in the EA cluster
YIRYORONT	233	641	Queensland	WIKMUNKAN	Only other ethnicity in the EA cluster
YUNGUR	66	80	Tiv,Jukun,Mbete,Wute,Ekoi	MUMUYE	Only other ethnicity in the EA cluster

[juamiji1]

Look at Missing values if ethnicities in cluster ID 279 (located in Greenland)