On 19/10/2016 4:54 PM, Rich Shepard wrote:
The file, daily_records.dat, contains these data:
"station","date","amount"
"0.3E",2014-01-01,
"0.3E",2014-01-02,
"0.3E",2014-01-03,0.01
"0.3E",2014-01-04,0.00
"0.3E",2014-01-05,0.00
"0.3E",2014-01-06,0.00
"0.3E",2014-01-07,0.10
"0.3E",2014-01-08,0.22
"0.3E",2014-01-09,0.49
Using read.table("daily_records.dat", header = TRUE, sep = ",", quote =
"\"\"") the data are assigned to a data.frame named 'rain.'
I expect the structure to show station and date as factors with amount as
numeric, but they're all factors:
str(rain)
'data.frame': 341 obs. of 3 variables:
$ station: Factor w/ 6 levels "0.3E","0.6W",..: 1 1 ...
$ date : Factor w/ 62 levels "2013-12-01","2013-12-02",..: 32 33 34 ...
$ amount : Factor w/ 48 levels "","0.00","0.01",..: 1 1 3 2 ...
Why is amount taken as a factor rather than numeric? I do not recall
having numbers read as factors before this.
I don't get that from those 9 observations, so there's likely something
else going on further down in the file.
Try which(is.na(as.numeric(as.character(rain$station)))) to find out
which lines are causing problems for that column, and similarly for
rain$amount.
Duncan Murdoch
I expect to need to convert dates using as.Date() but not to convert
numbers.
TIA,
Rich
______________________________________________
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.
______________________________________________
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.