0

i have an Dataframe with Columns symbol, YEAR, netIncome and change. The DataFrame has 2 YEARS, which should be both columns with the netIncome. (Is it easier to change the SQL Statement?)

          symbol  YEAR(date)    netIncome change
quarter
Q1       1037.HK        2019      2893750
Q1       1037.HK        2020      2566500
Q2       1037.HK        2019      2268550
Q2       1037.HK        2020      2586250

How it should be:

          symbol    YEAR1(2019)   YEAR2(2020)  change
quarter
Q1       1037.HK     2893750       2566500
Q2       1037.HK     2268550       2586250

Thanks for all helpfull comments

0 Answers0