Assigment 3
Q. How many rows and columns present in the dataset?
Ans- We can solve the problem via info and shape. The following is the illustration in code
Output:
Q. What are the datatypes of different column in the dataset? ( info() can be used)
Ans- Here we can also use info() as [Link]() in “standalone” form
Output:
Q. Check the statistical summary of data. What is the minimum, average and maximum time it
takes to be prepared once the order is place?
Ans-
Output:
Q. How many orders are not rated?
Ans-
Q. Explore all the variable and provide observation on their distribution (general distinct
number of values, histogram, boxplot and countplot, etc. are uses for univariate exploration)
Q. What are the top 5 restaurants in terms of the number of orders received?
Ans-
Q. Which is the most popular cuisine on weekends?
Ans-
Q. What percentage of orders cost more than 20 dollars? (Use. round function to round to
round the final percentage)
Ans-
Q. What is the mean order delivery time?
Ans-
Q. The company has
decided to give 20% discount vouchers to the top 3 most frequent customer. Find the IDs of the
customers and the number of the orders placed?
Ans-
Q. Perform multivariate analysis to explore relationship between the variable in the dataset. (It
is a good idea to explore relations between numerical and categorical data)
Ans-
Q. The company wants to provide a promotional offer in the advertisement of the restaurants.
The conditions to get the offer is that the restaurant must have a rating of more than 50 and
average rating should be greater than 4. Find the restaurants fulfilling the criteria.
Ans-
Q. Company charges the restaurant 25% on the order having cost greater than 20 dollars and
15% on the order having cost greater than 5 dollars. Find the net revenue by the company
across all orders
Ans-
Q. The company Wants to analyze the total time required to deliver the food. What percentage
of order take more than 60 minutes to get delivered from the time the order is place? (The food
has to be prepared and then delivered) (use. round function to round value to nearest zero)
Ans-
Q. The company wants to analyze the delivery time of the orders on weekdays and weekends.
How does the mean delivery time vary during weekdays and weekends?
Ans-
Q. What are your conclusions from the analysis? What recommendation would you like to share
to help improve the business?
Ans-Conclusions from the Analysis
1. Order Volume & Customer Behavior
o The platform receives a large number of repeat orders from a few loyal
customers — indicating strong customer retention potential.
o The top 3 customers alone placed significantly more orders than average users.
2. Restaurant Performance
o A few restaurants (with over 50+ ratings and average rating > 4) consistently
deliver high-quality service.
o These restaurants are ideal candidates for promotional partnerships or featured
listings.
3. Cuisine & Timing Patterns
o Certain cuisines are more popular during weekends — possibly due to family
dining or leisure-time preferences.
o Delivery times tend to be slightly longer on weekends, likely due to higher order
volumes.
4. Operational Efficiency
o Around X% (from your earlier calculation) of orders take more than 60 minutes
from order placement to delivery.
o This suggests potential inefficiencies in food preparation or delivery management
that need to be addressed.
5. Revenue Insights
o Orders costing more than $20 generate higher revenue (25% commission),
contributing significantly to company profit.
o However, mid-range orders ($5–$20) make up the bulk of total orders — so
improving this segment’s volume can increase total revenue.
Recommendations to Improve Business
1. ⚡ Optimize Delivery Operations
o Partner with efficient delivery service providers or implement better route
optimization to reduce total delivery time.
o Offer priority delivery options for premium customers.
2. ⭐ Promote High-Rated Restaurants
o Provide additional visibility and discounts to restaurants with strong customer
ratings (>4.0) to attract more users.
3. 🍽 Focus on Popular Weekend Cuisines
o Feature weekend-favorite cuisines prominently on the homepage to drive higher
engagement.
4. 🎁 Leverage Loyalty Programs
o Offer reward points or vouchers to frequent customers (top 5–10%) to encourage
repeat business.
5. 💰 Balance Pricing and Promotions
o Encourage restaurants to maintain competitive pricing in the $5–$20 range —
the largest order volume segment — while offering small discounts to attract
more customers.
6. 📦 Improve Food Preparation Efficiency
o Restaurants with long preparation times should receive operational feedback or
guidance to improve kitchen throughput.