Sales Automation

About   |   Technologies   |   Requirements   |   Execution   |   License   |   Author

🎯 About

This project consists of a script for automating processes related to store sales indicators. It reads data from Excel and CSV files, performs data analysis and operations, and sends emails with the results.

• pandas: For data manipulation and analysis.
• pathlib: For handling file and directory paths.
• smtplib and email.* modules: For sending emails with the results.
• os: For operating system-related operations.

📝 IDE and Python Version

• Python 3.8+
• Jupyter Notebook

📝 Installations

1. Install Python:

   • Visit Python Downloads and download the recommended version.
   • Follow the installer instructions. Make sure to check the "Add Python to PATH" option during installation.

2. Install Jupyter Notebook:

   • Open the terminal or command prompt and run:

     pip install jupyter
     

3. Install Required Libraries:

   • In the terminal or command prompt, install the necessary libraries for this project:

     pip install pandas
     

🚀 Technologies

The following tools were used in this project:

• Python
• Jupyter
• Anaconda

✅ Requirements

Before starting 🏁, you need to have Git and Python installed.

🏁 Execution

1. Clone this repository or download the files.

2. Open Jupyter Notebook by navigating to the project directory and running:

   jupyter notebook
   

3. In the browser, open the Automacao de Processo.ipynb file.

4. Inside Jupyter Notebook, navigate to the cell you want to execute and press Shift+Enter.

5. Follow the instructions in the markdown cells and execute the code cells in order.

📝 Notes

• Databases: Contains the data files used for analysis.
• Backup Store Files: Contains backups or files related to the stores.

📝 License

This project is licensed under the MIT License. For more details, check the LICENSE file.

Made with ❤️ by gsoaresdz

 

Back to top