<html><head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head><body wsmode="compose" style="color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255); font-family: Arial; font-size:
14pt;" bgcolor="#FFFFFF" text="#000000"><div style="font-size:
14pt;font-family: Arial;">
<div style="font-size:
14pt;font-family: Arial;">
<div style="font-size: 14pt;font-family: Arial;"><span
style="font-family: Arial;">Hi!<br>I have a simple question. Most of us
have our microsatellite data in an excel file to start with. The ones
how use GenAlex even have the geographic coordinates in the last two
rows. We can easily convert the data in the sheet into several formats.
How can I convert an easily obtained csv file with headers (1sr row =
individual id, 2nd = population id, 3rd row= allele 1, locus 1, </span><span><span
style="font-family: Arial;">4th row= allele 2, locus 1, etc, 17th row =
latitude, 18th row = longitude) nto a genind object that can be used in
sPCA? I get an error that coordinates are repeated, but that is normal
as there are multiple individuals in the same pop.<br><br>If this
question was answered previously, I will appreciate if you could direct
me to it.<br>Many thanks<br>Rita<br><br>first 5 rows of test.csv file<br>ind,pop,loc1A,loc1B,loc2A,loc2B,loc3A,loc3B,loc4A,loc4B,loc5A,loc5B,loc6A,loc6B,loc7A,loc7B,lat,long<br>FD_01,FD,151,163,168,170,189,201,248,248,177,187,166,166,230,246,49.85,-29.62<br>FD_02,FD,137,147,146,146,173,181,240,254,177,179,162,166,230,246,49.85,-29.62<br>FD_03,FD,137,169,146,168,173,173,222,238,193,203,164,164,230,246,49.85,-29.62<br>FD_04,FD,137,147,144,144,189,201,236,242,185,193,166,166,238,240,49.85,-29.62<br><br></span></span></div>
</div>
</div></body></html>