Finding unique values in a dataset for market basket analysis in csv file

by

Consider for example:

# create demo comma-separated file:
library(arules)
data(Groceries)
lst <- as(Groceries, "list")
writeLines(sapply(lst, paste, collapse=","), tf<-tempfile(fileext = ".csv"))
# readLines(tf)[1:3]
# # [1] "citrus fruit,semi-finished bread,margarine,ready soups"
# # [2] "tropical fruit,yogurt,coffee"                          
# # [3] "whole milk" 

# load csv and check number of items
trans <- read.transactions(tf,"basket",sep=",")
trans
# transactions in sparse format with
#  9835 transactions (rows) and
#  169 items (columns)
ncol(trans)
# [1] 169

More Related Contents:

  1. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  2. Numbering rows within groups in a data frame
  3. Subset rows corresponding to max value by group using data.table
  4. Fastest way to replace NAs in a large data.table
  5. Plot labels at ends of lines
  6. Number of months between two dates
  7. Convert integer to class Date
  8. How to set up conda-installed R for use with RStudio?
  9. How to uninstall R and RStudio with all packages, settings and everything else?
  10. Replace multiple strings in one gsub() or chartr() statement in R?
  11. Get values and positions to label a ggplot histogram
  12. How to subset data in R without losing NA rows?
  13. Using grep to help subset a data frame
  14. double integral in R
  15. R’s read.csv prepending 1st column name with junk text [duplicate]
  16. Delete duplicate rows in two columns simultaneously [duplicate]
  17. Should I use a data.frame or a matrix?
  18. How to change the now deprecated dplyr::funs() which includes an ifelse argument?
  19. Error in new.session() : Could not establish session after 5 attempts
  20. add image in title page of rmarkdown pdf
  21. Error in R: (Package which is only available in source form, and may need compilation of C/C++/Fortran)
  22. ggplot: Boxplot of multiple column values [duplicate]
  23. Gantt style time line plot (in base R)
  24. Replace missing values (NA) in one data set with values from another where columns match
  25. Asymmetric expansion of ggplot axis limits
  26. as.Date(as.POSIXct()) gives the wrong date?
  27. Convert scientific notation to numeric, preserving decimals
  28. Rcpp function check if missing value
  29. Fill option for fread
  30. Give name to list variable

Leave a Comment