[R] Importing data in text file into R
amarjit singh sethi
ajss_gndu at yahoo.com
Sat May 24 05:40:32 CEST 2008
Dear all,
I am quite new to R; facing certain problems:
Say, I have a text file( named as "try"):
Year C1 C2 C3 C4 C5 C6
Y1 3.5 13.8 9.5 6.8 0.4 24.2
Y2 3.8 13.9 9.9 7.6 0.7 12.8
Y3 4.5 14.5 14.2 9.2 0.6 14.5
Y4 5.9 16.2 24.6 12.7 0.2 24.3
Y5 7.2 20.4 40.6 18.2 0.8 28.2
Y6 5.9 18.6 37.4 14.5 0.3 36.9
Y7 8.0 16.1 88.6 24.1 0.1 34.6
Y8 13.6 21.1 56.3 19.0 0.7 33.3
I wish to import the file into R and make certain
computations, like intercorrelation matrix. I tried
the following syntax:
# Inputting the data file (saved in text format)
df="trial.txt"
idt=read.table(df,header=T, sep="\t")
idt
# To generate intercorrelatio matrix
r = cor(idt)
r=round(r, 4)
r
The seems to have been read, but further computations
not made, with the following output:
> # Inputting the data file (saved in text format)
> df="trial.txt"
> idt=read.table(df,header=T, sep="\t")
> idt
Year C1 C2 C3 C4 C5 C6
1 Y1 3.5 13.8 9.5 6.8 0.4 24.2
2 Y2 3.8 13.9 9.9 7.6 0.7 12.8
3 Y3 4.5 14.5 14.2 9.2 0.6 14.5
4 Y4 5.9 16.2 24.6 12.7 0.2 24.3
5 Y5 7.2 20.4 40.6 18.2 0.8 28.2
6 Y6 5.9 18.6 37.4 14.5 0.3 36.9
7 Y7 8.0 16.1 88.6 24.1 0.1 34.6
8 Y8 13.6 21.1 56.3 19.0 0.7 33.3
> # To generate intercorrelatio matrix
> r = cor(idt)
Error in cor(idt) : missing observations in cov/cor
In addition: Warning message:
In cor(idt) : NAs introduced by coercion
> r=round(r, 4)
Error: object "r" not found
> r
Error: object "r" not found
Kindly advise me as to how to get rid of the error
message.
AJSS
More information about the R-help
mailing list