Hi,
You may try:
dat1<- structure(list(Date.Time = c("C", "C", "C"), Unit = c(23L, 23L,
22L), Value = c(207L, 82L, 894L)), .Names = c("Date.Time", "Unit",
"Value"), class = "data.frame", row.names = c("27/06/13 02:35:01",
"27/06/13 02:50:01", "27/06/13 03:05:01"))
dat2<-data.frame(Date.Time=row.names(dat1),Unit=dat1[,1],Value=as.numeric(paste(dat1[,2],sprintf("%03d",dat1[,3]),sep="."))
,stringsAsFactors=FALSE)
dat2
# Date.Time Unit Value
#1 27/06/13 02:35:01 C 23.207
#2 27/06/13 02:50:01 C 23.082
#3 27/06/13 03:05:01 C 22.894
#or
lines1<-readLines("data1.csv")
dat2New<-read.table(text=gsub("(.*),(.*)$","\\1.\\2",lines1[-1]),sep=",",header=FALSE,stringsAsFactors=FALSE)
colnames(dat2New)<-strsplit(lines1[1],",")[[1]]
dat2New
# Date/Time Unit Value
#1 27/06/13 02:35:01 C 23.207
#2 27/06/13 02:50:01 C 23.082
#3 27/06/13 03:05:01 C 22.894
colnames(dat2)[1]<- colnames(dat2New)[1]
identical(dat2,dat2New)
#[1] TRUE
A.K.
Hi,
I'm trying to import a csv file into R using read.csv. Here's the first part of
the CSV:
Date/Time,Unit,Value
27/06/13 02:35:01,C,23,207
27/06/13 02:50:01,C,23,082
27/06/13 03:05:01,C,22,894
When I import this to R using:
data <- read.csv(file="", header =TRUE, skip=19)
I get:
Date.Time Unit Value
27/06/13 02:35:01 C 23 207
27/06/13 02:50:01 C 23 82
27/06/13 03:05:01 C 22 894
All the names are shifted to the right and the column with
temperature(Value) is split in two, probable because R thinks the Value
is two different columns since its in the form of 23,207 instead of
23.207. Is there any way to make this right within R or do I have to
manually change alle the Temperature values?
Thanks!
______________________________________________
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.
