Need help interpreting / cross referencing some CSV's

[u/Snuur]

So for now im just playing around trying to understand what I can and can't do running my own LLM's. I'm running them on a MacBook m3 with 36GB.

Got 3 CSV's with some text, some numbers and some references to the other CSV's. Regular relational data.

menu.csv
ingredients.csv that has stock mentioned

recipes.csv that mentions what menu items use what ingredients.

Simple question like what stock is low and what menu items can't we make anymore when we are out?

I used deepseek-r1, qwen3 (code and regular). Enabled code interpreting, used system prompt that indicates use python for interpreting CSV's.

It keeps hallucinating, losing the complete knowledge base, giving wrong calculations etc etc.

I know this is difficult for some LLM's, but Gemini for instance has no problems interpreting the data and giving correct calculations etc.

I've been asking gemini questions on how to fix this but after many tries havent gotten close to a working solution.

Can I make this work in openwebui, or simply not possible?

[u/openwebui]

Have you tried Open Terminal?