District crop production analysis

The brief

A state agriculture department wants to know where each crop is grown best and how that is changing. Load district-wise crop production data into a database and find leading districts by area, production and yield, and how they changed over the years. Good looks like: clean crop and district names, reconciled SQL queries, and maps or charts of the leading districts.

What you will build

1. Load the district crop production data
2. Clean crop, season and district names
3. Compute area, production and yield by district in SQL
4. Track changes over the years
5. Present the leading districts per crop

Free, open data to build it with

• Crop production in India ↗ Kaggle (data.gov.in)

Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.