I've heard that opening .xls files in LibreOffice can sometimes result in truncated data, depending on how the spreadsheet was created. .csv files, however, seem to work fine.

I've done some research, and everyone seems to recommend using a virtual machine (VM) in this situation. Since we only need these files in the initial stage for importing into a Jupyter Notebook and performing exploratory data analysis (EDA), I think a VM is a reasonable solution and maybe never need to do that.

Thanks, mate 🤙

Reply to this note

Please Login to reply.

Discussion

I used WinApps when I tried to solve this problem: https://github.com/Fmstrat/winapps

Unfortunately for me my machine couldn’t quite perform well enough running the apps in a virtual machine, so it wasn’t useable for me.