Data Analytics for Business Professionals Program (DABP) Advanced Analytics and Machine Learning Group Project
Fall 2018
Folder Name | Description |
---|---|
literature |
This folder will store all relevant literature related to the project. |
raw_data |
This folder will store the raw data files needed for our group project. |
src |
This will store all source code used for the project. |
write_data |
This folder will store all data files created from the raw_data files. |
-
What features influence the increase or decrease of corn acreage1 over time?
- Our null hypothesis is that the ratio of the corn to soy prices is a key decision factor. Can we reject it?
-
If possible, how do weather patterns influence corn acreage over time?
-
United States Department of Agriculture Farm Service Agency annual crop acreage data for every state from 2011 to 20172.
-
National Centers for Environmental Information monthly average temperature from January 2011 to December 2017 for the contiguous United States3.
-
Row-bind the individual .xlsx files from 2011 to 2017 into one master file.
-
Inspect features for collinearity.
-
Conduct exploratory data analysis to understand outliers and trends.
-
Incorporate weather data for each state as their own features.
-
Create a linear regression model to predict corn acreage for the next year.
-
Create clusters based on different crops, states, or years to determine any relevant groups that may be of interest to us to understanding corn acreage growth.
1 Hubbs, Todd. 2018. “Weekly Outlook: Corn and Soybean Acreage in 2018”. Department of Agricultural and Consumer Economics, University of Illinois at Urbana-Champaign. Available at: http://farmdocdaily.illinois.edu/2018/03/corn-soybean-acreage-2018.html.
2 Farm Service Agency. 2018. “Crop Acreage Data”. United States Department of Agriculture. Available here: https://www.fsa.usda.gov/news-room/efoia/electronic-reading-room/frequently-requested-information/crop-acreage-data/index.
3 National Oceanic and Atmospheric Administration. 2018. “Climate at a Glance”. National Centers for Environmental Information. Available here: https://www.ncdc.noaa.gov/cag/national/time-series/110/tavg/1/1/2011-2017?base_prd=true&firstbaseyear=2011&lastbaseyear=2017.