Apologies but I'm struggling to understand what the expected outcome is. Could you provide us with the data or twbx and give us maybe some screenshots of what you expect as the final outcome?
Thank you for your reply, I am sorry if I have not made my problem clear enough.
I have a dataset with a large number of user reviews, with a new datapoint/row for each review. Along with the review text, these data points also have some metadata, e.g. 'language'.
I am currently showing a distribution of the number of data points divided into the different languages (see image).
The coloring of the image shows another metadata, i.e. the review score of all reviews for that particular language - so for instance if the English reviews are generally more positive, the color of the English tile will be darker.
I would like to portrait this overview of review scores across languages on a geographical map, where the color of the different countries would represent the review score for the related language. Do do this I need to be able to create a link between the language variable and a geographical country-variable. Does any of you know how to do this, if it is even possible? (I could hard-code it for every country, but I still need to figure out, e.g. how to make 'Englishø apply to both UK and USA).
Below is a graphical example of what I am trying to acomplish. Note that I could not make English account for both the UK and USA.
I hope this has helped clear out some questions, let me know if I should ellaborate more on the subject.