Re:Show HN: Tool I created to covert tabular data to a 'pret...
by teekert on Thursday October 24, 2019 @04:53AM
(#21342755)
Is it Pandas based? I'm a bioinformatician and many of my data work flows start with pandas.read_excel() and end with pandas.DataFrame().to_excel(). I had some serious issues with it but I have come to terms with it. Actually Excel is ok as a central project "database" (up to certain size of course), anyone can quickly fill in a lot or rows (the smart dragging, the macro's that take in other Excel files, drop-downs for categories that I later use in Pandas/Seaborn...) and programmatically dealing with it is not too bad (pandas for bulk stuff, openpyxl for very fine-grained control and even conditional formatting, which we use a lot, etc).
[ Parent
| on HN ]
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @02:35PM
(#21347742)
There isn't too much to the rendered document, it reads the text as TSV and breaks that out into rows and cells. I tried keeping it as simple as possible for now, the idea isn't to help analyze data, but be able to share data in a usable format easily.