A developer creates a simple, AI-assisted Node.js tool for automatically loading CSV files into PostgreSQL with minimal configuration.
A tutorial on building a beginner-friendly Model Context Protocol (MCP) server in Python to connect Claude AI with local CSV and Parquet files.
A technical tip showing how to use AWK to convert CSV/TSV data into a human-readable markdown or HTML table for documentation.
A tutorial on reading CSV data, deserializing it into Rust structs, and displaying it as a formatted table in the terminal using crates like csv, serde, and ratatui.
A quick guide on using DuckDB's SQL commands to efficiently convert CSV files to the Parquet format, including schema modifications.
Introducing dsq, a command-line tool for running SQL queries against JSON, CSV, Excel, Parquet, and other data file formats.
A technical talk summary on using Terraform with CSVs and ForEach loops to achieve DRY (Don't Repeat Yourself) principles for scalable infrastructure-as-code deployments.
A technical guide on using kafkacat to load static CSV data into Apache Kafka topics for data enrichment, focusing on simplicity over Kafka Connect.
An analysis of the CSV data format, covering its advantages, drawbacks, and common parsing pitfalls in data processing.
A guide to cleaning and processing messy CSV data using Python's Pandas library, including reading files and assigning custom headers.
A technical guide on using Kafka Connect's SpoolDir connector to load CSV data into Apache Kafka, covering schema application and configuration.
A tutorial on using pandas and regex to conditionally populate missing columns in a CSV file based on data from another column.
A tutorial on using Python's pandas library to clean CSV data and export it to JSON format for data layer integration.
A short guide explaining why PowerShell's Export-Csv cmdlet behaves unexpectedly with string arrays and how to correctly export simple lists to CSV.
The Gamma project simplifies data visualization creation with a new four-step guide, allowing users to upload CSV data and build interactive charts.
A Python script called csv2vw converts CSV data into Vowpal Wabbit's input format for machine learning, with examples for label handling.
A critique of Excel's data handling flaws, showing how it silently corrupts timestamp data in CSV files upon saving.
A guide to removing Byte Order Marks (BOM) from files using a simple PHP code snippet.
A guide to using SQL queries and a simple Ruby script to send personalized, data-driven emails to users, avoiding complex marketing tools.
A quick R function to edit CSV files using R's native data editor, providing a lightweight alternative to spreadsheet software.
