[R] How to fix this problem

[Michael Dewey]

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.gross using 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-bounces using r-project.org> On Behalf Of Parkhurst, David
> Sent: Sunday, September 24, 2023 2:06 PM
> To: r-help using 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 using 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