DuckDB lets analysts run SQL directly on CSV files without any import step

·1 views

Data analyst Michael Nocito published a tutorial on August 8, 2026, explaining how to query CSV files using DuckDB without creating tables or defining schemas. DuckDB, a lightweight library similar to SQLite, can be installed with a single pip command and requires no server, background service, or admin rights. Users simply reference a CSV filename in quotes where a table name would normally appear in a SQL query, and DuckDB infers column types automatically. The tutorial was demonstrated using DuckDB version 1.5.5 on Windows against a 412-row CSV from the Chinook sample database. Nocito notes the tool is well-suited for large files but does not replace SQLite for shared, persistent databases.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Developer releases free CLI tool to audit JSON-LD structured data across entire sites

A developer has released schema-audit, a zero-dependency, single-file Node.js CLI tool designed to crawl entire websites and lint their JSON-LD structured data. The tool addresses a common problem where structured data errors go unnoticed because pages continue to render normally despite broken schemas. It runs nine checks covering JSON validity, required and recommended properties, value sanity, and duplicate entities across schema types including Product, LocalBusiness, BreadcrumbList, and more. Results can be output as a human-readable report or in JSON format, with CI-friendly exit codes that can fail a build when markup regresses. The open-source project, licensed under MIT and available on GitHub, is the third tool in the developer's technical-SEO toolkit, following hreflang-audit and llms-txt-kit.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Rebuilds Research Pipeline for PhD After Master's Thesis Outgrows It

A developer who built a data pipeline for their Master's thesis is now redesigning it from scratch to support a multi-year PhD research program. The original pipeline successfully processed a cross-national research database from heterogeneous sources, but was designed around a fixed research question with known variables and datasets. A PhD introduces open-ended demands — new questions, undiscovered datasets, and evolving methodological decisions — that expose the limits of a narrowly scoped system. The developer argues that working software creates a false sense of architectural validation, since reliable output only proves a system handles its current requirements. The rebuild shifts focus from producing a research product to building for extensibility, provenance tracking, selective reprocessing, and long-term maintainability.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Correctly Load a CSV into pandas and Avoid Silent Type Errors

Data analyst Michael Nocito published a practical guide on August 8, 2026, explaining how pandas' read_csv function automatically guesses column data types, often silently producing incorrect results. The tutorial uses a four-row CSV file containing four common real-world data problems: leading zeros in identifiers, ambiguous date formats, non-standard missing value markers, and currency figures stored as text. Nocito demonstrates that running df.dtypes immediately after loading a file — rather than relying on df.head() — is critical to catching these misinterpretations before they cause downstream errors. He shows that four specific read_csv arguments can replace pandas' default guessing behavior with explicit instructions, preventing issues like dropped leading zeros or money columns that cannot be summed. The guide targets pandas 3.0.2 but notes that the same arguments apply to older versions with minor behavioral differences.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Pandas pct_change and resample: Handling Gaps in Time Series Data

Data analyst Michael Nocito published a tutorial on August 8, 2026, explaining how to use pandas functions pct_change() and cumsum() to calculate period-on-period change and running totals from transactional data. A key finding highlighted is that pandas' groupby method only creates rows for periods with existing data, while resample automatically fills in missing calendar periods with zeros. Using a real 16-row orders dataset spanning January to May 2026, the guide demonstrates how a missing April causes groupby to return four rows instead of five, skewing percentage-change calculations. The tutorial also explains an edge case where pct_change() returns infinity when a value rises from zero, since division by zero has no finite result. Nocito recommends resample with a datetime index as the more reliable approach for building regular time series before applying any change or cumulative calculations.

0 comments Read more at DEV Community