Excel
Fixing Duplicate Column Names When Reading Excel Data
Handle duplicate column headers when reading Excel in pandas, Power Query and SQL loads: automatic suffixes, safe renaming and what duplicates mean.
7 min read
Tag
error-fix
93 posts
JSON
Fixing Invalid JSON Text Errors in MySQL Inserts and Imports
Decode MySQL error 3140 Invalid JSON text and its relatives, including the backslash trap in SQL string literals that silently changes your JSON.
9 min read
Excel
Excel Cell Contains More Than 32767 Characters Error
Excel allows 32767 characters per cell and draws only 1024. See what happens to longer text on import, export and in scripts, and where to store it.
6 min read
CSV
pandas read_csv Dtype Warnings and How to Fix Them
What DtypeWarning mixed types means in pandas read_csv, how it splits one column into ints and strings, and three ways to fix it, with counts.
7 min read
YAML
Reviewing YAML Config Changes in a Pull Request Safely
A two-line YAML diff can move a key to another level or turn a string into a float. Review the loaded data, not the text, with a short script and a linter.
7 min read
Excel
Fixing Circular Reference Warnings in Imported Sheets
Why imported Excel sheets warn about circular references, how to find the loop with the trace tools, and the fix for each cause in formulas and scripts.
7 min read
Excel
Excel Formula Shows as Text Instead of Calculating
Fix an Excel formula that shows as text instead of a result: Text format, Show Formulas, a leading apostrophe, manual calculation and scripts.
7 min read
Excel
Fixing BadZipFile When Reading an XLSX With Python
Fix zipfile.BadZipFile File is not a zip file when openpyxl or pandas reads an xlsx: wrong content, empty or truncated file, encryption and upload mistakes.
7 min read
Excel
Fixing the Python xlrd Error Excel xlsx Not Supported
Fix XLRDError Excel xlsx file not supported in pandas and Python: xlrd 2 reads only old xls files, so install openpyxl and pick the right engine.
6 min read
Excel
Excel Cannot Open the File Because the File Is Corrupt
Recover data from an Excel file that will not open: test the zip, try Open and Repair, extract sheet XML by hand and read what is left with Python.
7 min read
Excel
Fixing Excel Found Unreadable Content After a Script Export
Fix the Excel message about finding a problem with some content after a script export, with the usual causes, how to read the repair log and how to bisect.
7 min read
Excel
Why Excel Says the File Format or Extension Is Not Valid
Excel says the file format or extension is not valid when the content does not match the extension. Identify the real format from its first bytes and fix it.
6 min read