Python Spreadsheet Automation Demo

A simple Python project demonstrating spreadsheet automation using pandas.

Overview

This project shows how to:

• Read data from an Excel file (.xlsx)
• Process rows (e.g., convert names to uppercase)
• Save the results to a new Excel file

Setup

1. Create a virtual environment (recommended):

   python -m venv venv
   venv\Scripts\activate   # Windows

2. Install dependencies:

   pip install -r requirements.txt

Usage

1. Place your input data in data.xlsx (or use the included sample file)
2. Run the script:

   python main.py

3. Find the processed output in output.xlsx

Project Structure

.
├── main.py          # Main script
├── data.xlsx        # Input data (name, email columns)
├── output.xlsx     # Generated output (created on run)
├── requirements.txt
└── README.md

Requirements

• Python 3.8+
• pandas
• openpyxl (Excel engine for pandas)