New in Mathematica 14.2

Version 14.2 introduces a powerful tool in Tabular , which provides a very streamlined and efficient way to handle tables of data laid out in rows and columns, with hundreds of other functions enhanced to make use of its special features. Additional new functions and improvements have been added to enhance neural nets and LLMs, work with game theory, improve GPU computation, and expand images and videos.

Stephen Wolfram's Blog Entry announcing Version 14.2

• Create a version of a function protected against bad input with Failsafe
• Delete elements not obeying a criterion function with Discard
• Use AssociationComap to create an association by applying a list of functions to a value
• Display an expression completely shielded from evaluation with HoldCompleteForm
• Tabular represents column-oriented tabular data with different types, missing values, etc.
• ToTabular converts to Tabular with detailed control
• Multiple new functions introduced to support Tabular operations: FromTabular, TabularQ, TabularColumn, TabularRow, TabularSchema, ColumnKeyExistsQ, TabularQ, TabularColumnQ and TabularRowQ
• Several built-in functions have been updated to support Tabular natively, including Part, Take, Drop, TakeDrop, Key, KeyDrop, KeyTake, Select, Discard, TakeSmallestBy, TakeLargestBy, MaximalBy and MinimalBy
• Many Import formats have been added or updated to support tabular data, such as CSV, XLSX, XLS, ODS, SXC, TSV, Table, Parquet, ArrowIPC, ORC, ArrowDataset, SAV, SAS7BDAT, DTA, POR, XPORT, RData, RDS and DIF
• DataConnectionObject allows for connecting to data stores (with authentication, queries, etc.) such as "AmazonS3", "AzureBlobStorage", "Dropbox" and "IPFS"
• DatabaseReference updated to allow relational databases to be used as out-of-core back ends for Tabular
• Return an in-memory version of an out-of-core object with ToMemory
• Handle missing and outlier values in tabular data with TransformMissing and TransformAnomalies, respectively
• Spread values from a single column into several columns with PivotToColumns; inversely, gather values from several columns into one column with PivotFromColumns
• Use TransformColumns to compute columns from values in each row
• Perform simple or grouped aggregation with AggregateRows
• Compute a pivot table with multiple row and column pivots and aggregation with PivotTable
• Many visualization functions have been updated to support plotting values from tabular columns, including BarChart, PieChart, BubbleChart, Histogram, DateHistogram, ListPlot, ListLinePlot, ListPlot3D, StackedListPlot, DateListPlot and more
• Perform asynchronous LLM generation with LLMSynthesizeSubmit and ChatSubmit
• Multiple machine learning and neural network functions have been updated to support Tabular, including Classify, Predict, ClassifierMeasurements, PredictorMeasurements, FindClusters, LearnDistribution, FeatureExtraction, DimensionReduce, FeatureSpacePlot, NetTrain and NetMeasurements
• Represent a simultaneous game specified by payoff matrices or arrays with MatrixGame
• Find Nash equilibria in a MatrixGame with FindMatrixGameStrategies
• Visualize matrix games and strategies with MatrixGamePlot
• Represent a sequential game specified by a game tree with TreeGame
• Find subgame perfect equilibria (SPE) for a TreeGame with FindTreeGameStrategies
• Visualize tree games and strategies with TreeGamePlot
• Simplify or expand symbolic array expressions with ArraySimplify and ArrayExpand, respectively
• Use ComponentExpand to expand a symbolic array expression into its component parts
• Find the instant of relevant astronomical events with FindAstroEvent
• MidDate computes the midpoint date of a granular date or list of dates
• GPUArray stores data in memory accessible for GPU-accelerated computation
• Multiple built-in functions have been updated to support GPUArray, including ArrayDepth, Dimensions, Length, Part, Dot, Transpose, ConjugateTranspose, Diagonal, Tr, LinearSolve, Fourier, SeedRandom, RandomInteger, Mean, Variance, Min, Max, Plus, Times, Total, Sin, Cos, Tan, ArcSin, Exp, Log and more
• Detect and track objects in a video with VideoObjectTracking
• Highlight objects in a video with HighlightVideo
• Use SubtitleStyle to specify style for created subtitle tracks
• MagnetostaticPDEComponent models magnetostatics without currents
• MagneticPDEComponent models quasistatic magnetic fields with currents

See the complete list of what's new in the Wolfram Language with Mathematica 14.2 at the Wolfram Research website