Using readr to read the data might let you clean it on the way in...
readr::read_csv("filename.csv", col_types = list(rep(col_numeric(),6))
On Mon, 25 Sep 2023, 16:54 Ebert,Timothy Aaron, <teb...@ufl.edu> wrote:
> An update please:
> Collectively we have suggested removing commas from the "E..coli" column,
> checking for different forms of "NA", and looking outside the dataset for
> e-trash (spaces, text, or other content). For removing commas, I would use
> global replace to ensure that all commas were removed from all columns.
>
>
> Did this solve the problem?
>
> If not can you share some early lines and end lines from the data, and how
> R is reading your data? Something simple like head(KD6), tail(KD6), and
> str(KD6).
>
>
>
> -----Original Message-----
> From: R-help <r-help-boun...@r-project.org> On Behalf Of Michael Dewey
> Sent: Monday, September 25, 2023 11:09 AM
> To: avi.e.gr...@gmail.com; 'Parkhurst, David' <parkh...@indiana.edu>;
> r-help@r-project.org
> Subject: Re: [R] How to fix this problem
>
> [External Email]
>
> 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%2Fmailman%2Flistinfo%2Fr-help&data=05%7C01%7Ctebert%40ufl.edu
> > %7Cab9f2511a43e4f0cc0f308dbbdd95e2f%7C0d4da0f84a314d76ace60a62331e1b84
> > %7C0%7C0%7C638312513538190955%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAw
> > MDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sda
> > ta=kbguZQ1HLECz6FFh%2FEZI5A1mI3GweE1q7WgUGLxpjOI%3D&reserved=0
> > PLEASE do read the posting guide
> > http://www.r/
> > -project.org%2Fposting-guide.html&data=05%7C01%7Ctebert%40ufl.edu%7Cab
> > 9f2511a43e4f0cc0f308dbbdd95e2f%7C0d4da0f84a314d76ace60a62331e1b84%7C0%
> > 7C0%7C638312513538190955%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiL
> > CJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=By
> > 82TIbEPatOL9qRBoDbZ1tojvTd1%2B2Wo3UaBkIlt70%3D&reserved=0
> > 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.
> ______________________________________________
> 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.
>
[[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.
