owenqi 发表于 2021-3-18 12:29 
缺少b这个数据框,所以你的例子没办法复现,但是根据你的描述,你是打算每隔15行提取某些数据,一个比较可 ...
下面是总的代码,期待您的回复
setwd("F:/R/") #文件位置
getwd()
library(xlsx)
a<- read.xlsx("F:/R/练习/20210111-trp-5-projects.xlsx",1) #文件位置
a<- a[order(a$Component.Name,decreasing = FALSE),]
a<- subset(a,a$Sample.Type =="Standard")
View(a)
b<- subset(a,a$Correlation.Coefficient != "N/A" )
View(b)
n<- nrow(b)/15-1
table<- list()
for(x in 0:1){
c<-b[(15*x+1):(15*x+15),]
d<- subset(c,c$Used == TRUE,)
e<- d[which.min(d$Calculated.Concentration),]
LLOD<-e$Calculated.Concentration
f<- d$Calculated.Concentration
g<- as.numeric(f) #让f的数变成数值型
LLOQ<- min(g[g!=min(g)]) #去掉最小的那个数
h<- d[which.max(d$Actual.Concentration),]
ULOQ<-h$Actual.Concentration
i<- d$Correlation.Coefficient
R2<- max(i)
j<- d$Component.Name
Name<- j[1]
write.csv(data.frame(Name,LLOD,LLOQ,ULOQ,R2))
}