I have two dataframes df1 # var1 var2 # 1 X01 Red # 2 X02 Green # 3 X03 Red # 4 X04 Yellow # 5 X05 Red # 6 X06 Green df2 # X01 X02
I'm migrating a query of Oracle pivot to PostgreSQL crosstab. create table(cntry numeric,week numeric,year numeric,days text,day text); insert into x_c values(