Re: [R] How to import an excel data file

2023-09-24 Thread Rainer Hurling
Dear David, Am 23.09.23 um 01:10 schrieb Parkhurst, David: I know I should save it as a .csv file, which I have done. I�m told I should use the read_excel() function from the readxl package. My question is, how do I express the location of the file. The file is named KurtzData.csv. Its

Re: [R] How to import an excel data file

2023-09-23 Thread Duncan Murdoch
On 23/09/2023 3:35 p.m., Ivan Krylov wrote: В Fri, 22 Sep 2023 23:10:58 + "Parkhurst, David" пишет: Its location in my Mac files is DFPfiles/ae/FriendsMonroe/KurtzData.csv How exactly---What _, etc.---do I type with its name in the read_excel() function? In RGui on Windows,

Re: [R] How to import an excel data file

2023-09-23 Thread Ivan Krylov
В Fri, 22 Sep 2023 23:10:58 + "Parkhurst, David" пишет: > Its location in my Mac files is > DFPfiles/ae/FriendsMonroe/KurtzData.csv How exactly---What _, > etc.---do I type with its name in the read_excel() function? In RGui on Windows, file.choose() opens a dialog window letting the user

Re: [R] How to import an excel data file

2023-09-23 Thread Stevie Pederson
Hi David, If you're using RStudio, I'd encourage the use of R Projects, with a new project for each analysis, even if you only do one every few years. That would also correspond to a new directory for each analysis, which many also find helpful. The package 'here' [install.packages("here")] then

Re: [R] How to import an excel data file

2023-09-23 Thread Richard O'Keefe
Are you sure that read.csv() can't read your data? [If you depend on extra packages you might want to consider using the 'groundhog' package so that you can be more confident of reproducing your work in a year or two.] You said that your question is how you should write the name of the file in

Re: [R] How to import an excel data file

2023-09-23 Thread Maria Lathouri via R-help
Dear David,  I also use excel files for R. This is what I do install.packages("readxl") library(readxl) mydata=read_excel('mydata.xlsx') Hope this helps.  Best, Maria Στις Σάββατο 23 Σεπτεμβρίου 2023 στις 09:23:43 π.μ. GMT+1, ο χρήστης Parkhurst, David έγραψε: I know I should save

[R] How to import an excel data file

2023-09-23 Thread Parkhurst, David
I know I should save it as a .csv file, which I have done. I�m told I should use the read_excel() function from the readxl package. My question is, how do I express the location of the file. The file is named KurtzData.csv. Its location in my Mac files is DFPfiles/ae/FriendsMonroe/KurtzData.csv