I have a WHO csv file on my computer that I have downloaded to numbers9 that I want to load into my copy of R but none of the procedures listed work and all i get from r are error messages saying that the file WHO cannot be found. My operating system is MacOS High Sierra 10 13.6. Can you help?
iMac, macOS 10.13
I can confirm Ian's comment that R doesn't recognize Numbers documents. "Out of the box" I don't think it recognizes Excel format either though there may be some add-ons for that. It does recognize CSV out of the box, though. Perhaps you have done some "cleaning up" of your data in Numbers? If so you can File > Export To > CSV ... to save it in a format that you can import into R.
SG
I can confirm Ian's comment that R doesn't recognize Numbers documents. "Out of the box" I don't think it recognizes Excel format either though there may be some add-ons for that. It does recognize CSV out of the box, though. Perhaps you have done some "cleaning up" of your data in Numbers? If so you can File > Export To > CSV ... to save it in a format that you can import into R.
SG
Hi Darwin,
I have used R (a statistical package similar to S-plus) on a Windows machine. I have not tried R on an Apple machine. Perhaps R does not recognise Numbers documents. From memory (7 years ago!) R will open an Excel file or a tab-delimited text file. From Numbers '09 (and later versions of Numbers) you can export to Excel. Or you can copy data from Numbers and paste into TextEdit, then save to create a tab-delimited text file.
Regards,
Ian.
When I opened the download my mac put the who.csv file into numbers9 which I saved to iCloud using WHO.csv. I tried telling r where the file was located using hints that appear on the internet for importing csv files into r, but nothing works.My version of r is 3.4.3
"downloaded to numbers9" = "imported using Numbers '09" ?
After importing, what did you do with the resulting Numbers document?
"R" ?
Please clarify.
Barry
Instead of opening the downloaded csv file with Numbers, why not directly import into R using the usual methods (which are not "hints"; they are how how R works)? The csv file most likely will download into your Downloads folder on your Mac, not somewhere in iCloud Drive.
SG
importing cvsv files from numbers to r
