Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]

by

You can try this

num <- c("1.23M", "15.69B", "123.999M")
num <- gsub('B', 'e9', num)
num <- gsub('M', 'e6', num)
format(as.numeric(num), scientific = FALSE, big.mark = ",")

"84,060,000" "30,120,000,000" "251,290,000"

More Related Contents:

  1. R spreading multiple columns with tidyr [duplicate]
  2. Reshape multiple values at once
  3. How to complete missing factor levels in data frame?
  4. How to transpose a dataframe in tidyverse?
  5. Quickly reading very large tables as dataframes
  6. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  7. Convert a list to a data frame
  8. Split a large dataframe into a list of data frames based on common value in column
  9. Splitting a dataframe string column into multiple different columns [duplicate]
  10. Conditional replacement of values in a data.frame
  11. How do I combine two data-frames based on two columns? [duplicate]
  12. R Apply() function on specific dataframe columns
  13. Count NAs per row in dataframe [duplicate]
  14. Spread with data.frame/tibble with duplicate identifiers
  15. Using spread with duplicate identifiers for rows
  16. Add (insert) a column between two columns in a data.frame
  17. Add a prefix to column names
  18. Create a Data Frame of Unequal Lengths
  19. apply a function over groups of columns
  20. Specifying column names in a data.frame changes spaces to “.”
  21. Convert from billion to million and vice versa
  22. Delete a column in a data frame within a list
  23. Dollar sign before a variable
  24. R: Replace multiple values in multiple columns of dataframes with NA
  25. R convert dataframe to JSON
  26. Select rows from one data.frame that are not present in a second data.frame
  27. How to sort all dataframes in a list of dataframes on the same column?
  28. Join two data frames in R based on closest timestamp
  29. Shifting a column down by one
  30. Identifying where value changes in R data.frame column

Leave a Comment