AgMRC-Commodities
Data Science for the Public Good
The Data Science for the Public Good (DSPG) Young Scholars program is an immersive summer program that engages students from across Iowa to work together on projects that address local and state government challenges around critical social issues relevant in the world today. Learn more about the program here.
AgMRC Commodity Reports
AGMRC Commodity Reports in tableau can be used as preliminary research in determining current production, market analysis, demographic data and price points. It can be useful in applying for a wide variety of grant funding, financial institutional loans, etc. The customizable marketing studies provide Value Added Producer Grant (VAPG) applicants with market intelligence that can easily be incorporated into feasibility studies and business plans that support the application process.
Objectives
Develop end to end automated report:
- create two commodity reports(Egg and Beef)
- data discovery to find data sources to create finer detailed final product
- explore new and interesting infographic techniques applicable to increased understanding
- streamline all reports with better filters to handle differing data based on geography and year
- Use tools like R for data manipulation
Egg/Beef Commodity Report
Cover Page (Egg/Beef)
- This page includes overview of the commodity and the resources
Market and Harvest Trends
- It includes information on Production, sales, price etc.,
- Analyzing Production Trends(in dozens by states and over the years)
- Organic Sales(in $)
- Egg/Cattle price received in $/dozen over the years
- Frozen Stocks
Market Consumption Profile
- This page is an overview of the market consumption profile and data behind it
- It has yearly beef expenditure, changes and comparison with national average
Demographic Profile – Part 1 & Part 2
- It has demographics information like population, race, monthly precipitation info of Iowa, National Level Local Food Market Locations and statewide agricultural export percentages
Data Sources
| Data Name | Level | Accessed Through | Usage | Website |
|---|---|---|---|---|
| ESRI Consumer Spending | Primary | Arc GIS Pro and previous teams work | Used to find consumer spending for egg, beef, and overall food at and away from home | Link |
| USDA Agricultural Marketing Service | Secondary | MariaDB | Used to find number of CSAs and farmers markets in a state | Link |
| CDC State Indicator Report | Secondary | MariaDB | Used to find number of food hubs in a state | Link |
| Data Axle Genie | Secondary | MariaDB | Used to find number of grocery stores and restaurants in a state | Link |
| National Oceanic and Atmospheric Administration | Primary | Website | state historical weather data | Link |
| USDA Local Food Directories | Primary | Website | locations of farmer’s markets, food hubs | Link |
| USDA Quickstats | Primary | Website | survey and census data | Link |
Detailed information about sources used can be found here
Code
Corresponding code is available on:
- GitHub Repository
- For the Final Presentation click here
- For the Final Dashboards click here
Team
The team brought together backgrounds in Computer Science, Data Science, Economics, and Political Science, with interests in applications of technical skills to achieve meaningful impacts for decision making processes related to products at the local level.
- Rakesh Shah - Team Leader, Iowa State University
- Muskan Tantia - Graduate fellow, Iowa State University, Computer Science
- Maxwell Skinner - Intern, Iowa State University, Data Science & Political Science
- Joel Martin - Intern, Iowa State University, Data Science
- Tanishq Jain - Intern, Iowa State University, Statistics & Data Science