I would like to do a weight overlay analysis for each column of the CSV and present it as a layer of the map of United States of America.
For the county shapefile, you can download from US Census.
Use the 20m zip. Unzip and import into QGIS, call it
When you open the shapefile, you will notice that there is a column called
STATEFP - that is the FIPS code. Each state has a unique FIPS code and you can find the key here.
What you'll need to do is copy these 52 codes and their corresponding state abbreviation (if you include Puerto Rico and Guam) into a spreadsheat. You should have two columns. Save this as a csv and import into QGIS as a delimited text layer - call it
stateKey. Then, in your csv file with all of your demographic data - split the
Area_name column using a comma separator which will create two seaprate columns -
County Name and
State Abbreviation. You can do this with the
Data > Text to Columns in OpenOffice and there is a similar function in Excel. Then import all of your data into QGIS as a delimited text layer, call it
Now you will perform a few joins. First, you will join the
counties. Right click
counties > properties > joins then join
stateKey by the FIPS code and keep all columns.
Now you have a
counties shapefile with state abbreviations.
Next, perform the same step, except this time join
data by state abbreviation. And voila.
Now you can classify the counties by whichever attribute you choose. For example. Right click
counties > properties > style > graduated. Then you can choose the
column which you want to visualize.
For more complex modeling, you could consult the Processing Modeler tutorial