<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>