Everything useful before you download or buy.
All the practice data of the five LucidPlexus Field Books in one zip, with the faults left in for you to find.
32 tables and 12,653 rows as CSV files, one folder per book: Clearstone's budget, invoices and cash (Follow the Money), agricultural exports and prices (Can I Trust This Data?), HealSync's claims and telemedicine sessions (Explain Your Query), the Verdant Union's energy, emissions and air quality (Green on Paper) and Lanternfield's 1,000 startup applications (Worth Backing?).
A README says what each book's data is about, what one row of every table is and how many rows it has, with hints for each book's faults: 83 in all, from duplicates and misspelled countries to numbers stored as text and a renewable flag set on coal. The answer list, with the DuckDB query that counts each fault, is at the end, below a line you can stop reading at.
Also inside: a data dictionary with the book, table, type, an example value and a short note for each of the 164 columns (including which tables join on what), and a script that loads every table into DuckDB. The CSV files are the same as the free LucidPlexus Community datasets.
ZIP of 35 files. Opens with DuckDB, pandas or any SQL tool.
Read the complete resource here once you are signed in, or download it below.
This resource does not currently include a preview file.
One review per person. Submitting again updates your existing review.
Be the first to review this resource.
More picks from the LucidPlexus shelf.