Category

# Data Manipulation & Analysis

165 items

Pairs each element of a list with its index

• ### AggregateSmallest

Group small values in an association into a single category

• ### Antidiagonal

Give the antidiagonal of a matrix

• ### AntidiagonalMatrix

Creates an antidiagonal matrix by given the antidiagonal

• ### AppendColumn

Append a column to the right of a matrix

• ### ApplyLevel

Create an operator that applies a function over data at a specified level

• ### ArcsineLawRandomnessTest

Use the arcsine law to assess the randomness of a sequence of zeros and ones

• ### AssociatePairs

Convert a list of pairs into an association

• ### AssociationKeyFlatten

Flatten keys in a nested association

• ### AssociationMapAt

Similar to MapAt but with improved behavior for nested expressions involving associations

• ### AssociationPartition

Partition an association into a list of associations

• ### BayesianLinearRegression

Perform Bayesian linear regression with conjugate priors

• ### BinaryRunRandomnessTest

Conduct a runs–based test on a sequence of zeros and ones

• ### BinarySearch

Find the position of a target value within a sorted array

• ### BinarySearchBy

Find the position of a target value within an array sorted after applying a function

• ### BinCountAssociation

Collect histogram data in an association of bin intervals and bin heights

• ### BinListsBy

Bins data in to lists based on applying a function to each item.

• ### BiPlot

Visualize the principal components of tabular data

• ### BisectList

Make a pair of lists consisting of alternate terms from the original list

• ### BitListToByteArray

Convert a list of bits to a byte array

• ### BoolEval

Fast vectorized evaluation of array inequalities

• ### BootstrapStatistics

Bootstrap a single statistic or a list of statistics

• ### ByteArrayToBitList

Converts a byte array to a list of bits

• ### CanonicalListRotation

Return a canonical rotation for a list of values

• ### ChernoffFace

Make Chernoff face diagrams

• ### ChiSquareRandomnessTest

Test a sequence of zeroes and ones (or a set of random reals between 0 and 1) for equidistribution and return a p-value

• ### ChordDiagram

Make a weighted connectivity graph using circular embedding

• ### ConditionedMultinormalDistribution

Calculate conditional and marginal distributions of the multivariate normal distribution

• ### ConstantAssociation

Create an association whose values are all a constant

• ### ContainsQ

Determine whether an input expression contains one or more subexpressions (at any level) matching a given pattern

• ### CorrespondingIntegers

Create a list of positive integers containing as many elements as the expression to which it is applied

• ### CrossRecurrencePlot

Visualize the overlap of two discrete time series

• ### CrossTabulate

Compute the contingency table for a two- or three- column dataset or array

• ### CrossValidateModel

Check the quality of a data fitting model by splitting the data into test and validation sets multiple times

• ### CumulativeAverages

Calculate the cumulative averages of a list

• ### CUSUMMaxRandomnessTest

Conduct a cumulative sum-based randomness test that creates a test statistic from the maximum value that a cumulative sums random walk achieves

One-step creation of a Dataset with named columns

Delete adjacent duplicates from a list

• ### DeleteCasesFrom

Remove all elements from the value of a symbol that match a pattern and reset the symbol to the result

• ### DeleteFailures

Delete failures in an expression

• ### DiracMatrix

Dirac matrices in any dimensions

Eliminate elements from a list for which a given conditional is True

• ### DNAAlignmentPlot

Generate a visualization for DNA sequence alignment

• ### DropColumn

Drop columns from matrices

• ### DuplicatesList

Give the elements that appear more than once in the input list

• ### EmptyQ

Test whether a structure can be considered empty

• ### Equisample

Sample evenly spaced elements from a list

• ### FindRanges

Find continuous ranges in a list of integers

• ### FourierShift

Shift the zero-frequency term to the center of the spectrum

• ### FromISOCountry

Parse ISO 3166-1 country codes to a Country entity

• ### FromISOTimestamp

Parse a string in ISO 8601 format to a DateObject

• ### GetKeyValuePattern

Create a suitable KeyValuePattern from an example association

• ### HedgesG

Computes the Hedges' g statistic measuring an "effects size" difference between two lists of data

• ### ImportCSVToDataset

Import CSV and TSV files to datasets

• ### IndependentComponentAnalysis

Decompose a matrix into Independent Component Analysis matrix factors

• ### InShuffle

