-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdash031xWordCloud.R
38 lines (30 loc) · 1.65 KB
/
dash031xWordCloud.R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#[1] "D:/colldash2/collprep"
setwd("./output/")
quickDash <- read.csv("FullDash13.csv", stringsAsFactors = F)
qDchina <- quickDash[which("China" %in% quickDash$Where),]
qDchina <- quickDash[which(grep("China", quickDash$Where)>0,]
#Error: unexpected ']' in "qDchina <- quickDash[which(grep("China", quickDash$Where)>0,]"
#qDchina <- quickDash[which(grep("China", quickDash$Where)>0),]
#View(qDchina)
#NROW(qDchina[which(nchar(qDchina$Who)>0),])
#[1] 261
write.csv(qDchina$Who, file="qDchinaWho.csv", row.names = F, na="")
qDchinaWho <- (qDchina$Who[which(nchar(qDchina$Who)>0)])
write.csv(qDchinaWho, file="qDchinaWho.csv", row.names = F, na="")
write.csv(qDchinaWho, file="qDchinaWho.csv", row.names = F, na="")
write.table(qDchinaWho, file="qDchinaWho.txt", row.names = F, col.names = F, na="")
qDchina <- quickDash[which(nchar(quickDash$Who)>0),]
write.table(quickDash, file="qDallWho.txt", row.names = F, col.names=F,na="")
write.table(quickDash$Who, file="qDallWho.txt", row.names = F, col.names=F,na="")
write.table(qDchina$Who, file="qDallWho.txt", row.names = F, col.names=F,na="")
qdAllCount <- dplyr::count(qDchina, Who)
qdAll2 <- qDchina$Who
qdAll2 <- strsplit(qdAll2, " | ")
qdAll2 <- unlist(qdAll2)
qdAll2 <- data.frame("WhoCount" = qdAll2, stringsAsFactors = F)
qdAllCount2 <- dplyr::count(qdAll2, WhoCount)
qdAll3 <- data.frame("WhoCount" = qdAll2[which(nchar(qdAll2$WhoCount)>1),], stringsAsFactors = F)
qdAllCount3 <- dplyr::count(qdAll3, WhoCount)
write.table(qdAllCount3,file="qdAll3.txt",quote=F,row.names = F,col.names = F,sep=",",na="")
qdAll4 <- as.list(qdAll3)
write.table(qdAll4,file="AllWhoList4.txt",quote=F,row.names = F,col.names = F,sep=",",na="")