How mo-ramezanpour/merging-excel-files works
Main Components
• Data Sources: Represented by the three input Excel files (Ireland.xlsx, Japan.xlsx, Norway.xlsx). These files are the raw data source.
• Data Ingestion/Processing Module: This is the core of the application - encapsulated in Sales.py. It reads data from the Excel files, converts them into pandas DataFrames, and performs operations such as adding new columns (month, year, percentage calculations, etc.), concatenating the data, and formatting.
• Transformation and Calculation: Within Sales.py, you have multiple transformation steps such as format conversion for sales numbers, calculation of totals and percentages, and adding additional columns (e.g., total monthly sales).
• Data Output Module: The final step in the process writes the combined and transformed DataFrame to a new Excel file (Total_Sales.xlsx).
Relationships and Interactions
• Internal Processes: Within Sales.py, break down the workflow to show sequential transformations – data reading, data transformation (column additions, conversions, calculations), and final output writing.
• Use components such as blocks for “Data Ingestion”, “Data Transformation”, and “Data Output” to clearly show the process.
Architectural Patterns
• Data Pipeline Pattern: The design mimics a data pipeline where each stage processes the data further until the output is produced.
Relevant Technologies
• Python as the programming language.
• pandas for data reading, manipulation, and writing.
• Excel files as the data source and output format.
• Additional dependencies or libraries if they are used (e.g., numpy), though pandas is the primary one mentioned in the README.