You're intentionally duplicating effort. Start with R and just continue. Instead you start with Excel and then redo it with R. Seems daft :)
-
-
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 -
Replying to @BioMickWatson @o_guest and
Would also like suggestions - when n<100 or it's not just me doing data entry, I haven't found any general purpose alternatives that work well (I do use other things for big/specialised data entry)
3 replies 1 retweet 2 likes -
Replying to @realMingChia @BioMickWatson and
I used Google Sheets for when the lab needed all of us (all 6 postdocs) to enter data at the same time. It was so good.
2 replies 2 retweets 4 likes -
Replying to @o_guest @realMingChia and
google sheets and docs is amazing for multiple simultaneous editors
1 reply 0 retweets 0 likes
I also turned validation for the columns and it was neat-o.
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.