removeNonExistingRecord: Function to remove non-existing record

In SWS-Methodology/faoswsProcessing: Standard data manipulation procedure for SWS.

Function to remove non-existing record

Description

Sometimes non-existing records (observation status flag and method flag and value all NA) are returned by the database, or can be created by denormalising the data. This function removes these records.

Usage

removeNonExistingRecord(
  data,
  areaVar = "geographicAreaM49",
  itemVar = "measuredItemCPC",
  elementVar = "measuredElement",
  yearVar = "timePointYears",
  flagObsVar = "flagObservationStatus",
  flagMethodVar = "flagMethod",
  valueVar = "Value"
)

Arguments

data	The data containing non-existing record
areaVar	The column name corresponding to the geographic area.
itemVar	The column name corresponding to the commodity item.
elementVar	The column name corresponding to the measured element.
yearVar	The column name corresponding to the year.
flagObsVar	The column name corresponding to the observation status flag.
flagMethodVar	The column name corresponding to the method flag.
valueVar	The column name corresponding to the value.

Value

Data with non-existing records omitted.

SWS-Methodology/faoswsProcessing documentation built on June 24, 2024, 6:57 a.m.