Have got a dataframe like below:
Site Flow Week Type MAE
11 Onion Red 19 Forecast 14.66
11 Onion Red 19 APU6 19.49
11 Onion Red 19 APU5 26.26
11 Onion Red 20 Forecast 2.16
11 Onion Red 20 APU6 7.40
11 Onion Red 20 APU5 14.73
11 Apple Pink 19 Forecast 24.65
11 Apple Pink 19 APU6 10.49
11 Apple Pink 19 APU5 16.2
11 Apple Pink 20 Forecast 3.10
11 Apple Pink 20 APU6 8.30
11 Apple Pink 20 APU5 15.73
Need to transform some rows as column like below
Site Flow Week Forecast APU6 APU5
11 Onion Red 19 14.66 19.49 26.26
11 Onion Red 20 2.16 7.40 14.73
11 Apple Pink 19 24.65 10.49 16.2
11 Apple Pink 20 3.10 8.30 15.73
Help me out!
