Convert character string with Dollar signs and commas to numerics

Description

as.numeric of character strings after suppressing commas and dollar signs. This is a special case of parseCommas.

Usage

parseDollars(x, pattern='\$|,', replacement='', ...)

Arguments

Details

as.numeric(gsub(x, ...)). See also parseCommas.

Value

Numeric vector converted from x.

Author(s)

Spencer Graves

See Also

gsub as.numeric parseCommas

Examples

##
## 1.  a character vector
##
X2 <- c('-$2,500', '$5,000.50')
x2 <- parseDollars(X2)


all.equal(x2, c(-2500, 5000.5))


##
## A data.frame
##
chDF <- data.frame(let=letters[1:2], Dol=X2, dol=x2)
numDF <- parseCommas(chDF)

chkDF <- chDF
chkDF$Dol <- x2

all.equal(numDF, chkDF)

Results

R version 3.3.1 (2016-06-21) -- "Bug in Your Hair"
Copyright (C) 2016 The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library(Ecfun)

Attaching package: 'Ecfun'

The following object is masked from 'package:base':

    sign

> png(filename="/home/ddbj/snapshot/RGM3/R_CC/result/Ecfun/parseDollars.Rd_%03d_medium.png", width=480, height=480)
> ### Name: parseDollars
> ### Title: Convert character string with Dollar signs and commas to
> ###   numerics
> ### Aliases: parseDollars
> ### Keywords: manip
> 
> ### ** Examples
> 
> ##
> ## 1.  a character vector
> ##
> X2 <- c('-$2,500', '$5,000.50')
> x2 <- parseDollars(X2)
> 
> ## Don't show: 
> stopifnot(
+ ## End(Don't show)
+ all.equal(x2, c(-2500, 5000.5))
+ ## Don't show: 
+ )
> ## End(Don't show)
> 
> ##
> ## A data.frame
> ##
> chDF <- data.frame(let=letters[1:2], Dol=X2, dol=x2)
> numDF <- parseCommas(chDF)
Warning message:
In parseDollars(xc, pattern, replacement, ...) : NAs introduced by coercion
> 
> chkDF <- chDF
> chkDF$Dol <- x2
> ## Don't show: 
> stopifnot(
+ ## End(Don't show)
+ all.equal(numDF, chkDF)
+ ## Don't show: 
+ )
> ## End(Don't show)
> 
> 
> 
> 
> 
> dev.off()
null device 
          1 
>