It looks here as though the E coli column has commas in it so will be
treated as character.
Michael
On 25/09/2023 15:45, avi.e.gr...@gmail.com wrote:
David,
This may just be the same as your earlier problem. When the type of a column is
guessed by looking at the early entries, any non-numeric entry forces the
entire column to be character.
Suggestion: fix your original EXCEL FILE or edit your CSV to remove the last
entries that look just lie commas.
-----Original Message-----
From: R-help <r-help-boun...@r-project.org> On Behalf Of Parkhurst, David
Sent: Sunday, September 24, 2023 2:06 PM
To: r-help@r-project.org
Subject: [R] How to fix this problem
I have a matrix, KD6, and I�m trying to get a correlation matrix from it. When
I enter cor(KD6), I get the message �Error in cor(KD6) : 'x' must be numeric�.
Here are some early lines from KD6:
Flow E..coli TN SRP TP TSS
1 38.8 2,420 1.65300 0.0270 0.0630 66.80
2 133.0 2,420 1.39400 0.0670 0.1360 6.80
3 86.2 10 1.73400 0.0700 0.1720 97.30
4 4.8 5,390 0.40400 0.0060 0.0280 8.50
5 0.3 2,490 0.45800 0.0050 0.0430 19.75
6 0.0 186 0.51200 0.0040 0.0470 12.00
7 11.1 9,835 1.25500 0.0660 0.1450 12.20
Why are these not numeric?
There are some NAs later in the matrix, but I get this same error if I ask for
cor(KD6[1:39,]) to leave out the lines with NAs. Are they a problem anyway?
[[alternative HTML version deleted]]
______________________________________________
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.
--
Michael
______________________________________________
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.