๐ŸŒพ Track 02: AI for Farmers โณ Not Yet Started (Planned Weekend R&D)
EXPERIMENT #08

AI Mandi Intelligence Engine

A real-time APMC Mandi market intelligence platform that analyzes arrival volumes, historical price trends, and nearby mandis to answer price questions.

๐ŸŽฏ

The Problem

What difficult challenge is this experiment tackling?

Farmers frequently sell produce to local middlemen at a steep discount because they lack real-time price transparency across surrounding district mandis.

๐Ÿ’ก

The Hypothesis

What do I believe autonomous AI & engineering can accomplish?

Aggregating open Agmarknet government data into an automated conversational time-series model helps farmers determine optimal selling timing and target mandi locations.

๐Ÿ›๏ธ

System Architecture & Workflow

End-to-end design, data pipelines, and component interaction
01 Agmarknet Daily Data Scraper
02 Data Cleaning & Outlier Removal
03 DuckDB Time-Series Store
04 Spatial Distance Calculator
05 LLM Query Synthesizer
06 WhatsApp / SMS Broadcast.
๐Ÿ“Š

Benchmark & Empirical Metrics

Accuracy โ€ข Latency โ€ข Cost โ€ข Token Usage โ€ข Human Intervention

Automated daily ingestion of 500+ mandis within 10 minutes of release; queries answered with historical verification in <1.2s.

๐Ÿ›ก๏ธ

Security, Privacy & Ethical Guardrails

Risk mitigation, strict boundaries, and sandbox controls

Anti-speculation safeguard: Clearly presents historical facts and price spreads, avoiding speculative price guarantees.

๐Ÿ“

Lessons Learned & Observations

Empirical findings from prototyping and testing

Mandi data pipeline schema defined; handling missing data on regional market holidays.

๐Ÿš€

Next Experiment Iteration

Upcoming modifications, scaling factors, or new hypotheses

Incorporate diesel transport cost calculations to calculate net farmer profit per mandi.