Convert -1 values to NA

[Robinlovelace]

As that's what it means in all cases.

[Robinlovelace]

Another example of this:

v = stats19::get_stats19(year = 2019, type = "vehicles")
#> Files identified: DfTRoadSafety_Vehicles_2019.zip
#>    http://data.dft.gov.uk.s3.amazonaws.com/road-accidents-safety-data/DfTRoadSafety_Vehicles_2019.zip
#> Data already exists in data_dir, not downloading
#> Data saved at ~/stats19-data/DfTRoadSafety_Vehicles_2019/Road Safety Data- Vehicles 2019.csv
summary(v$age_of_vehicle == -1)
#>    Mode   FALSE    TRUE 
#> logical  154626   61755
skimr::skim(v$age_of_vehicle)

Data summary

Name	v$age_of_vehicle
Number of rows	216381
Number of columns	1
_______________________
Column type frequency:
numeric	1
________________________
Group variables	None

Data summary

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
data	0	1	5.6	6.2	-1	-1	4	10	94	▇▁▁▁▁

v$age_of_vehicle[v$age_of_vehicle == -1] = NA
skimr::skim(v$age_of_vehicle)

Data summary

Name	v$age_of_vehicle
Number of rows	216381
Number of columns	1
_______________________
Column type frequency:
numeric	1
________________________
Group variables	None

Data summary

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
data	61755	0.71	8.23	5.43	1	4	8	12	94	▇▁▁▁▁

^{Created on 2020-10-28 by the reprex package (v0.3.0)}