Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Unpivot a DataFrame from wide format to long format, optionally leaving identifier columns set. This is the reverse to groupBy(...).pivot(...).agg(...), except for the aggregation, which cannot be reversed.
melt is an alias for unpivot.
Syntax
melt(ids: Union["ColumnOrName", List["ColumnOrName"], Tuple["ColumnOrName", ...]], values: Optional[Union["ColumnOrName", List["ColumnOrName"], Tuple["ColumnOrName", ...]]], variableColumnName: str, valueColumnName: str)
Parameters
| Parameter | Type | Description |
|---|---|---|
ids |
str, Column, tuple, list, optional | Column(s) to use as identifiers. Can be a single column or column name, or a list or tuple for multiple columns. |
values |
str, Column, tuple, list, optional | Column(s) to unpivot. Can be a single column or column name, or a list or tuple for multiple columns. If not specified or empty, use all columns that are not set as ids. |
variableColumnName |
str | Name of the variable column. |
valueColumnName |
str | Name of the value column. |
Returns
DataFrame: Unpivoted DataFrame.
Notes
Supports Spark Connect.