Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di...
by pytlicek on Wednesday April 21, 2021 @09:32AM
(#26889432)
Here it is the same. But with the difference that you don't have to install a relatively "large" Pandas library. It always depends on what you want to achieve. If you just read the lines and values, you can always use something small to help. If you want to Dockerize similar solution, you have the difference that Pandas needs specific system libraries and it will increase your Docker Image to almost 2GB compared to sheet2dict where it is a couple of KB.
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di...
by dragonwriter on Wednesday April 21, 2021 @10:48AM
(#26890353)
> I usually import CSVs into a Python Pandas Dataframe and then iterate over the dataframe in a loop
Isn’t a big point of dataframes providing tools that are more efficient so you don’t have to use Python loops for operations across a body of data?
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di...
by BugsJustFindMe on Wednesday April 21, 2021 @11:38AM
(#26891081)
Yes. Manually looping over rows in a dataframe is wildly inefficient.
Is this a better approach?