For smallish spreadsheets, it's often faster to just copy & paste into R
(though that's not exactly "reproducible"), using:
df <- read.delim("clipboard-128")
For larger datasets, using data.table fread() with a CSV file is more
efficient:
df <- fread("<filename>.csv")
--Mel.
On 3/20/2016 2:19 PM, Carl Sutton wrote:
1. in excel save the file as either <filename>.csv or <filename>.txt
into the same directory you will be writing your script(this saves
having to direct R to a path to the data)
2. use either read.table or read.csv to get the data into memory
?read.table will get you all you need to know to accomplish this
3. google mann whitney u test R and to get the information to do your
testing
Carl Sutton
On Saturday, March 19, 2016 3:28 PM, Santib2002 <[email protected]>
wrote:
This may be really basic, but could you help me with this issue?
I have an excel file named table1.xls.
I need to input this table in r, in order to calculate mann
whitney between
columns 1 and 2.
Could you please show me how to do this task?
--
View this message in context:
http://r.789695.n4.nabble.com/HELP-Mann-whitney-in-R-tp4718804.html
Sent from the datatable-help mailing list archive at Nabble.com.
_______________________________________________
datatable-help mailing list
[email protected]
<mailto:[email protected]>
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
_______________________________________________
datatable-help mailing list
[email protected]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
_______________________________________________
datatable-help mailing list
[email protected]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help