Project at University: how to transform this raw data into something I can work with?

[theworstprogrammer]

Hello There,

I am a participator of a quality project at the university where we've given some random data from the industry. I have a raw data which just contains some strings, there is no order for rows/columns.

Question: How Can I Transform this Data into a format that i receive a headline, rows, columns - naturally assigned accordingly.

I know that i have to remove the "," but i dunno how i should go on.

Thanks

[FJCC]

Take a look at the read.csv() function.

Also, I suggest you read this post:

FAQ: Homework Policy

Can I ask questions from a course I am taking here? General questions are always welcome! Please do ask general questions about things like: How to use R How to use the RStudio IDE or RStudio Cloud How to work with tidyverse packages Where to find resources to help you learn or solve problems Specific questions can be OK, if you follow these rules: Never copy-paste instructions from an assignment (even for online courses). Explicitly mention the course you are taking and use the #homework tag. Ask your question as a reproducible example (reprex), preferably prepared for posting using the reprex package. Want to maximize your chances of getting the help you need? Keep readin…

[jcblum]

If you're using RStudio, you might also try the data import wizard:

Importing Data with the RStudio IDE

It will help you figure out how to import your data file, and it shows you the code it is constructing that does all the work , so it's a great first step if you're feeling baffled by writing the code directly.

Another great resource is this Data Import Cheatsheet:

Posit