Reading data from a spreadsheet in RStudio

[boleyr]

I am having trouble opening up a csv file in RStudio. I am unable to run lines 20 and 22 but it seams as though the path is correct. I am working on a mac.

Thank you

[cderv]

Can you provide a reprex ?

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

The only thing we can say here is that there is something wrong with file. R can't access it to read it.
Does it exist in this folder ?
Have you the right to read it ?
Is there a typo in the filename ?

[boleyr]

I am going through a tutorial on R for beginners. Initially the tutorial came with a set of example files in a folder. I am learning how to read data from a spreadsheet in RStudio. I was given a .xlsx file of a data set and then converted it into a csv comma delimited file and then re-saved it on my desktop. I then tried creating the sn.csv data frame that then has read.csv that reads my new csv file on my desktop but I am unable to specify the path which to read the desired csv file which is still on my desktop. I hope this helps.

[cderv]

I think you could learn to use RStudio Projects and how to read data from there. I could help to not deal with absolute path.

Posit

The other webinars are useful too.

Your R code seems ok. the error means the file path provided is not readable. I can't do much more here.

[boleyr]

Thank you! It seams as though the pathway sn.csv <- read.csv("Desktop/social_network.csv") worked instead.

[cderv]

Good to know !
it is possible as I suspected that the space in the path was not understood correctly.

If your question's been answered (even by you!), would you mind choosing a solution? It helps other people see which questions still need help, or find solutions if they have similar problems. Here’s how to do it:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …