[Link to the map and my blog post on it, which I’m reposting here](https://zarasophos.net/erasmus/). I recommend a desktop/laptop on fullscreen for the map and yes, it is sadly a bit laggy.
**What are you talking about?**
I created a map of a lot of the Erasmus student exchanges between 2008 and 2019 (a lot, not all, due to technical reasons explained below). The map is city-based, so all universities in one city are grouped together. You can also select time periods and also go through the data year by year.
The map only shows exchanges between Erasmus member states, so for example not the Eastern Partnership countries or Erasmus Mundus exchanges. It only shows student exchanges, not work placements (which would be another interesting map, but would require some further work).
While the data provided by the Commission is very nice, it doesn’t show geographic location. This means I had to geocode each exchange in the dataset. For this I had to start on two different levels: The first few years showed home and host universities, the other years cities. So, for the first few years, I first had to convert the codes of universities to the cities the universities were located in. Then I only had the names of cities, and those I could then geocode.
But this is of course much easier said then done: The data was hand-filled, so I had to deal with a lot of different ways of writing the names of cities. I did my best, but overall I was only able to identify around 84% of them. That sounds alright until you remember that an exchange involves two cities, so only 70% (0,84² = 0,7) of exchanges could be completely geocoded.
As you might notice, the map is already quite laggy because there are so many different exchanges on there. In order to help out a bit with that, I removed all exchanges that only included a single student.
In total, there are 4,9 million exchanges in the data. Out of those, 4,7 million were usable (mostly excluding non-student exchanges), and out of those, 3,3 million could successfully be geocoded. I couldn’t find data on how many people actually went on exchange between 2008 and 2013, but for 2014 to 2019, that means around 55% of all exchanges are included in the map.
Well, you probably shouldn’t. But if you are so inclined, it might be interesting to check the relations of cities: What cities do students in Marseille like to go on Erasmus to? How far does the Erasmus network of Sofia stretch to? And you can also check developments over time: How popular has Budapest been as an Erasmus destination? Has this changed, and if yes, when and why?
But that would just be my suggestions.
I’m like 90% sure you pinned salamanca’s university (in Salamanca) in the Salamanca district, Madrid.
Cool map otherwise.
Have you considered posting this on r/mapporn? So many shitty maps there and this one is cool and beautifully done!
El enlace no funciona! Pero increíble trabajo la verdad
Cool! I found my line in the European Commission CSV!
I think that a lot of the multi-campus universities (at least in Madrid) aren’t being correctly mapped but because they aren’t correctly reported (but that’s a problem of the source data).
E.g. My university has campuses in Leganés, Getafe, Colmenarejo and Madrid, and I was studying in Leganés, but I’ve been reported as coming from Madrid. But now I wondes how there are some entries in the map for Leganés and Getafe, for example. Maybe they are unrelated to the university?
I’m also reported as studying in Dutch but I studied in English lol.
Who tf going to Vilnius
Disgusting. Erasmus is all about fucking, drinking and spending parent’s money. what a fucking awful culture.
Oleeee Sevilla ahí, vinos, siesta, ole ole
Básicamente todo el mundo ama Sevilla
If I’m not mistaken this map shows that Sevilla is the most popular/common Erasmus exchange destination times about a thousand?
🤣🤣🤣
Its a very good, good, good map. That gives visual expression to the reality that you observed. A good work !
/r/mapassincanarias
Spain is such a paradise! I feel so grateful for having born here 😃
That’s not good for people going to Andalusia, the Spanish language used there tend to ignore the “S” letters and is way harder to understand, even for Spanish people sometimes, and it will make the learning harder and less effective
15 comments
[Link to the map and my blog post on it, which I’m reposting here](https://zarasophos.net/erasmus/). I recommend a desktop/laptop on fullscreen for the map and yes, it is sadly a bit laggy.
**What are you talking about?**
I created a map of a lot of the Erasmus student exchanges between 2008 and 2019 (a lot, not all, due to technical reasons explained below). The map is city-based, so all universities in one city are grouped together. You can also select time periods and also go through the data year by year.
The map only shows exchanges between Erasmus member states, so for example not the Eastern Partnership countries or Erasmus Mundus exchanges. It only shows student exchanges, not work placements (which would be another interesting map, but would require some further work).
**Where did you get the data from?**
The [Erasmus data](https://data.europa.eu/data/datasets?query=erasmus%20mobility%20statistics&locale=en&publisher=http%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FEAC&page=1&limit=10) is published by the European Commission. Further data for geocoding the various universities is also taken [from the Commission](https://erasmus-plus.ec.europa.eu/document/higher-education-institutions-holding-an-eche-2021-2027) and [from Geonames](https://data.opendatasoft.com/explore/dataset/geonames-all-cities-with-a-population-1000%40public/table/?disjunctive.cou_name_en&sort=name).
**What did you do to the data?**
While the data provided by the Commission is very nice, it doesn’t show geographic location. This means I had to geocode each exchange in the dataset. For this I had to start on two different levels: The first few years showed home and host universities, the other years cities. So, for the first few years, I first had to convert the codes of universities to the cities the universities were located in. Then I only had the names of cities, and those I could then geocode.
But this is of course much easier said then done: The data was hand-filled, so I had to deal with a lot of different ways of writing the names of cities. I did my best, but overall I was only able to identify around 84% of them. That sounds alright until you remember that an exchange involves two cities, so only 70% (0,84² = 0,7) of exchanges could be completely geocoded.
As you might notice, the map is already quite laggy because there are so many different exchanges on there. In order to help out a bit with that, I removed all exchanges that only included a single student.
In total, there are 4,9 million exchanges in the data. Out of those, 4,7 million were usable (mostly excluding non-student exchanges), and out of those, 3,3 million could successfully be geocoded. I couldn’t find data on how many people actually went on exchange between 2008 and 2013, but for 2014 to 2019, that means around 55% of all exchanges are included in the map.
You can check what I did with the data yourself in this project’s [repository](https://github.com/maximilianhenning/erasmus-data).
**Why should I care about this?**
Well, you probably shouldn’t. But if you are so inclined, it might be interesting to check the relations of cities: What cities do students in Marseille like to go on Erasmus to? How far does the Erasmus network of Sofia stretch to? And you can also check developments over time: How popular has Budapest been as an Erasmus destination? Has this changed, and if yes, when and why?
But that would just be my suggestions.
I’m like 90% sure you pinned salamanca’s university (in Salamanca) in the Salamanca district, Madrid.
Cool map otherwise.
Have you considered posting this on r/mapporn? So many shitty maps there and this one is cool and beautifully done!
El enlace no funciona! Pero increíble trabajo la verdad
Cool! I found my line in the European Commission CSV!
I think that a lot of the multi-campus universities (at least in Madrid) aren’t being correctly mapped but because they aren’t correctly reported (but that’s a problem of the source data).
E.g. My university has campuses in Leganés, Getafe, Colmenarejo and Madrid, and I was studying in Leganés, but I’ve been reported as coming from Madrid. But now I wondes how there are some entries in the map for Leganés and Getafe, for example. Maybe they are unrelated to the university?
I’m also reported as studying in Dutch but I studied in English lol.
Who tf going to Vilnius
Disgusting. Erasmus is all about fucking, drinking and spending parent’s money. what a fucking awful culture.
Oleeee Sevilla ahí, vinos, siesta, ole ole
Básicamente todo el mundo ama Sevilla
If I’m not mistaken this map shows that Sevilla is the most popular/common Erasmus exchange destination times about a thousand?
🤣🤣🤣
Its a very good, good, good map. That gives visual expression to the reality that you observed. A good work !
/r/mapassincanarias
Spain is such a paradise! I feel so grateful for having born here 😃
That’s not good for people going to Andalusia, the Spanish language used there tend to ignore the “S” letters and is way harder to understand, even for Spanish people sometimes, and it will make the learning harder and less effective