Start with the data we have
I checked the dataset’s size, field types, and rating completeness before comparing demand or performance.
Data preparation decision
There are no literal nulls in the CSV. I counted 736 “Not given” ratings and kept them missing in the analysis. I don’t replace them with an average because that would create ratings customers never submitted and could distort restaurant averages.
Explore each variable on its own
Order counts show where demand sits. Histograms and boxplots show the spread, typical range, and unusual values in cost and timing.
Order frequency by restaurant
Order cost distribution
Ratings as recorded
Food preparation time
Delivery time
Time spread at a glance
Compare variables together
These views show how order mix, prices, ratings, and time measures vary across groups. Small cuisine samples need extra caution.
Cuisine demand by day
Order price by cuisine
Preparation time by recorded rating
Delivery time by day
Preparation and delivery window
Mean delivery time by cuisine
Answers for the business
The requested figures, recalculated directly from the CSV and using the stated definitions.
What I would take forward
The conclusions keep the original direction while separating what the data shows from what should be tested.
Recommendations
Reduce or adjust weekday delivery fees in a controlled promotion to encourage orders on slower days. Compare order lift, average order value, and delivery time with a baseline before expanding.
Try featuring less-frequented restaurants on weekdays, while making the most popular cuisines easy to find during busy periods. Track whether the placement brings new orders rather than shifting existing ones.
There are many restaurants with 20 or fewer orders. Look into discoverability, menu availability, pricing, and customer feedback before deciding which support would help.
Follow up after delivery with a simple rating prompt. Monitor the response rate and the share of low ratings so missing feedback is not mistaken for positive feedback.
Explore the complete dataset
All 1,898 source rows are packaged in this file. Search or filter the table, then export the data.
| Order ID | Customer ID | Restaurant | Cuisine | Cost | Day | Rating | Prep (min) | Delivery (min) |
|---|
The supplied CSV has 1,898 rows and 9 columns. “Not given” is a missing-rating marker. It remains separate from scores for every rating count, average, and promotion check.
Applied 25% to order costs above $20 and 15% to order costs above $5 through $20. This is modeled commission, not profit; it excludes other expenses and revenue sources.