Skip to content

README.md

Latest commit

 

History

History
42 lines (35 loc) · 956 Bytes

README.md

File metadata and controls

42 lines (35 loc) · 956 Bytes
Raw

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