Beginner problem with variables number

[lea]

Hi
I'm struggling with Rstudio but I'm a total beginner so it's probably really easy to solve. So easy that I can't find it explained on internet!!

I do this:

dframe1 <- read.csv(file.choose())

summary(dframe1)
names(dframe1)
str(dframe1)

my file is correct, I can see it but R says 200 observations of 1 variable despite there is 12 columns in my file and I was expecting 12 variables
How can I make it work?

Thank you!!

[andresrcs]

Are you sure that your file has comma separated values? maybe it has another format, please paste a few lines from the file to take a look into its structure.

[lea]

summary(dframe1)
Individual.Size.Territory.Coral.Algae.Attack.Visitor.Diet.Farming.Exploring..Defending.Other
30;5;>1m;10;10;0;Abudefduf;Omnivore;60;94;9;17 : 5
44;5;<1m;0;30;0;Abudefduf;Omnivore;39;94;0;47 : 5
30;5;>1m;10;10;1;Pomacentrus;Algivore;60;94;9;17 : 4

Like this? Thank you for your reply!

[andresrcs]

It seems like your values are separeted by ";" instead of ","
Try reading your file with this

dframe1 <- read.csv(file.choose(), sep = ";")

[lea]

@andresrcs

dframe1 <- read.csv(file.choose(), sep = ";")

Oh my god you did it!! Thank you, I spent like 4 hours trying everything!!

[andresrcs]

Your welcome!

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] …