I'm new to GIS and new to StackedExchange.
I need help joining a CSV of Accessibility data to a LSOA shapefile in QGIS.
The process explained here does not work for me and I don't know why. The mmqgis plugin and the Joins feature in QGIS both provide me with either an empty Shapefile or an empty CSV file.
I'm trying to map statistics related to accessibility to hospitals from the Department for Transport. The data can be downloaded from here and is in CSV format and is georeferenced by Lower Super Output Area (LSOA), with one column of LSOA codes and the rest are the separate statistics (time taken to get to nearest hospital, for example).
I also have a LSOA shapefile from here, which obviously has the exact same list of LSOA codes.
How can I join the two datasets so that I can map the accessibility stats for each LSOA with a range of colours? I've tried using the 'Join' feature but I can't seem to get it to work.
Any help would be much appreciated.
The first image shows the Accessibility data, note the LSOA data in the first column which matches the LSOA data in the Shapefile and the last column is what I want to map/Join. The second image shows the data associated with the LSOA shapefile, note the LSOA data matches that in the Accessibility data. As far as I know the data type in each file matches. What I want to do is map the data in, say, column 5 of the Accessibility data onto the LSOA shapefile.