R—在多个名称和值上更宽的枢轴

Question

我将数据按如下方式排列:

<表类> 行业 年国家 价值 tbody><<tr>Ind_A1999国家1245Ind_A2000B国132Ind_B2000国家145Ind_C2000B国122

你需要设置names_from = "Industry，你会有正确的

df %>% 
pivot_wider(names_from = "Industry", values_from = "Value") %>% 
arrange(Country)
# A tibble: 3 × 5
Year Country  Ind_A Ind_B Ind_C
<int> <chr>    <int> <int> <int>
1  1999 CountryA  1245    NA    NA
2  2000 CountryA    NA   145    NA
3  2000 CountryB   132    NA   122