0

For the context: For downloading DHS data I follow this link: https://rspatialdata.github.io/dhs-data.html#Loading_datasets_and_associating_its_metadata_into_R

I want to analyze it following this post: https://github.com/DHSProgram/DHS-Indicators-R/commit/1c64b0f2af33ac56d149a7dbce34ea8bb21ce3f9

Since I have data from 5 countries, starting in 2000 I joined HW files to PR files, where the orginal PR files did't have the hc (undernourishment) variables. The merge of HW files to PR files ended up the comb_extract_HW_res dataframe. However, when I want to bind my comb_extract_HW_res to the other dataframes (which files already included the hc variables) comb_extract by rbin_labelled (as I did for example to create comb_extact and everything just worked fine). But in this step (combining comb_extract which already contained hc variables and comb_extract_HW_res, where I added the variables) I somehow loosing all my negative values of my hc variables. Someone have an idea how this happens?

comb_extract_all <- rbind_labelled(list(comb_extract, comb_extract_HW_res),  labels = list(hv023 ="concatenate", hv024 = "concatenate", hc70 = "concatenate", hc71 = "concatenate", hc72 = "concatenate", hc73 = "concatenate"))

my two dfs are:

dput(comb_extract[1:3,1:10])
structure(list(hhid = c("        1 27", "        1 27", "        1 27"
), hv001 = c(1, 1, 1), hv002 = c(27, 27, 27), hv005 = c(1707326, 
1707326, 1707326), hv006 = c(8, 8, 8), hv007 = c(2003, 2003, 
2003), hv021 = c(1, 1, 1), hv023 = structure(c(34L, 34L, 34L), labels = structure(1:343, names = c("1", 
"10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "2", 
"20", "21", "22", "23", "24", "25", "3", "4", "5", "6", "7", 
"8", "9", "Acholi", "Addis Ababa", "Afar-rural", "Afar-Urban", 
"Affar rural", "Affar urban", "Amhara-rural", "Amhara-urban", 
"Amhara rural", "Amhara urban", "Ankole", "Balaka - rural", "Balaka - urban", 
"Benishangul-Gumuz-rural", "Benishangul-Gumuz-urban", "Benishangul-Gumuz rural", 
"Benishangul-Gumuz urban", "Blantyre - rural", "Blantyre - urban", 
"Bomi - Rural", "Bomi - Urban", "Bomi Rural", "Bomi Urban", "Bong - Rural", 
"Bong - Urban", "Bong Rural", "Bong Urban", "Bugesera", "Bugesera - rural", 
"Bugesera - urban", "Bugisu", "Bukedi", "Bulawayo - Urban", "Bunyoro", 
"Burera", "Burera - rural", "Burera - urban", "Busoga", "Central", 
"Central 1", "Central 2", "Chikwawa - rural", "Chikwawa - urban", 
"Chiradzulu - rural", "Chiradzulu - urban", "Chitipa - rural", 
"Chitipa - urban", "Dedza - rural", "Dedza - urban", "Dire Dawa-urban", 
"Dire Dawa -rural", "Dire Dawa rural", "Dire Dawa urban", "Dowa - rural", 
"Dowa - urban", "East Central", "East Central Island-rural", 
"Eastern", "Gakenke", "Gakenke - rural", "Gakenke - urban", "Gambela-rural", 
"Gambela-urban", "Gambela rural", "Gambela urban", "Gasabo", 
"Gasabo - rural", "Gasabo - urban", "Gatsibo", "Gatsibo - rural", 
"Gatsibo - urban", "Gbarpolu - Rural", "Gbarpolu - Urban", "Gbarpolu Rural", 
"Gbarpolu Urban", "Gicumbi", "Gicumbi - rural", "Gicumbi - urban", 
"Gisagara", "Gisagara - rural", "Gisagara - urban", "Grand Bassa - Rural", 
"Grand Bassa - Urban", "Grand Bassa Rural", "Grand Bassa Urban", 
"Grand Cape Mount - Rural", "Grand Cape Mount - Urban", "Grand Cape Mount Rural", 
"Grand Cape Mount Urban", "Grand Gedeh - Rural", "Grand Gedeh - Urban", 
"Grand Gedeh Rural", "Grand Gedeh Urban", "Grand Kru - Rural", 
"Grand Kru - Urban", "Grand Kru Rural", "Grand Kru Urban", "Harare - Urban", 
"Harari-rural", "Harari-urban", "Harari rural", "Harari urban", 
"Huye", "Huye - rural", "Huye - urban", "Kamonyi", "Kamonyi - rural", 
"Kamonyi - urban", "Kampala", "Karamoja", "Karonga - rural", 
"Karonga - urban", "Karongi", "Karongi - rural", "Karongi - urban", 
"Kasungu - rural", "Kasungu - urban", "Kayonza", "Kayonza - rural", 
"Kayonza - urban", "Kicukiro", "Kicukiro - rural", "Kicukiro - urban", 
"Kigezi", "Kirehe", "Kirehe - rural", "Kirehe - urban", "Lango", 
"Likoma - rural", "Likoma - urban", "Lilongwe - rural", "Lilongwe - urban", 
"Lofa - Rural", "Lofa - Urban", "Lofa Rural", "Lofa Urban", "Machinga - rural", 
"Machinga - urban", "Mangochi - rural", "Mangochi - urban", "Manicaland - Rural", 
"Manicaland - Urban", "Margibi - Rural", "Margibi - Urban", "Margibi Rural", 
"Margibi Urban", "Maryland - Rural", "Maryland - Urban", "Maryland Rural", 
"Maryland Urban", "Mashonaland Central - Rural", "Mashonaland Central - Urban", 
"Mashonaland East - Rural", "Mashonaland East - Urban", "Mashonaland West - Rural", 
"Mashonaland West - Urban", "Masvingo - Rural", "Masvingo - Urban", 
"Matabeleland North - Rural", "Matabeleland North - Urban", "Matabeleland South - Rural", 
"Matabeleland South - Urban", "Mchinji - rural", "Mchinji - urban", 
"Midlands - Rural", "Midlands - Urban", "Montserrado - Rural", 
"Montserrado - Urban", "Montserrado Rural", "Montserrado Urban", 
"Muhanga", "Muhanga - rural", "Muhanga - urban", "Mulanje - rural", 
"Mulanje - urban", "Musanze", "Musanze - rural", "Musanze - urban", 
"Mwanza - rural", "Mwanza - urban", "Mzimba - rural", "Mzimba - urban", 
"National", "Neno - rural", "Neno - urban", "Ngoma", "Ngoma - rural", 
"Ngoma - urban", "Ngororero", "Ngororero - rural", "Ngororero - urban", 
"Nimba - Rural", "Nimba - Urban", "Nimba Rural", "Nimba Urban", 
"Nkhatabay - rural", "Nkhatabay - urban", "Nkhota kota - rural", 
"Nkhota kota - urban", "North ( excluding refugee camps )", "North Buganda", 
"North Buganda Island-rural", "North Buganda Island-urban", "Northern", 
"Nsanje - rural", "Nsanje - urban", "Ntcheu - rural", "Ntcheu - urban", 
"Ntchisi - rural", "Ntchisi - urban", "Nyabihu", "Nyabihu - rural", 
"Nyabihu - urban", "Nyagatare", "Nyagatare - rural", "Nyagatare - urban", 
"Nyamagabe", "Nyamagabe - rural", "Nyamagabe - urban", "Nyamasheke", 
"Nyamasheke - rural", "Nyamasheke - urban", "Nyanza", "Nyanza - rural", 
"Nyanza - urban", "Nyarugenge", "Nyarugenge - rural", "Nyarugenge - urban", 
"Nyaruguru", "Nyaruguru - rural", "Nyaruguru - urban", "Oromia-rural", 
"Oromia-urban", "Oromiya rural", "Oromiya urban", "Phalombe - rural", 
"Phalombe - urban", "Refugee camps", "River Cess - Rural", "River Cess - Urban", 
"River Gee - Rural", "River Gee - Urban", "River Gee Rural", 
"River Gee Urban", "Rivercess Rural", "Rivercess Urban", "Rubavu", 
"Rubavu - rural", "Rubavu - urban", "Ruhango", "Ruhango - rural", 
"Ruhango - urban", "Rulindo", "Rulindo - rural", "Rulindo - urban", 
"Rumphi - rural", "Rumphi - urban", "Rural : Harare", "Rural : Manicaland", 
"Rural : Mashonaland Central", "Rural : Mashonaland East", "Rural : Mashonaland West", 
"Rural : Masvingo", "Rural : Matabeleland North", "Rural : Matabeleland South", 
"Rural : Midlands", "Rusizi", "Rusizi - rural", "Rusizi - urban", 
"Rutsiro", "Rutsiro - rural", "Rutsiro - urban", "Rwamagana", 
"Rwamagana - rural", "Rwamagana - urban", "S.N.N.P. rural", "S.N.N.P. urban", 
"Salima - rural", "Salima - urban", "Sinoe - Rural", "Sinoe - Urban", 
"Sinoe Rural", "Sinoe Urban", "SNNPR-rural", "SNNPR-urban", "Somali-rural", 
"Somali-urban", "Somali oversample rural", "Somali oversample urban", 
"Somali rural", "Somali urban", "South Buganda", "South Buganda Island-rural", 
"South Buganda Island-urban", "Southern", "Southwest", "Teso", 
"Thyolo - rural", "Thyolo - urban", "Tigray-rural", "Tigray-urban", 
"Tigray rural", "Tigray urban", "Tooro", "Urban : Bulawayo", 
"Urban : Harare", "Urban : Manicaland", "Urban : Mashonaland Central", 
"Urban : Mashonaland East", "Urban : Mashonaland West", "Urban : Masvingo", 
"Urban : Matabeleland North", "Urban : Matabeleland South", "Urban : Midlands", 
"West Nile", "Western", "Zomba - rural", "Zomba - urban")), class = c("haven_labelled", 
"vctrs_vctr", "integer")), hv024 = structure(c(6L, 6L, 6L), labels = structure(1:66, names = c("Acholi", 
"Addis Ababa", "Addis Adaba", "Afar", "Affar", "Amhara", "Ankole", 
"Benishangul", "Benishangul-Gumuz", "Bugisu", "Bukedi", "Bulawayo", 
"Bunyoro", "Busoga", "Central", "Central 1", "Central 2", "Central region", 
"Dire Dawa", "East", "East Central", "Eastern", "Gambela", "Harare", 
"Harari", "Kampala", "Karamoja", "Kigali", "Kigali City", "Kigezi", 
"Lango", "Manicaland", "Mashonaland Central", "Mashonaland East", 
"Mashonaland West", "Masvingo", "Matabeleland North", "Matabeleland South", 
"Midlands", "Monrovia", "North", "North Buganda", "North Central", 
"North Western", "Northern", "Northern region", "Oromia", "Oromiya", 
"SNNP", "SNNPR", "Somali", "South", "South Buganda", "South Central", 
"South Eastern A", "South Eastern B", "Southern", "Southern region", 
"Southwest", "Teso", "Tigray", "Tooro", "West", "West-Nile", 
"West Nile", "Western")), class = c("haven_labelled", "vctrs_vctr", 
"integer")), hv025 = structure(c(2, 2, 2), labels = c(Urban = 1, 
Rural = 2), label = "Type of place of residence", class = c("haven_labelled", 
"vctrs_vctr", "double"))), row.names = c("ETPR61SV.1", "ETPR61SV.2", 
"ETPR61SV.3"), class = "data.frame")

