A small Python application will take an Excel file (.xlsx) as input, allowing users to specify which rows and columns to update. The application will then modify the specified cells based on user input or predefined rules. Additionally, it will analyze the data to create a visually appealing graph (e.g., bar chart, line chart, or pie chart) that highlights key trends or insights. The updated data and graph will be saved to a new Excel sheet within the same file, preserving the original data while adding the enhancements to a new tab. The application will use popular libraries like pandas for data manipulation and openpyxl for creating charts and managing Excel files."
Description
A small Python application will take an Excel file (.xlsx) as input, allowing users to specify which rows and columns to update. The application will then modify the specified cells based on user input or predefined rules. Additionally, it will analyze the data to create a visually appealing graph (e.g., bar chart, line chart, or pie chart) that highlights key trends or insights. The updated data and graph will be saved to a new Excel sheet within the same file, preserving the original data while adding the enhancements to a new tab. The application will use popular libraries like pandas for data manipulation and openpyxl for creating charts and managing Excel files."
[Arshmah Saeed]