that is great, thank you Bill for time and help ;) ! On Wed, Sep 2, 2015 at 4:36 PM, William Dunlap <wdun...@tibco.com> wrote:
> y <- as.matrix(read.table("FILE_NAME",header=T,row.names=1)) > colnames(y) <- gsub("X","", colnames(y)) > > Use read.table's check.names=FALSE argument so it won't mangle > the column names instead of trying to demangle them with gsub() > afterwards. > > E.g., > txt <- " 50% 100%\nA 5 8\nB 13 14\n" > cat(txt) > # 50% 100% > #A 5 8 > #B 13 14 > read.table(text=txt, head=TRUE, row.names=1) > # X50. X100. > #A 5 8 > #B 13 14 > read.table(text=txt, head=TRUE, row.names=1, check.names=FALSE) > # 50% 100% > #A 5 8 > #B 13 14 > > > Bill Dunlap > TIBCO Software > wdunlap tibco.com > > On Wed, Sep 2, 2015 at 4:08 PM, Bogdan Tanasa <tan...@gmail.com> wrote: > >> Thanks, Bert ! I solved the situation in the meanwhile, by using : >> >> y <- as.matrix(read.table("FILE_NAME",header=T,row.names=1)) >> >> colnames(y) <- gsub("X","", colnames(y)) >> >> >> On Wed, Sep 2, 2015 at 3:59 PM, Bert Gunter <bgunter.4...@gmail.com> >> wrote: >> >> > Please read the Help file carefully before posting: >> > >> > "read.table is not the right tool for reading large matrices, >> > especially those with many columns: it is designed to read data frames >> > which may have columns of very different classes. Use scan instead for >> > matrices." >> > >> > But the answer to your question can be found in >> > >> > ?make.names >> > >> > for what constitutes a syntactically valid name in R. >> > >> > >> > Cheers, >> > Bert >> > >> > Bert Gunter >> > >> > "Data is not information. Information is not knowledge. And knowledge >> > is certainly not wisdom." >> > -- Clifford Stoll >> > >> > >> > On Wed, Sep 2, 2015 at 3:11 PM, Bogdan Tanasa <tan...@gmail.com> wrote: >> > > Dear all, >> > > >> > > would appreciate a piece of help with a simple question: I am reading >> in >> > R >> > > a file that is formatted as a matrix (an example is shown below, >> although >> > > it is more complex, a matrix of 1000 * 1000 ): >> > > >> > > the names of the columns are 0, 10000, 40000, 80000, etc >> > > the names of the rows are 0, 10000, 40000, 80000, etc >> > > >> > > 0 200000 400000 >> > > 0 0 0 0 >> > > 200000 0 0 0 >> > > 400000 0 0 0 >> > > >> > > shall I use the command : >> > > >> > > y <- read.table("file",row.names=1, header=T) >> > > >> > > the results is : >> > > >> > >> y[1:3,1:3] >> > > X0 X200000 X400000 >> > > 0 0 0 0 >> > > 200000 0 0 0 >> > > 400000 0 0 0 >> > > >> > > The question is : why R adds an X to the names of the columns eg X0, >> > > X20000, X40000, when it shall be only 0, 20000, 40000 ? thanks ! >> > > >> > > -- bogdan >> > > >> > > [[alternative HTML version deleted]] >> > > >> > > ______________________________________________ >> > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> > > https://stat.ethz.ch/mailman/listinfo/r-help >> > > PLEASE do read the posting guide >> > http://www.R-project.org/posting-guide.html >> > > and provide commented, minimal, self-contained, reproducible code. >> > >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.