Online Food Orders Analysis with Python

In this project, we aim to analyze a dataset titled "Online Food Orders Analysis with Python."
The dataset contains information about online food orders, including details such as order ID,
customer ID, order date, order time, items ordered, quantity, price, and delivery information. We
will use Python and various data analysis libraries to explore, visualize, and derive insights from
the dataset.

Import Library
In [1]: import pandas as pd

In [2]: import pandas as pd

import seaborn as sns
import matplotlib.pyplot as plt
import seaborn as sns

C:\Users\Syed Arif\anaconda3\lib\site-packages\scipy\__init__.py:146: UserWar

ning: A NumPy version >=1.16.5 and <1.23.0 is required for this version of Sc
iPy (detected version 1.25.1
warnings.warn(f"A NumPy version >={np_minversion} and <{np_maxversion}"

Uploading Csv fle

In [3]: df = pd.read_csv(r"C:\Users\Syed Arif\Desktop\onlinefoods.csv")

Data Preprocessing

.head()
head is used show to the By default = 5 rows in the dataset
In [4]: df.head()

Out[4]:
Marital Monthly Educational Family Pin
Age Gender Occupation latitude longitude
Status Income Qualifications size code

No
0 20 Female Single Student Post Graduate 4 12.9766 77.5993 560001
Income

Below
1 24 Female Single Student Graduate 3 12.9770 77.5773 560009
Rs.10000

Below
2 22 Male Single Student Post Graduate 3 12.9551 77.6593 560017
Rs.10000

No
3 22 Female Single Student Graduate 6 12.9473 77.5616 560019
Income

Below
4 22 Male Single Student Post Graduate 4 12.9850 77.5533 560010
Rs.10000

.tail()
tail is used to show rows by Descending order

In [5]: df.tail()

Out[5]:
Marital Monthly Educational Family
Age Gender Occupation latitude longitude
Status Income Qualifications size co

No
383 23 Female Single Student Post Graduate 2 12.9766 77.5993 5600
Income

No
384 23 Female Single Student Post Graduate 4 12.9854 77.7081 5600
Income

No
385 22 Female Single Student Post Graduate 5 12.9850 77.5533 5600
Income

Below
386 23 Male Single Student Post Graduate 2 12.9770 77.5773 5600
Rs.10000

No
387 23 Male Single Student Post Graduate 5 12.8988 77.5764 5600
Income

.shape
It show the total no of rows & Column in the dataset

In [6]: df.shape

Out[6]: (388, 13)

 .Columns
It show the no of each Column

In [7]: df.columns

Out[7]: Index(['Age', 'Gender', 'Marital Status', 'Occupation', 'Monthly Income',

'Educational Qualifications', 'Family size', 'latitude', 'longitude',
'Pin code', 'Output', 'Feedback', 'Unnamed: 12'],
dtype='object')

.dtypes
This Attribute show the data type of each column

In [8]: df.dtypes

Out[8]: Age int64

Gender object
Marital Status object
Occupation object
Monthly Income object
Educational Qualifications object
Family size int64
latitude float64
longitude float64
Pin code int64
Output object
Feedback object
Unnamed: 12 object
dtype: object

.unique()
In a column, It show the unique value of specific column.

In [10]: df["Monthly Income"].unique()

Out[10]: array(['No Income', 'Below Rs.10000', 'More than 50000', '10001 to 25000',
'25001 to 50000'], dtype=object)

.nuique()
It will show the total no of unque value from whole data frame
In [11]: df.nunique()

Out[11]: Age 16
Gender 2
Marital Status 3
Occupation 4
Monthly Income 5
Educational Qualifications 5
Family size 6
latitude 77
longitude 76
Pin code 77
Output 2
Feedback 2
Unnamed: 12 2
dtype: int64

.describe()
It show the Count, mean , median etc

In [12]: df.describe()

Out[12]:
Age Family size latitude longitude Pin code

count 388.000000 388.000000 388.000000 388.000000 388.000000

mean 24.628866 3.280928 12.972058 77.600160 560040.113402

std 2.975593 1.351025 0.044489 0.051354 31.399609

min 18.000000 1.000000 12.865200 77.484200 560001.000000

25% 23.000000 2.000000 12.936900 77.565275 560010.750000

50% 24.000000 3.000000 12.977000 77.592100 560033.500000

75% 26.000000 4.000000 12.997025 77.630900 560068.000000

max 33.000000 6.000000 13.102000 77.758200 560109.000000

.value_counts
It Shows all the unique values with their count

In [13]: df["Monthly Income"].value_counts()

Out[13]: No Income 187

25001 to 50000 69
More than 50000 62
10001 to 25000 45
Below Rs.10000 25
Name: Monthly Income, dtype: int64
 .isnull()
It shows the how many null values

In [14]: df.isnull()

Out[14]:
Marital Monthly Educational Family Pi
Age Gender Occupation latitude longitude
Status Income Qualifications size cod

0 False False False False False False False False False Fals

1 False False False False False False False False False Fals

2 False False False False False False False False False Fals

3 False False False False False False False False False Fals

4 False False False False False False False False False Fals

... ... ... ... ... ... ... ... ... ... .

383 False False False False False False False False False Fals

384 False False False False False False False False False Fals

385 False False False False False False False False False Fals

386 False False False False False False False False False Fals

387 False False False False False False False False False Fals

388 rows × 13 columns

In [15]: sns.heatmap(df.isnull())

Out[15]: <AxesSubplot:>

In [17]: df['Occupation'].value_counts().plot(kind = 'pie' , title = 'Pie Chart for gend

autopct="%.0f%%", colormap='nipy_spectral_r')

Out[17]: <AxesSubplot:title={'center':'Pie Chart for gender'}, ylabel='Occupation'>

In [19]: plt.figure(figsize=(8, 6))
sns.countplot(data=df, x='Gender')
plt.xlabel('Gender')
plt.ylabel('Distribuation')
plt.title('Distribuation of Gender')
plt.show()
In [20]: plt.figure(figsize=(8, 6))
sns.countplot(data=df, x='Gender', hue ="Occupation")
plt.xlabel('Gender')
plt.ylabel('Occupation')
plt.title('Gender Vise Occupation')
plt.show()
In [21]: plt.figure(figsize=(8, 6))
sns.countplot(data=df, x='Marital Status')
plt.xlabel('Marital Status')
plt.ylabel('Marital Status')
plt.title('Distribuation of Material Status')
plt.show()
In [22]: # Group the data by Feedback and calculate the count of each category
feedback_counts = df.groupby('Feedback').size()
​
# Create a pie chart
plt.figure(figsize=(8, 8))
plt.pie(feedback_counts, labels=feedback_counts.index, autopct='%1.1f%%', start
plt.title('Distribution of Feedback')
plt.axis('equal') # Equal aspect ratio ensures that pie is drawn as a circle.
plt.show()
In [23]: plt.figure(figsize=(8, 6))
sns.countplot(data=df, x='Occupation', hue ="Feedback")
plt.xlabel('Occupation')
plt.ylabel('Feedback')
plt.title('Occupation Vise Feedback')
plt.show()
In [25]: plt.figure(figsize=(8, 6))
sns.countplot(data=df, x='Monthly Income')
plt.xlabel('Monthly Income')
plt.ylabel('Educational Qualifications')
plt.title('Distribuation of Monthly Income')
plt.show()