anujkumar8076 Spreadsheet Skill
Work with Excel workbooks and CSV data.
Setup
pip install openpyxl pandas
Creating a workbook
Build with openpyxl: create a workbook, write header row, append data rows, apply number formats, then save as .xlsx.
Analyzing CSV data
Load with pandas, report shape and dtypes first, then run the analysis the user asked for. Show intermediate results for anything non-obvious.
Data cleanup
Normalize column names, trim whitespace, coerce types explicitly, and report how many rows were affected by each cleanup step.
Output format
Save as .xlsx unless the user asked for CSV. Summarize what changed.