Behind the contest
About the project
As this year the Eurovision contest took place in Israel, we thought it will be interesting to find some correlation between countries votes' to their cultural and neighbors countries.
Thus, we want to help researchers understand these questions with our tools and conclusions.
Graphs and conclusions
Neighbors and Votes
For each country let n be the number of it's neighbors.
ratio = sum of total score voted to n neighbors / sum of n high scored countries the country voted
This graph represents the total points that country voted to other country, the bold edges represents votes above 7% of the total points this country gave to the other countries.
Red edges represent bold edges and neighbors country. as you may see, the red color is major.
Cultures and Votes
for each country let n be the number of it's culture related countries.
ratio = sum of total score voted to n related / sum of n high scored countries the country voted
This graph represents the total points that country voted to other country, the bold edges represents votes above 7% of the total points this country gave to the other countries.
Red edges represent bold edges and culture related country.
Cultures and Neighbors
Now we merged both ratios.
This chart show the relation between the cultural relations and geographically border.
Both ratios on map
The process
get the Data
we looked for data related to the eurovision and countries culture relations.
we used Eurovision Song Contest Score DB that include all the scores were made since 1975 till 2018.
more, we used dataset that shows each country and its neighbors.
moreover, we used the Ethnic Power Relations (EPR) Dataset Family that provides comprehensive coverage of ethnicity around the world, both in time and space, as described in Vogt, Bormann, Rüegger, Cederman, Hunziker, Girardin (2015).
Process the Data
We used pandas to process the row data, filtering it and matches the data.
visualize the data
We used some free tools like datawrapper to analyze the row data, in order to emphasize the relation between the countries.
After the data is been processed we visualize it, so researchers can make their conclusions with our graphs and charts.
Get the sources
Eurovision Song Contest scores 1975-2018
All the scores from all the finals and semi-finals between 1975 and 2018.
credit: https://data.world/
Transborder Ethnic Kin dataset
The Transborder Ethnic Kin (EPR-TEK 2018) dataset records all politically relevant ethnic groups living in at least two countries. this dataset is based on EPR dataset: The EPR Core Dataset identifies all politically relevant ethnic groups and their level of access to state power for all countries of the world from 1946-2017.
Country Borders Dataset
Country borders is a free data that provides a complete list of countries and the associated land border countries (the neighbouring countries).
credit : www.geodatasource.com
All the code, process, DB and more you can find at our public github
