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 :)
-
-
Replying to @BioMickWatson
You're intentionally duplicating effort. Start with R and just continue. Instead you start with Excel and then redo it with R. Seems daft :)
3 replies 1 retweet 4 likes -
Replying to @drchriscole @BioMickWatson
There's an important distinction between "seeing the data" (Excel is unarguably good at this) and "working with data" (Excel is unarguably poor at this).
2 replies 4 retweets 7 likes -
If limited to just "seeing" the contents I would argue that is fine, although you do not need Excel to do that. Very expensive and bloated for just looking at some columns. Can be done better with better/smaller software.
2 replies 1 retweet 2 likes -
Replying to @o_guest @froggleston and
Olivia Guest | Ολίβια Γκεστ Retweeted Dorothy Bishop
What people seem to do is ENTER the data in Excel. This is disturbing. Please do not do that.https://twitter.com/deevybee/status/1031151509965352960 …
Olivia Guest | Ολίβια Γκεστ added,
Dorothy Bishop @deevybeeReplying to @ProfDataAargh. Are you not aware that sometimes a human being needs to intervene to input data? Not all data comes from a 'data collection program'. Sorry, but I've had enough of being told what I know this morning and I am going back to my data analysis (in R).3 replies 2 retweets 0 likes -
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.
1 reply 0 retweets 0 likes -
Even if Excel is known to mangle stuff and other less bloated and cheaper software does less of this?
1 reply 0 retweets 0 likes -
would love to hear suggestions - I think lots of people don't know about these
3 replies 0 retweets 1 like -
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 …
4 replies 0 retweets 2 likes -
type DEC10 into Google Sheets and it does exactly what Excel does :/
1 reply 0 retweets 1 like
Ah, that sucks.
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.