Saya memiliki data.frame dengan dua kolom, pengidentifikasi unik dan hasil. Saya perlu mengulang data.frame dan menghitung berapa banyak Pengidentifikasi unik yang ada dan menghitung hasil uniknya. Kolom hasil dapat memiliki tiga kemungkinan hasil, Positif, Negatif, atau Ambigu. Jadi misalnya jika ada 10 pengidentifikasi “RVP PCR” saya perlu membuat baris dengan empat kolom lagi, "Hitungan", "Positif", "Negatif", "Ambigu" dan di kolom tersebut harus ada hitungan berapa kali itu terjadi. Jadi dalam contoh dengan 10 Pengidentifikasi ”RVP PCR”, baris keluaran harus menampilkan Pengidentifikasi kemudian hitungan 10, 7 Negatif, 1 Positif dan 2 Ambigu. Bagaimana Anda mencapai ini dengan R ?
str(foo)
>
'data.frame': 51 obs. of 2 variables:
$ identifier: Factor w/ 99 levels "ADENOPCR","ALB-BF",..: 51 51 56 56 57 57 57 57 18 18 ...
$ result : Factor w/ 3 levels "Ambiguous","Negative",..: 2 1 2 1 2 1 2 1 2 1 ...
dput(foo)
>
structure(list(identifier = structure(c(80L, 80L, 80L, 80L, 80L,
80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L,
80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 80L, 64L,
18L, 18L, 76L, 76L, 76L, 70L, 70L, 70L, 70L, 71L, 64L, 77L, 77L,
77L, 77L, 77L, 77L, 77L, 77L, 76L), .Label = c("ADENOPCR", "ALB-BF",
"ASPERAG", "ASPERAGB", "BDGLUCAN", "BLASTO", "BORD PCR", "BPERT",
"CMV QNT", "CMVPCR", "COCCI", "COCCI G/M", "COCCI PAN", "COCCI-PPT",
"CPNEUMOPCR", "CRP", "CRY BLD", "CWP-KOH", "DIFF CONF", "EBV PAN",
"EBV PAN 2", "EBV QNT", "EXCEPT", "EXCEPT TT", "FLUFAC", "FUNG PKG",
"FUNGSEQ", "GLU-FL", "HERP I", "HHV6PCR", "HISTO", "HISTO PPT",
"HISTOAG S", "HISTOGM U", "HMPVFA", "HMPVPCR", "HSVPCR", "LEGAG-U",
"LEGIONFA", "LEGIONPCR", "MA AFB", "MA FUNGAL", "MA MIC", "MA MTBPRIM",
"MC AFB", "MC AFBID", "MC AFBR", "MC BAL", "MC BLD", "MC CYST",
"MC FUNG", "MC FUNGID", "MC Legion", "MC LEGION", "MC MTD", "MC NOC",
"MC RESP", "MC STAPH", "MC Strep", "MC STREP", "MC VRE", "MC W",
"MICROSEQ", "MPNEUMOPCR", "MS CWP", "MTBRIF PCR", "MYCO-M", "NG REPORT",
"ORGSEQ", "PARAFLUPCR", "PCP PCR", "PNEUMO AB", "PNEUMST", "PNEUMST R",
"RESPMINI", "RESPMINI ", "RSPFA", "RSPFAC", "RSV", "RVP PCR",
"RVPPCR", "SPN AG", "TP-FL", "V CMVC", "V FLUC", "V HSVC", "V HSVCT",
"V RESPC", "V Urea", "V VIC", "V VIC R", "V VIRAL", "V VIRAL N",
"V VIRAL R", "V VZV", "VDRL CSF", "VZVFAC", "VZVPCR", "WNILE PCR"
), class = "factor"), result = structure(c(2L, 2L, 3L, 2L, 2L,
2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 3L, 2L, 2L, 2L, 2L,
2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 3L, 2L, 2L, 2L, 2L, 2L, 3L,
2L, 2L, 2L, 3L, 3L, 3L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), .Label = c("Ambiguous",
"Negative", "Positive"), class = "factor")), .Names = c("identifier",
"result"), row.names = 1500:1550, class = "data.frame")