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 -
Replying to @o_guest @froggleston and
How should people do data entry? Assuming the data initially exists in some noncomputerised form?
2 replies 1 retweet 3 likes -
In my experience it usually boils down to either a spreadsheet or a forms based front end to a database. In the first case,
#LibreOffice Calc is much less likely to go rogue with your data than Excel. In either case, using double entry plus automated validation check is helpful.1 reply 0 retweets 1 like -
Replying to @davidbraze @deevybee and
Loads of recommendations that are not Excel and do not save as binary in this thread.
1 reply 0 retweets 0 likes -
I saw that, and confess thatm I've never used any of them. But double entry validation is important to me when hand keying data. Do you know if any of these other tools support that directly?
2 replies 1 retweet 1 like
Please ask the people who recommended them. As one of the few women in comp/cog modelling, I don't do any (or very very rarely) manual data entry. So I'm not best placed to recommend sw. I do see huge issues with the advice offered and I can and will point that out though.
-
-
Sorry. Meant the "you" as more generic than specific, & request was for off-hand knowledge, not asking anyone to do homework. I've dealt with lots of manual entry. Biggest prob is miskeyed data. Type/range checks only a partial solution. There is no substitute for double entry.
0 replies 0 retweets 1 likeThanks. 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.