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
Library
Everything you need to level up your coding skills.
XML
Converting XML to CSV for Spreadsheet Users Safely
Turn a nested XML file into a flat CSV with Python, joining repeated authors into one cell with correct quoting, and see why pandas read_xml dropped one.
7 min read
XMLGuide
Converting XML to JSON CSV YAML and Excel Without Data Loss
One XML file converted to JSON, CSV, YAML and Excel with one parse and four writers, what each target loses, and how to prove nothing went missing.
20 min read
XML
Loading a Product Feed in XML Into PostgreSQL With xmltable
Load a Google Merchant style product feed into PostgreSQL with xmltable and a namespace, split price from currency, and handle missing GTINs and empty prices.
7 min read
XML
Should You Store XML in a Database Column or Shred It
Store XML whole, shred it into tables, or both? What each engine keeps and loses, what validation you get, and what it costs on 200,000 documents.
7 min read
XMLGuide
Parsing and Writing XML in Python With ElementTree and lxml
A tested guide to XML in Python: ElementTree versus lxml, reading, streaming, writing, namespaces, validation, XSLT, tables, safety and an end-to-end script.
18 min read
XML
XPath Basics Selecting Nodes by Path in XML Documents
XPath basics on a small library document: absolute and relative paths, //, *, @ attributes, text(), the parent step and the node-set versus value results.
6 min read
XMLGuide
XPath Queries That Cover Most Real Needs in XML Work
A tested XPath guide: the twenty expressions that cover most needs, the traps (namespaces, positions, units, injection), tools, timings on 200,000 records.
18 min read
XML
Pretty Printing XML to Spot Structural Mistakes Quickly
When a minified XML file will not parse, xmllint --format and lxml refuse to indent it. A 30-line tokenizer indents what it can and flags the first mismatch.
6 min read
XML
Encoding Mismatch Errors in XML Documents From Mixed Sources
When an XML feed mixes encodings or was encoded twice: why detectors guess wrong on short text, the UTF-8 first rule and per-line fallback.
7 min read
XML
Fixing XML With Unescaped Ampersands From a Legacy Export
Repair a 29 MB XML export with 215,385 raw ampersands using a lookahead regex that leaves existing entities alone, with the cases that need judgment.
6 min read
XML
Python ParseError Unbound Prefix in XML and How to Fix It
Fix ElementTree ParseError unbound prefix and lxml Namespace prefix is not defined: fragments cut from a document, auto-declared prefixes, recover.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.