basetable: A Complete Function Reference2 months ago
Introduction | Core verbs | Subsetting rows and columns: subset() | Picking and dropping columns: pick(), drop() | Creating and modifying columns: transform(), within() | Renaming columns: renamecols() | Aggregation and grouping | Grouped summaries: aggregate() | Counting rows: count(), propcount() | Named summaries with summaries() | Splitting into groups: split() and applyby() | First/last row per group: firstby(), lastby() | Joining tables | Standard joins: merge() | Semi- and anti-joins: semimerge(), antimerge() | Key-matching helpers: matchedkeys(), unmatchedkeys(), joinrelationship() | Cross joins: crossmerge() | Rolling and nearest-key joins: rollingmerge(), nearestmerge() | Interval overlap joins: overlapmerge() | Updating values from another table: updatemerge() | Conditional joins: nonequimerge(), rangemerge() | Set operations and table comparison | Row-level set operations: unionrows(), intersectrows(), diffrows() | Comparing two tables: equalrows(), equaldata(), sameschema(), compareschema(), changedcols() | Comparing two snapshots of the same table: addedrows(), removedrows(), changedrows() | Row/column binding: rbindfill(), cbind() | Reshaping | Long and wide formats: tolong(), towide() | Base R reshape, stack, and unstack: reshape(), stack(), unstack() | Splitting and combining text columns: separate(), unite() | Transposing: transpose() | Exploration and EDA | Shape and types: dims(), types(), nrows(), ncols() | Peeking at data: headtail(), preview() | Descriptive statistics: describe(), profile() | Frequency tables: freq() | Table 1-style summaries: summarytab() | Missingness: missingness() | Comparing two tables at a glance: compare() | Data cleaning and validation | Assertions that stop on failure: assert*() | Finding rows/values that fail a check: invalidrows(), invalidvalues(), outofrange() | Missing-data helpers: missingrows(), keepmissing(), omitmissing(), missingindicator() | Filling in missing combinations: completegrid(), expandrows() | Recoding values: naif(), nato(), blanktona(), natoblank(), replacevalues(), replacewhere(), replacecols() | Deduplication: uniquerows(), removeduplicates(), duplicaterows(), duplicatekeys(), duplicatenames() | Column-name hygiene: cleannames(), repairnames(), renamewith(), commonnames() | Filling in missing values within groups: filldown(), fillup(), fillboth() | Row and column utilities | Column metadata: colnames(), rownames(), classes(), uniques(), cardinality(), constants(), emptycols() | Finding blank rows: emptyrows() | Reordering columns: move(), firstcols(), lastcols() | Row subsets: firstrows(), lastrows(), samplerows(), samplefrac(), reverse() | Sorting rows: orderrows() | Row position helpers: rownumber() | Row-wise reductions across columns: rowmin(), rowmax(), rowany(), rowall(), rowcount(), rowfirst(), rowlast(), rowapply() | Applying a function to selected columns: applycols(), convertcols() | String manipulation | Whitespace and case: trim(), squish(), lower(), upper(), titlecase(), sentencecase(), textlen() | Substrings and padding: left(), right(), middle(), truncate(), padleft(), padright(), padcenter() | Pattern matching: containstext(), matchestext(), startswith(), endswith(), countmatch(), locate(), locateall() | Extraction: extract(), extractall(), extractnum(), extractint(), extractbetween() | Replace and remove: replacetext(), removetext(), removeall(), replaceall() | Split and join: splittext(), splitfirst(), splitlast(), jointext(), collapsetext() | Blank and encoding helpers: isblank(), removeaccents(), normalizeunicode(), normalizeencoding(), transliterate() | String distance and similarity: textdist(), nearesttext(), similartext() | Classification predicates: isalpha(), isalphanumeric(), isnumerictext(), isintegertext(), isemail(), isurl() | Recoding and grouping values: recode(), collapsevalues(), casewhen(), collapselevels(), lump(), reorderlevels(), expandlevels() | Parsing text into typed values | Dates and times | Extracting components | Arithmetic and sequences: adddays(), addweeks(), addmonths(), addyears(), datediff(), dateseq(), betweendates() | Rounding dates: floordate(), ceilingdate(), rounddate() | Numeric transforms and rolling windows | Rescaling and standardizing: rescale(), standardize(), center(), winsorize() | Binning: quantilegroup() | Period-over-period change and rank: percentchange(), percentrank(), denserank() | Cumulative helpers: cumcount(), cumedist(), cumavg() | Lag/lead and differencing: difference(), lagvalue(), leadvalue() | Rolling window functions: rollmean(), rollsum(), rollmin(), rollmax(), rollmedian(), rollsd(), rollvar(), rollprod(), rollapply() | Functional helpers | Closing notes
basetable 1.4.2Imad El Badisy functions-reference.Rmd