and

dput(comb_extract_HW_res[1:3,1:10])
structure(list(hhid = c("         1 1", "         1 1", "         1 1"
), hvidx = c(1, 1, 2), FileName = c("MW", "RW", "MW"), hv001 = c(1, 
1, 1), hv002 = c(1, 1, 1), hv005 = c(476295, 1402416, 476295), 
    hv006 = c(12, 4, 12), hv007 = c(2004, 2005, 2004), hv021 = c(1, 
    1, 1), hv023 = structure(c(29L, 20L, 29L), labels = structure(1:55, names = c("Addis Ababa - rural", 
    "Addis Ababa - urban", "Afar - rural", "Afar - urban", "Amhara - rural", 
    "Amhara - urban", "Ben-Gumz - rural", "Ben-Gumz - urban", 
    "Blantyre District", "Bulawayo", "Butare", "Byumba", "Cyangugu", 
    "Dire Dawa - rural", "Dire Dawa - urban", "Gambela - rural", 
    "Gambela - urban", "Gikongoro", "Gisenyi", "Gitarama", "Harare", 
    "Harari - rural", "Harari - urban", "Kasungu District", "Kibungo", 
    "Kibuye", "Kigali Ngali", "Lilongwe District", "Machinga District", 
    "Mangochi District", "Manicaland", "Mashonaland Central", 
    "Mashonaland East", "Mashonaland West", "Masvingo", "Matebeleland North", 
    "Matebeleland South", "Midlands", "Mulanje District", "Mzimba District", 
    "Oromiya - rural", "Oromiya - urban", "Rest of Malawi", "Ruhengeri", 
    "Salima District", "SNNP - rural", "SNNP - urban", "Somali - rural", 
    "Somali - urban", "Thyolo District", "Tigray - rural", "Tigray - urban", 
    "Umutara", "Ville de Kigali", "Zomba District")), class = c("haven_labelled", 
    "vctrs_vctr", "integer"))), row.names = c(NA, 3L), class = "data.frame")
Sulz
  • 333
  • 1
  • 8

0 Answers0