Upload

newDataset()

Upload data to Crunch to make a new dataset

newExampleDataset()

Import a fixture dataset for testing

toVariable()

Generic method for converting objects to Crunch representations

VariableDefinition() VarDef()

Construct a variable definition

addVariables()

Add multiple variables to a dataset

appendStream()

Manually trigger a pending append to a dataset

pendingStream()

Get the pending streams for a dataset

pk() `pk<-`()

Get and set the primary key for a Crunch dataset

prepareDataForCrunch()

Translate a data.frame to Crunch format

createWithPreparedData()

Upload a prepared data.frame with metadata to Crunch

Load

listDatasets()

Get the names of datasets in a project

loadDataset()

Load a Crunch Dataset

datasets() `datasets<-`()

Get a catalog of datasets

Dataset manipulation

as.environment(<CrunchDataset>)

as.environment method for CrunchDataset

batches()

See the appended batches of this dataset

cleanseBatches()

Remove batches from a dataset

as.data.frame(<CrunchDataset>) as.data.frame(<CrunchDataFrame>)

as.data.frame method for CrunchDataset

delete()

Delete a Crunch object from the server

deleteDataset()

Delete a dataset from the dataset list

ncol() dim(<CrunchDataset>)

Dataset dimensions

dropRows()

Permanently delete rows from a dataset

exclusion() `exclusion<-`()

View and set exclusion filters

restoreVersion()

Restore a dataset to a previously saved version

saveVersion()

Create a new saved version

versions()

Access the saved versions of a dataset

`is.weight<-`() weight() `weight<-`() is.weight()

Dataset weights

weightVariables()

Get a dataset's weightVariables

`weightVariables<-`() `is.weightVariable<-`() modifyWeightVariables() is.weightVariable()

Change which variables can be set as a dataset's weight.

settings() `settings<-`()

View and modify dataset-level settings

popSize() popMagnitude() `popSize<-`() `popMagnitude<-`() setPopulation()

Get and set the market size for Crunch datasets

lock() unlock()

Lock and unlock a dataset for editing

streaming() `streaming<-`()

Set the streaming property of a dataset

Multiple datasets

appendDataset()

Append one Crunch dataset to another

compareDatasets()

Compare two datasets to see how they will append

joinDatasets() extendDataset() merge(<CrunchDataset>)

Add columns from one dataset to another, joining on a key

forkDataset()

Create a fork of a dataset

mergeFork()

Merge changes to a dataset from a fork

searchDatasets()

Search Crunch for datasets.

Variable manipulation

c(<Categories>) c(<Category>)

S3 method to concatenate Categories and Category objects

categoriesFromLevels()

Convert a factor's levels into Crunch categories.

changeCategoryID()

Change the id of a category for a categorical variable

collapseCategories()

Combine Categories in place

variables() `variables<-`() allVariables() `allVariables<-`()

Access a catalog of variables

deleteVariables() deleteVariable()

Delete Variables Within a Dataset

derivation() `derivation<-`() is.derived() `is.derived<-`()

Get or set a derived variable's expression

hiddenFolder() privateFolder() hide() unhide() privatize() deprivatize() hideVariables() `hiddenVariables<-`() unhideVariables() hiddenVariables() privatise() deprivatise() privatizeVariables() privatiseVariables() `privateVariables<-`() deprivatizeVariables() deprivatiseVariables() privateVariables()

Hide/Unhide or Privatize/Deprivatize Variables

na.omit()

Omit missing categories

resolution() `resolution<-`() rollup() rollupResolution() `rollupResolution<-`()

Methods for Datetime variable resolutions

type() `type<-`()

Change Crunch variable types

categories() `categories<-`()

Get and set Categories on Variables

Categories() Category()

Categories in CategoricalVariables

variableMetadata()

Get all variable metadata for a dataset

Deriving variables

crunchdbFunc()

Construct Crunch Expressions from Crunch Database Functions

combine() combineCategories() combineResponses()

Combine categories or responses

copyVariable() copy()

Copy a variable

makeCaseVariable() caseExpr()

Make a case variable

makeCaseWhenVariable() caseWhenExpr()

Create a categorical or numeric variable based on conditions

cut(<NumericVariable>)

Cut a numeric Crunch variable

cut(<DatetimeVariable>)

Cut a Datetime Crunch variable

interactVariables()

Create a variable by interacting categorical variables

conditionalTransform()

Conditional transformation

makeWeight()

Generate a weight variable

as.Text() as.Numeric() as.Categorical() as.Datetime() as.double(<CrunchVariable>) as.character(<CrunchVariable>) as.double(<CrunchExpr>) as.character(<CrunchExpr>)

as.* methods for variables

which(<CrunchLogicalExpr>)

"which" method for CrunchLogicalExpr

rowCount()

Create variables based on row-wise functions for crunch Multiple Response Variables

rowDistinct() straightlineResponse()

Create variables useful for determining whether a row's values are suspicious

slideCategories()

Create sliding subvariable definitions

Array variables

