Provides both English and Chinese versions of the raw data and prompts
Utilizes CodeExecutionToolkit, ExcelToolkit, and FileWriteToolkit to complete related tasks
Implements ExcelRolePlaying based on OwlRolePlaying, which overrides the system_prompt with a cleaner, more focused version tailored for data analysis scenarios
tested using gpt-4o and deepseek-v3
The analysis and visualization of this Excel file involve:
- Complex headers (merged rows)
- Nan value handling
- Complex group calculations
- Visualization

How to Use

Set up the environment according to Owl's official instructions

Run the following commands:

cd community_usecase/excel_analyzer

# Chinese version, using deepseek-v3
python excel_analyzer_zh.py

# English version, using gpt-4o
python excel_analyzer_zh.py

The analysis results will be saved in the current directory