Find duplicate values in R

You could use table, i.e.

n_occur <- data.frame(table(vocabulary$id))

gives you a data frame with a list of ids and the number of times they occurred.

n_occur[n_occur$Freq > 1,]

tells you which ids occurred more than once.

vocabulary[vocabulary$id %in% n_occur$Var1[n_occur$Freq > 1],]

returns the records with more than one occurrence.

Related Posts:

  1. Replace a value in a data frame based on a conditional (`if`) statement
  2. How to read in .HTM into R as a data frame?
  3. Create empty data frame with column names by assigning a string vector?
  4. Changing font size and direction of axes text in ggplot2
  5. How to randomize ggplot factor color scheme, keeping same default distances on color wheel?
  6. Count number of occurences for each unique value
  7. Warning message: line appears to contain embedded nulls [duplicate]
  8. How to change line width in ggplot?
  9. Change size of axes title and labels in ggplot2
  10. Multiple If Statements in R
  11. ggplot geom_text font size control
  12. What’s the difference between lapply and do.call?
  13. ggplot2, change title size
  14. Combine two or more columns in a dataframe into a new column with a new name
  15. Initial value in ‘vmmin’ is not finite even when changing the starting value
  16. Test if a vector contains a given element
  17. R “Error: unexpected ‘}’ in “}”
  18. How to remove outliers from a dataset
  19. Insert a blank column in dataframe
  20. Mean per group in a data.frame
  21. standard deviation on dataframe does not work
  22. Warning message: In `…` : invalid factor level, NA generated
  23. How to increase font size in a plot in R?
  24. Merge r brings error “‘by’ must specify uniquely valid columns”
  25. Subscripts in plots in R
  26. Aggregate multiple columns at once
  27. Non-numeric argument to mathematical function
  28. Position-dodge warning with ggplot boxplot?
  29. Plot two graphs in same plot in R
  30. data.table vs dplyr: can one do something well the other can’t or does poorly?
  31. Error in rep(1, n.ahead) : invalid ‘times’ argument in R
  32. Producing subscripts in R markdown
  33. lme4::lmer reports “fixed-effect model matrix is rank deficient”, do I need a fix and how to?
  34. How do you use “<<-" (scoping assignment) in R?
  35. Remove quotes from a character vector in R
  36. Convert data.frame columns from factors to characters
  37. Re-ordering factor levels in data frame
  38. Is it possible to have a multi-line comments in R?
  39. Understanding the result of modulo operator: %%
  40. R – error “variable lengths differ”
  41. Select rows from a data frame based on values in a vector
  42. how to increase the limit for max.print in R
  43. dplyr: “Error in n(): function should not be called directly”
  44. In R formulas, why do I have to use the I() function on power terms, like y ~ I(x^3)
  45. backward elimination in R
  46. Error in eval(expr, envir, enclos) : object not found
  47. Filter data.frame rows by a logical condition
  48. Replace NA with 0 in a data frame column [duplicate]
  49. How to plot 3D scatter diagram using ggplot?
  50. How do I convert a factor into date format?
  51. R will plot but won’t draw abline
  52. scale_fill_discrete and scale_fill_manual – legend options confusion
  53. ‘Incomplete final line’ warning when trying to read a .csv file into R
  54. Merging data – Error in fix.by(by.x, x)
  55. Error in 2:n : NA/NaN argument
  56. Error : Unable to start png() device
  57. How do I flip rows and columns in R
  58. Remove NA values from a vector
  59. How to catch integer(0)?
  60. Print string and variable contents on the same line in R
  61. Does R have a wildcard expression (such as an asterisk (*))?
  62. r random forest error – type of predictors in new data do not match
  63. Simple for loop in R producing “replacement has length zero” in R
  64. Removing punctuations from text using R
  65. How to find out which package version is loaded in R?
  66. How to solve it. error:Error in data[[rowvar]] : attempt to select less than one element
  67. How to melt and cast dataframes using dplyr?
  68. How to prevent scientific notation in R?
  69. How to declare a vector of zeros in R
  70. Launching R help: Error in file(out, “wt”) : cannot open the connection
  71. Boolean operators && and ||
  72. R avoiding “restarting interrupted promise evaluation” warning
  73. How to increase the font size of ggtitle in ggplot2
  74. do-while loop in R
  75. Error in as.vector(x, mode) : cannot coerce type ‘closure’ to vector of type ‘any’
  76. Suppress output of a function
  77. Error in G * t(hat) : non-conformable arrays
  78. Get dplyr count of distinct in a readable way
  79. Error: isTRUE(gpclibPermitStatus()) is not TRUE
  80. What does is.na() applied to non-(list or vector) of type ‘NULL’ mean?
  81. error r: invalid subscript type “closure” in a simple regression
  82. Merge two rows in data.frame
  83. r function unzip error 1 in extracting from zip file
  84. Colour points in a plot differently depending on a vector of values
  85. How to access the last value in a vector?
  86. increase legend font size ggplot2
  87. Mask output of `The following objects are masked from….:` after calling attach() function
  88. How To Create Vector of Vector In R
  89. Round down a numeric
  90. Use of ~ (tilde) in R programming Language
  91. Construct a manual legend for a complicated plot
  92. Code to clear all plots in RStudio
  93. Error: x must be atomic for ‘sort.list’
  94. Installing R on Android
  95. Transposing in dplyr
  96. Can dplyr join on multiple columns or composite key?
  97. Convert data.frame column to a vector?
  98. Error in summary.connection(connection) : invalid connection
  99. Converting from a character to a numeric data frame
  100. When trying to replace values, “missing values are not allowed in subscripted assignments of data frames”

Leave a Comment