0

I have the long dataframe like:

   Item  Count    Per 
Chinese   3351  96.3%
English     28   0.8% 
   Math    100  2.87%

I want to pivot to wide table like this:

Item  Chinese  English  Math
Count    3351       28   100
Per     96.3%     0.8%  2.87%

I have tried

dt_wide <- dt %>% tidyr::pivot_wider(id_cols = Count, names_from = Item, values_from = Per)

Totally Not what I want to get. Any help would be greatly appreciated! Thank you!

benson23
  • 16,369
  • 9
  • 19
  • 38
Alegría
  • 179
  • 5

0 Answers0