- Zomato is an Indian restaurant aggregator and online food delivery company available in 24 countries. Here we have data about 8792 restaurants we want to extract some important information from it to improve business. There are many questions to ask about this data like Relation between restaurants that provides table & do not provide table? Top restaurant chains in Bangalore? and so on.
- Calculate Average Rating of each restaurant
- Get distribution of Rating column & try to find out what distribution this feature support?
- Top restaurant chains in Bengalore
- How many of the restaurant do not accept online orders?
- What is the ratio b/w restaurants that provide and do not provide table booking?
- How many types of restaurants we have?
- Highest voted restaurant
- Total restaurant at different locations of Bengalore
- Total number of variety of restaurants ie north indian,south Indian
- Analyse Approx cost for 2 people
- Cost vs Rating
- Is there any difference b/w votes of restaurants accepting and not accepting online orders?
- Is there any difference b/w price of restaurants accepting and not accepting online orders?
- Distribution of cost for 2 people
- Top 10 Most Expensive restaurant with approx cost for 2 people
- Top 10 Cheapest restaurant with approx cost for 2 people
- All the restautant that are below than 500(budget hotel)
- Restaurants that have better rating >4 and that are under budget too
- Total numbers of Restaurants that have better rating >4 and that are under budget too ie less than 500
- Total such various affordable hotels at different location
- Which are the foodie areas?
- Geographical Analysis