GoPie for Public Data

Public data, ready for answers

Government tables arrive with stray spaces, cryptic headers and a dozen spellings of the same state. GoPie cleans them on the way in, standardises them against predefined codebooks, and makes them AI-ready, with the official reports that explain them sitting right alongside.

RAW SOURCEScrop_census_2024.xlsx" Iowa "subsidies.csvSt_Nm · YIELD(2024 )farm_report.pdfCONTEXT REPORTCLEAN + STANDARDISECLEANING✓ trim whitespace✓ fix column names✓ standardise values✓ type the columnsPREDEFINED CODEBOOKSstate codes · IA, KS…crop types · regionsAI-READY PROJECTagri_analysis▤ clean datasets+ auto descriptions▥ official reportsINSIGHTS FROM BOTHASKChat insightsCITES DATA + PDFDashboardsONE CLICKReportsONE CLICK · SHAREABLE

FROM MESSY UPLOAD TO AI-READY PROJECT, AUTOMATICALLY

The cleaning you always do, done for you.

Enable data cleaning on a project and every upload is trimmed, retyped and renamed before anyone asks it a question. No more find-and-replace mornings.

RAW UPLOADcrop_raw.xlsx
St_NameYIELD(2024 )
" Iowa " 204
NebraskaNA
Kansas 138
01 Trim stray whitespace
02 Fix column names
03 Standardise values
04 Add code dictionaries

Auto-applied · you review & tweak any step

CLEANEDcrop_yield_2024
state_namestate_codeyield_2024
IowaIA204
NebraskaNEnull
KansasKS138

STATE_CODE ADDED FROM STANDARD DICTIONARY

One name for every state, district and scheme.

Public data spells the same place ten ways. GoPie standardises values against predefined codebooks, like state codes and LGD district codes, and adds the standard code as its own column.

Every dataset in the project ends up speaking the same language, so answers can join census, budget and survey data without anyone reconciling spellings first.

CODEBOOK · STATE & DISTRICT CODESAPPLIED ✓
levelas uploadedstandardisedcode
STATE" Andhra pradesh "Andhra PradeshAP
STATETamilNaduTamil NaduTN
DISTRICTAnanthapuramAnantapurLGD 553
DISTRICTVizagVisakhapatnamLGD 561
global_economy · chat
Which economies grew fastest in 2024?
GoPie is querying gdp_growth · context: imf_outlook.pdf
economygrowthyear
India+7.8%2024
Vietnam+6.4%2024
Indonesia+5.1%2024

India grew fastest at 7.8%, with emerging Asia leading the pack. The IMF outlook ties the surge to strong domestic demand and easing inflation across the region.

▤ gdp_growth.csv▥ imf_outlook.pdf
You stay in the loop
✎ Refine ↺ Show working ✓ Approve

Not just the numbers. The reports behind them.

Add official reports, methodology notes and scheme guidelines to the same project as context documents. Answers draw on both, and cite both.

Auto-generated dataset and column descriptions make retrieval precise, so a question about groundwater finds the right table and the right paragraph of the right PDF.

Built for the people who work public data.

M&E teams

Track programme indicators across regions and years, with the methodology sitting right beside the numbers.

Researchers

Join census, budget and survey data and interrogate it in plain language, without weeks of wrangling.

Administrative data

Make departmental records consistent and queryable across every district and reporting cycle.

Policy & think tanks

Test a hypothesis against official data and cite the source document in the same answer.

Journalists

Ask hard questions of public datasets and get answers that always show their working.

Development sector

Turn scattered scheme data into dashboards and reports for funders and field teams.

Working with public data?

Tell us about your datasets. We'll show you what AI-ready looks like.