The DHS Program User Forum: Geographic Data » Joining Household-Member Recode Data (xls) to Geo-coded spatial data (shapefile)

Home » Data » Geographic Data » Joining Household-Member Recode Data (xls) to Geo-coded spatial data (shapefile)

Show: Today's Messages :: Show Polls :: Message Navigator

Joining Household-Member Recode Data (xls) to Geo-coded spatial data (shapefile) [message #13330]

Mon, 23 October 2017 07:15

Nadine
Messages: 1
Registered: October 2017
Location: Berlin

Member

Dear All,

I am pretty new to DHS Data and QGis and currently trying to join Household-Member Recode Data (xls) to spatial data (shapefile). I would very much appreciate your help.

I have obtained Ethiopian Household-Member Recode Data and the connected geo-coded shapefile from DHS. Using QGis and following the "MEASURE DHS and MEASURE Evaluation GIS Training" Document I tried to join this Excel file with the shapefile on QGIS.

Now the problem I have is, that in the xls file I have about 10.000 cases but when I join xls and shapefile (with the cluster-number as the common indicator) I have only about 600 cases left.
This is because the individual cases in the xls do not have individual cluster-numbers but are grouped into clusters and when joining QGIS just uses ONE case of the xls to represent the whole cluster.

So my question is how to include all my 10.000 cases into my spatial representation at QGIS?

I would be very thankful for any help!!

Thank you and best regards
Nadine

Report message to a moderator

Previous Topic:	v101
Next Topic:	District Variable in the 2015-16 Malawi DHS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 10:28:30 Coordinated Universal Time 2024