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
Tag
python
134 posts
CSV
Reading a CSV Into Dictionaries With csv DictReader
csv.DictReader turns each CSV row into a dict keyed by the header. See what it does with missing and extra fields, BOMs, duplicate headers and blank lines.
9 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
CSV
Using the Python csv Module for Reading Files Line by Line
Read CSV in Python with csv.reader: open with newline='', handle quoted commas and multi-line fields, set the dialect, and stream millions of rows.
8 min read
Editor's pick
CSVGuide
Reading and Writing CSV Files in Python the Right Way
A working guide to CSV in Python: csv module, DictReader, pandas, polars and DuckDB measured on 2,000,000 rows, plus the encoding, quoting and type rules.
22 min read
XML
Analyzing Podcast and Blog Feeds From XML With Python
Turn an RSS podcast feed into cadence, duration and size numbers, handle itunes durations in two formats and RFC 822 dates, and compare with feedparser.
6 min read
YAML
Why yaml load Is Dangerous and What to Use Instead
How a YAML tag makes PyYAML run code during load, a harmless demonstration, what changed in PyYAML 6 and the safe options for loading untrusted files.
6 min read
YAMLGuide
Reading and Writing YAML in Python Safely and Cleanly
A tested Python guide to YAML: safe loading, speed, strict keys, validation, clean output, round trips, merging, env substitution and a reference module.
20 min read
XML
Converting CSV to XML With a Template That Escapes Correctly
Build XML from CSV rows without string templates that break on an ampersand. Use lxml or escape every value, and handle control characters and empty cells.
7 min read
XML
Converting XML to Excel With Python and Typed Cells
Write an XML file into an xlsx workbook with openpyxl so numbers are numbers, booleans are booleans and identifiers stay text, and read it back to check.
7 min read
ExcelGuide
Reading and Writing Excel Files With openpyxl in Python
A working guide to openpyxl: the workbook model, reading values and formulas, writing and editing files, large-file modes, styles, charts and errors.
19 min read
Excel
Freezing Panes Filters and Column Widths From Code
Freeze the header row, add filter buttons and set column widths from Python with openpyxl and XlsxWriter, including an auto-width helper and print settings.
7 min read