refine: Clean up raw records

Description Usage Arguments Value Examples

View source: R/process_records.R

Description

Uses functions from the dplyr package to clean up raw records obtained from the Bath: Hacked datastore. The process is as follows:

Usage

1
refine(x, max_prop = 1.1, first_upload = FALSE)

Arguments

x

A data frame containing records to be cleaned up (e.g. the data frame obtained by calling get_all_crude).

max_prop

The point at which records are discarded due to overly-full Occupancy values (default is 1.1, or 110% full, to allow for circulating cars).

first_upload

If TRUE, ensures that when duplicate records are removed, the copy which is kept is the first one uploaded after the record was taken. This takes much longer to run, due to sorting.

Value

A data frame of clean records, with 7 columns:

Name

The name of the car park where the record was taken.

LastUpdate

The time the record was taken (POSIXct date-time object).

DateUploaded

The time the record was uploaded to the Bath: Hacked database (POSIXct date-time object).

Occupancy

The total number of cars in the car park.

Capacity

The number of parking spaces in the car park.

Status

Description of the change in occupancy since the previous record from that car park.

Proportion

Calculated as (Occupancy/Capacity).

Examples

1
2
3
4
5
6
7
8
9
raw_data <- get_all_crude()
some_records <- raw_data[1:1000, ]

dim(some_records)
## 1000   16

df <- refine(raw_data)
dim(df)
## 813   7

BANEScarparkinglite documentation built on July 2, 2018, 1:02 a.m.