Data and Code for "Climate impacts and adaptation in US dairy systems 1981-2018"

This data and code archive provides all the files that are necessary to replicate the empirical analyses that are presented in the paper "Climate impacts and adaptation in US dairy systems 1981-2018" authored by Maria Gisbert-Queral, Arne Henningsen, Bo Markussen, Meredith T. Niles, Ermias Kebreab, Angela J. Rigden, and Nathaniel D. Mueller and published in 'Nature Food' (2021, DOI: 10.1038/s43016-021-00372-z). The empirical analyses are entirely conducted with the "R" statistical software using the add-on packages "car", "data.table", "dplyr", "ggplot2", "grid", "gridExtra", "lmtest", "lubridate", "magrittr", "nlme", "OneR", "plyr", "pracma", "quadprog", "readxl", "sandwich", "tidyr", "usfertilizer", and "usmap". The R code was written by Maria Gisbert-Queral and Arne Henningsen with assistance from Bo Markussen. Some parts of the data preparation and the analyses require substantial amounts of memory (RAM) and computational power (CPU). Running the entire analysis (all R scripts consecutively) on a laptop computer with 32 GB physical memory (RAM), 16 GB swap memory, an 8-core Intel Xeon CPU E3-1505M @ 3.00 GHz, and a GNU/Linux/Ubuntu operating system takes around 11 hours. Running some parts in parallel can speed up the computations but bears the risk that the computations terminate when two or more memory-demanding computations are executed at the same time. This data and code archive contains the following files and folders: * README Description: text file with this description * flowchart.pdf Description: a PDF file with a flow chart that illustrates how R scripts transform the raw data files to files that contain generated data sets and intermediate results and, finally, to the tables and figures that are presented in the paper. * runAll.sh Description: a (bash) shell script that runs all R scripts in this data and code archive sequentially and in a suitable order (on computers with a "bash" shell such as most computers with MacOS, GNU/Linux, or Unix operating systems) * Folder "DataRaw" Description: folder for raw data files This folder contains the following files: - DataRaw/COWS.xlsx Description: MS-Excel file with the number of cows per county Source: USDA NASS Quickstats Observations: All available counties and years from 2002 to 2012 - DataRaw/milk_state.xlsx Description: MS-Excel file with average monthly milk yields per cow Source: USDA NASS Quickstats Observations: All available states from 1981 to 2018 - DataRaw/TMAX.csv Description: CSV file with daily maximum temperatures Source: PRISM Climate Group (spatially averaged) Observations: All counties from 1981 to 2018 - DataRaw/VPD.csv Description: CSV file with daily maximum vapor pressure deficits Source: PRISM Climate Group (spatially averaged) Observations: All counties from 1981 to 2018 - DataRaw/countynamesandID.csv Description: CSV file with county names, state FIPS codes, and county FIPS codes Source: US Census Bureau Observations: All counties - DataRaw/statecentroids.csv Descriptions: CSV file with latitudes and longitudes of state centroids Source: Generated by Nathan Mueller from Matlab state shapefiles using the Matlab "centroid" function Observations: All states * Folder "DataGenerated" Description: folder for data sets that are generated by the R scripts in this data and code archive. In order to reproduce our entire analysis 'from scratch', the files in this folder should be deleted. We provide these generated data files so that parts of the analysis can be replicated (e.g., on computers with insufficient memory to run all parts of the analysis). * Folder "Results" Description: folder for intermediate results that are generated by the R scripts in this data and code archive. In order to reproduce our entire analysis 'from scratch', the files in this folder should be deleted. We provide these intermediate results so that parts of the analysis can be replicated (e.g., on computers with insufficient memory to run all parts of the analysis). * Folder "Figures" Description: folder for the figures that are generated by the R scripts in this data and code archive and that are presented in our paper. In order to reproduce our entire analysis 'from scratch', the files in this folder should be deleted. We provide these figures so that people who replicate our analysis can more easily compare the figures that they get with the figures that are presented in our paper. Additionally, this folder contains CSV files with the data that are required to reproduce the figures. * Folder "Tables" Description: folder for the tables that are generated by the R scripts in this data and code archive and that are presented in our paper. In order to reproduce our entire analysis 'from scratch', the files in this folder should be deleted. We provide these tables so that people who replicate our analysis can more easily compare the tables that they get with the tables that are presented in our paper. * Folder "logFiles" Description: the shell script runAll.sh writes the output of each R script that it runs into this folder. We provide these log files so that people who replicate our analysis can more easily compare the R output that they get with the R output that we got. * PrepareCowsData.R Description: R script that imports the raw data set COWS.xlsx and prepares it for the further analyses * PrepareWeatherData.R Description: R script that imports the raw data sets TMAX.csv, VPD.csv, and countynamesandID.csv, merges these three data sets, and prepares the data for the further analyses * PrepareMilkData.R Description: R script that imports the raw data set milk_state.xlsx and prepares it for the further analyses * CalcFrequenciesTHI_Temp.R Description: R script that calculates the frequencies of days with the different THI bins and the different temperature bins in each month for each state * CalcAvgTHI.R Description: R script that calculates the average THI in each state * PreparePanelTHI.R Description: R script that creates a state-month panel/longitudinal data set with exposure to the different THI bins * PreparePanelTemp.R Description: R script that creates a state-month panel/longitudinal data set with exposure to the different temperature bins * PreparePanelFinal.R Description: R script that creates the state-month panel/longitudinal data set with all variables (e.g., THI bins, temperature bins, milk yield) that are used in our statistical analyses * EstimateTrendsTHI.R Description: R script that estimates the trends of the frequencies of the different THI bins within our sampling period for each state in our data set * EstimateModels.R Description: R script that estimates all model specifications that are used for generating results that are presented in the paper or for comparing or testing different model specifications * CalcCoefStateYear.R Description: R script that calculates the effects of each THI bin on the milk yield for all combinations of states and years based on our 'final' model specification * SearchWeightMonths.R Description: R script that estimates our 'final' model specification with different values of the weight of the temporal component relative to the weight of the spatial component in the temporally and spatially correlated error term * TestModelSpec.R Description: R script that applies Wald tests and Likelihood-Ratio tests to compare different model specifications and creates Table S10 * CreateFigure1a.R Description: R script that creates subfigure a of Figure 1 * CreateFigure1b.R Description: R script that creates subfigure b of Figure 1 * CreateFigure2a.R Description: R script that creates subfigure a of Figure 2 * CreateFigure2b.R Description: R script that creates subfigure b of Figure 2 * CreateFigure2c.R Description: R script that creates subfigure c of Figure 2 * CreateFigure3.R Description: R script that creates the subfigures of Figure 3 * CreateFigure4.R Description: R script that creates the subfigures of Figure 4 * CreateFigure5_TableS6.R Description: R script that creates the subfigures of Figure 5 and Table S6 * CreateFigureS1.R Description: R script that creates Figure S1 * CreateFigureS2.R Description: R script that creates Figure S2 * CreateTableS2_S3_S7.R Description: R script that creates Tables S2, S3, and S7 * CreateTableS4_S5.R Description: R script that creates Tables S4 and S5 * CreateTableS8.R Description: R script that creates Table S8 * CreateTableS9.R Description: R script that creates Table S9