Exploratory
Search
K
Comment on page

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

  1. 1.
    Rows - select columns for Pivot Row.
  2. 2.
    Columns - select colums for Pivot Columns.
  3. 3.
    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.
clarity_colour
GIA
HRD
VS1_F
5842
0
VS2_H
4585
0
VVS2_F
5881
10796
VVS2_H
5193
0
Last modified 2yr ago