Hi, I have a peculier problem in R-Project that is when my CSV file have one column with all values as 'F' the R-Project converting this 'F' to FALSE. Can some one please suggest how to stop this convertion. Because I want to use 'F' in my calculations and show it in screen. for example my data is like sex group F 1 F 2 F 3 but when I use read.csv and load the csv file data is converting it to sex group FALSE 1 FALSE 2 FALSE 3 but i want it as source data like sex group F 1 F 2 F 3 Thanks in advance, D V Kiran Kumar [[alternative HTML version deleted]]
Look at "colClasses" in ?read.csv> Date: Thu, 5 Sep 2013 18:14:49 +0530 > From: kiran4u2all@gmail.com > To: r-help@r-project.org > Subject: [R] Problem with converting F to FALSE > > Hi, > I have a peculier problem in R-Project that is when my CSV file have one > column with all values as 'F' the R-Project converting this 'F' to FALSE. > Can some one please suggest how to stop this convertion. Because I want to > use 'F' in my calculations and show it in screen. for example my data is > like > > sex group > F 1 > F 2 > F 3 > > but when I use read.csv and load the csv file data is converting it to > > sex group > FALSE 1 > FALSE 2 > FALSE 3 > but i want it as source data like > > sex group > F 1 > F 2 > F 3 > > > Thanks in advance, > D V Kiran Kumar > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > 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]]
Hi, Try: dat1<-read.table(text=" sex? group F?????? 1 F?????? 2 F?????? 3 ",sep="",header=TRUE,colClasses=c("character","numeric")) ?dat1 #? sex group #1?? F???? 1 #2?? F???? 2 #3?? F???? 3 #if you are using read.csv() ?dat2<-read.csv("new1.csv",sep="",header=TRUE,colClasses=c("character","numeric")) ?dat2 #? sex group #1?? F???? 1 #2?? F???? 2 #3?? F???? 3 #Suppose you want to convert after reading it: ?dat2New<-read.csv("new1.csv",sep="",header=TRUE) ?dat2New[,1]<-substr(dat2New[,1],1,1) ?dat2New #? sex group #1?? F???? 1 #2?? F???? 2 #3?? F???? 3 A.K. Hi, I have a peculier problem in R-Project that is when my CSV file have one column with all values as 'F' the R-Project converting this 'F' to FALSE. Can some one please suggest how to stop this convertion. Because I want to use 'F' in my calculations and show it in screen. for example my data is like sex ?group F ? ? ? 1 F ? ? ? 2 F ? ? ? 3 but when I use read.csv and load the csv file data is converting it to sex ? ? ? ? ?group FALSE ? ? ? 1 FALSE ? ? ? 2 FALSE ? ? ? 3 but i want it as source data like sex group F ? ? ?1 F ? ? ?2 F ? ? ?3 Thanks in advance, D V Kiran Kumar
Hi, You can either manually specify colClasses or the asis argument. See ?read.csv for more details. If you just had those two columns, something like: read.table(header = TRUE, text = " sex group F 1 T 2 ", colClasses = c("character", "integer")) Cheers, Josh read.csv("file.csv", colClasses = c("character", "integer")) On Thu, Sep 5, 2013 at 5:44 AM, Venkata Kirankumar <kiran4u2all at gmail.com> wrote:> Hi, > I have a peculier problem in R-Project that is when my CSV file have one > column with all values as 'F' the R-Project converting this 'F' to FALSE. > Can some one please suggest how to stop this convertion. Because I want to > use 'F' in my calculations and show it in screen. for example my data is > like > > sex group > F 1 > F 2 > F 3 > > but when I use read.csv and load the csv file data is converting it to > > sex group > FALSE 1 > FALSE 2 > FALSE 3 > but i want it as source data like > > sex group > F 1 > F 2 > F 3 > > > Thanks in advance, > D V Kiran Kumar > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > 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.-- Joshua Wiley Ph.D. Student, Health Psychology University of California, Los Angeles http://joshuawiley.com/ Senior Analyst - Elkhart Group Ltd. http://elkhartgroup.com