Hi On 22 Apr 2006 at 23:29, Bob Green wrote:
Date sent: Sat, 22 Apr 2006 23:29:02 +1000 To: r-help@stat.math.ethz.ch From: Bob Green <[EMAIL PROTECTED]> Subject: [R] Missing values detected when there are no missing values > I am hoping for some advice on the following matters. > > I have a csv data file with 153 variables x 92 rows. To determine > what the variables looked like I ran the summary command. One > variable had a large number of missing values 54/92. For some > reason, all subsequent 74 variables are reported as having 92 NA > values, irrespective of whether the original csv variable was complete > or not. I have not seen any answer yet so I try to shot one. first how do you know there is not any missing value in your csv file? > > Below are the commands I ran: > > > study1dat <- read.csv("c:\\study1r.csv",header=T) > > attach(study1dat) > > names(study1dat) > > summary(study1dat) You showed what you did but we can not know much about study1r.csv so my answer is only guess. Let's assume that csv was constructed from Excel, couldn't be a problem in its construction? Some space in some columns which are not seen in Excel but are exported to csv and read to R as NA values? What does str(study1dat) say about your data? And are there really "," vaues separators and "." decimal separators as required by read.csv? > > The second puzzling issue, is that one variable with no missing values > is reported in R as having 3 missing values, whereas there are no > missing values in the csv file. The only errors in reading the data I > received were: Not when reading but when attaching data frame. Names in your data frame are same as names of some functions in mentioned packages, which is not an error, R just tell you that this had happened and you shall be avare of it. HTH Petr > > The following object(s) are masked from package:stats : > time > > The following object(s) are masked from package:graphics : > screen > > The following object(s) are masked from package:datasets : > sleep > > The following object(s) are masked from package:base : > pipe > > I am happy to send the csv file if required. Any advice that can > offered is appreciated, > > Bob > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html Petr Pikal [EMAIL PROTECTED] ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html