This project performs an analysis on the Belgian delivery apps market. Specifically three of the main players: Deliveroo, Takeaway and Uber Eats.
One data base and its corresponding schema are provived per platform.
The first objective is to learn how to work with databases and tables, and perform data extraction, preprocessing, manipulation and analysis using mainly SQL queries.
The second objective is to answer the following questions in the process:
About price:
- What is the price distribution of menu items?
- Which restaurants have the best price-to-rating ratio?
- Map locations offering kapsalons and their average price.
- How do delivery fees vary across platforms and locations?
About location:
- What is the distribution of restaurants per location?
- Find the furthest point in Flanders from a bottle of Coke, using geospatial data.
- Where are the delivery ‘dead zones’—areas with minimal restaurant coverage?
- How does the availability of vegetarian and vegan dishes vary by area?
About rating:
- Which are the top 10 pizza restaurants by rating?
- Create a Venn diagram comparing restaurant distributions across Uber Eats, Deliveroo, and Takeaway. Discuss trends.
- How do ratings of similar restaurants differ across Uber Eats, Deliveroo, and Takeaway?
- Identify the World Hummus Order (WHO); top 3 hummus serving restaurants.
- Install the required dependencies (requirements.txt) in your environment.
- Clone the repository:
git clone https://github.com/Celina-Bolanos/delivery-market-analysis
- Select the file corresponding to the analysis you want to explore (price, location or rating).
- Execute the script (.py files) or cells (.ipynb files).
- Imad Faeik Eldeib
- Tumi Modiba
- Celina Bolaños
Check details via this Trello Board