I see Excel is being hated on again. To be honest, its quick visual sorting, filtering and graphing functions are exceptional. Fantastic for initial exploration of the data. I use it daily.
Once I see the data, of course #rstats for serious graphs :)
-
-
type DEC10 into Google Sheets and it does exactly what Excel does :/
- 1 more reply
New conversation -
-
-
Doesn't GSheets have similar issues to Excel? (reformat by default, little enforcement of data structure) (it's great for collab though!)
-
Yup, sure does.
-
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.
- 2 more replies
New conversation -
-
-
I would stick my neck out and state that the issue, 100%, is that biologists aren't universally trained in how to enter data into any system, anywhere. You're just left to your own devices, because, hey if you don't put that you "know" Excel on your CV, you look like a dingus.
-
Oh, dear! Depressing: "if you don't put that you "know" Excel on your CV, you look like a dingus"!!!
-
I dunno - there's not a job interview goes by that Excel (or MS Office) isn't explicitly mentioned in IT skills. It's like a lowest common denominator.
-
I'm sorry. This makes me feel my field is so ahead and that I should be prouder of where we are when all job apps pretty much say "Python needed" and no mention of any MS products.
End of conversation
New conversation -
-
-
Gnumeric is much less buggy than GSheets. Also can use Deducer in R to give a spreqdsheet
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
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.