Pulling data via Python, CSV is being reported as 'incorrect format'

I am able to use Python to grab data from the Digi remote unit. However, the file tosses a format error when attempting to use the data for reporting or informatics use.

Oddly, the file will load into Excel fine and doesn’t seem to have any errors that way.

What might be the best/preferred BI type web-reporting tool to use the data provided from a Digi unit, or is there some form of flag I need to set for it to export/give me data which doesn’t report as wrong or corrupted?

Thank you.