News for hackers. Stuff that matters.
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by lettergram on Wednesday April 21, 2021 @12:05PM (#26891452)
I maintain a similar project, load any CSV, manipulate and get stats, detect sensitive data, etc

https://github.com/capitalone/DataProfiler

My question, how do you do header detection? That's a _very_ difficult problem.

Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by nojito on Wednesday April 21, 2021 @07:08PM (#26896526)
You could emulate what data.table does and allow a search string variable to identify the header row.

https://github.com/h2oai/datatable/blob/385a9b370db32de90135...