Live data from Hacker News

Which table format do LLMs understand best?

improvingagents.com

101–110 of 115 posts

Re: Which table format do LLMs understand best?

#101
It appears that this is just testing data retrieval from somewhere in the table? Do the results translate to something where data analysis is performed? From something as simple as summing across rows or averages to generating graphs.

I once tried to get Claude and ChatGPT to build me a excel financial model, failed pretty hard. The models seem to lose track where they are in a table

Re: Which table format do LLMs understand best?

#102

Earlier quoted context omitted.

There’s a big difference between mistyping 1% of the time yourself (human error) and a calculator failing 1% of the time (machine error) and I am willing to bet there isn’t a company out there (maybe a handful of less scrupulous ones) that has knowingly shipped a calculator that got it wrong 1% of the time. Especially in previous decades when countless people were using a dedicated calculator dozens of times a day. H…

There isn't a difference in the big picture. Error is error. Even when we have incredibly reliable things, there's error when they interface with humans. Humans have error interfacing with each other. But you seem to have missed the main point I was making. See? Another error. They're everwhere! ;)

> But you seem to have missed the main point I was making. See? Another error. They're everwhere! ;)

You really could’ve done without this bit.

Re: Which table format do LLMs understand best?

#103
post #43

Earlier quoted context omitted.

Please go away and do the work for us and let us know what anmazing accuracy you got with whatever version you think is better. Anything below 100% is actually pretty useless when it comes to stats.

If you want 100% accuracy from these kinds of tasks with LLMs you can get it today, but you need to provide the LLM with the ability to run Python code and tell it to use something like Pandas. You can confirm it's doing the right thing by reviewing the code it wrote.

Or you can just write the code to do it correctly. Which would be quicker. If you can review it properly you already understand how to do it.

Re: Which table format do LLMs understand best?

#105
post #43

Earlier quoted context omitted.

If you want 100% accuracy from these kinds of tasks with LLMs you can get it today, but you need to provide the LLM with the ability to run Python code and tell it to use something like Pandas. You can confirm it's doing the right thing by reviewing the code it wrote.

Or you can just write the code to do it correctly. Which would be quicker. If you can review it properly you already understand how to do it.

That would require me to have memorized the pandas API.

I've been using pandas on-and-off for over a decade and I still haven't come close to doing that.

Re: Which table format do LLMs understand best?

#106

Earlier quoted context omitted.

You realize that when typing into a calculator, you probably hit a wrong key more than 1% of the time? Which is why you always type important calculations twice? I've been stunned by how many smart people talk so casually about how because LLMs aren't perfect, they therefore have no value. Do they just forget that nothing in the world is perfect, and the values of things are measured in degrees?

There’s a big difference between mistyping 1% of the time yourself (human error) and a calculator failing 1% of the time (machine error) and I am willing to bet there isn’t a company out there (maybe a handful of less scrupulous ones) that has knowingly shipped a calculator that got it wrong 1% of the time. Especially in previous decades when countless people were using a dedicated calculator dozens of times a day. H…

The computer on your desk has a number of errors just holding values in memory.

Yes, it's not 1%, but the argument is about them being imperfect devices. It's not a horrible thing to start with the presumption that calculators are not perfect.

Re: Which table format do LLMs understand best?

#107
post #97

Earlier quoted context omitted.

LLMs have documented position biases, with skew towards first and last. This is strongest in messages due to system prompt + current question training data, but it's present in list data in general.

Exactly. But the papers I’ve seen, the tests are done based on answers being multiple choice usually. Where do you eat? A) floor B) table C) dirt In this case, the questions asked have an answer. The bias would then be on the order of the input data. It’s different enough that it triggered my curiosity.

https://direct.mit.edu/tacl/article/doi/10.1162/tacl_a_00638...

Re: Which table format do LLMs understand best?

#108
post #5

> where accuracy is paramount > accuracy: 60% Not to mention that the least poorly performing format is probably the stupidest way to encode tabular data, beating even XML. But I guess that’s the new normal because we’re trying to shoehorn conversational AI models to every use case rather than, say, training finetunes that are better at particular tasks. (Yes, of course you can’t train finetunes when the model is a p…

I'm the person who ran the test. To explain the 60% a bit more... With small amounts of input data, the accuracy is near 100%. As you increase the size of the input data, the accuracy gradually decreases. For this test, I intentionally chose an input data set large enough that the LLM would score in the region of 50% accuracy (with variation between formats) in order to maximise the discriminative power of the test.

Thank you for including the tokens needed for each test.

It looks to me that the concisest way of representing each of these tables was a CSV and then a standard markdown table. The amount of tokens appears to be 1/2 or 1/3 of the other options. For experiments not in mice (GPT-4.1-nano), but in larger models or larger context aside from the data table itself, my guess is that preserving context is might be higher value than having the higher-LLM-legibility of the Markdown-KV.

Re: Which table format do LLMs understand best?

#109

Can someone explain why one would want to use an LLM to read tabular data? This is something even trivial code could do while using far fewer compute and energy resources.

I want this for after the code has run and returned results. Often when you use code to answer questions about a table, the result is in the form of a smaller table. I'd like to know how small that table needs to be before you can rely on the model being able to make reliable observations about it.

Re: Which table format do LLMs understand best?

#110

Earlier quoted context omitted.

There’s a big difference between mistyping 1% of the time yourself (human error) and a calculator failing 1% of the time (machine error) and I am willing to bet there isn’t a company out there (maybe a handful of less scrupulous ones) that has knowingly shipped a calculator that got it wrong 1% of the time. Especially in previous decades when countless people were using a dedicated calculator dozens of times a day. H…

The computer on your desk has a number of errors just holding values in memory. Yes, it's not 1%, but the argument is about them being imperfect devices. It's not a horrible thing to start with the presumption that calculators are not perfect.

Yes but I don’t depend on the output of my comp’s memory in such explicit terms and it doesn’t have lasting consequences. If my calculator literally gives me the wrong answer 1% of the time that’s a bigger problem.
Post reply on HN