<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
For smallish spreadsheets, it's often faster to just copy &
paste into R (though that's not exactly "reproducible"), using:<br>
<tt>df <- read.delim("clipboard-128")</tt><br>
<br>
For larger datasets, using data.table fread() with a CSV file is
more efficient:<br>
<tt>df <- fread("</tt><span
id="yui_3_16_0_ym18_1_1458496430639_12850"><tt><filename>.csv")</tt><br>
<br>
</span>--Mel.<br>
<br>
<div class="moz-cite-prefix">On 3/20/2016 2:19 PM, Carl Sutton
wrote:<br>
</div>
<blockquote
cite="mid:1135632685.1856031.1458497947855.JavaMail.yahoo@mail.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif;font-size:16px">
<div dir="ltr" id="yui_3_16_0_ym18_1_1458496430639_12848"><span
id="yui_3_16_0_ym18_1_1458496430639_12850">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)<br>
</span></div>
<div id="yui_3_16_0_ym18_1_1458496430639_12918" dir="ltr"><span
id="yui_3_16_0_ym18_1_1458496430639_12850">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</span></div>
<div id="yui_3_16_0_ym18_1_1458496430639_13081" dir="ltr"><span
id="yui_3_16_0_ym18_1_1458496430639_12850">3. google mann
whitney u test R and to get the information to do your
testing</span></div>
<div id="yui_3_16_0_ym18_1_1458496430639_12847"> </div>
<div id="yui_3_16_0_ym18_1_1458496430639_12846"
class="signature">Carl Sutton<br>
</div>
<div class="qtdSeparateBR"><br>
<br>
</div>
<div style="display: block;" class="yahoo_quoted">
<div style="font-family: HelveticaNeue, Helvetica Neue,
Helvetica, Arial, Lucida Grande, sans-serif; font-size:
16px;">
<div style="font-family: HelveticaNeue, Helvetica Neue,
Helvetica, Arial, Lucida Grande, sans-serif; font-size:
16px;">
<div dir="ltr"><font size="2" face="Arial"> On Saturday,
March 19, 2016 3:28 PM, Santib2002
<a class="moz-txt-link-rfc2396E" href="mailto:Santib2002@gmail.com"><Santib2002@gmail.com></a> wrote:<br>
</font></div>
<blockquote style="border-left: 2px solid rgb(16, 16,
255); margin-left: 5px; margin-top: 5px; padding-left:
5px;"> <br>
<br>
<div class="y_msg_container">This may be really basic,
but could you help me with this issue?<br>
I have an excel file named table1.xls.<br>
I need to input this table in r, in order to calculate
mann whitney between<br>
columns 1 and 2.<br>
Could you please show me how to do this task?<br>
<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a
moz-do-not-send="true"
href="http://r.789695.n4.nabble.com/HELP-Mann-whitney-in-R-tp4718804.html"
target="_blank"><a class="moz-txt-link-freetext" href="http://r.789695.n4.nabble.com/HELP-Mann-whitney-in-R-tp4718804.html">http://r.789695.n4.nabble.com/HELP-Mann-whitney-in-R-tp4718804.html</a></a><br>
Sent from the datatable-help mailing list archive at
Nabble.com.<br>
_______________________________________________<br>
datatable-help mailing list<br>
<a moz-do-not-send="true"
ymailto="mailto:datatable-help@lists.r-forge.r-project.org"
href="mailto:datatable-help@lists.r-forge.r-project.org">datatable-help@lists.r-forge.r-project.org</a><br>
<a moz-do-not-send="true"
href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help"
target="_blank">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a><br>
<br>
<br>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
datatable-help mailing list
<a class="moz-txt-link-abbreviated" href="mailto:datatable-help@lists.r-forge.r-project.org">datatable-help@lists.r-forge.r-project.org</a>
<a class="moz-txt-link-freetext" href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a></pre>
</blockquote>
<br>
</body>
</html>