Perform an in shuffle on a list

• ### IntervalComplement

Calculate the complement of intervals

• ### IrregularPeriodogram

Compute a periodogram for data from unevenly spaced intervals

• ### ItemCounts

A two-argument form of Counts that gives an association between a set of provided keys and the number of times those keys appear in a list

• ### JoinMost

An operator that joins in front of its arguments the sequence of lists it is provided

• ### JoinRest

An operator that performs a Join of its argument with the sequence of lists it is provided

• ### KeyCombine

Map a function over the keys of an association, and collect or combine values in the event of key collisions

• ### KeyIndex

Create an association indexed by a given key from a list of associations

• ### KeyMapIf

Map a function conditionally over keys in an association

• ### KeyReplace

Replace keys in an association

• ### KullbackLeiblerDivergence

Calculate the Kullback–Leibler divergence between two distributions

• ### ListGrowthPlot

Plot the growth of lists and temporal data

• ### Loess

Smooth noisy data using local regression

• ### LogSumExpLayer

Neural network layer that implements the LogSumExp operation on any level

• ### LookupKeys

Look up a set of keys applying a function when a key is missing

• ### MapLevel

Create an operator that maps a function over data at a specified level

• ### MappedTransformedDistribution

Transform a statistical distribution by applying the same function to all of its arguments

• ### MapReduceOperator

Like an operator form of GroupBy, but where one also specifies a reducer function to be applied

• ### MapSelectCounted

Map a function over selected elements of a list, also passing in a running count of such elements

Create a beta distribution using the mean and a measure of its spread as parameters instead of using the conventional parameters

• ### MetricNumberString

Convert raw numbers into metric system amounts for human readability

• ### MultidimensionalScaling

Reduce a matrix of real values to low dimension using the principal coordinates analysis method

• ### MultiNonlinearModelFit

Fit multiple datasets with multiple expressions that share parameters

• ### MultipleAxesListPlot

A version of ListPlot that displays two lists of data with different y axes

• ### MultipleAxesPlot

Display different vertical axes for two plotted expressions

• ### MultisetDiceDissimilarity

Compute the Dice dissimilarity of two multisets

• ### MultisetJaccardDissimilarity

Compute the Jaccard dissimilarity of two multisets

• ### MultisetSokalSneathDissimilarity

Compute the Sokal–Sneath dissimilarity of two multisets

• ### NestedKeyDrop

Drop keys from a nested association

• ### NestedLookup

Look up a set of keys in order to get deeper parts of an association or list of rules

• ### NInverseFourierTransform

Find a numerical approximation for the inverse Fourier transform

• ### NPseudoVoigt

Fast numerical approximation to the PDF of the Voigt distribution with around 1.2% of maximum deviation

• ### OEISSequence

Return the list provided by the OEIS for a given OEIS sequence number

• ### OutShuffle

Perform an out shuffle on a list

• ### PairwiseScatterPlot

Construct a scatter plot matrix

• ### PermutationAscents

Give the indices of a permutation where there is an immediate ascent

• ### PivotTable

A spreadsheet-like operation to collate data by values common to specified columns, summarizing corresponding values in a specified column

• ### PointsToRules

Convert a list of points into a list of substitution rules

• ### PolarDendrogramPlot

Plot a polar dendrogram of a clustering

• ### PooledStandardDeviation

Compute the pooled standard deviation of multiple lists of data

• ### PooledVariance

Compute the pooled variance of multiple lists of data

• ### PopulationStandardDeviation

Compute the population standard deviation for a set of data

• ### PopulationVariance

Compute the population variance for a set of data

• ### PositionedCases

Find positions and values within an expression matching a pattern

• ### PositionLargest

Get the position of the largest elements in a list

• ### PositionLargestBy

The position of the elements in a list that are largest according to a given function

• ### PowerMean

Compute the mean of a list of numbers all taken to some power

• ### PowerSubdivide

Subdivide an interval such that the ratio of subsequent elements is constant

• ### PowerTotal

Compute the total of a list of numbers all taken to some power

• ### PrefixQ

Test if the first elements of a list are the same as those from another list

• ### PrependColumn

Prepend a column to the left of a matrix

• ### PrettyGrid

Conveniently display two dimensional data in a nicely styled grid

• ### ProgressiveMaxPositions

Find the positions of the largest elements so far in a list

• ### Proportions

