Dear R helpers,

xx = data.frame(country = c("USA", "UK", "Canada"), x = c(10, 50, 20), y = c(40, 80, 35), z = c(70, 62, 10))

> xx
       country      x     y    z
1      USA        10    40  70
2     
 UK          50   80   62
3     Canada    20   35   10




I need to arrange this as a new data.frame as follows -

country       type     values
USA            x         10 
USA            y         40
USA            z         70
UK             x         50
 
UK             y         80 
UK             z         62  
Canada         x         20  
Canada         y         35
Canada         z         10

I did try reshape package but things are in mess. Please guide

Regards

Vincy  
 


	[[alternative HTML version deleted]]

