Food Menu Analysis

Project Overview

This project analyzes a food menu dataset using Python, Pandas, NumPy, and OpenPyXL. It categorizes menu items, calculates nutritional summaries, performs category-wise analysis, and exports the cleaned dataset to an Excel file.

Technologies Used

• Python
• Pandas
• NumPy
• OpenPyXL

Features

• Creates a structured food menu dataset
• Displays statistical summary using describe()
• Filters items by category
• Calculates category-wise totals
• Computes overall totals for:
  • Price
  • Protein
  • Calories
• Generates category summary using groupby()
• Creates indicator columns using NumPy
• Exports cleaned data to Excel

Categories Included

• Fried Chicken
• Burgers
• Rice & Rolls
• Sides
• Beverages
• Desserts
• Snacks/Popcorn

Output

The cleaned dataset is exported as:

food_data_cleaned.xlsx

Author

Rina Mohan B.E-Electronics and Communication Engineering Aspiring software engineer