Querying the Data


For all examples the movies data set contained in the package will be used.

library(UpSetR)
movies <- read.csv( system.file("extdata", "movies.csv", package = "UpSetR"), header=T, sep=";" )


queries Parameter Breakdown

Each list contained in the queries parameter takes 4 fields: query, params, color, and active.

To learn how queries can be explored and visualized on an element level see the Attribute Plots vignette.


Example 1: Built-in Intersection Query

This example shows how to use the built in intersection query, intersects, to find or display elements in specific intersections. In this example the color selected for the active query is from the default color palette.

upset(movies, queries = list(list(query = intersects, params = list("Drama", "Comedy", "Action"), color = "orange", active = T), list(query = intersects, params = list("Drama"), color = "red", active = F), list(query = intersects, params = list("Action", "Drama"), active = T)))


Example 2: Built-In Elements Query

This example shows how to use the built in element query, elements, to visualize how certain elements are distributed amongst the intersections.

upset(movies, queries = list(list(query = elements, params = list("AvgRating", 3.5, 4.1), color = "blue", active = T), list(query = elements, params = list("ReleaseDate", 1980, 1990, 2000), color = "red", active = F)))


Example 3: Using Expression Parameter to Subset Intersection and Element Queries

This example shows how to use the expression parameter to subset the results of element and intersection queries.

upset(movies, queries = list(list(query = intersects, params = list("Action", "Drama"), active = T), list(query = elements, params = list("ReleaseDate", 1980, 1990, 2000), color = "red", active = F)), expression = "AvgRating > 3 & Watches > 100")


Example 4: Creating Custom Queries on Set Elements and Attributes

Creating a custom query to operate on the rows of the data.

Myfunc <- function(row, release, rating){
    data <- (row["ReleaseDate"] %in% release) & (row["AvgRating"] > rating)
}

Applying the created query to the queries parameter.

upset(movies, queries = list(list(query = Myfunc, params = list(c(1970,1980, 1990, 1999, 2000), 2.5), color = "blue", active =T)))


Example 5: Applying a query legend

To add a legend for the queries applied, the query.legend parameter can be used. The query.legend parameter takes the position where the legend should be displayed, either top or bottom. To apply a specific name to each query, the parameter query.name can be used when defining the query in the queries paramter. If no query.name is provided, a generic name will be used. The example below shows how to do this.

upset(movies, query.legend = "top", queries = list(list(query = intersects, params = list("Drama", "Comedy", "Action"), color = "orange", active = T, query.name="Funny action"), list(query = intersects, params = list("Drama"), color = "red", active = F), list(query = intersects, params = list("Action", "Drama"), active = T, query.name="Emotional action")))


Example 6: Applying Everything at Once

Combining pieces from all previous examples into one awesome query!

upset(movies, query.legend = "bottom", queries = list(list(query = Myfunc, params = list(c(1970,1980, 1990, 1999, 2000), 2.5), color = "orange", active =T), list(query = intersects, params = list("Action", "Drama"), active = F), list(query = elements, params = list("ReleaseDate", 1980, 1990, 2000), color = "red", active = F, query.name="Decades")), expression = "AvgRating > 3 & Watches > 100")


Try the UpSetR package in your browser

Any scripts or data that you put into this service are public.

UpSetR documentation built on May 23, 2019, 1:03 a.m.