Description Usage Arguments Value Note See Also Examples
Accepts formatted accounting data (as would be found in data imported from .csv
,
.xls
, or xlsx
files, as well as from webscraping) with dollar signs and
character notations for trillion, billion, and million. Converts the input into a numeric
that can be used in operations that require type as.numeric.
1 | cleanAccount(acc)
|
acc |
Character; string of a number in accounting format (i.e. "$792.76B") |
Numeric; non-formatted version of the input argument
Data with a suffix of a single "m" or "M" character will not be considered "1000" but will be interpreted as one million (1000000).
Other data cleaning functions: cleanIP
,
cleanIndex
, cleanSector
1 2 | cleanAccount("$792.76B")
cleanAccount("435.5 mn")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.