JSON
Faster JSON in Python With orjson and What Changes
orjson wrote a 35 MB document 6 times faster than json and parsed it 1.7 times faster. What it returns, what it rejects and what to check before migrating.
6 min read
Topic
Scripting
Shell one-liners and small scripts that turn your repeated database chores into a single command.
JSON
Loading JSON Into a pandas DataFrame the Right Way
pandas read_json turned the zip "01234" into 1234. How orient, lines, dtype and the pyarrow backend change the result, and what changed in pandas 3.
6 min read
JSON
Pretty Printing JSON in Python and From the Terminal
Pretty print JSON with json.dumps(indent), python -m json.tool and pprint, keep non-ASCII readable, sort keys and collapse short arrays.
6 min read
CSV
Reading a CSV in Swift on macOS and the CRLF Line Trap
Swift has no CSV parser in Foundation, and its String treats CRLF as one Character, so splitting on a newline fails. Parse bytes or use SwiftCSV.
9 min read
CSV
Reading a CSV File in Kotlin for a Quick Import Job
Read a CSV in Kotlin with kotlin-csv and build a small import job that validates rows, rejects bad ones with row numbers and never hides a failure.
11 min read
CSV
Reading CSV Files in Bash Without Breaking on Quotes
A bash read loop on a CSV breaks on quoted commas, backslashes, a missing last newline and empty tab fields. Let a CSV parser emit safe records first.
10 min read
CSV
Parsing CSV in Ruby With the CSV Library and Its Converters
Parse CSV in Ruby 3.4 with the csv gem: the Gemfile LoadError, a numeric converter that read 02134 as 1116, nil versus empty strings, and timings.
10 min read
CSV
Reading a CSV File in PHP With fgetcsv and SplFileObject
Read CSV in PHP 8.5 with fgetcsv and SplFileObject: the $escape deprecation, a backslash that swallows the file, str_getcsv traps and the BOM.
10 min read
CSV
Reading a CSV File in C Sharp With CsvHelper Correctly
Read CSV in C# with CsvHelper 33: case-sensitive headers, typed ZIP codes, silent ragged rows, and a de-DE culture that made a total 91 times too big.
10 min read
CSV
Parsing CSV in Rust With the csv Crate and Serde Types
Parse CSV in Rust with the csv crate: StringRecord, ByteRecord and serde, UnequalLengths errors, typed ZIP codes and an unclosed quote it accepts.
9 min read
CSV
Reading CSV Files in R With readr and fread Safely
Compare read_csv, fread and base read.csv on the same files: type guessing and ZIP codes, ragged rows, bad quotes, the BOM, and speed on 2,000,000 rows.
10 min read
CSV
Reading a CSV File in Java With OpenCSV and Commons CSV
Read CSV in Java with OpenCSV and Commons CSV: a backslash escape that breaks paths, ints that turn blanks into 0, and a writer that quotes everything.
10 min read
Get new articles by email
We send one email when a new article is published. No spam.