Off topic:Extracting column value from csv file according to if else and & operator
1
0
Entering edit mode
8.7 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?

R • 2.7k views
ADD COMMENT
This thread is not open. No new answers may be added
Traffic: 2549 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6