- Read csv files into a SQLite database. - SQLite does NOT have a built-in COPY-from-CSV like DuckDB. We create tables using SQL, then load CSV data using Python. - Use Python to automate SQL scripts ...
- Read csv files into a DuckDB database. - Use Python to automate SQL scripts (stored in files). - Log the pipeline process. Paths (relative to repo root): DATA_RAW ...
𝗘𝘅𝗰𝗲𝗹 𝘃𝘀 𝗦𝗤𝗟 𝘃𝘀 𝗣𝘆𝘁𝗵𝗼𝗻 — 𝗪𝗵𝗶𝗰𝗵 𝗢𝗻𝗲 𝗦𝗵𝗼𝘂𝗹𝗱 𝗬𝗼𝘂 𝗨𝘀𝗲? One of the most common questions from aspiring data professionals is: 👉 "Should I learn Excel, SQL, or Python?
Aniwa is a universal dataset profiling and intelligence tool designed to help developers, analysts, and data teams understand datasets quickly and clearly. With a simple CLI, Aniwa can profile CSV, ...