search

Watts-College / cpp-527-fall-2021

A course shell for CPP 527 Foundations of Data Science II
https://watts-college.github.io/cpp-527-fall-2021/
2 stars 6 forks source link

CSV not recognized on Mac #58

Closed voznyuky closed 2 years ago

voznyuky commented 2 years ago

Professor Lecy,

I have made several attempts to edit the 'positions.csv' file but because I am working on a mac it is opening it in 'Numbers' and R cannot read it when I try to run this:

position_data <- read_csv('positions.csv') %>%

I am not sure what my options are, if you know of a trick, please let me know. Otherwise I am just getting error codes by trying to edit excel in another program.

voznyuky commented 2 years ago

I think I might've figured it out. I can use 'TextEdit', a bit of a trickier process but seems to work..

lecy commented 2 years ago

Numbers should work, but make sure you are saving the file as a CSV when done.

You can also edit right in R:

d <- read.csv( "filename.csv" )
fix( d )
voznyuky commented 2 years ago

I was looking for a code like that last night, I knew it existed, but no luck! I was able to edit in the textedit, just submitted. Thanks for the code mentioned, something I may reference later on as I will continue using the mac.