Wolfram Language Paclet Repository

Community-contributed installable additions to the Wolfram Language

Primary Navigation

    • Cloud & Deployment
    • Core Language & Structure
    • Data Manipulation & Analysis
    • Engineering Data & Computation
    • External Interfaces & Connections
    • Financial Data & Computation
    • Geographic Data & Computation
    • Geometry
    • Graphs & Networks
    • Higher Mathematical Computation
    • Images
    • Knowledge Representation & Natural Language
    • Machine Learning
    • Notebook Documents & Presentation
    • Scientific and Medical Data & Computation
    • Social, Cultural & Linguistic Data
    • Strings & Text
    • Symbolic & Numeric Computation
    • System Operation & Setup
    • Time-Related Computation
    • User Interface Construction
    • Visualization & Graphics
    • Random Paclet
    • Alphabetical List
  • Using Paclets
    • Get Started
    • Download Definition Notebook
  • Learn More about Wolfram Language

DataReshapers

Guides

  • Data reshaping functions

Tech Notes

  • Data transformation workflows
  • Long form data transformation
  • Wide form data transformation

Symbols

  • CrossTabulate
  • CrossTabulationMatrixQ
  • CrossTensorate
  • CrossTensorateSplit
  • DatasetToMatrix
  • GridTableForm
  • LongFormDataset
  • PivotLonger
  • RecordsSummary
  • RecordsToLongFormDataset
  • RecordsToWideFormDataset
  • SeparateColumn
  • ToAutomaticKeysAssociation
  • TypeOfDataToBeReshaped
  • WideFormDataset
AntonAntonov`DataReshapers`
WideFormDataset
​
WideFormDataset[ds,idCols,varCol,valCol]
converts the dataset
ds
into wide form that has rows corresponding to
idCols
, columns from the column
varCol
, and values from the column
valCol
.
​
Details and Options

Examples  
(7)
Basic Examples  
(1)
Here is a dataset in long form:
In[1]:=
SeedRandom[55];​​dataset=Dataset

Out[1]=
Word
Letter
Value
automated
b
0.88
automated
a
0.84
dissemble
a
0.97
knitwear
a
0.57
dissemble
c
0.53
dissemble
a
0.93
knitwear
a
0.86
automated
c
0.74
dissemble
b
0.82
Convert to wide form for word vs letter:
In[2]:=
WideFormDataset
[dataset,"Word","Letter","Value"]
Out[2]=
Word
b
a
c
automated
0.88
0.84
0.74
dissemble
0.82
1.9
0.53
knitwear
—
1.43
—
Convert to wide form for word vs letter using a different aggregation function:
In[3]:=
WideFormDataset
[dataset,"Word","Letter","Value","AggregationFunction"Mean]
Out[3]=
Word
b
a
c
automated
0.88
0.84
0.74
dissemble
0.82
0.95
0.53
knitwear
—
0.715
—
Scope  
(1)

Options  
(1)

Applications  
(1)

Properties & Relations  
(2)

Possible Issues  
(1)

SeeAlso
LongFormDataset
 
▪
CrossTabulate
 
▪
RecordsSummary
RelatedGuides
▪
Data reshaping functions
""

© 2025 Wolfram. All rights reserved.

  • Legal & Privacy Policy
  • Contact Us
  • WolframAlpha.com
  • WolframCloud.com