SO IN THIS POST, I AM GOING TO EXPLAIN EDA ON FOOD ORDER ANALYSIS.
SUPPOSE YOU ARE WORKING IN SOME XYZ COMPANY AS DATA SCIENTIST OR DATA ANALYST.
YOUR MANAGER COMES TO YOU AND GIVE YOU SOME QUESTIONS AND DATA. AND TELL YOU TO FIND ANSWER OF THOSE QUESTION FROM THAT DATA.
SUPPOSE THE DATA GIVEN BY MANAGER IS THIS :
CLICK ON THIS LINK TO DOWNLOAD THE DATA.
AND THE QUESTIONS ARE :
question 1: what most people prefer? seating in the restaurant to eat or take it home?
question 2: The number of orders received in this month by Day. example(Monday -> 10,Friday -> 200)
question 3: find out the avg order per day.
question 4: what quantity of food mostly customers prefer?
question 5: which type of food people prefer most? (breakfast, salad, etc)
question 6: on which week do we have a very high no of orders?
question 7: no of order serve by each server. who is the most active server? and who is not active at all?
STEP 1: FIRST WE HAVE TO IMPORT ALL REQUIRED LIBRARY :
import pandas as pdimport numpy as npimport seaborn as snsimport matplotlib.pyplot as plt
STEP 2: LOAD THE DATASET
data = pd.read_csv('Data.csv')
I won't be able to explain everything in the post. so I created a video for the same.