subvariables() `subvariables<-`()

Subvariables in Array Variables

addSubvariable() addSubvariables()

Add subvariable to an array

deleteSubvariables() deleteSubvariable()

Delete subvariables from an array

flipArrays()

Rearrange array subvariables

deriveArray() makeArray() makeMR()

Make a Categorical Array or Multiple Response variable

makeMRFromText()

Create Multiple Response Variable from Delimited lists

makeArrayGadget()

Array builder

is.dichotomized() dichotomize() undichotomize() is.selected() `is.selected<-`()

Indicate how categories represent a dichotomized value

unbind()

Split an array or multiple-response variable into its CategoricalVariables

Folders and organization

folder() `folder<-`()

Find and move entities to a new folder

mv() mkdir()

Functions to manipulate variables' or project's folder structure

cd()

Change to different folder

rmdir()

Delete a folder

setOrder()

Change the order of entities in folder

setName()

Change the name of the current folder

setNames()

Change the name of the entities in a catalog

copyFolders()

Copy the folder structure from one dataset to another.

copyOrder()

Copy the variable order from one dataset to another.

Crunch Automation

runCrunchAutomation() showScriptErrors()

Run a crunch automation script

undoScript() revertScript() scriptSavepoint()

Undo behavior of a Crunch Automation Script

scripts()

Crunch Automation scripts entities for a dataset

Analysis

crtabs()

Crunch xtabs: Crosstab and otherwise aggregate variables in a Crunch Dataset

mean() sd() median() min(<CrunchVariable>) min(<NumericVariable>) min(<DatetimeVariable>) max(<CrunchVariable>) max(<NumericVariable>) max(<DatetimeVariable>)

Univariate statistics on Crunch objects

margin.table() prop.table() bases() round(<CrunchCube>)

Work with CrunchCubes, MultitableResults, and TabBookResults

dimensions() `dimensions<-`() measures() dimnames(<CubeDims>) dim(<CubeDims>) is.na(<CubeDims>) dim(<CrunchCube>) dimnames(<CrunchCube>)

Methods on Cube objects

zScores() rstandard()

Calculate standardized residuals from a CrunchCube

showMissing() hideMissing() showIfAny()

Modify cube missing behavior

index.table()

Calculate an index table for a CrunchCube

dashboard() setDashboardURL() `dashboard<-`()

View or set a dashboard URL

duplicated()

"duplicated" method for Crunch objects

filters() `filters<-`()

Get or set a dataset's filters

is.na(<Categories>) `is.na<-`(<Categories>,<character>) `is.na<-`(<Categories>,<logical>) is.na(<Category>) `is.na<-`(<Category>,<logical>)

is.na for Categories

multitables() `multitables<-`()

Multitable entities for a dataset

newFilter()

Create a new filter

newMultitable()

Create a new Multitable

table()

Table function for Crunch objects

as.vector(<CrunchVariable>) as.vector(<CrunchExpr>)

Convert Variables to local R objects

compareCols() compareRows() compareDims()

Column and row comparison

compareColsPairwise() compareRowsPairwise() compareDimsPairwise()

Pairwise column and row comparison

Decks

decks() `decks<-`()

Get a dataset's DeckCatalog

newDeck()

Create an empty Crunch Deck

filter() `filter<-`() analyses() analysis() `analysis<-`() `query<-`() cube() cubes() formulaToSlideQuery() slideQueryEnv()

Get and set slide analyses

slides() `slides<-`()

Access the slides of a CrunchDeck

newSlide()

Append a new slide to a Crunch Deck

titles() `titles<-`() title() `title<-`() subtitles() `subtitles<-`() subtitle() `subtitle<-`()

Manipulate deck titles

reorderSlides()

Reorder slides in a CrunchDeck

displaySettings() `displaySettings<-`() cubes(<CrunchDeck>)

Get or set a slide's display settings

exportDeck()

Export a Crunch Deck

Data presentation

Subtotal() Heading() subtotals() `subtotals<-`() Subtotal() is.Subtotal() is.Heading() are.Subtotals() are.Headings() Heading()

Subtotals and headings

subtotalArray() applyTransforms()

Calculate the transforms from a CrunchCube

noTransforms()

Remove transformations from a CrunchCube

showTransforms()

Show transformations on a Crunch object

addSummaryStat()

Add summary statistics to a CrunchCube

SummaryStat() SummaryStat() is.SummaryStat() are.SummaryStats()

Summary insertions

Insertions() Insertion() .Insertion() anchor() anchors() `anchor<-`() arguments() `arguments<-`() func() funcs() `subtotals<-`(<Insertion>,<ANY>)

Insert categories in transformations

Transforms() TransformsList() transforms() `transforms<-`()

Transformations of variable and cube views

Export

crunchBox() CrunchBox()

Make a CrunchBox

embedCrunchBox()

Get HTML for embedding a CrunchBox

exportDataset() write.csv(<CrunchDataset>)

Export a dataset to a file

preCrunchBoxCheck()

