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