Merge error : negative length vectors are not allowed

I tried to merge two data.frames, and they are like below:

   GVKEY YEAR coperol     delta     vega firm_related_wealth
1 001045 1992       1  38.88885 17.86943            2998.816
2 001045 1993       1  33.57905 19.19287            2286.418
3 001045 1994       1  48.54719 16.85830            3924.053
4 001045 1995       1 111.46762 38.71565            8550.903
5 001045 1996       1 218.89279 45.59413           17834.921
6 001045 1997       1 415.61461 51.45863           34279.515

AND

   GVKEY YEAR fracdirafter fracdirafterindep twfracdirafter
1 001004 1996         1.00              0.70    1.000000000
2 001004 1997         0.00              0.00    0.000000000
3 001004 1998         0.00              0.00    0.000000000
4 001004 1999         0.00              0.00    0.000000000
5 001004 2000         0.00              0.00    0.000000000
6 001004 2001         0.25              0.25    0.009645437

They both have 1,048,575 rows. My code is merge(a,b,by=c("GVKEY","YEAR")), I kept receiving error message “negative length vectors are not allowed“. I also tried the data.table way, but got error message saying that my results would exceed 2^31 rows. Apparently, the merged data will not be so big, so I am not sure how to solve this issue.

Related Posts:

  1. How do I select the first row in an R data frame that meets certain criteria?
  2. Poker hand range chart visualization in R
  3. Error in plot.new() : figure margins too large, Scatter plot
  4. How to join (merge) data frames (inner, outer, left, right)
  5. rbind error: “names do not match previous names”
  6. rbind error: “names do not match previous names”
  7. $ operator is invalid for atomic vectors for dataframe R
  8. adding x and y axis labels in ggplot2
  9. Set NA to 0 in R
  10. R: Using equation with natural logarithm in nls
  11. kmeans complains “NA/NaN/Inf in foreign function call (arg 1)”, when there are none?
  12. Why use as.factor() instead of just factor()
  13. Update R using RStudio
  14. mean() warning: argument is not numeric or logical: returning NA
  15. ‘x’ and ‘y’ lengths differ ERROR when plotting
  16. What does “Error: object ‘‘ not found” mean?
  17. mean() warning: argument is not numeric or logical: returning NA
  18. Difference between paste() and paste0()
  19. How do I delete rows in a data frame?
  20. Error in grid.Call(L_textBounds, as.graphicsAnnot(x$label), x$x, x$y, : Polygon edge not found
  21. Drop data frame columns by name
  22. Having trouble setting working directory
  23. How to find the statistical mode?
  24. How can two strings be concatenated?
  25. Error in colMeans(x, na.rm = TRUE) : ‘x’ must be numeric in KNN classification
  26. Error in ggplot.data.frame : Mapping should be created with aes or aes_string
  27. SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
  28. Remove a row from a data table in R
  29. Add color to boxplot – “Continuous value supplied to discrete scale” error
  30. Error in plot.window(…) : need finite ‘xlim’ valuescc
  31. “Error: Continuous value supplied to discrete scale” in default data set example mtcars and ggplot2
  32. Logistic Regression on factor: Error in eval(family$initialize) : y values must be 0 <= y <= 1
  33. Error: Incorrect number of dimensions in R
  34. cannot coerce type ‘closure’ to vector of type ‘character’
  35. Basic – T-Test -> Grouping Factor Must have Exactly 2 Levels
  36. Error: attempt to use zero-length variable name
  37. How does one reorder columns in a data frame?
  38. R error: cannot coerce type ‘closure’ to vector of type ‘double’
  39. scale_color_manual() not working
  40. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) 0 non-na cases
  41. Clear R environment of all objetcs & packages
  42. Why I get this error writing data to a file
  43. How to save a data frame as CSV to a user selected location using tcltk
  44. Plot a line graph, error in xy.coords(x, y, xlabel, ylabel, log) : ‘x’ and ‘y’ lengths differ
  45. Subscript out of bounds – general definition and solution?
  46. R: Error in eval(predvars, data, env) : numeric ‘envir’ arg not of length one in intrinsic.pars() in multgee package
  47. Calculate correlation for more than two variables?
  48. Convert a list to a data frame
  49. What does the double percentage sign (%%) mean?
  50. How to subset a Data frame column wise using column names?
  51. Create an empty data.frame
  52. Error : length of ‘dimnames’ [2] not equal to array extent
  53. Can’t draw Histogram, ‘x’ must be numeric
  54. How can I plot data with confidence intervals?
  55. MLE error in R: initial value in ‘vmmin’ is not finite
  56. Rename multiple columns by names
  57. Unimplemented type list when trying to write.table
  58. Remove rows with all or some NAs (missing values) in data.frame
  59. Subscript out of bounds – general definition and solution?
  60. Convert date-time string to class Date
  61. Reshaping data.frame from wide to long format
  62. How to set limits for axes in ggplot2 R plots?
  63. duplicate ‘row.names’ are not allowed error
  64. predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
  65. Nested ifelse statement
  66. Convert categorical variables to numeric in R
  67. How to sum data.frame column values?
  68. How do I get RSS from a linear model output
  69. Warning message: In `…` : invalid factor level, NA generated
  70. Mean of a column in a data frame, given the column’s name
  71. How to overcome error:”attempt to set ‘colnames’ on an object with less than two dimension” in xts object
  72. What does “The following object is masked from ‘package:xxx'” mean?
  73. grep using a character vector with multiple patterns
  74. How to avoid “Error in stripchart.default(x1, …) : invalid plotting method” error?
  75. ‘height’ must be a vector or a matrix. barplot error
  76. install.packages fails in knitr document: “trying to use CRAN without setting a mirror”
  77. Unused arguments in R
  78. How to convert a data frame column to numeric type?
  79. Optimization of a function in R ( L-BFGS-B needs finite values of ‘fn’)
  80. Error: ggplot2 doesn’t know how to deal with data of class matrix?
  81. Error in file(filename, “r”, encoding = encoding) : cannot open the connection
  82. What is integer overflow in R and how can it happen?
  83. R histogram range error: some ‘x’ not counted; maybe ‘breaks’ do not span range of ‘x
  84. Error in contrib.url(repos, “source”) in R trying to use CRAN without setting a mirror Calls: install.packages -> contrib.url Execution halted
  85. Error in : target of assignment expands to non-language object
  86. run a for loop in parallel in R
  87. How do I combine two data-frames based on two columns?
  88. How to eliminate “NA/NaN/Inf in foreign function call (arg 7)” running predict with randomForest
  89. Indicator function in R
  90. IF “OR” multiple conditions
  91. R4DS error comparison (1) is possible only for atomic and list types
  92. Error in x[[i]] : recursive indexing failed at level 2
  93. non-numeric argument to binary operator
  94. How to avoid “operations are possible only for numeric, logical or complex types” when computing top 3 elements in each group
  95. Column standard deviation R [duplicate]
  96. Meaning of objects being masked by the global environment
  97. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  98. invalid (do_set) left-hand side to assignment in R
  99. How do I print a hexadecimal number with leading 0 to have width 2 using sprintf?
  100. In R, dealing with Error: ggplot2 doesn’t know how to deal with data of class numeric

Leave a Comment

tech