mbmackenzie / tidybear Goto Github PK

import pandas as pd
import tidybear as tb
from tidybear.selectors import starts_with

data = pd.DataFrame(
    {
        "THING": ["A", "A", "B", "B"],
        "YEAR": [2021, 2022, 2021, 2022],
        "VALUE": [1, 2, 3, 4],
    }
)

tmp = tb.pivot_wider(data, names_from="YEAR", values_from="VALUE")
tb.pivot_longer(tmp, starts_with("20"), names_to="YEAR", values_to="VALUE")