text: user2686: I have a table with information about SNPs, the table has a total of 55127 rows.
  How can I know the number of gene mutations in the table and if a gene is present?
  The table is in xls format.
  
  
  user581: For working with a relatively small dataset in tabular format, I would recommend dplyr. You can read in a excel file using readxl
  library(readxl)
  library(dplyr)
  
  df <- read_excel(FILENAME)
  
  To get the number of mutations per gene:
  df %>% group_by(`Gene name`) %>%
    summarise(num_mutations=n())
  
  If you want to know if there are mutations in a particular gene:
  df %>% filter(`Gene name` == QUERY)
  
  
original_text: 2686: <p>I have a table with information about SNPs, the table has a total of 55127 rows.</p>
  
  <p>How can I know the number of gene mutations in the table and if a gene is present?</p>
  
  <p>The table is in xls format.</p>
  
  <p><a href="https://i.stack.imgur.com/MfFs4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MfFs4.png" alt="enter image description here"></a></p>
   581: <p>For working with a relatively small dataset in tabular format, I would recommend <a href="https://cran.r-project.org/web/packages/dplyr/vignettes/dplyr.html" rel="nofollow noreferrer">dplyr</a>. You can read in a <code>excel</code> file using <a href="https://readxl.tidyverse.org" rel="nofollow noreferrer">readxl</a></p>
  
  <pre><code>library(readxl)
  library(dplyr)
  
  df &lt;- read_excel(FILENAME)
  </code></pre>
  
  <p>To get the number of mutations per gene:</p>
  
  <pre><code>df %&gt;% group_by(`Gene name`) %&gt;%
    summarise(num_mutations=n())
  </code></pre>
  
  <p>If you want to know if there are mutations in a particular gene:</p>
  
  <pre><code>df %&gt;% filter(`Gene name` == QUERY)
  </code></pre>
  