Data joins serve an important function in any database. It often means that we can join data with a common identifier, extending the original data. In this section, we will create a simple table and join it to the Canada_Provinces Shapefile that we have just created.
Using the data on the corresponding Wikipedia pages for each of the three provinces that we have captured, I have created the following .csv file:
Here, I have kept the ID the same as the one we created in our Shapefile. I have saved this .csv file in the same place as my Canada_Provinces.shp. Create this ...