how to convert data.frame to transactions for arules

by

I have found some information that worked for me on this website. Let me copy relevant paragraph:

The dataframe can be in either a normalized (single) form or a flat file (basket) form.
When the file is in basket form it means that each record represents a transaction where the items in the basket are represented by columns.
When the dataset is in single form it means that each record represents one single item and each item contains a transaction id.

To load transactions from file, use read.transactions. In both your and my case file is in the single form.
I’ve used following code to load .csv file as transactions:

trans = read.transactions("some_data.csv", format = "single", sep = ",", cols = c("transactionID", "productID"))

To fully understand above command, take a look at read.transactions manual, available after typing ?read.transactions in R console.

More Related Contents:

  1. Looping over a Date or POSIXct object results in a numeric iterator
  2. Is there a dplyr equivalent to data.table::rleid?
  3. Capitalize the first letter of both words in a two word string
  4. `levels
  5. Frequency count of two column in R
  6. Creating arbitrary panes in ggplot2
  7. Selecting multiple odd or even columns/rows for dataframe
  8. Rolling mean (moving average) by group/id with dplyr
  9. Getting path of an R script
  10. Difference: “Compile PDF” button in RStudio vs. knit() and knit2pdf()
  11. Rotating x axis labels in R for barplot
  12. How do I convert a factor into date format?
  13. Pass a vector of variable names to arrange() in dplyr
  14. How to select a CRAN mirror in R
  15. How subset a data frame by a factor and repeat a plot for each subset?
  16. change background and text of strips associated to multiple panels in R / lattice
  17. percentage on y lab in a faceted ggplot barchart?
  18. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  19. Milliseconds in POSIXct Class
  20. heatmap with values (ggplot2)
  21. How to choose variable to display in tooltip when using ggplotly?
  22. Using different scales as fill based on factor
  23. Conditional binary join and update by reference using the data.table package
  24. predict.lm() with an unknown factor level in test data
  25. How to read csv file in R where some values contain the percent symbol (%)
  26. Delete entries with only one observation in a group
  27. Specify height and width of ggplot graph in Rmarkdown knitr output
  28. how to debug “factor has new levels” error for linear model and prediction [duplicate]
  29. How to get all possible subsets of a character vector in R?
  30. Convert latitude and longitude coordinates to country name in R

Leave a Comment