combine two data frames with all posible combinations

by

With this particular example I think you can just use the merge function. As a standard its arguments all.x and all.y are set to TRUE, so it automatically creates all combinations since the dataframes do not have any variables or values in common.

df <-data.frame(a=letters[1:10] )
df1<-data.frame(one=1:10)

dfcomb <- merge(df,df1)
dim(dfcomb) 
[1] 100   2 #gives 100 rows and 2 columns

More Related Contents:

  1. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  2. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  3. Replace values greater than zero with 1 in r
  4. Gather multiple sets of columns
  5. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  6. Combine Multiple Columns Into Tidy Data [duplicate]
  7. R spreading multiple columns with tidyr [duplicate]
  8. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  9. Using spread with duplicate identifiers for rows
  10. Proper idiom for adding zero count rows in tidyr/dplyr
  11. Add NAs to make all list elements equal length
  12. Reshape from long to wide and create columns with binary value
  13. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  14. Filling missing dates in a grouped time series – a tidyverse-way?
  15. data.table equivalent of tidyr::complete()
  16. Canonical tidyverse method to update some values of a vector from a look-up table
  17. Spreading a two column data frame with tidyr
  18. Error with select function from dplyr
  19. Mutate multiple variable to create multiple new variables
  20. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  21. mutate with case_when and contains
  22. Add row in each group using dplyr and add_row()
  23. pivot_longer into multiple columns
  24. Unlisting columns by groups
  25. Extract a dplyr tbl column as a vector
  26. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  27. ignore NA in dplyr row sum
  28. mutate function is not updating
  29. How to pass column name as argument to function for dplyr verbs?
  30. How to use data.table within functions and loops?

Leave a Comment