processing negative number in “accounting” format

by

If you create an “as.acntngFmt” method for the accounting format, you can read (or perhaps re-read with a text connection using colClasses(“acnt”).

 setClass("acntngFmt")
 # [1] "acntngFmt"
 setAs("character", "acntngFmt",
    function(from) as.numeric( gsub("\\)", "", gsub("\\(", "-", from))))

  Input <- "A, B, C
  (1.76), 1%, 3.50€
  2.00, 2%, 4.77€
  3.000, 3% , €5.68"

   DF <- read.csv(textConnection(Input), header = TRUE,
     colClasses = c("acntngFmt", "character", "character"))
   str(DF)
'data.frame':   3 obs. of  3 variables:
 $ A: num  -1.76 2 3
 $ B: chr  "1%" "2%" "3%"
 $ C: chr  "3.50€" "4.77€" "€5.68"

More Related Contents:

  1. R tick data : merging date and time into a single object
  2. Replacing negative values in a model (system of ODEs) with zero
  3. Generate multiple graphics from within an R function
  4. Frequency counts in R [duplicate]
  5. Explain a lazy evaluation quirk
  6. Tools for making latex tables in R [closed]
  7. Efficient way to rbind data.frames with different columns
  8. Lattice: multiple plots in one window?
  9. What are the differences between “=” and “
  10. What does the dot mean in R – personal preference, naming convention or more?
  11. Escaping backslash (\) in string or paths in R
  12. R: data.table cross-join not working
  13. in R, use gsub to remove all punctuation except period
  14. Create zip file: error running command ” ” had status 127
  15. Saving multiple ggplots from ls into one and separate files in R
  16. Importing two functions with same name using roxygen2
  17. How to get top n companies from a data frame in decreasing order
  18. Recode categorical variable to binary (0/1)
  19. Sparklyr: how to center a Spark table based on column?
  20. Writing multiple data frames into .csv files using R
  21. Improve centering county names ggplot & maps
  22. How to find the indices of the top 10,000 elements in a symmetric matrix(12k X 12k) in R
  23. Generate ggplot2 boxplot with different colours for multiple groups
  24. Drawing a barchart to compare two sets of data using ggplot2 package?
  25. Plotting multiple graphs in R [closed]
  26. Applying a function to each row of a data.table
  27. ggplot2 – using two different color scales for overlayed plots
  28. Extract digit from numeric in r
  29. What does the period mean when used with ~ (in a formula)?
  30. heatmap-like plot, but for categorical variables

Leave a Comment