Reads and cleans crops' water footprint dataset.

Source: R/water_footprint.R

Reads and cleans crops' water footprint dataset from https://waterfootprint.org/en/resources/waterstat/product-water-footprint-statistics/ and converts it to tidy format.

ci_wf_prep_crops(
  filename = "Report47-Appendix-II.xlsx",
  sheetname = "App-II-WF_perTon",
  skip_rows = 3,
  country = NULL
)

Arguments

filename

String with the XLSX file name containing the water footprint. File should be stored in data/data-raw folder.
sheetname

String with the name of the Excel's sheet to be imported.
skip_rows

Number containing the number of rows to be skipped when importing the XLSX data.
country

String with the country name we want to get water footprint from.

Value

Dataframe in a tidy format, providing values for the selected country only.