This is previewing only CSVs, not real spreadsheets. In almost all of the CSVs

Python's csv.sniffer.has_header <div class="snippet-clipboard-content notranslate

Sticky first row should be addressed when working on <a class="issue-link js-issue-lin

Style "first row" differently (and probably make it stick with the header) about heiho HOT 3 CLOSED

kktsvetkov commented on May 21, 2024

Style "first row" differently (and probably make it stick with the header)

from heiho.

Comments (3)

kktsvetkov commented on May 21, 2024

Here's a few heuristics that would tend to indicate the first line isn't a header:

The first row has columns that are not strings or are empty

The first row's columns are not all unique

The first row appears to contain dates or other common data formats (eg, xx-xx-xx)

https://stackoverflow.com/a/2674078

from heiho.

kktsvetkov commented on May 21, 2024

Python's csv.sniffer.has_header

        # Creates a dictionary of types of data in each column. If any
        # column is of a single type (say, integers), *except* for the first
        # row, then the first row is presumed to be labels. If the type
        # can't be determined, it is assumed to be a string in which case
        # the length of the string is the determining factor: if all of the
        # rows except for the first are the same length, it's a header.
        # Finally, a 'vote' is taken at the end for each column, adding or
        # subtracting from the likelihood of the first row being a header.

https://hg.python.org/cpython/file/tip/Lib/csv.py#l384

from heiho.

kktsvetkov commented on May 21, 2024

Sticky first row should be addressed when working on #3

from heiho.

Recommend Projects