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`
RecordsSummary
​
RecordsSummary[data]
summarizes the argument data.
​
​
RecordsSummary[data,cols]
summarizes data using the specified column names cols.
​
Details and Options

Examples  
(18)
Basic Examples  
(5)
Summarize a vector of numbers:
In[1]:=
RecordsSummary
[RandomReal[{-10,10},100]]
Out[1]=

1 column 1
Min
-9.78836
1st Qu
-5.9724
Median
-1.61349
Mean
-0.485644
3rd Qu
5.00192
Max
9.98062

​
Summarize a matrix of strings and specify the column names:
In[1]:=
sarr=Transpose[{RandomChoice[CharacterRange["A","Z"],20],RandomWord["CommonWords",20]}];​​
RecordsSummary
[sarr,{"random letter","random word"}]
Out[1]=

1 random letter
D
2
G
2
I
2
O
2
S
2
T
2
(Other)
8
,
2 random word
ascribe
1
capsicum
1
cropper
1
encrypt
1
filtration
1
hear
1
(Other)
14

​
Summarize a vector of numbers with missing values:
In[1]:=
RecordsSummary
[RandomSample[Join[RandomReal[{-10,10},100],Table[Missing[],4]]]]
Out[1]=

1 column 1
Min
-9.86408
1st Qu
-5.16355
Median
-0.7392
Mean
-0.413041
3rd Qu
3.85282
Max
9.89438
Missing[___]
4

​
Summarize a full 2D array with numerical and categorical columns (numbers, strings, and symbols):
In[1]:=
Block[{n=200},​​arr=Flatten/@Transpose[{RandomReal[{-10,10},{n,2}],MapAt[ToLowerCase,RandomChoice[CharacterRange["A","Z"],{n,2}],{All,2}],RandomChoice[{,,Γ},n]}]​​];
In[2]:=
RecordsSummary
[arr]
Out[2]=

1 column 1
Min
-9.78729
1st Qu
-4.8424
Mean
0.241568
Median
0.489257
3rd Qu
5.47596
Max
9.81633
,
2 column 2
Min
-9.91169
1st Qu
-4.67995
Median
0.482631
Mean
0.505138
3rd Qu
5.8764
Max
9.96417
,
3 column 3
U
12
F
11
I
11
Q
10
Z
10
B
9
(Other)
137
,
4 column 4
z
14
u
12
g
11
n
11
p
11
x
11
(Other)
130
,
5 column 5

75

67
Γ
58

Summarize a dataset:
In[3]:=
RecordsSummary
[Dataset[arr]]
Out[3]=

1
Min
-9.78729
1st Qu
-4.8424
Mean
0.241568
Median
0.489257
3rd Qu
5.47596
Max
9.81633
,
2
Min
-9.91169
1st Qu
-4.67995
Median
0.482631
Mean
0.505138
3rd Qu
5.8764
Max
9.96417
,
3
U
12
F
11
I
11
Q
10
Z
10
B
9
(Other)
137
,
4
z
14
u
12
g
11
n
11
p
11
x
11
(Other)
130
,
5

75

67
Γ
58

Summarize a dataset with column names:
In[4]:=
ds=Dataset[arr][All,AssociationThread[{"num1","num2","char1","char2","symb"},#]&];
In[5]:=
RecordsSummary
[ds]
Out[5]=

1 num1
Min
-9.78729
1st Qu
-4.8424
Mean
0.241568
Median
0.489257
3rd Qu
5.47596
Max
9.81633
,
2 num2
Min
-9.91169
1st Qu
-4.67995
Median
0.482631
Mean
0.505138
3rd Qu
5.8764
Max
9.96417
,
3 char1
U
12
F
11
I
11
Q
10
Z
10
B
9
(Other)
137
,
4 char2
z
14
u
12
g
11
n
11
p
11
x
11
(Other)
130
,
5 symb

75

67
Γ
58

​
Summarize an association of vectors:
In[1]:=
asc=AssociationThread[Range[10]Table[Append[RandomReal[1,2],RandomWord[]],10]];
In[2]:=
RecordsSummary
[asc,ThreadTrue]
Out[2]=

1 column 1
Min
1
1st Qu
3
Mean
5.5
Median
5.5
3rd Qu
8
Max
10

1 column 1
Min
0.0108506
1st Qu
0.144962
Mean
0.350332
Median
0.350455
3rd Qu
0.459586
Max
0.825137
,
2 column 2
Min
0.0641558
1st Qu
0.194447
Median
0.40316
Mean
0.46101
3rd Qu
0.672576
Max
0.964379
,
3 column 3
confabulate
1
crate
1
forthwith
1
hassle
1
reflex
1
reignite
1
(Other)
4

Scope  
(4)

Options  
(3)

Applications  
(2)

Possible Issues  
(1)

Interactive Examples  
(1)

Neat Examples  
(2)

SeeAlso
Tally
RelatedGuides
▪
Data reshaping functions
""

© 2025 Wolfram. All rights reserved.

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