error reading HapMap.hmp.txt file in r: more columns than column names

[Jia0116]

Dear R Studio Community,

I am trying to read the SNPs data as hapmap format (showing in attached photo). I could not find the reason that caused more columns as mentioned in error messages. Do you have any suggestions for it?

> hapmap_toad <- read.table("canetoad_wild_filtered_rename.hmp.txt", header=TRUE, row.names=1, sep="\t")
Error in read.table("canetoad_wild_filtered_rename.hmp.txt", header = TRUE,  : 
  more columns than column names

[nirgrahamuk]

I recommend you use library(readr)
and readr::read_tsv() for more informative messages

[Jia0116]

Hi Nirgrahamuk,

Thanks for the quick response. Good to know more information about the table.

The error is solved by removing the "#" symbol from some of the column names.

Thanks,

Jia