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

Reply via email to