NLData2Opt: Benchmarking Parameter Derivation and Prediction for Modeling Optimization Problems from Natural Language and Data
Organizations: Kyoto University · Hokkaido University · Recruit Co., Ltd.
Abstract
Formulating optimization problems from raw inputs of problem descriptions and data is time-consuming and costly. While Large Language Models (LLMs) offer a promising way to automate this process, existing benchmarks overestimate their capabilities by relying on idealized inputs where all data is relevant and complete. This diverges from reality, where data-centric reasoning is required to extract, compute, and predict parameters from noisy sources. To address this, we introduce NLData2Opt, a benchmark to evaluate LLMs on the multi-stage reasoning inherent in practical optimization workflows. NLData2Opt decomposes problems into problem descriptions and data, and requires models to (1) extract relevant parameters from data containing misleading attributes, (2) compute missing parameters derived by transforming existing data attributes, and (3) predict unavailable future values from historical observations. Evaluation results show substantial performance decline relative to existing benchmarks, indicating that benchmark progress does not directly translate to formulation accuracy in practical optimization workflows. NLData2Opt is available at https://github.com/sumarivyn/NLData2Opt.
Figures & tables
Appendix figures & tables19 assets
Supplementary material from the paper’s appendix.
Appendix
| Simple Forecasting | Oracle Prediction | LLM | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Case | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| One-Variable | 0.8665 | 0.6144 | 0.5377 | 0.8654 | 0.7305 | 0.5858 | 0.8836 | 0.7357 | 0.5572 |
| One-Variable + Irr | 0.8551 | 0.4796 | 0.4655 | 0.8436 | 0.6538 | 0.5018 | 0.8441 | 0.5331 | 0.4602 |
| Multi-Variable | 0.8739 | 0.5810 | 0.5552 | 0.8643 | 0.6257 | 0.5886 | 0.8626 | 0.6225 | 0.5300 |
| Multi-Variable + Irr | 0.8424 | 0.4972 | 0.4482 | 0.8325 | 0.5898 | 0.4769 | 0.8683 | 0.6393 | 0.4671 |
| Simple Forecasting | Oracle Prediction | LLM | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Case | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| One-Variable | 0.8968 | 0.2213 | 0.5390 | 0.8548 | 0.2224 | 0.6043 | 0.3788 | 0.2386 | 0.5368 |
| One-Variable + Irr | 0.9208 | 0.1671 | 0.4878 | 0.8765 | 0.1945 | 0.4716 | 0.4259 | 0.2555 | 0.4443 |
| Multi-Variable | 0.9535 | 0.2229 | 0.5239 | 0.8582 | 0.2798 | 0.5830 | 0.3837 | 0.2680 | 0.5522 |
| Multi-Variable + Irr | 0.8714 | 0.1512 | 0.4692 | 0.8500 | 0.1533 | 0.4833 | 0.3419 | 0.2071 | 0.4434 |
| Simple Forecasting | Oracle Prediction | LLM | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Case | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| One-Variable | 0.8756 | 0.0962 | 0.4874 | 0.8007 | 0.1847 | 0.5626 | 0.3486 | 0.1824 | 0.4932 |
| One-Variable + Irr | 0.8004 | 0.0733 | 0.4308 | 0.8046 | 0.0999 | 0.4493 | 0.1557 | 0.1180 | 0.4176 |
| Multi-Variable | 0.8087 | 0.1387 | 0.5107 | 0.8681 | 0.2397 | 0.5739 | 0.4154 | 0.2825 | 0.5045 |
| Multi-Variable + Irr | 0.6693 | 0.1066 | 0.4305 | 0.7159 | 0.1425 | 0.4543 | 0.2925 | 0.2008 | 0.3960 |
| Model/Method | NLP4LP | Mamo E. | Mamo C. |
|---|---|---|---|
| GPT-4o-mini | 0.000 | 0.000 | 0.000 |
| GPT-4o | 0.425 | 0.367 | 0.467 |
| Gemini-2.5-Pro | 0.000 | 0.067 | 0.000 |
| Claude Haiku 4.5 | 0.600 | 0.587 | 0.593 |
| Claude Sonnet 4.6 | 0.573 | 0.533 | 0.307 |
| Claude Opus 4.6 | 0.567 | 0.547 | 0.440 |
| One-variable | Multiple-variables | |||||||
| Standard | Irr. attributes | Standard | Irr. attributes | |||||
| Model/Method | EM | SC | EM | SC | EM | SC | EM | SC |
| GPT-4o Mini | 0.433 | 0.779 | 0.322 | 0.711 | 0.371 | 0.526 | 0.287 | 0.506 |
| GPT-4o | 0.611 | 0.892 | 0.400 | 0.845 | 0.408 | 0.560 | 0.258 | 0.511 |
| Gemini 2.5 Pro | 0.078 | 0.219 | 0.022 | 0.125 | 0.102 | 0.146 | 0.069 | 0.107 |
| Claude Haiku 4.5 | 0.556 | 0.972 | 0.478 | 0.961 | 0.603 | 0.744 | 0.521 | 0.718 |
| Case | Compilation Success | Exact Match Rate | Syntax Error | Structural Error |
|---|---|---|---|---|
| NL | 51% | 23% | 11% | 43% |
| NL + Data | 45% | 22% | 24% | 46% |
| NL + Data + Irr | 48% | 25% | 16% | 46% |
| Derivation | 42% | 8% | 20% | 50% |
| Derivation + Irr | 43% | 10% | 12% | 49% |
| Prediction (1-Var) | 37% | 7% | 17% | 54% |
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.582 | 0.818 | 0.729 | 0.867 | 0.809 | 0.130 | |||
| GPT-4o | 0.968 | 0.150 | 0.687 | 0.767 | 0.870 | 0.468 | |||
| Gemini 2.5 Pro | 0.413 | 0.000 | 0.370 | 0.000 | 0.301 | 0.000 | |||
| Claude Haiku 4.5 | 0.588 | 0.702 | 0.825 | 0.845 | 0.865 | 0.619 | |||
| Claude Sonnet 4.6 | 0.880 | 0.450 | 0.850 | 0.600 | 0.905 | 0.616 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.931 | 0.400 | 0.700 | 0.345 | 0.876 | 0.393 | |||
| GPT-4o | 0.940 | 0.150 | 0.670 | 0.639 | 0.887 | 0.612 | |||
| Gemini 2.5 Pro | 0.427 | 0.000 | 0.239 | 0.000 | 0.327 | 0.000 | |||
| Claude Haiku 4.5 | 0.896 | 0.733 | 0.734 | 0.753 | 0.872 | 0.630 | |||
| Claude Sonnet 4.6 | 0.945 | 0.290 | 0.670 | 0.553 | 0.879 | 0.794 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.737 | 0.266 | 0.600 | 0.490 | 0.811 | 0.336 | |||
| GPT-4o | 0.723 | 0.627 | 0.627 | 0.513 | 0.801 | 0.385 | |||
| Gemini 2.5 Pro | 0.879 | 0.273 | 0.635 | 0.219 | 0.800 | 0.032 | |||
| Claude Haiku 4.5 | 0.824 | 0.613 | 0.667 | 0.697 | 0.875 | 0.551 | |||
| Claude Sonnet 4.6 | 0.861 | 0.223 | 0.701 | 0.284 | 0.876 | 0.678 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.901 | 0.259 | 0.637 | 0.151 | 0.730 | 0.132 | |||
| GPT-4o | 0.913 | 0.125 | 0.609 | 0.328 | 0.792 | 0.416 | |||
| Gemini 2.5 Pro | 0.378 | 0.000 | 0.222 | 0.000 | 0.282 | 0.000 | |||
| Claude Haiku 4.5 | 0.782 | 0.542 | 0.696 | 0.560 | 0.818 | 0.438 | |||
| Claude Sonnet 4.6 | 0.864 | 0.289 | 0.646 | 0.215 | 0.845 | 0.542 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.672 | 0.194 | 0.499 | 0.190 | 0.654 | 0.048 | |||
| GPT-4o | 0.685 | 0.444 | 0.537 | 0.283 | 0.695 | 0.275 | |||
| Gemini 2.5 Pro | 0.914 | 0.128 | 0.708 | 0.025 | 0.800 | 0.033 | |||
| Claude Haiku 4.5 | 0.766 | 0.510 | 0.653 | 0.478 | 0.827 | 0.357 | |||
| Claude Sonnet 4.6 | 0.795 | 0.225 | 0.561 | 0.276 | 0.851 | 0.426 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.326 | 0.240 | 0.399 | 0.385 | 0.442 | 0.204 | |||
| GPT-4o | 0.676 | 0.554 | 0.546 | 0.548 | 0.710 | 0.404 | |||
| Gemini 2.5 Pro | 0.405 | 0.322 | 0.297 | 0.293 | 0.113 | 0.038 | |||
| Claude Haiku 4.5 | 0.891 | 0.355 | 0.709 | 0.473 | 0.902 | 0.629 | |||
| Claude Sonnet 4.6 | 0.769 | 0.164 | 0.712 | 0.557 | 0.844 | 0.602 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.423 | 0.247 | 0.330 | 0.298 | 0.451 | 0.257 | |||
| GPT-4o | 0.670 | 0.480 | 0.527 | 0.585 | 0.754 | 0.410 | |||
| Gemini 2.5 Pro | 0.330 | 0.065 | 0.242 | 0.268 | 0.024 | 0.035 | |||
| Claude Haiku 4.5 | 0.800 | 0.401 | 0.684 | 0.422 | 0.851 | 0.504 | |||
| Claude Sonnet 4.6 | 0.751 | 0.317 | 0.716 | 0.493 | 0.854 | 0.694 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.334 | 0.283 | 0.323 | 0.298 | 0.461 | 0.242 | |||
| GPT-4o | 0.776 | 0.596 | 0.531 | 0.538 | 0.711 | 0.447 | |||
| Gemini 2.5 Pro | 0.410 | 0.199 | 0.245 | 0.184 | 0.137 | 0.000 | |||
| Claude Haiku 4.5 | 0.879 | 0.630 | 0.632 | 0.394 | 0.907 | 0.467 | |||
| Claude Sonnet 4.6 | 0.842 | 0.328 | 0.622 | 0.493 | 0.853 | 0.598 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Model/Method | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| GPT-4o Mini | 0.397 | 0.264 | 0.250 | 0.181 | 0.292 | 0.140 | |||
| GPT-4o | 0.743 | 0.569 | 0.492 | 0.510 | 0.711 | 0.471 | |||
| Gemini 2.5 Pro | 0.300 | 0.206 | 0.192 | 0.130 | 0.090 | 0.034 | |||
| Claude Haiku 4.5 | 0.778 | 0.599 | 0.610 | 0.345 | 0.825 | 0.389 | |||
| Claude Sonnet 4.6 | 0.803 | 0.253 | 0.683 | 0.429 | 0.773 | 0.605 | |||
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Case | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| NL | 0.5488 | 0.7231 | 0.4190 | 0.7933 | 0.7517 | 0.6199 | 0.8062 | 0.7066 | 0.6224 |
| NL + Data | 0.8342 | 0.7080 | 0.6033 | 0.7268 | 0.6463 | 0.5453 | 0.8319 | 0.7241 | 0.6148 |
| NL + Data + Irr | 0.7640 | 0.5451 | 0.3848 | 0.7143 | 0.5813 | 0.4926 | 0.8550 | 0.7068 | 0.5743 |
| Derivation | 0.7589 | 0.5547 | 0.4595 | 0.6676 | 0.3369 | 0.3955 | 0.8043 | 0.5772 | 0.5443 |
| Derivation + Irr | 0.6921 | 0.3794 | 0.3519 | 0.6362 | 0.3118 | 0.3698 | 0.7848 | 0.5151 | 0.4881 |
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Case | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| NL | 0.5172 | 0.0129 | 0.4554 | 0.7853 | 0.0484 | 0.6422 | 0.6145 | 0.1378 | 0.5933 |
| NL + Data | 0.7512 | 0.4018 | 0.6506 | 0.6280 | 0.4861 | 0.5301 | 0.6822 | 0.2486 | 0.6205 |
| NL + Data + Irr | 0.7097 | 0.3552 | 0.4253 | 0.5781 | 0.4292 | 0.4368 | 0.6216 | 0.2468 | 0.5376 |
| Derivation | 0.6503 | 0.2272 | 0.4502 | 0.5233 | 0.2200 | 0.4094 | 0.5393 | 0.1769 | 0.4886 |
| Derivation + Irr | 0.5797 | 0.1991 | 0.3636 | 0.4748 | 0.1738 | 0.3671 | 0.5504 | 0.1390 | 0.4419 |
| NLP4LP | Mamo Easy | Mamo Complex | |||||||
| Case | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES | EF1 | EBC | LLM-ES |
| NL | 0.6900 | 0.2745 | 0.5193 | 0.6711 | 0.1124 | 0.6403 | 0.6371 | 0.2787 | 0.6095 |
| NL + Data | 0.4554 | 0.2995 | 0.6033 | 0.5043 | 0.3895 | 0.5202 | 0.6037 | 0.2272 | 0.5914 |
| NL + Data + Irr | 0.4710 | 0.2009 | 0.4004 | 0.4215 | 0.3046 | 0.4354 | 0.5017 | 0.1382 | 0.4881 |
| Derivation | 0.4192 | 0.1636 | 0.4498 | 0.3829 | 0.1930 | 0.4097 | 0.5778 | 0.1262 | 0.4990 |
| Derivation + Irr | 0.3707 | 0.0847 | 0.3699 | 0.3103 | 0.1161 | 0.3628 | 0.4487 | 0.0749 | 0.4305 |
Natural Language to Optimization Modeling
Natural language to optimization modeling translates human requirements into formal mathematical models and solver-ready code.
See all 76 papers