How to Delete Columns Columns from CSV before or after reading it.

Apr 10, 2014 at 10:17 AM
Hello all,

I Need to delete certain columns from the CSV file that i have read.
how to achieve that. ?
  1. engine.Evaluate("dataset<-read.table(file.choose(), header=TRUE, sep = ',')");
    I will read a CSV file
    2.now i need to remove columns from 1 to 3 "[-c(1:3)]");"
Need syntax for doing the same

Regards,
Antony
Developer
Apr 18, 2014 at 12:25 AM
What aspect of the syntax is missing? If you know how to do so in R, R syntax is all you need:
e.Evaluate("z <- expand.grid(a=letters[1:2], b=3:4, c=LETTERS[5:6],d=7:8)");
z_subset <- e.Evaluate("z[,-c(1,3)]").AsDataFrame();
Apr 18, 2014 at 7:58 AM
Thank you

Sent from my Windows Phone