Check if a dataset will make a good CrunchBox

tabBook()

Compute a Tab Book

write.csv.gz()

Write CSV to a compressed file

writePreparedData()

Persist to disk a prepared data.frame and metadata

pollProgress()

Check a Crunch progress URL until it finishes

dim(<CrunchDataFrame>)

CrunchDataFrame

merge(<CrunchDataFrame>)

Merge a CrunchDataFrame

dim(<TabBookResult>)

TabBookResult and MultitableResult dimension

Geodata

addGeoMetadata()

Add geodata metadata to a crunch variable

availableGeodataFeatures()

Get the property features for available geographies

CrunchGeography() geo() `geo<-`() availableGeodata()

Geography properties for crunch variables

matchCatToFeat()

Match categories with features from geodata

scoreCatToFeat()

Score similarity between a feature dataframe and categories

Admin

is.archived() `is.archived<-`() is.draft() `is.draft<-`() is.published() `is.published<-`() archive() publish()

Get and set "archived" and "published" status of a dataset

owner() `owner<-`()

Get and set the owner of a dataset

getAccountUserCatalog()

Find all users on your account

getTeams()

Retrieve your teams

is.public() `is.public<-`()

View and modify the "public" attribute of artifacts

is.editor() `is.editor<-`()

Read and set edit privileges

login()

Authenticate with the Crunch API

logout()

Kill the active Crunch session

me()

My user entity

users()

Get information about users who have access to a dataset

email()

Extract the email from a User Entity

newProject()

Create a new project

owners() ownerNames()

See who owns these datasets

members() `members<-`() permissions()

Manage access to datasets and other objects

projects()

Get the project catalog

resetPassword()

Reset your password

share()

Share a dataset

unshare()

Revoke a user's access to a dataset

reassignUser()

Reassign all Crunch objects from a user

team() `team<-`()

Share Crunch assets with a team

Utility

is.VariableDefinition() is.VarDef() is.script() is.dataset() is.CrunchExpr() is.Expr() is.Geodata() is.shoji() is.variable() is.Numeric() is.Categorical() is.Text() is.Datetime() is.Multiple() is.MR() is.MultipleResponse() is.CA() is.Array() is.CategoricalArray()

Test whether a Crunch object belongs to a class

name() `name<-`() id() value() `value<-`() description() `description<-`() startDate() `startDate<-`() endDate() `endDate<-`() alias() `alias<-`() digits() `digits<-`() uniformBasis() `uniformBasis<-`() notes() `notes<-`() dates(<Category>) `dates<-`(<Category>)

Name, alias, and description for Crunch objects

aliases() `aliases<-`() descriptions() `descriptions<-`() emails() types() timestamps() ids() `ids<-`() values() `values<-`() scriptBody() dates() `dates<-`() names(<AbstractCategories>) `names<-`(<AbstractCategories>) names(<BatchCatalog>) names(<CrunchDataFrame>) names(<CrunchCube>) notes(<CrunchCube>) names(<CrunchDataset>) names(<ShojiCatalog>) `names<-`(<ShojiCatalog>) names(<CrunchDeck>) `names<-`(<CrunchDeck>) `names<-`(<MultitableCatalog>) names(<ShojiOrder>) names(<OrderGroup>) names(<SlideCatalog>) `names<-`(<SlideCatalog>) names(<CategoricalArrayVariable>) names(<TabBookResult>) names(<MultitableResult>) notes(<VariableCatalog>) `notes<-`(<VariableCatalog>) names(<VersionCatalog>)

Get and set names, aliases on Catalog-type objects

refresh()

Get a fresh copy from the server

webApp()

View a Crunch Object in the Web Application

as.data.frame(<VariableCatalog>) as.data.frame(<ShojiCatalog>) as.data.frame(<BatchCatalog>) as.data.frame(<FilterCatalog>) as.data.frame(<UserCatalog>)

as.data.frame method for catalog objects

index() `index<-`()

Get the body of a Catalog

consent() with_consent()

Give consent to do things that require permission

API

crGET() crPUT() crPATCH() crPOST() crDELETE()

HTTP methods for communicating with the Crunch API

self()

Get the URL of this object

session()

Get various catalogs for your Crunch session

jsonprep() toJSON()

toJSON methods for Crunch objects

Other

CrunchDataset-class

Crunch Datasets

CrunchVariable-class

Variables in Crunch

DatasetOrder-class

Organize Datasets

ShojiObject-class

Mix-in class for multiple inheritance of variables and datasets.

VariableCatalog-class

Collection of Variables within a Dataset

VariableOrder-class

Organize Variables within a Dataset

crunch

Crunch.io: instant, visual, collaborative data analysis

Internal

ContextManager()

Context managers

show()

Show methods for Crunch objects

temp.options() temp.option()

Set some global options temporarily

with(<contextManager>)

Context manager's "with" method

Data

SO_schema

Schema for the 2017 Stack Overflow developer survey

SO_survey

R users who responded to the 2017 Stack Overflow developer survey