Convert from billion to million and vice versa

by

One idea,

new <- ifelse(gsub('.*\\s+', '', DF$Revenue) == 'bn',
              as.numeric(gsub('[A-Za-z]', '', DF$Revenue))*1000, DF$Revenue)

new[!grepl('Mn', new)] <- paste(new[!grepl('Mn', new)], 'Mn', sep = ' ')
DF$Revenue <- new

DF
#  Brands  Revenue
#1      A 50100 Mn
#2      B 41200 Mn
#3      C  32.5 Mn
#4      D 15100 Mn

To do the opposite then,

new <- ifelse(gsub('.*\\s+', '', DF$Revenue) == 'Mn',
               as.numeric(gsub('[A-Za-z]', '', DF$Revenue))/1000, DF$Revenue)

 new[!grepl('bn', new)] <- paste(new[!grepl('bn', new)], 'bn', sep = ' ')
 DF$Revenue <- new
 DF
#  Brands   Revenue
#1      A   50.1 bn
#2      B   41.2 bn
#3      C 0.0325 bn
#4      D   15.1 bn

More Related Contents:

  1. Repeat each row of data.frame the number of times specified in a column
  2. Filter data.frame rows by a logical condition
  3. Split column at delimiter in data frame [duplicate]
  4. Pass a data.frame column name to a function
  5. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  6. Select groups based on number of unique / distinct values
  7. Assign multiple columns using := in data.table, by group
  8. Filtering a data frame on a vector [duplicate]
  9. How to replace NA values in a table for selected columns
  10. Remove an entire column from a data.frame in R
  11. Sample n random rows per group in a dataframe
  12. Select every nth row from dataframe
  13. Remove Rows From Data Frame where a Row matches a String
  14. duplicates in multiple columns
  15. R – add column that counts sequentially within groups but repeats for duplicates
  16. Extend contigency table with proportions (percentages)
  17. R self reference
  18. Subsetting a data frame based on contents of another data frame
  19. Unlist a data frame by rows, not columns
  20. Deleting columns from a data.frame where NA is more than 15% of the column length [duplicate]
  21. Using lapply to apply a function over list of data frames and saving output to files with different names
  22. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  23. Return df with a columns values that occur more than once [duplicate]
  24. Row-wise sum of values grouped by columns with same name
  25. Replicate each row of data.frame and specify the number of replications for each row?
  26. Count unique values for every column
  27. Numbers as column names of data frames
  28. Divide each value by the sum of values by group
  29. Convert all data frame character columns to factors
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment