R Error (from NA’s to 0): duplicate subscripts for column in Data Frame

I looked at multiple answers on Stackoverflow, but I stil couldn’t fix my problem. I made a function that works, but I added something and now it won’t work anymore. I want to replace all NA’s to 0, which seems simple to me.

This is my function, and I added bframe[is.na(bframe)] <- 0:

B <- function(frame1, frame2, column){
  bframe <- merge(frame 1, frame2, by = column, all = TRUE)
  bframe$result <- bframe$freq.x - bframe$freq.y
  bframe$percentage <- (bframe$result/bframe$freq.y)*100
  bframe[is.na(bframe)] <- 0
  return(bframe)
}

B(DT2_1, 2_1, "BurgS")

However, it gives this error: Error in '[<-.data.frame'('* tmp *, thisvar, value = 0) : duplicate subscripts for columns.

The error occurs because there are NAs and it cannot perform the calculations:

BurgS  freq.x  freq.y  result   percentage  percentageABS
1      9204    184042  -174838  -94.99897   94.99897 
2      150     3034    -2884    -95.05603   95.05603 
3      130     2602    -2472    -95.00384   95.00384 
98     NA      47      NA       NA          NA

Not every data frame has this structure, so I am looking for a solution that changes NA’s in the whole data set. Can someone help me out?

Changed 26/6/2018: I stumbled up the solution myself. The code is as follows, so that the NA of freq.x is changed to 0 and still can be part of the calculations which the outcome is shown in the last three columns:

B <- function(frame1, frame2, column){
  bframe$freq.x[is.na(bframe$freq.x)] <- 0
  bframe <- merge(frame 1, frame2, by = column, all = TRUE)
  bframe$result <- bframe$freq.x - bframe$freq.y
  bframe$percentage <- (bframe$result/bframe$freq.y)*100
  return(bframe)
}

B(DT2_1, 2_1, "BurgS")

Related Posts:

  1. Emulate ggplot2 default color palette
  2. ggplot wrong color assignment
  3. How to rename a single column in a data.frame?
  4. Critical t values in R
  5. t-stat for feature selection
  6. Reasons for using the set.seed function
  7. What does na.rm=TRUE actually means?
  8. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  9. How do I replace NA values with zeros in an R dataframe?
  10. How to change legend title in ggplot
  11. Changing column names of a data frame
  12. Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
  13. R on MacOS Error: vector memory exhausted (limit reached?)
  14. Counting the number of elements with the values of x in a vector
  15. Non-numeric Argument to Binary Operator Error in R
  16. Non-numeric Argument to Binary Operator Error in R
  17. R issue “object not found”
  18. Error in Confusion Matrix : the data and reference factors must have the same number of levels
  19. Why do I get “number of items to replace is not a multiple of replacement length”
  20. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  21. Extracting value specific rows in R
  22. “Error: Mapping should be created with `aes()` or `aes_()`.”
  23. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  24. Longer object length is not a multiple of shorter object length?
  25. plot.new has not been called yet
  26. Error in lm.fit(x,y,offset = offset, singular.ok,…) 0 non-NA cases with boxcox formula
  27. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  28. Logistic regression – eval(family$initialize) : y values must be 0 <= y <= 1
  29. Opposite of %in%: exclude rows with values specified in a vector
  30. Add text to ggplot
  31. Rotating and spacing axis labels in ggplot2
  32. Arcsine transformation of percentage data
  33. R loop that adds following numbers to each element in list
  34. Can I calculate z-score with R?
  35. Reading PSV (pipe-separated) file or string
  36. Function to clear the console in R and RStudio
  37. plot.new has not been called yet
  38. “replace” function examples
  39. Why I get this error writing data to a file
  40. Remove NA values from a vector
  41. Correlation between multiple variables of a data frame
  42. character string is not in a standard unambiguous format
  43. Remove rows with all or some NAs (missing values) in data.frame
  44. duplicate ‘row.names’ are not allowed error
  45. Function to clear the console in R and RStudio
  46. Adding a regression line on a ggplot
  47. Invalid factor level, NA generated warning
  48. R: “Unary operator error” from multiline ggplot2 command
  49. invalid type (list) for variable
  50. not a Stata version 5-12 .dta file
  51. Error: unexpected ‘}’ in “}” in R [duplicate]
  52. No non-missing arguments warning when using min or max in reshape2
  53. How to convert a factor to integer\numeric without loss of information?
  54. Having trouble setting working directory
  55. Understanding `scale` in R
  56. Add empty columns to a dataframe with specified names from a vector
  57. `fread` with headers with special characters (latin1) and unusual nested quotes
  58. Generate a set of random unique integers from an interval
  59. How to move or position a legend in ggplot2
  60. Rotating and spacing axis labels in ggplot2
  61. “installation of package ‘FILE_PATH’ had non-zero exit status” in R
  62. Plot multiple lines (data series) each with unique color in R
  63. Replace all particular values in a data frame
  64. Plot a legend outside of the plotting area in base graphics?
  65. Still getting error in dev.off() : cannot shut down device 1 (the null device)
  66. How to sum a variable by group
  67. lme4 error: boundary (singular) fit: see ?isSingular
  68. How to get summary statistics by group
  69. Non-conformable arrays error in code
  70. object of type ‘builtin’ is not subsettable
  71. What causes an R script to get Killed?
  72. Combine two data frames by rows (rbind) when they have different sets of columns
  73. Function to calculate R2 (R-squared) in R
  74. dplyr mutate with conditional values
  75. `Error in file(con, “r”) : cannot open the connection` from running BRugsFit()
  76. Getting invalid model formula in ExtractVars when using rpart function in R
  77. Too few periods for decompose()
  78. Error in match.fun(FUN)
  79. installing data.table results in “there is no package”
  80. changing title in multiplot ggplot2 using grid.arrange
  81. Correct syntax for mutate_if
  82. Plotting data in R; error: default method not implemented for type ‘list’
  83. Error:attempt to apply non-function
  84. Changing fonts in ggplot2
  85. Error in xj[i] : invalid subscript type ‘list’
  86. How do you specifically order ggplot2 x axis instead of alphabetical order?
  87. Sample random rows in dataframe
  88. Batch convert columns to numeric type
  89. Error in eval(predvars, data, env) : object ‘Rm’ not found
  90. How to initialize a vector with fixed length in R
  91. Efficiently sum across multiple columns in R
  92. How can I make a list of lists in R?
  93. lib unspecified & Error in loadNamespace
  94. How to convert data.frame column from Factor to numeric [duplicate]
  95. Merge data frames based on rownames in R
  96. What do these R glm error messages mean: “Error: no valid set of coefficients has been found: please supply starting values”
  97. Remove columns from dataframe where some of values are NA
  98. What is the meaning of the dollar sign “$” in R function()?
  99. How can I change the name of a data frame
  100. How to calculate combination and permutation in R?

Leave a Comment