hapmap format data import error

142 views
Skip to first unread message

Erena Edae

unread,
Nov 30, 2021, 2:30:30 PM11/30/21
to TASSEL - Trait Analysis by Association, Evolution and Linkage
Hello,
I did not use TASSEl for a while. Not sure what is changed recently as far as data format. Unable to import hapmap formatted SNP data.
What is wrong with the attached data?

Thanks,
Erena.



rst_snp_hapmap.xlsx

Alden Perkins

unread,
Nov 30, 2021, 2:42:34 PM11/30/21
to TASSEL - Trait Analysis by Association, Evolution and Linkage
I think it just needs to be converted from an Excel file to a tab delimited file. You could do that in R like this:

library(readxl)
df <- read_excel("~/Desktop/HapmapConversion/rst_snp_hapmap.xlsx")
write.table(df, "rst_snp_hapmap.hmp.txt", sep = "\t", quote=FALSE, row.names = FALSE)

and the output is attached



rst_snp_hapmap.hmp.txt

Erena Edae

unread,
Nov 30, 2021, 5:20:09 PM11/30/21
to tas...@googlegroups.com
The one I sent you is from excel, but I was not trying to import directly try from excel. Rather 1st I saved it as table delimited file and then tried to import into TASSEL. It did not work. I will try to save it from R if it works in that way.

Thanks,
Erena.



--
You received this message because you are subscribed to the Google Groups "TASSEL - Trait Analysis by Association, Evolution and Linkage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tassel+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tassel/4f869a39-3719-473c-a961-4518259c052fn%40googlegroups.com.


--
----------
Erena A. Edae, PhD
Researcher, Department of Plant Pathology, University of Minnesota
1551 Lindig st, St. Paul, MN 55108
Skype: erena.a.edae

Erena Edae

unread,
Nov 30, 2021, 5:47:51 PM11/30/21
to tas...@googlegroups.com
Thank you very much it worked!

Erena.

On Tue, Nov 30, 2021 at 1:42 PM Alden Perkins <a.perk...@gmail.com> wrote:
--
You received this message because you are subscribed to the Google Groups "TASSEL - Trait Analysis by Association, Evolution and Linkage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tassel+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tassel/4f869a39-3719-473c-a961-4518259c052fn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages