For the complete documentation index, see llms.txt. This page is also available as Markdown.
Pivot
Pivot columns into rows and columns. Values are count of pairs of rows and columns or aggregation of another column.
How to Access This Feature
Click "+" button and select "Pivot"
From Column Menu
You can also select "Pivot" from column menu of the column you want to pivot.
Pivot
Rows - select columns for Pivot Row.
Columns - select colums for Pivot Columns.
Value (Optional) - A column for values in output data frame.
Parameters
Remove NA - The default is TRUE. If NA should be removed from value.
Fill NA with - The default is 0. This is what should be used for missing value in groups.
Example
Original data:
clarity
certification
colour
price
VVS2
HRD
F
10796
VS1
GIA
F
1551
VS1
GIA
F
4291
VVS2
GIA
F
5881
VS2
GIA
H
4585
VVS2
GIA
H
5193
if you set row: clarify, colour columns: certification value: price fill:0
it returns data frame with rows of combinations of clarity and colour and with columns of certification. Values are sum of price and missing values are filled by 0.
