A Beginners Guide to Analyzing Food Delivery Data Online

In this blog, we will analyze the significant players in the food delivery segment in Germany.

Lieferando is the leading food delivery aggregator mediator between the restaurant and the customer. Customers can select between various cuisines, restaurants, prices, and menu items through these aggregators.

To start with, we have to collect data on Lieferando.

There is a pythonic technique to scrape this data; however, we won't get it covered. Let's start by navigating Lieferando's site and submitting the address to delivery locations. We've chosen an address in inner Berlin where there will probably become a higher restaurant availability.

Before refreshing the pages, launch the Chrome Inspector Tool. Go to the Networks tab and search for the Fetch/XHR request, which looks like this:

In the background, the network request is dragging in the JSON file with all restaurants within the range of the typed Home Address. We have just right to click the preview request as well a copy as given below:

Save a JSON file within the text editor.

We will fire up the Jupyter Notebook to see what's within our JSON file.

Let's break the rows down slowly.

The restaurant ID uniquely defines every restaurant as:'''' Every id is associated with many rows describing a restaurant, like its brand, location, cuisine type, voucher acceptance, payment procedures, or delivery polygons.

In some rows, we get nested JSON objects like brand, location, supports, ratings, and shippingInfo. All these objects get 2nd-level JSON data having more data.

You could think about nested JSON objects like a tree in which one branch has many branches till you get the leaves.

What we will do here is filter the rows which we wanted with the given code.

By comparing column length with the full restaurants accessible on Lieferando's main page, we understand there are higher numbers of restaurants within the dataset. By having a ''uport'' row, we can observe that Boolean values for ''deliver'' represent True or False. We believe that we get Falses in our datasets; therefore, restaurants that don't deliver are included, so sellers filter that out.

What we would do here is to the will the ''uports' row as well as convert that row into a Pandas series entity that is a one-dimensional array. The apply technique applies a Pandas series function with every element in a row.

Within our 'delivery_is_true' object, we get all restaurant IDs with a True delivery value. We will utilize this list for filtering my whole dataset. And after that, we would repeat this exercise and crush out a 'location' row.

Now, we have values for city, country, street address, time zone, and coordinates for every restaurant ID.

We would repeat an exercise with rows' shippingInfo' and 'brand.' And inside 'brand,' we want a 'name' column, as well as within 'shippingInfo,' we would only filter columns: 'minOrderValue and 'deliveryFeeDefault.'

Now, we get Delivery Fees as well as Minimum Order Value for every Restaurant ID. These numbers being shown are like an integer. What we want is to convert it into a float.

We would now focus on all the objects processed in one Lieferando dataset.

Fantastic, so we get our complete listing of restaurants, addresses, delivery fees, and minimum order values. If we love to observe how much the share of a complete listing of restaurants is, we would need to turn both 'deliveryFeeDefault' and 'minOrderValue' by the counts of restaurants.

Depending on the given table, we understand that around 70% of the restaurants making deliveries to our addresses have 10 Euros minimum order value, and the delivery fees range from 0-5 Euros- most of which are in 4-5 Euros bucket. One factor getting calculated in delivery fees here is the distance between a restaurant and customers and the timing it would need to deliver.

Seeing that we get the coordinates for all the Lieferando restaurants, we could go one step further to plot it across Berlin.

To do that, we would require to initially convert latitude & longitude columns into a float as well as read a suitable shapefile for Berlin.

In addition, we would add the coordinates given below and show them as the red point.

Good! Now we get all restaurants visualized like orange dots, delivered to the address. Now let's authorize that the further the restaurants are from the customers, the higher the shipping fees would be. We could utilize

earlier insights which, at minimum, 70% of the restaurants delivering are within the range of 0–5 Euros, and make a function for applying any color to a scatter point depending on the delivery fees.

Wonderful! So we've established that the closer a restaurant is to the consumer, the lower the delivery fees would be. There are a few

exceptions where a restaurant is far away outside an inner city; however, the delivery fee is 0-3.99 Euros.

That's it for now! Happy Scraping!

For more information, contact Actowiz Solutions!

Hear It Directly from Our Clients

Watch how businesses like yours are using Actowiz data to drive growth.

▶

1 min

★★★★★

"Actowiz Solutions offered exceptional support with transparency and guidance throughout. Anna and Saga made the process easy for a non-technical user like me. Great service, fair pricing!"

Febbin Chacko

Small Business Owner

Fin

▶

2 min

★★★★★

"Actowiz delivered impeccable results for our company. Their team ensured data accuracy and on-time delivery. The competitive intelligence completely transformed our pricing strategy."

Javier Ibanez

Head of Analytics

atacy.es

▶

1:30

★★★★★

"What impressed me most was the speed — we went from requirement to production data in under 48 hours. The API integration was seamless and the support team is always responsive."

Rajesh Kumar

CTO

QComm Brand

⭐ 4.8/5 Average Rating

📹 50+ Video Testimonials

🔄 92% Client Retention

🌍 50+ Countries Served

AI Solutions Engineered
for Your Needs

→

LLM-Powered Attribute Extraction: High-precision product matching using large language models for accurate data classification.

→

Advanced Computer Vision: Fine-grained object detection for precise product classification using text and image embeddings.

→

GPT-Based Analytics Layer: Natural language query-based reporting and visualization for business intelligence.

→

Human-in-the-Loop AI: Continuous feedback loop to improve AI model accuracy over time.

🎯 Product Matching 🏷️ Attribute Tagging 📝 Content Optimization 💬 Sentiment Analysis 📊 Prompt-Based Reporting

Connect the Dots Across
Your Retail Ecosystem

We partner with agencies, system integrators, and technology platforms to deliver end-to-end solutions across the retail and digital shelf ecosystem.

Analytics Services

Ad Tech

Price Optimization

Business Consulting

System Integration

Market Research

Become a Partner →

Array ( [as_domain] => amazon.com [as_name] => Amazon.com, Inc. [asn] => AS16509 [continent] => North America [continent_code] => NA [country] => United States [country_code] => US )

Enterprise Data Extraction

AI Training Data

Analytics Dashboard

AI Dynamic Pricing

Social Commerce

Ready-to-Use Data

AI Training Data

Ready-Made Scrapers

API Playground

Case Studies

Sample Datasets

ROI Calculator

A Beginner's Guide to Analyzing Food Delivery Data Online

Feb 06, 2023

Trusted by Global Leaders Across Q-Commerce, Travel, Retail, and FoodTech

Hear It Directly from Our Clients

Join 3,000+ Companies Growing with Actowiz

Why Global Leaders Trust Actowiz

AI Solutions Engineeredfor Your Needs

Connect the Dots AcrossYour Retail Ecosystem

Popular Datasets — Ready to Download

Latest Insights & Resources

How IHG Hotels & Resorts Data Scraping Helps Overcome Real-Time Availability and Rate Monitoring Issues

UK Grocery Chain Achieves 300% ROI on Promotional Campaigns

Track UK Grocery Products Daily Using Automated Data Scraping to Monitor 50,000+ UK Grocery Products from Morrisons, Asda, Tesco, Sainsbury’s, Iceland, Co-op, Waitrose, Ocado

Start Where It Makes Sense for You

Our perks are irreplaceable

Time Zone Flexibility

Clear Communication

Uncompromising Quality

Our Affiliations

Request Free Sample Data

AI Solutions Engineered
for Your Needs

Connect the Dots Across
Your Retail Ecosystem