[R] selecting certain columns or rows from a .csv

Fahim fahim.md at gmail.com
Sun Apr 11 04:24:57 CEST 2010


dataFile = read.csv("filename.csv",header= TRUE);
#suppose u want col 1, col 9 and col 15 
col1 = 1;
col9 = 9;
col15 = 15;
modifiedDataFile1 = dataFile[,c(col1, col9, col15)];

#if u want rows from 1-100 and then 1000-5000
modifiedDataFile2 = dataFile[c(1:100, 1000:5000), ];

#If u want to select rows and col simultaneously as specified above then 
modifiedDataFile = dataFile[c(1:100, 1000:5000), c(col1, col9, col15)];

Hope this will work.

Thanks 
Fahim Mohammad 
Grad student 
CECS, Univ of Louisville 
-- 
View this message in context: http://n4.nabble.com/selecting-certain-columns-or-rows-from-a-csv-tp1835692p1835760.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list