У меня есть таблица данных вида
ID REGION INCOME_BAND RESIDENCY_YEARS
1 SW Under 5,000 10-15
2 Wales Over 70,000 1-5
3 Center 15,000-19,999 6-9
4 SE 15,000-19,999 15-19
5 North 15,000-19,999 10-15
6 North 15,000-19,999 6-9
создан
exp = data.table(
ID = c(1,2,3,4,5,6),
REGION=c("SW", "Wales", "Center", "SE", "North", "North"),
INCOME_BAND = c("Under ?5,000", "Over ?70,000", "?15,000-?19,999", "?15,000-?19,999", "?15,000-?19,999","?15,000-?19,999"),
RESIDENCY_YEARS = c("10-15","1-5","6-9","15-19","10-15", "6-9"))
Я хотел бы преобразовать это в
Мне удалось проделать большую часть работы с dcast:
exp.dcast = dcast(exp,ID~REGION+INCOME_BAND+RESIDENCY_YEARS, fun=length,
value.var=c('REGION', 'INCOME_BAND', 'RESIDENCY_YEARS'))
Однако мне нужна помощь в создании разумных заголовков столбцов. В настоящее время у меня есть
["ID"
"REGION.1_Center_? 15,000-? 19,999_6-9"
"REGION.1_North_? 15,000-? 19,999_10-15"
"REGION.1_North_? 15,000-? 19,999_6- 9 "
" REGION.1_SE_? 15,000-? 19,999_15-19 "" REGION.1_SW_Under? 5,000_10-15 "" REGION.1_Wales_Over? 70,000_1-5 "
" INCOME_BAND.1_Center_? 15,000-? 19,999 _6-9 "
" ДОХОДНАЯ_БАНДА.1_Северная_? 15 000-? 19 999_10-15 "
" ДОХОДНАЯ_БАНДА.1_Северная_? 15 000-? 19,999_6-9 "
" ДОХОДНАЯ_БАНДА.1_SE_? 15 000-? 19,999_15- 19 "
" INCOME_BAND.1_SW_Under? 5,000_10-15 "
" INCOME_BAND.1_Wales_Over? 70,000_1-5 "
" RESIDENCY_YEARS.1_Center_? 15,000-? 19,999_6-9 "" RESIDENCY_YEARS.1_North_? 15,000 -? 19,999_10-15 "" RESIDENCY_YEARS.1_SW_? 15,000-? 19,999_6-9 "
" RESIDENCY_YEARS.1_SE_? 15,000-? 19,999_15-19 "
" RESIDENCY_YEARS.1_SW_Under? 5,000_10-15 "< br> "RESIDENCY_YEARS.1_Wales_Over? 70,000_1-5"
И я бы хотел, чтобы заголовки столбцов были
ID SW Wales Center SE North Under 5,000 Over 70,000 15,000-19,999 1-5 6-9 10-15 15-19
Кто-нибудь может посоветовать?