read.zoo problem reading in date time
One must specify that there is a header if there is one, each % item
should only
be listed once, and format is currently only used for "Date" class so
you want to
use the FUN= argument -- although in the development version of zoo format is
availailable more generally. Here are several ways to do this. z1 is
created using
chron, z2 uses POSIXct and the z3 uses POSIXct and the new version of read.zoo
in the devel version of zoo.
library(zoo)
Lines <- "DateTime,Temp,SpCond,DOConc,Depth,pH,ORP,Turbidity+,Chlorophyll,Battery,Cond,DO%,Salinity,TDS
01/13/2006 17:01,10.87,84,9.36,0.664,7.3,132,28.8,3.1,11.5,0.062,84.6,0.04,0.055
01/13/2006 17:16,10.9,84,9.36,0.66,7.31,133,28.7,2.9,11.5,0.062,84.7,0.04,0.055
01/13/2006 17:31,10.92,84,9.36,0.655,7.3,132,28.4,2.6,11.4,0.062,84.8,0.04,0.055
01/13/2006 17:46,10.96,85,9.37,0.651,7.3,133,27.5,2.3,11.4,0.062,84.9,0.04,0.055
01/13/2006 18:01,10.96,85,9.35,0.644,7.33,132,28.2,2.9,11.4,0.062,84.7,0.04,0.055
01/13/2006 18:16,10.98,85,9.35,0.638,7.33,132,27.9,2.5,11.4,0.062,84.8,0.04,0.055
01/13/2006 18:31,11.01,85,9.35,0.635,7.31,131,26.4,3,11.5,0.062,84.8,0.04,0.055
01/13/2006 18:46,11.04,85,9.33,0.635,7.31,133,26.1,2.9,11.5,0.062,84.7,0.04,0.055
01/13/2006 19:01,11.04,85,9.33,0.632,7.33,133,26.3,2.9,11.4,0.062,84.7,0.04,0.055
01/13/2006 19:16,11.06,85,9.32,0.639,7.34,134,26,2.6,11.5,0.062,84.6,0.04,0.055
01/13/2006 19:31,11.11,85,9.37,0.656,7.35,136,25.6,2.1,11.4,0.062,85.2,0.04,0.055
01/13/2006 19:46,11.11,84,9.36,0.65,7.33,137,26.6,2.4,11.4,0.062,85.2,0.04,0.055
01/13/2006 20:01,11.18,84,9.41,0.649,7.35,138,27,2.8,11.4,0.062,85.7,0.04,0.055
01/13/2006 20:16,11.13,84,9.35,0.651,7.34,140,27.1,2.7,11.4,0.062,85,0.04,0.055
01/13/2006 20:31,11.12,84,9.33,0.656,7.32,142,26.7,2.9,11.4,0.062,84.8,0.04,0.055
01/13/2006 20:46,11.07,84,9.33,0.667,7.32,143,26.4,3.1,11.4,0.062,84.8,0.04,0.055
01/13/2006 21:01,11.05,84,9.35,0.67,7.31,145,26.6,2.7,11.4,0.062,84.9,0.04,0.055
01/13/2006 21:16,11.02,84,9.34,0.67,7.32,145,25.9,2.6,11.4,0.062,84.8,0.04,0.055
01/13/2006 21:31,11.01,84,9.35,0.673,7.32,146,26.3,3.1,11.4,0.062,84.8,0.04,0.055
01/13/2006 21:46,10.99,84,9.35,0.676,7.32,146,26.4,3.3,11.4,0.062,84.8,0.04,0.055
01/13/2006 22:01,10.96,84,9.34,0.673,7.32,146,26,2.6,11.5,0.062,84.7,0.04,0.055
01/13/2006 22:16,10.94,84,9.32,0.668,7.32,147,26.5,2.9,11.5,0.061,84.4,0.04,0.055
01/13/2006 22:31,10.93,84,9.3,0.666,7.31,148,25.8,2.4,11.4,0.062,84.3,0.04,0.055
01/13/2006 22:46,10.92,84,9.3,0.666,7.32,148,26,2.2,11.4,0.061,84.2,0.04,0.055
01/13/2006 23:01,10.91,84,9.27,0.666,7.32,148,26.5,2.9,11.5,0.062,83.9,0.04,0.055
01/13/2006 23:16,10.92,84,9.34,0.666,7.31,149,26.9,2.5,11.4,0.062,84.6,0.04,0.055
01/13/2006 23:31,10.93,84,9.31,0.667,7.33,148,25.8,2.8,11.4,0.062,84.3,0.04,0.055
01/13/2006 23:46,10.92,84,9.34,0.666,7.31,150,26.1,3.1,11.4,0.062,84.6,0.04,0.055
01/14/2006 00:01,10.95,84,9.28,0.667,7.3,144,26.4,2.5,11.5,0.062,84.1,0.04,0.055
01/14/2006 00:16,10.95,84,9.29,0.667,7.31,142,25.6,2.3,11.5,0.062,84.2,0.04,0.055
01/14/2006 00:31,10.94,84,9.29,0.669,7.3,142,25.6,2.4,11.4,0.062,84.2,0.04,0.055
01/14/2006 00:46,10.94,85,9.29,0.671,7.31,139,25.3,3.1,11.4,0.062,84.1,0.04,0.055
01/14/2006 01:01,10.95,85,9.26,0.672,7.3,141,25.3,2.6,11.3,0.062,83.9,0.04,0.055
01/14/2006 01:16,10.95,85,9.28,0.673,7.31,141,26,3.1,11.4,0.062,84,0.04,0.055
01/14/2006 01:31,10.96,85,9.27,0.673,7.34,139,25.4,2.1,11.4,0.062,84,0.04,0.055
01/14/2006 01:46,10.95,85,9.28,0.673,7.32,138,24.8,2.5,11.4,0.062,84.1,0.04,0.055
01/14/2006 02:01,10.93,85,9.27,0.673,7.31,137,25.1,2.2,11.4,0.062,84,0.04,0.055
01/14/2006 02:16,10.93,85,9.28,0.673,7.31,137,24.6,2,11.4,0.062,84.1,0.04,0.055
01/14/2006 02:31,10.94,85,9.29,0.671,7.35,133,24.8,2.8,11.4,0.062,84.2,0.04,0.055
01/14/2006 02:46,10.91,85,9.27,0.671,7.35,130,24.7,2.1,11.4,0.062,83.8,0.04,0.055
01/14/2006 03:01,10.92,85,9.28,0.67,7.32,131,24.5,2.6,11.4,0.062,84,0.04,0.055
01/14/2006 03:16,10.91,85,9.26,0.669,7.32,129,24.8,2.6,11.3,0.062,83.8,0.04,0.055
01/14/2006 03:31,10.9,85,9.28,0.671,7.32,129,24.5,2.5,11.4,0.062,84,0.04,0.055
01/14/2006 03:46,10.86,85,9.28,0.669,7.33,127,23.8,2.5,11.4,0.062,83.9,0.04,0.055
01/14/2006 04:01,10.87,85,9.27,0.669,7.33,128,24.3,2.7,11.4,0.062,83.9,0.04,0.055
01/14/2006 04:16,10.87,85,9.26,0.668,7.36,125,23.6,2.9,11.3,0.062,83.7,0.04,0.055
01/14/2006 04:31,10.8,85,9.28,0.667,7.34,123,23.6,2,11.3,0.062,83.8,0.04,0.056
01/14/2006 04:46,10.82,85,9.28,0.666,7.34,125,23.8,2.5,11.4,0.062,83.8,0.04,0.056
01/14/2006 05:01,10.82,85,9.26,0.665,7.33,124,24.3,2.3,11.3,0.062,83.7,0.04,0.056
01/14/2006 05:16,10.8,86,9.27,0.665,7.33,122,23.8,2.4,11.4,0.062,83.7,0.04,0.056
01/14/2006 05:31,10.78,86,9.28,0.667,7.35,122,24.1,3.1,11.3,0.062,83.7,0.04,0.056
01/14/2006 05:46,10.76,86,9.27,0.668,7.35,123,23.8,2.8,11.3,0.062,83.6,0.04,0.056
01/14/2006 06:01,10.77,86,9.26,0.668,7.34,116,24.2,2.6,11.3,0.062,83.5,0.04,0.056
"
# chron
library(chron)
fmt.chron <- function(x) {
chron(sub(" .*", "", x), gsub(".* (.*)", "\\1:00", x))
}
z1 <- read.zoo(textConnection(Lines), sep = ",", header = TRUE, FUN = fmt.chron)
# POSIXct
fmt.POSIXct <- function(x) {
as.POSIXct(strptime(x, "%m/%d/%Y %H:%M"))
}
z2 <- read.zoo(textConnection(Lines), sep = ",", header = TRUE, FUN =
fmt.POSIXct)
# POSIXct - using development version of zoo
# next line reads in devel version of read.zoo from R-Forge
source("http://r-forge.r-project.org/plugins/scmsvn/viewcvs.php/*checkout*/pkg/R/read.zoo.R?rev=445&root=zoo")
z3 <- read.zoo(textConnection(Lines), sep = ",", header = TRUE,
format = "%m/%d/%Y %H:%M", tz = "")
On Mon, Mar 3, 2008 at 11:12 AM, stephen sefick <ssefick at gmail.com> wrote:
DateTime,Temp,SpCond,DOConc,Depth,pH,ORP,Turbidity+,Chlorophyll,Battery,Cond,DO%,Salinity,TDS
01/13/2006 17:01,10.87,84,9.36,0.664,7.3,132,28.8,3.1,11.5,0.062,84.6,0.04,0.055
01/13/2006 17:16,10.9,84,9.36,0.66,7.31,133,28.7,2.9,11.5,0.062,84.7,0.04,0.055
01/13/2006 17:31,10.92,84,9.36,0.655,7.3,132,28.4,2.6,11.4,0.062,84.8,0.04,0.055
01/13/2006 17:46,10.96,85,9.37,0.651,7.3,133,27.5,2.3,11.4,0.062,84.9,0.04,0.055
01/13/2006 18:01,10.96,85,9.35,0.644,7.33,132,28.2,2.9,11.4,0.062,84.7,0.04,0.055
01/13/2006 18:16,10.98,85,9.35,0.638,7.33,132,27.9,2.5,11.4,0.062,84.8,0.04,0.055
01/13/2006 18:31,11.01,85,9.35,0.635,7.31,131,26.4,3,11.5,0.062,84.8,0.04,0.055
01/13/2006 18:46,11.04,85,9.33,0.635,7.31,133,26.1,2.9,11.5,0.062,84.7,0.04,0.055
01/13/2006 19:01,11.04,85,9.33,0.632,7.33,133,26.3,2.9,11.4,0.062,84.7,0.04,0.055
01/13/2006 19:16,11.06,85,9.32,0.639,7.34,134,26,2.6,11.5,0.062,84.6,0.04,0.055
01/13/2006 19:31,11.11,85,9.37,0.656,7.35,136,25.6,2.1,11.4,0.062,85.2,0.04,0.055
01/13/2006 19:46,11.11,84,9.36,0.65,7.33,137,26.6,2.4,11.4,0.062,85.2,0.04,0.055
01/13/2006 20:01,11.18,84,9.41,0.649,7.35,138,27,2.8,11.4,0.062,85.7,0.04,0.055
01/13/2006 20:16,11.13,84,9.35,0.651,7.34,140,27.1,2.7,11.4,0.062,85,0.04,0.055
01/13/2006 20:31,11.12,84,9.33,0.656,7.32,142,26.7,2.9,11.4,0.062,84.8,0.04,0.055
01/13/2006 20:46,11.07,84,9.33,0.667,7.32,143,26.4,3.1,11.4,0.062,84.8,0.04,0.055
01/13/2006 21:01,11.05,84,9.35,0.67,7.31,145,26.6,2.7,11.4,0.062,84.9,0.04,0.055
01/13/2006 21:16,11.02,84,9.34,0.67,7.32,145,25.9,2.6,11.4,0.062,84.8,0.04,0.055
01/13/2006 21:31,11.01,84,9.35,0.673,7.32,146,26.3,3.1,11.4,0.062,84.8,0.04,0.055
01/13/2006 21:46,10.99,84,9.35,0.676,7.32,146,26.4,3.3,11.4,0.062,84.8,0.04,0.055
01/13/2006 22:01,10.96,84,9.34,0.673,7.32,146,26,2.6,11.5,0.062,84.7,0.04,0.055
01/13/2006 22:16,10.94,84,9.32,0.668,7.32,147,26.5,2.9,11.5,0.061,84.4,0.04,0.055
01/13/2006 22:31,10.93,84,9.3,0.666,7.31,148,25.8,2.4,11.4,0.062,84.3,0.04,0.055
01/13/2006 22:46,10.92,84,9.3,0.666,7.32,148,26,2.2,11.4,0.061,84.2,0.04,0.055
01/13/2006 23:01,10.91,84,9.27,0.666,7.32,148,26.5,2.9,11.5,0.062,83.9,0.04,0.055
01/13/2006 23:16,10.92,84,9.34,0.666,7.31,149,26.9,2.5,11.4,0.062,84.6,0.04,0.055
01/13/2006 23:31,10.93,84,9.31,0.667,7.33,148,25.8,2.8,11.4,0.062,84.3,0.04,0.055
01/13/2006 23:46,10.92,84,9.34,0.666,7.31,150,26.1,3.1,11.4,0.062,84.6,0.04,0.055
01/14/2006 00:01,10.95,84,9.28,0.667,7.3,144,26.4,2.5,11.5,0.062,84.1,0.04,0.055
01/14/2006 00:16,10.95,84,9.29,0.667,7.31,142,25.6,2.3,11.5,0.062,84.2,0.04,0.055
01/14/2006 00:31,10.94,84,9.29,0.669,7.3,142,25.6,2.4,11.4,0.062,84.2,0.04,0.055
01/14/2006 00:46,10.94,85,9.29,0.671,7.31,139,25.3,3.1,11.4,0.062,84.1,0.04,0.055
01/14/2006 01:01,10.95,85,9.26,0.672,7.3,141,25.3,2.6,11.3,0.062,83.9,0.04,0.055
01/14/2006 01:16,10.95,85,9.28,0.673,7.31,141,26,3.1,11.4,0.062,84,0.04,0.055
01/14/2006 01:31,10.96,85,9.27,0.673,7.34,139,25.4,2.1,11.4,0.062,84,0.04,0.055
01/14/2006 01:46,10.95,85,9.28,0.673,7.32,138,24.8,2.5,11.4,0.062,84.1,0.04,0.055
01/14/2006 02:01,10.93,85,9.27,0.673,7.31,137,25.1,2.2,11.4,0.062,84,0.04,0.055
01/14/2006 02:16,10.93,85,9.28,0.673,7.31,137,24.6,2,11.4,0.062,84.1,0.04,0.055
01/14/2006 02:31,10.94,85,9.29,0.671,7.35,133,24.8,2.8,11.4,0.062,84.2,0.04,0.055
01/14/2006 02:46,10.91,85,9.27,0.671,7.35,130,24.7,2.1,11.4,0.062,83.8,0.04,0.055
01/14/2006 03:01,10.92,85,9.28,0.67,7.32,131,24.5,2.6,11.4,0.062,84,0.04,0.055
01/14/2006 03:16,10.91,85,9.26,0.669,7.32,129,24.8,2.6,11.3,0.062,83.8,0.04,0.055
01/14/2006 03:31,10.9,85,9.28,0.671,7.32,129,24.5,2.5,11.4,0.062,84,0.04,0.055
01/14/2006 03:46,10.86,85,9.28,0.669,7.33,127,23.8,2.5,11.4,0.062,83.9,0.04,0.055
01/14/2006 04:01,10.87,85,9.27,0.669,7.33,128,24.3,2.7,11.4,0.062,83.9,0.04,0.055
01/14/2006 04:16,10.87,85,9.26,0.668,7.36,125,23.6,2.9,11.3,0.062,83.7,0.04,0.055
01/14/2006 04:31,10.8,85,9.28,0.667,7.34,123,23.6,2,11.3,0.062,83.8,0.04,0.056
01/14/2006 04:46,10.82,85,9.28,0.666,7.34,125,23.8,2.5,11.4,0.062,83.8,0.04,0.056
01/14/2006 05:01,10.82,85,9.26,0.665,7.33,124,24.3,2.3,11.3,0.062,83.7,0.04,0.056
01/14/2006 05:16,10.8,86,9.27,0.665,7.33,122,23.8,2.4,11.4,0.062,83.7,0.04,0.056
01/14/2006 05:31,10.78,86,9.28,0.667,7.35,122,24.1,3.1,11.3,0.062,83.7,0.04,0.056
01/14/2006 05:46,10.76,86,9.27,0.668,7.35,123,23.8,2.8,11.3,0.062,83.6,0.04,0.056
01/14/2006 06:01,10.77,86,9.26,0.668,7.34,116,24.2,2.6,11.3,0.062,83.5,0.04,0.056
x<-read.zoo("SC2.csv", sep="," , format="%m%m/%d%d/%y%y%y%y %h%h:%m%m")
#Error in read.zoo("SC2.csv", sep = ",", format =
"%m%m/%d%d/%y%y%y%y %h%h:%m%m") :
index contains NAs Error message
what am I doing wrong SC2.csv is a comma seperated file. The above
data is right out out of the csv file, which is more like 30,000 rows.
There are some NA for all of the variables except DateTime for a week
here and a week there, but I can not find any missing dates.
thanks
stephen
--
Let's not spend our time and resources thinking about things that are
so little or so large that all they really do for us is puff us up and
make us feel like gods. We are mammals, and have not exhausted the
annoying little problems of being mammals.
-K. Mullis
______________________________________________ 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.