Log in

View Full Version : Is there a software that converts gedmatch format to vahaduo format?



Scandal
01-11-2022, 05:57 PM
I mean a software where I paste my gedmatch result in the following format


North_Atlantic 28.69 Pct
Baltic 39.52 Pct
West_Med 11.43 Pct
West_Asian 3.62 Pct
East_Med 13.02 Pct
Red_Sea 2.3 Pct
South_Asian -
East_Asian -
Siberian 0.48 Pct
Amerindian -
Oceanian 0.23 Pct
Northeast_African 0.72 Pct
Sub-Saharan -

and then it converts to this format?


Universe,28.69,39.52,11.43,3.62,13.02,2.30,0,0,0.4 8,0,0.23,0.72,0

I thought about creating such application, but if it already exists it's not needed.

Ion Basescul
01-11-2022, 06:35 PM
Below is what I do in Sheets/LibreOffice Calc...only the joining part is automated, because the rest take about 10 seconds, so I never bothered automating it fully.
Split text to columns -> Split by space separation -> Copy the values -> Paste transposed -> Join text with commas

Scandal
01-11-2022, 06:39 PM
Below is what I do in Sheets/LibreOffice Calc...only the joining part is automated, because the rest take about 10 seconds, so I never bothered automating it fully.
Split text to columns -> Split by space separation -> Copy the values -> Paste transposed -> Join text with commas
https://mat3e.github.io/brains/img/3.jpg

Lucas
01-15-2022, 11:44 PM
I mean a software where I paste my gedmatch result in the following format


North_Atlantic 28.69 Pct
Baltic 39.52 Pct
West_Med 11.43 Pct
West_Asian 3.62 Pct
East_Med 13.02 Pct
Red_Sea 2.3 Pct
South_Asian -
East_Asian -
Siberian 0.48 Pct
Amerindian -
Oceanian 0.23 Pct
Northeast_African 0.72 Pct
Sub-Saharan -

and then it converts to this format?


Universe,28.69,39.52,11.43,3.62,13.02,2.30,0,0,0.4 8,0,0.23,0.72,0

I thought about creating such application, but if it already exists it's not needed.

Of course it is:) Just Control + V your Gedmatch results (with all those component names and stuff) and press Enter

https://trinket.io/python/41dad9165d?outputOnly=true&runOption=run