
HI,

I want to transform the following dataset

 Product Price_LC.1 Price_LC.2 Price_elasticity.1 Price_elasticity.2 Mean_Price Mean_Price_elasticity Trade_Price_Band Country
     100     35               52           -4.14                   -2.84               47              -3.69                         0-542811              VN
   1208     43               53           -3.94                   -3.45               47              -3.65                         0-542811              VN



into:

  
Product       VN                  Price_Band
  
100           -3.69                 0-542811   
                [35,52] 
                [43,53]

1208         -3.65                 0-542811
               [43,53]
               [-3.94,-3.45]


How do I get it in R? I have large dataset like this, I need to create mechanism to tranform those. Thanks.


Kind regards,
Lingyi



 		 	   		  
	[[alternative HTML version deleted]]

