Entering edit mode
8.6 years ago
shawin
▴
20
I have a csv file and I would like to extract the value of it with specific range for the last column for example; F>2 & F<2 & P=1, and then write the result to csv file.
The data is:
x1 x2 x3 x4 x5 x6
9.488404 9.470895 9.282434 9.366707 9.955383 9.640816
8.63063 8.558311 8.788391 8.576231 8.671588 8.84298
9.354749 9.367669 9.259953 9.421538 9.554635 9.603745
9.944864 9.950428 10.19102 10.07351 10.0327 10.13079
Fc p
1.037883 0.320095
1.057708 0.060132
1.065191 0.111192
I tried the code bellow but , it does not work?
FCPval <- read.csv("C:/Users/shawin/Desktop/RProgramms/RAdipose/FCPval.csv")
c=as.data.frame(FCPval)
for (i in 1:rowN){if (C$F[i] >= 2 && C$F[i]<=-2&& C$p[i]<=3){
dfrmPFC=data.frame(Fc=FC,p=p)}
}
The error is:
Error in C$FC : object of type 'closure' is not subsettable.
Can I extract the value according to the condition?