| name | skill-076 |
| description | Automated report generation tool for creating and formatting reports in Excel format, enabling seamless presentation of data insights. |
| license | Proprietary. LICENSE.txt has complete terms |
Requirements for Outputs
General Reporting Standards
Report Structure
- Each report must have a clear and consistent structure including a cover page, table of contents, and clearly defined sections.
Data Visualization Standards
- Use appropriate charts (bar, line, pie) depending on the data being represented.
- Ensure that all visuals have titles and legends where applicable.
Report Generation Techniques
Automated Chart Creation
- Use libraries to automatically generate charts based on input data.
- Example code snippet:
import pandas as pd
import matplotlib.pyplot as plt
def generate_chart(data):
plt.bar(data['categories'], data['values'])
plt.title('Sample Chart')
plt.savefig('chart.png')
Formatting Reports
- Apply consistent formatting styles to fonts, colors, and layouts across all pages.
- Example code snippet:
def format_report(sheet):
sheet['A1'].font = Font(bold=True, size=14)
sheet['A1'].fill = PatternFill(start_color='FFFF00', end_color='FFFF00', fill_type='solid')
Exporting Reports
- Ensure reports are saved in multiple formats (e.g., .xlsx, .pdf) for ease of sharing.
- Example code snippet:
from openpyxl import Workbook
wb = Workbook()
wb.save('report.xlsx')
Documentation Requirements
Report Metadata
- Each report must include a header with the report title, author, and date of generation.
- Example: "Generated by [Author Name] on [Date]".
Version Control
- Maintain version control to track changes made during report iterations.
