# Best LLMs for Data Analysis in 2026

> AI models ranked for data analysis — quantitative reasoning, discrete reasoning over text, and analysis-code generation.

Data analysis stresses a specific blend: quantitative accuracy (MATH-500, AIME), discrete reasoning over messy source material (DROP, BBH), and writing correct analysis code (LiveCodeBench). This reporting family weights those benchmarks to rank models for spreadsheet work, statistics, SQL and pandas generation, and interpreting results without arithmetic slips.

Canonical page: https://benchlm.ai/best/data-analysis

Last updated: September 29, 2026

## Rankings

| Rank | Model | Creator | Type | Context | Score |
|------|-------|---------|------|---------|-------|
| 1 | [Ternary Bonsai 2 27B](/models/ternary-bonsai-2-27b) | Prism ML | Open Weight | 262K | 97.9 |
| 2 | [MiniCPM5-2B](/models/minicpm5-2b) | OpenBMB | Open Weight | 131K | 92.6 |
| 3 | [GLM-4.7](/models/glm-4-7) | Z.AI | Open Weight | 200K | 88.5 |
| 4 | [MiniCPM5-1B](/models/minicpm5-1b) | OpenBMB | Open Weight | 131K | 77.4 |
| 5 | [LFM2.5-8B-A1B](/models/lfm2-5-8b-a1b) | LiquidAI | Open Weight | 128K | 77.2 |
| 6 | [Soofi S 30B-A3B](/models/soofi-s-30b-a3b) | Soofi Project | Open Weight | 1M | 70.6 |

## Key Takeaways

- Top model: [Ternary Bonsai 2 27B](/models/ternary-bonsai-2-27b) with a score of 97.9
- Best open-weight option: [Ternary Bonsai 2 27B](/models/ternary-bonsai-2-27b) at #1
- Models included: 6

## Compare the Leaders

- [Ternary Bonsai 2 27B vs MiniCPM5-2B](/compare/minicpm5-2b-vs-ternary-bonsai-2-27b)