This year I started my master thesis internship in the data science team at mytaxi in Hamburg. I’ve been pursuing my master studies in data science at Lüneburg University. If you live in Germany or a large European city you might have heard of mytaxi, it is the largest taxi-hailing app in Europe. Today more than 10 million have been riding with mytaxi.
My first onboarding story
When working in data science one deals a lot with various aspects of data such as data acquisition, exploration, and modeling. In order to get a hang of the data structure at mytaxi and understanding the customer base, I needed an onboarding task.
Luckily as I started right after New Years everybody in the office was curious about what happened in the cities before and after the New Years Parties. Today I am ready to share my insights with you.
A Tale of two cities
My research tells about what happened in two cities on New Year’s Eve. It gives a complete picture of where people went to hang out, where late parties of the city were and how people organized a way back home. For investigation, two cities were chosen Hamburg and Berlin.
As I said earlier mytaxi has millions of users and this number grows every day. How many users create new accounts on New Year’s Eve? As a base for comparison let’s take the 30th of December (Figure 1).
As you might see in Figure 1, the number of users on New Year’s Eve increased by two and a half times just for 24 hours. Wow, this is impressive!
After registering new accounts, lucky ones called a taxi and moved in the direction of the celebration. You can see in Figure 2 how there was a spike in requests at 23:00 in Hamburg, whereas in Berlin more people went to parties at 9 pm.
Where did people go?
I wondered where the most popular places in the city were. The heat map is a nice choice for visualization. Places with the highest requests rate have a red color and places with the lowest are green. Below you can see the most popular places for Berlin (Figure 3a) and Hamburg (Figure 3b) cities.
What about going home?
No matter how great the party is, there’s nothing better than to fall asleep in your bed. I do not dare to say for all, but mytaxi users are in solidarity with me. It seems that most people in both Berlin and Hamburg tried to get home between 12:30–2:00 am (Figure 4).
What about the ones who didn’t go home immediately? Where did most late parties happen? Based on figure 4 we can presume that the second wave of requests started between 4 am and 6 am. We can sort out requests with respect to this time range and we will get locations of streets where clubs were open till the early morning (Figure 5a and Figure 5b).
This research was my first story-task in mytaxi. I have got experience with real data analysis and I am very excited about that. Moreover, this investigation gave me the chance to learn a lot of new things.
I hope that this story was interesting for you and now you know where districts full of life are in Hamburg and Berlin on New Year’s Eve.