how to do analysis of a table content SNP?
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 &lt;- read_excel(FILENAME)


To get the number of mutations per gene:

df %&gt;% group_by(`Gene name`) %&gt;%
  summarise(num_mutations=n())


If you want to know if there are mutations in a particular gene:

df %&gt;% filter(`Gene name` == QUERY)