Choose header row about tabletool HOT 4 OPEN

It's true that this sample is a non-standard format, but there are many different softwares that use header rows. So I'm suggesting a way to choose an arbitrary number of header rows, for example by right-clicking a row. My last example was from Ecobee thermostat. Here is different example of an ALE (Avid Log Exchange), which is basically a tsv.

All Takes.ale.txt

from tabletool.

I believe that file format is too non-standard and I do not recommend that we support it.

from tabletool.

It's pretty common to see multiple non-data rows at the top of a CSV file, my energy company even provides hourly reports that have a bunch of info at the top that aren't "data headers", so I think "non-standard" isn't a strong argument.

not all CSV files are made equal

from tabletool.

That file is a chunked file. Even if you start reading at the header row there is still an extra "data" label row.

If you start reading the file by truncating some rows then what happens when you save the file? Will that data be silently truncated? That would be bad.

If it is not silently truncated then there are two problems: a) how to set up the "loading" screen to figure everything out? b) how to display the extra data on the screen when it is not a row or a column?

I don't see a clean solution to these problems. Prove me wrong, if there is a UI with screenshots that you can show which show this is feasible I'd like to see it. If we are supporting any data file then all the options on this page would be in scope for TableTool --- https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_csv.html

I don't mind having a million options like that. But if we're going to do that then we should have a clear path and UI idea before starting this journey of supporting yet more weird data file formats.

from tabletool.