Etydhv

I'd like to create something almost identical to this:

I'd like to display what languages are most spoken within each neightbourhood. My data has 6 languages. Is this possible for a novice like myself? I've put together some maps with 1 category of data (eg. population, income, etc), but never with 6 categories.

My data table looks like this:

Is there a relatively easy way to do this? Is my data organized properly to do so? Is there a better way to represent this data? I've tried using the Random Points Inside Polygons but I can't get it to work.

Here's my error message: https://imgur.com/a/TGbaWb6m

My data does not have lat & long for each point.

From the content of the error message, it would appear that you're trying to run the algorithm on a field which contains null values, so that's the main problem.

Open up the Field Calculator and check the box to Update existing field and select the the field you're creating your points from, which I'm assuming is the "total" field in your data.

Enter the following expression:

if( "number" IS NULL, 0, "number")

This will insert 0's in place of all the nulls, which will allow you to run the Random Points tool now.

In Excel, re-arrange the table so that you have only one row for each Geography value. Create a column for each language, and put the number of speakers of that language in that column. Eg, convert this

to this

I did this manually, but I think you can do it automatically using something called a pivot table, as mentioned here and here.

Save the new table as a CSV. Add the new table to your QGIS project.

Join the new table to the neighborhood layer. Now you have a one-to-one relationship between table rows and neighborhood geometries.

Run Random points inside polygons once for each language category. Be sure to name each new layer with the name of the language.

The input data you have has blank cells as one of the values. QGIS uses the field you specified to add points up to the number in the field. To do this it converts the field into an integer, but it cannot convert a blank cell into an integer.

The easiest way for you to fix this is to put 0's into the blank cells of your source data.