Skip to content

Wrong csv data?

3 messages · Grigory Fateyev, PIKAL Petr

#
Hello!

I have csv file (attached) with any data, where first column is time.
When I read into data.frame become temperature values. What it can be?

data <- read.csv("rp5_vladimir2010.csv", colClasses = "character", sep
= ";") names(data)
data$Time
data[,1]
#
Hi

Attachment did not went through. Can you show us result of dput(head(data)) or output from str(data)?

Anyway I wonder how time can became temperature. R is smart but I do not believe that during import it somehow gets a local temperature at given time and put it in your data.

Regards
Petr
#
Hello PIKAL Petr!
On Fri, 25 Jan 2013 10:09:54 +0000 you wrote:

            
Thank you for the answer. The problem was solved just remove traling
";" at the end every row. Header line hasn't traling semicolon.

sed -e "s/;\r/\r/g" file.csv > file.csv_tmp