Answer to Question #293846 in Python for YKZ

Question

"""Q5: 

Create a Pivot Table that shows the median rating for each director, grouped by their respective countries. Name your variable

'pivot_agg'

"""

AssertionError: DataFrame are different

DataFrame shape mismatch
[left]:  (19, 117)
[right]: (125, 1)

Answer 1

import pandas._testing as tm


def unpivot(frame):
    N, K = frame.shape
    data = {
        "value": frame.to_numpy().ravel("F"),
        "variable": np.asarray(frame.columns).repeat(N),
        "date": np.tile(np.asarray(frame.index), K),
    }
    return pd.DataFrame(data, columns=["date", "variable", "value"])


df = unpivot(tm.makeTimeDataFrame(3))