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 :)
-
-
Other spreadsheet software will munge your gene names/dates. It's not just Excel. It's default formatting/user ignorance/poor automated error checking that spreadsheets suffer from, which is why we teach how to account for this in
@thecarpentries. -
Ah, that makes sense. But I am still worried about dependance on Excel. Can't we move to something more (financially) sustainable? It would help people who don't get free stuff from MS too.
-
LibreOffice is completely free, and is almost identical in terms of functionality.
-
I'm aware but have no idea if it's good. Don't use any spreadsheet software except Google Sheets and that very very rarely. My data comes from code I write myself so I'm in a diff boat and I can generate it to my needs 100%.
-
That sounds wonderful *quietly weeps*
-
I am shocked people enter and manipulate data in Excel in 2018. Genuinely still recovering from the shock.
-
At a recent training workshop in Nairobi, when we asked 14 biologist fellows what format their data is usually in, all of them said Excel. All of them. It's absolutely normalised in biology to use Excel for data input, validation, checking, and sharing.
-
Wait! So not even .csv actually .xls? Eek. How do you even version control that?
- 2 more replies
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.