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 :)
-
-
Excel is bad for so many reasons.
-
yes indeed, it has many problems. I was just highlighting some of the things it does very well (IMHO)
-
I hope for your own sake you can wean yourself off this. I don't use R, but if you do, you should just use R and RStudio to look at your data. It can do everything, as you know, that Excel can do and more.
-
I use R daily and have written and published multiple R packages :-) Excel is still great at an initial "first look" in my opinion, but of course, opinions vary :-)
-
I don't even have Excel on Linux — so are you developing on a Mac? Impressive, because that does my head in with its BS with Cython. Maybe deving in R is more Mac-friendly.
-
this is going to blow your mind... my main computers are Windows....
- End of conversation
New conversation -
-
-
How should people do data entry? Assuming the data initially exists in some noncomputerised form?
-
I don't know — but it worries me ppl use Excel. Many useful replies further down the thread. In my idea world, we would move away from MS products and we would also not use tools that are bloated for something as simple as just typing in values that could be stored as raw text.
-
Also see, refreshing recommendation:https://twitter.com/drchriscole/status/1031495590054711296?s=19 …
-
Last two are most definitely not spreadsheet software!

-
And more info here on chameleon:https://twitter.com/ODILabs/status/1031506383475290112?s=19 …
- 3 more replies
New conversation -
-
-
TBF the alternatives for human data entry are very limited. Even I'll admit Excel is good for that. Important to structure the data first.
-
Even if Excel is known to mangle stuff and other less bloated and cheaper software does less of this?
-
would love to hear suggestions - I think lots of people don't know about these
-
I can't say with certainty what is better as a) I don't enter data manually (I think this is important experience-based knowledge) and b) a lot of the issues highlighted by people are input-specific. So I'd suggest shopping around — Google Sheets? https://support.google.com/docs/answer/6388102?co=GENIE.Platform%3DDesktop&hl=en …
-
type DEC10 into Google Sheets and it does exactly what Excel does :/
-
Ah, that sucks.
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.
