Project Description

DataAnalisys is a simple Python project to analyze monthly sales data from a CSV file (Sales.csv).
It uses pandas for data processing and provides summaries such as total sales per month, best-selling product, and product with the highest revenue.

Features

• Cleans and preprocesses sales data (price formatting, date parsing)
• Calculates monthly sales totals
• Identifies:
  • Product with the most units sold
  • Product with the highest income generated

Getting Started

1. Place your sales CSV file as Sales.csv in the project folder.
   The file is expected to contain at least the columns:
   • fecha (date in day/month/year format)
   • cantidad (units sold)
   • producto (product name)
   • precio (price with possible spaces, $ signs, commas, or dots)
2. Install the required Python package:

   pip install -r requirements.txt
   

3. Run the analysis script:

   python analisis.py
   

Output Examples

• Prints monthly sales totals to the console
• Reports which product sold the most (quantity)
• Reports which product generated the most revenue

File Structure

DataAnalisys/
├── analisis.py
├── Sales.csv
├── .gitignore
└── README.md

Notes

• The script expects certain column formats; adjust analisis.py if your data deviates.
• The virtual environment folder (venv/) is excluded via .gitignore.
• This project is for basic exercise/educational purposes.

Author

Created by Fernando Daniel Jaime