You're intentionally duplicating effort. Start with R and just continue. Instead you start with Excel and then redo it with R. Seems daft :)
So the real solution is to enter data in raw text and delimit manually using tabs or commas, right?
-
-
Yes, it makes the most sense to teach that Excel is OK for producing tabular representations, and that there are bad ways of doing this, but if you need to do anything else, export to CSV: https://datacarpentry.org/spreadsheet-ecology-lesson/ …
-
Which is exactly what the paper that started this whole discussion off recommends! I wish people would just read it.
-
I didn't see the freeware software alternatives nor issues with version control mentioned in it last time I read it, when it first came out. Maybe I'm forgetting!
-
For example, this: "Keep all versions of the data files, so that if something gets corrupted (e.g., you accidentally type over some of the data and do not notice it until much later), you will be able to go back and fix it. Before you start inserting more data, make a copy of"
-
"the file with a new version number: file_v1.xlsx, file_v2.xlsx,..." Is really bad advice.
-
Why are binaries being used here?
- End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.