Get the proportion of times that each distinct element appears in a list

• ### ProportionsBy

Get the proportion of times that each distinct element appears in a list when evaluated with a given function

• ### QuantileOperator

An operator form of the Quantile function

• ### QuantileRegression

Computes quantile regression fits over a time series, a list of numbers or a list of numeric pairs

• ### QueryTreeForm

Present a query as a tree

Show numerical data in a radar-style chart

• ### RandomRealPoint

Randomly choose a point within a specified domain

• ### Rarest

The rarest elements in a list

• ### RatioPartition

Partition a list into sublists with lengths proportional to weights in another list

• ### RecordsSummary

Summarizes datasets, lists, or associations that can be transformed into full two dimensional arrays

• ### RegressionListPlot

Display the regression line of a dataset

• ### ReplaceAllOutside

Similar to ReplaceAll, but parts of the expression can be ignored by providing a pattern

• ### ReplaceAt

Replace parts of an expression using replacement rules and a part specification

• ### ResetDataset

Force a reanalysis of the types contained in a Dataset, sometimes leading to a different presentation of the data

• ### RotateLeftUntil

Cycle the elements of a list to the left until a criterion is satisfied

• ### RunCountRandomnessTest

Conduct a runs up–based randomness test on a sequence of random reals between 0 and 1

• ### RunLengthRandomnessTest

Conduct a randomness test on a sequence of random reals between 0 and 1 using run lengths of increasing subsequences

• ### SecondsToday

Fractional number of seconds that have elapsed since midnight

• ### SelectFirstBy

Apply a function to a list and select the first that satisfies a test

• ### SelectFirstIndex

Find the index of the first element satisfying a criterion

• ### SelectIndices

Find indices of parts satisfying a criterion

• ### SelectPositions

A function like Select that returns positions instead of values

• ### SequenceGraph

Create a graph from a data sequence

• ### SerialRandomnessTest

Conduct an empirically derived test that assesses randomness using the frequencies of serial combinations of 0s and 1s

• ### SetPartitions

Give all possible ways to partition a set into blocks, ignoring the order of blocks and order within blocks

• ### Slice

An operator form of Part

• ### SortLike

Sort a list so that elements in common with another list are in the same order

• ### SparseAssociation

Create a data rectangular structure that behaves like a SparseArray indexed by string keys

• ### SpectralRandomnessTest

Use a discrete cosine transform–based method to test the randomness of a sequence of random reals

• ### SplitWhen

Split a list every time an element satisfies a test

• ### StatisticsSummary

Create summary statistics for numeric data

• ### TableQ

Similar to ArrayQ, except it allows for ragged collections of nested lists

• ### TableToTrainingSet

Prepare rectangular data for use in machine learning functions Classify, Predict and NetTrain

• ### TakeAfter

Take elements after a specified element in an expression

• ### TakeBefore

Take elements before the specified element in an expression

• ### TakeLarger

Take values larger than a threshold in a list or association

• ### TakeSmaller

Take values smaller than a threshold in a list or association

• ### TallyBy

Tally items that give the same value when a function is applied

• ### TimeSeriesCompress

Remove redundant data from a time series

• ### TimeSeriesZero

Shift a time series to start at 0 seconds

• ### ToAssociations

Recursively replace lists of rules with associations

• ### TrainTestSplit

Split data into training and testing sets

• ### TrimLeft

Shorten lists to the same length by removing elements from the left

• ### TrimRight

Shorten lists to the same length by removing elements from the right

• ### TwoSidedPValue

Find the probability of the absolute value of the test statistic being at least as extreme as the given value

• ### UnionTo

Equivalent to Union but redefines the first argument to the result

• ### UniqueCases

Similar to Cases, but removes duplicates

• ### UnsortedComplement

Delete the elements of some lists from a list x without changing either the order of x or the multiplicities of its elements

• ### ValueMap

Similar to AssociationMap but maps over a given set of values to obtain keys rather than vice versa

• ### ValueMapIndexed

Create an association from a set of values, using a map-indexed function on those values to form the keys

• ### VarianceAround

Calculate the variance of a list along with its uncertainty

• ### VennGraphPlot

Visualize the intersections of overlapping sets

• ### VideoColorMap

Create a “color map” image from a video

• ### WinLossChart

Create a simple bar chart that shows the number of items in a list that fit set criteria compared to those that do not