search

matt-dray / oystr

:station::ticket: R package: wrangle Oyster-card data supplied by Transport for London
https://matt-dray.github.io/oystr/
Other
2 stars 0 forks source link

oy_clean() steps #5

Open matt-dray opened 5 years ago

matt-dray commented 5 years ago

These should be dates/times:

Journey.Action should be split into multiple columns, like:

Charge is already numeric and zero. Credit will be money, so it should be numeric and NA should be 0? Maybe not; is there a conceptual difference between no charge for a journey (e.g. because of a season ticket) and credit, which is like one-off repayments? balance is numeric and okay.

Need some Note examples to see how they could be split to provide new columns of data.

matt-dray commented 5 years ago
matt-dray commented 5 years ago

In the July/August vignette example the charge and credit columns are numeric. I think credit should always be numeric (update oy_read() with as.numeric()?), but looks like charge can include season ticket (may need to separate this out into a separate column to leave charge with numeric values only).