我是R的初学者,所以我希望你们中的大多数人对这个问题感兴趣。
下面是我正在使用的collar
文件的示例:
observed predicted probability results1
1 Head-up Grazing 0.2727273 NEGATIVE
2 Head-up Grazing 0.7272727 NEGATIVE
3 Head-up Grazing 0.7272727 NEGATIVE
4 Head-up Grazing 0.5454545 NEGATIVE
5 Head-up Grazing 0.7272727 NEGATIVE
6 Head-up Grazing 0.4545455 NEGATIVE
7 Head-up Vigilance 0.3636364 NEGATIVE
8 Head-up Grazing 0.3636364 NEGATIVE
9 Head-up Vigilance 0.3636364 NEGATIVE
10 Unknown Grazing 0.3636364 NEGATIVE
11 Moving Head-up 0.4545455 NEGATIVE
12 Moving Grazing 0.3636364 NEGATIVE
13 Head-up Grazing 0.4545455 NEGATIVE
14 Head-up Grazing 0.3636364 NEGATIVE
15 Head-up Grazing 0.4545455 NEGATIVE
16 Head-up Grazing 0.3636364 NEGATIVE
17 Head-up Head-up 0.4545455 POSITIVE
18 Head-up Grazing 0.2727273 NEGATIVE
接下来,我打算创建一个将添加第5列"results2"
的for
循环。因为第5列"results2"
的结果依赖于一个从0到1且递增0.1的Excel值,所以我想为每个i
值创建多个i
文件(其中i=0
、i=0.1
等直到i=1
)。这是我到目前为止一直在尝试的:
#Creating the for loop for column results 2 with i [0:1] increasing of 0.1. The file collar is the full file from the sample above.
for (i in seq(0, 1, by = 0.1))
{collar$results2<-mutate(collar,results2 = case_when( (probability > i & results1 == "POSITIVE") | (probability < i & results1 == "NEGATIVE") ~ TRUE, TRUE ~ FALSE) )
as.character(collar$results2)
#Writing down Excel files for each i value
collaraccuracy1=paste('collar41361_41365', i, 'csv', sep = '.')
write.csv(collaraccuracy1)}
这是R在运行循环时打印的内容。名称与我想要的完全相同:
"","x"
"1","collar41361_41365.0.csv"
"","x"
"1","collar41361_41365.0.1.csv"
"","x"
"1","collar41361_41365.0.2.csv"
"","x"
"1","collar41361_41365.0.3.csv"
"","x"
"1","collar41361_41365.0.4.csv"
"","x"
"1","collar41361_41365.0.5.csv"
"","x"
"1","collar41361_41365.0.6.csv"
"","x"
"1","collar41361_41365.0.7.csv"
"","x"
"1","collar41361_41365.0.8.csv"
"","x"
"1","collar41361_41365.0.9.csv"
"","x"
"1","collar41361_41365.1.csv"
然而,我在我的电脑里找不到这些文件,我想知道write.csv
函数的格式是否正确。
有什么建议吗?如有任何帮助,我们不胜感激!
发布于 2019-02-12 12:14:58
问题是write.csv
需要一个循环中没有提供的对象参数'x‘。它将“collaraccuracy1”读作file
。
...
write.csv(x = collar, collaraccuracy1)
}
https://stackoverflow.com/questions/54649526
复制相似问题