-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathTemp.txt
71 lines (55 loc) · 2.31 KB
/
Temp.txt
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
# You should change to your path.
setwd('D:\\Dropbox\\GIBMS_BMLGoh\\ADM\\Data\\Code')
NowPath = getwd() # save now path
source('ADMNeuroPsyLoadCSV.r') # skip warnings(), that ok
# You should change to your path.
CodingSheetFolderPath = 'D:\\Dropbox\\GIBMS_BMLGoh\\ADM\\Data\\CodingSheetCSV'
setwd(CodingSheetFolderPath)
CsvList = dir()
# [Undo] check any other sub-file name in Folder
# and/or file format error
LatestCodingNum = 10
#LatestCodingNum = as.numeric(substr(CsvList[length(CsvList)],start=5,stop=7)) # get latest coding done
# so this code only can use in filename : "ADMSXXX.csv", XXX for Subj. Num
SubTestList = c("Profile", "Body", "Handiness", "GDS", "SelfEva", "STAT", "AD8",
"Demo", "Language", "MedHistory", "DisFactor", "Exercise", "Diet",
"MMSE" #, "WMS", "WAIS", "TMT", "SVS", "NEO"
)
SubTestTotal = length(SubTestList)
# 1. Source R Code of each Sub Test
# You should change to your path.
LoadTaskPath = "D:\\Dropbox\\GIBMS_BMLGoh\\ADM\\Data\\Code\\LoadEachTest"
setwd(LoadTaskPath)
for (SubTestNum in 1:SubTestTotal) {
Str = paste("source('Load", SubTestList[SubTestNum], ".r', encoding = 'utf-8')", sep = "")
eval(parse(text = Str))
}
# 2. Declaration Variance
for (SubTestNum in 1:SubTestTotal) {
if (SubTestNum == 1) {
Str = paste("Data = Load", SubTestList[SubTestNum], "(1, LatestCodingNum, LoadTaskPath)", sep = "")
} else {
Str = paste("Data = c(Data, Load", SubTestList[SubTestNum], "(1, LatestCodingNum, LoadTaskPath))", sep = "")
}
eval(parse(text = Str))
}
# Call Individual CSV Sheet
setwd(CodingSheetFolderPath)
for (CsvListNum in 1:LatestCodingNum) {
NowCodingNum = as.numeric(substr(CsvList[CsvListNum],start = 5,stop = 7))
# don't load header, missing data put null
DataTemp = read.csv(CsvList[CsvListNum], header = FALSE, na.string = "NULL", )
# if seat error, everything wrong ! I use S095 to make.
# 3. Read CSV by Coordination
for (SubTestNum in 1:SubTestTotal) {
Str = paste("StrMat = Load", SubTestList[SubTestNum], "(2, NowCodingNum, LoadTaskPath)", sep = "")
eval(parse(text = Str))
VarTotal = length(StrMat)
for (VarNum in 1:VarTotal) {
Str = StrMat[VarNum]
eval(parse(text = Str))
}
}
}
# 4. Data Frame Construction
DataDF = as.data.frame(Data)