Reshape DataFrame¶
Convert Pandas DataFrame Between Wide Format and Long Format
-
reshape.
gather
(df, key_col=None, key='key', value='value', dropna=True)¶ Gather column to key-value pairs
Parameters: - df (DataFrame) –
- key (return DataFrame column name of key) –
- value (return DataFrame column name fo value) –
- dropna (boolean, default True) – Whether to drop rows in the resulting Frame/Series with no valid values
Returns: Return type: Pandas DataFrame
-
reshape.
spread
(df, row_index, key)¶ Spread key-value pair to multiple columns
Parameters: - df (long format Dataframe) –
- row_index (transform to wide format row index column) –
- key (key column which return DataFrame column name) –
Returns: Return type: Pandas DataFrame