+- The GenArchivist Forum (https://genarchivist.com)
+-- Forum: Human Personal & Genealogical Genetics (https://genarchivist.com/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://genarchivist.com/forumdisplay.php?fid=2)
+--- Thread: The Kolompar Kollection - AADR anno with G25 coordinates (/showthread.php?tid=544)
The Kolompar Kollection - AADR anno with G25 coordinates - kolompar - 02-14-2024
The advantage of the Reich AADR anno file is that it can be opened in Excel where you can filter by all the attributes there are: dates, coverage, geographical coordinates, contamination, even sex and haplogroup if you're looking for an ancestor, or publishing year for nostalgia.
I added the G25 coordinates from the latest ancients files to the end of the lines where the corresponding ID was found.
Did it with a Python script that had problems with the encoding so may not be 100%. It could probably be done simply in Excel too, importing the G25 datasheets, and textsplit and vlookup the IDs.
https://docs.google.com/spreadsheets/d/e/2PACX-1vQLRq28TkqRWE6wxIO3QOrmWGdfnNFlUSpbsd1Zufivg35G1hDRH4Bn7W8JbzlNjaE5b20HtOcMf4gI/pub?output=tsv
RE: The Kolompar Kollection - AADR anno with G25 coordinates - ChrisR - 02-21-2024
Thank you! I always thought some kind of "automatic/scripted" combination of the official G25 coordinates with the dates, geographical coordinates, etc would be a huge increase in utility. I would hope Davidski would find someone to do this officially and to have it always updated.