Gedmatch calculators on Vahaduo

**Leto** · 01-10-2022, 12:33 PM

Originally Posted by Ion Basescul

These are distinct regions. Wallachia is the only one that could be removed, because it's just the average of all Muntenia and Oltenia samples.

Can you calculate Wallachia and Transylvania averages for Dodecad? Just use the best samples, obviously not all that are available.

**~~Dunai~~** · 01-10-2022, 03:04 PM

Originally Posted by vbnetkhio

here's a hastily edited sheet with only one average per ethnicity:

Code:

Aari,0.43,0.14,0.32,1.97,2.23,9.70,1.41,0.23,0.53,0.20,0.37,74.12,8.35
Abhkaz,1.64,4.62,9.81,54.30,22.78,1.84,1.91,1.48,1.11,0.17,0.33,0.01,0.01
Aboriginal_Australian,0,0,0,0,0,0,14.73,11.06,4.79,0.2,65.9,3.33,0
Afrikaner,44.12,22.79,14.04,4.98,6.17,0.86,2.28,0.89,0.39,0.52,0.57,0.46,1.89
Alawite,5.95,1.56,13.93,24.33,39.43,9.69,1.82,0.42,0.76,0.21,0.35,1.28,0.23
Albanian,21.69,17.54,21.72,11.13,23.86,2.59,0.16,0.28,0.28,0.28,0.22,0.16,0.09
Algerian,13.95,0.61,24.25,0.00,27.47,14.21,0.00,0.31,0.12,0.10,0.39,8.89,9.66
Altai,4.25,9.58,0.55,8.32,0.14,0.23,2.94,21.39,48.62,3.21,0.51,0.01,0.25
Amerindian_North,0.00,1.64,0.00,0.01,0.00,0.01,1.03,1.61,21.97,73.72,0.02,0.00,0.00
Amhara,0.07,0.01,0.77,0.04,21.14,26.79,0.03,0.14,0.02,0.17,0.21,47.07,3.55
Anuak_Ethiopia,0.00,0.00,0.00,0.00,0.00,0.00,0.03,0.03,0.02,0.02,0.02,61.65,38.24
Armenian,3.13,2.22,12.06,37.82,35.29,5.75,2.77,0.24,0.10,0.13,0.35,0.17,0.16
Aromanian,21.26,20.34,19.00,11.77,22.61,3.09,0.18,0.47,0.47,0.41,0.38,0.04,0.00
Arunthathiyar,0.07,0.02,0.98,12.79,0.43,1.37,76.82,3.51,0.21,0.05,2.40,0.79,0.56
Assyrian,1.74,1.07,11.94,32.56,39.58,8.59,3.29,0.25,0.13,0.16,0.30,0.24,0.12
Austrian,37.21,29.87,14.58,7.23,8.23,1.56,0.78,0.07,0.16,0.12,0.11,0.07,0.00
Avar,14.40,16.11,1.05,49.59,8.76,0.69,5.74,0.06,1.74,1.37,0.27,0.02,0.19
Azerbaijani,5.54,4.68,6.92,34.81,28.48,5.51,7.13,2.28,2.92,0.54,0.54,0.35,0.29
Baka,0.00,0.01,0.00,0.00,0.00,0.00,0.01,0.02,0.05,0.01,0.35,21.06,78.49
Balkar,6.59,10.90,9.30,45.36,14.67,0.77,1.99,3.35,5.53,0.83,0.50,0.06,0.17
Baloch,2.96,3.55,0.24,53.45,5.02,3.15,29.58,0.00,0.17,0.63,0.04,0.32,0.90
Bamar,0.32,0.81,1.02,0.70,0.54,0.31,18.39,60.71,13.69,0.79,1.64,0.24,0.84
Bantu,0.06,0.08,0.05,0.12,0.24,0.37,0.11,0.23,0.16,0.20,0.20,17.75,80.43
Bashkir,13.65,24.98,2.13,13.63,1.26,0.28,3.45,8.71,27.40,3.25,0.41,0.58,0.27
Basque_France,52.62,6.10,35.86,0.35,3.07,0.31,0.32,0.65,0.06,0.08,0.30,0.22,0.04
Bedouin,1.25,1.19,11.06,14.43,38.15,21.40,1.85,0.25,0.69,0.27,0.21,6.33,2.91
Belarusian,29.37,49.40,7.59,3.87,4.98,1.44,0.97,0.18,1.32,0.18,0.38,0.20,0.13
Belgian,45.20,22.22,15.56,5.69,7.34,1.11,0.97,0.27,0.10,0.54,0.43,0.35,0.15
Bengali_Bangladesh,2.38,4.43,0.93,18.87,0.54,0.25,58.19,8.99,2.54,0.76,1.71,0.02,0.40
Beta_Israel,0,0,0.30,0,17.83,29.31,0,0,0.03,0.02,0.20,51.57,0.72
Bosniak,25.73,35.04,14.18,8.58,12.19,1.26,0.98,0.31,0.62,0.60,0.25,0.16,0.10
Brahmin_Uttar_Pradesh,7.52,8.07,0.41,23.86,0.12,0.07,55.38,0.65,0.74,1.88,0.85,0.23,0.23
Brahui,1.52,2.28,0.06,53.84,5.71,3.18,29.92,0.06,0.51,0.64,0.28,0.80,1.20
Bulgarian,21.80,24.15,17.82,11.65,19.51,2.40,0.53,0.42,0.77,0.38,0.33,0.11,0.08
Burusho,2.50,8.83,0.01,37.09,0.22,0.04,36.76,5.04,6.21,2.26,0.33,0.24,0.47
Buryat,0.47,3.04,1.11,5.10,1.22,0.73,0.74,26.85,58.82,1.44,0.26,0.21,0.01
Chamar,0.45,1.72,1.27,11.50,0.59,0.71,77.02,1.75,1.69,1.23,1.44,0.51,0.11
Chechen,10.14,15.25,4.48,46.45,13.11,1.36,3.47,1.34,1.73,1.32,1.05,0.18,0.12
Chenchu,0.75,0.34,1.51,12.87,1.46,0.37,71.14,6.32,1.84,0.81,1.92,0.32,0.35
Chukchi,0.02,3.65,0.00,0.05,0.00,0.00,1.28,8.84,60.79,24.71,0.65,0.00,0.00
Chuvash,14.88,43.07,2.02,8.74,1.29,0.85,2.28,2.66,20.08,2.77,0.44,0.55,0.36
Circassian,6.38,12.14,7.88,47.22,16.97,1.95,2.79,1.08,2.58,0.80,0.13,0.05,0.03
Croat,28.10,33.15,15.02,7.76,12.05,1.40,0.49,0.28,0.59,0.54,0.38,0.12,0.10
Csángó-Ceangău,27.60,29.46,15.34,8.91,11.04,1.51,0.87,1.07,2.64,0.81,0.47,0.15,0.15
Czech,33.53,37.14,12.43,5.94,7,0.9,1.18,0.14,0.66,0.59,0.26,0.19,0.13
Dai,0.03,1.07,0.03,0.16,0.01,0.01,4.19,90.46,1.69,0.55,1.41,0.10,0.28
Danish,50.61,28.70,10.19,5.00,2.12,0.52,0.99,0.19,0.42,0.59,0.23,0.12,0.17
Dargin,14.95,17.38,0.62,50.93,7.03,0.27,4.53,0.11,1.40,2.41,0.14,0.04,0.28
Dharkar,1.85,4.01,1.94,19.67,0.57,0.03,65.77,1.74,1.80,0.84,0.82,0.72,0.23
Dolgan,1.57,7.84,0.63,0.78,0.14,0.06,1.92,9.23,75.33,1.38,0.43,0.59,0.11
Dutch,49.05,25.20,12.14,4.99,4.00,1.13,0.94,0.39,0.51,0.60,0.42,0.26,0.29
Egyptian,3.00,0.09,11.72,7.86,39.56,18.84,0.09,0.14,0.30,0.10,0.23,11.83,6.24
English,49.68,23.44,13.70,5.62,3.96,0.71,1.03,0.15,0.29,0.57,0.39,0.21,0.17
Estonian,32.93,50.58,6.76,2.45,0.57,0.09,0.95,0.05,3.51,1.35,0.61,0.04,0.09
Even,0.14,3.03,0.90,0.48,0.37,0.38,0.37,10.18,80.93,2.43,0.61,0.18,0.01
Evenk,0.26,4.32,0.37,0.52,0.20,0.12,0.44,11.82,79.19,1.34,1.21,0.11,0.11
Finnish,34.17,47.69,4.43,2.21,0.65,0.42,0.53,0.96,6.48,0.90,0.81,0.50,0.26
Flemish,45.58,22.81,15.33,5.88,6.79,0.60,0.97,0.37,0.12,0.57,0.38,0.35,0.17
French,42.27,17.40,21.23,4.91,10.09,1.57,0.59,0.27,0.35,0.55,0.31,0.25,0.20
Gagauz,19.35,22.92,18.13,13.07,21.02,2.46,0.65,0.37,0.91,0.33,0.51,0.21,0.07
Georgian,3.72,5.52,10.13,52.14,21.85,3.22,1.80,0.65,0.37,0.42,0.12,0.03,0.03
German,43.00,27.31,13.88,5.81,6.40,0.94,0.94,0.15,0.34,0.46,0.36,0.15,0.13
Greek,15.76,11.62,19.89,17.55,29.18,3.91,0.40,0.37,0.40,0.26,0.33,0.22,0.07
Greenlandic_Inuit,0.96,7.75,0.01,0.46,0.01,0.01,2.40,6.87,41.49,39.74,0.18,0.08,0.06
Gujarati,4.22,6.43,0.04,27.49,0.40,0.18,58.04,0.65,1.25,0.37,0.49,0.11,0.33
Gumuz_Ethiopia,0.00,0.00,0.00,0.01,0.00,0.01,0.78,0.51,0.30,0.10,0.41,72.20,25.69
Hadza,0.41,0.32,0.01,0.97,0.14,1.32,2.66,0.05,0.25,0.12,0.55,61.84,31.36
Hazara_Afghanistan,7.36,7.11,0.59,23.61,5.37,0.96,13.56,17.57,20.94,2.12,0.35,0.12,0.31
Hazara,3.20,8.47,1.46,21.92,3.70,0.76,12.59,20.87,24.42,1.87,0.40,0.21,0.13
Ho,0.00,0.00,0.01,0.00,0.00,0.00,69.42,24.77,0.18,0.08,4.28,0.68,0.58
Hungarian,30.43,32.58,14.23,7.16,10.42,1.28,0.9,0.55,1.19,0.55,0.35,0.2,0.15
Icelandic,51.20,26.73,10.31,6.30,1.57,0.78,0.83,0.20,0.77,0.84,0.12,0.24,0.06
Ingush,8.91,11.47,6.17,48.35,15.47,1.35,2.13,1.56,2.88,1.09,0.59,0,0.13
Iranian,2.07,4.23,4.23,38.20,29.70,7.48,10.56,0.04,1.34,0.28,0.24,0.17,1.47
Iraqi,2.66,2.3,8.46,28.81,33.63,11.82,6.83,0.61,0.88,0.37,0.27,2.54,0.81
Irish,52.43,22.93,12.62,6.82,1.44,0.50,1.40,0.16,0.28,0.80,0.29,0.14,0.13
Italian,26.37,11.03,22.88,10.51,24.03,3.65,0.27,0.23,0.10,0.23,0.30,0.26,0.15
Japanese,0.01,0.00,0.01,0.00,0.02,0.01,0.22,65.93,31.72,0.83,0.62,0.32,0.30
Jat_Punjab,7.52,10.46,0.07,35.03,0.74,0.59,43.04,0.07,0.41,1.30,0.33,0.07,0.38
Jewish,9.30,2.70,15.95,17.34,39.29,10.09,1.53,0.42,0.28,0.20,0.41,2.07,0.42
Jordanian,2.45,0.69,10.94,18.25,40.75,14.70,1.48,0.40,0.16,0.61,0.50,6.96,2.12
Kabardian,7.04,13.45,8.22,44.99,13.16,1.89,2.40,2.32,5.14,0.72,0.23,0.24,0.19
Kalash,5.72,11.37,0.00,43.42,0.69,0.00,34.83,0.03,1.28,1.85,0.22,0.09,0.49
Kanjar,2.02,5.26,0.51,19.37,0.25,0.05,67.26,1.77,0.77,0.83,1.14,0.47,0.29
Kannada_North,0.28,4.26,0.35,15.05,0.64,0.05,72.33,2.12,1.82,0.61,1.48,0.40,0.61
Karakalpak,7.81,12.16,2.15,13.31,3.51,1.45,4.49,20.04,32.27,1.72,0.65,0.08,0.28
Karitiana,0.00,0.01,0.00,0.00,0.00,0.00,0.01,0.32,0.02,99.62,0.00,0.01,0.01
Kazakh,7.42,11.87,1.47,12.28,0.99,0.86,3.34,22.47,36.11,2.22,0.91,0.05,0.03
Ket,2.00,22.06,0.00,2.96,0.00,0.00,3.98,3.40,57.55,7.77,0.28,0.00,0.00
Khakas,3.88,16.30,0.23,9.81,0.02,0.06,3.33,17.07,44.91,3.88,0.15,0.14,0.21
Khanty,5.65,31.35,0.00,3.55,0.00,0.00,4.34,0.83,47.59,6.01,0.56,0.00,0.10
Khmer_Cambodia,0.08,1.82,0.49,0.33,0.16,0.40,14.67,76.89,0.84,0.30,3.19,0.49,0.33
Kirgiz,5.81,7.94,1.15,12.69,2.05,0.34,4.21,24.46,37.76,2.56,0.91,0.04,0.08
Kol,2.16,2.90,1.81,16.00,0.57,0.03,71.04,2.16,0.85,1.10,0.70,0.44,0.25
Komi,22.39,43.60,3.11,8.46,0.17,0.31,2.39,0.57,15.43,2.56,0.25,0.21,0.54
Koryak,0.02,3.90,0.00,0.24,0.00,0.00,0.93,10.91,66.39,17.42,0.16,0.00,0.02
Kshatriya,4.22,6.62,0.27,24.46,0.76,0.10,58.75,0.71,1.19,1.40,0.81,0.43,0.28
Kumyk,7.40,12.43,6.78,41.62,18.24,2.19,3.84,2.21,3.07,1.39,0.46,0.15,0.21
Kurd,3.67,3.55,6.20,40.33,29.77,5.69,8.07,0.36,1.01,0.49,0.28,0.52,0.07
Kurumba,0.92,0.05,0.42,20.26,0.77,0.60,70.73,1.53,1.69,0.28,1.63,0.71,0.40
Lahu,0.27,0.48,0.26,0.05,0.16,0.16,4.49,81.47,9.62,0.88,1.46,0.51,0.17
Lak,13.14,17.90,0.88,50.54,7.79,0.64,4.30,0.20,2.24,1.83,0.30,0.19,0.23
Latvian,26.74,58.36,6.41,2.73,0.78,1.1,0.77,0.09,1.43,0.73,0.32,0.33,0.22
Laz,1.47,1.72,14.18,45.4,32.17,3.04,0.88,0.51,0,0.11,0.38,0,0.09
Lebanese_Christian,1.47,0.19,15.36,20.76,47.26,12.40,0.77,0.59,0.19,0.01,0.17,0.83,0.01
Lebanese_Druze,5.04,1.19,10.62,21.22,48.65,9.37,1.61,0.45,0.53,0.01,0.42,0.58,0.30
Lebanese_Muslim,4.62,1.30,13.94,23.11,39.72,10.79,2.44,0.19,0.07,0.01,0.62,2.22,0.95
Lemko_Poland,27.74,37.63,14.89,7.34,9.48,0.24,0.42,0.58,0.56,0.60,0.52,0.00,0.00
Lezgin,11.19,15.66,1.70,47.07,15.17,1.06,4.19,0.77,1.51,1.04,0.40,0.13,0.11
Libyan,6.27,0.45,16.18,1.23,31.33,22.97,0.17,0.57,0.54,0.38,0.36,10.54,9.00
Lithuanian,28.87,53.90,7.17,3.91,1.48,0.76,1.34,0.06,0.82,0.77,0.41,0.29,0.22
Luhya,0.19,0.09,0.06,0.15,0.08,0.70,0.15,0.25,0.04,0.02,0.28,25.17,72.81
Lur,1.16,3.82,5.91,39.11,29.66,7.04,9.87,0.18,1.31,0.38,0.39,0.36,0.68
Maasai,0.23,0.09,0.62,0.14,2.81,11.37,0.02,0.05,0.05,0.05,0.45,53.34,30.78
Macedonian,23.12,20.72,20.37,10.94,20.81,2.30,0.26,0.38,0.34,0.42,0.31,0.03,0.03
Malay,0.17,2.99,0.07,0.15,0.05,0.02,16.44,73.60,0.08,0.57,5.15,0.34,0.36
Maltese,16.41,6.49,20.59,13.9,31.37,6.62,0.68,0.7,0.01,0,0.32,1.38,1.53
Mandaean,1.8,0.35,9.34,31.52,39.83,10.23,5.62,0.02,0.09,0.15,0.19,0.71,0.12
Mandinka,0.27,0.16,0.39,0.05,0.63,1.58,0.14,0.12,0.17,0.08,0.21,7.23,88.98
Mansi,8.34,30.51,0.00,4.75,0.00,0.00,4.24,1.92,43.90,5.26,0.81,0.14,0.13
Mari,13.18,42.21,1.21,6.31,0.63,0.45,4.35,0.87,26.26,3.33,0.38,0.15,0.67
Maya,1.71,0.40,5.07,0.10,0.18,0.17,0.09,1.09,2.53,86.31,0.26,0.32,1.78
Mbuti,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.01,0.00,0.01,0.14,33.21,66.64
Melanesian_Papuan,0.06,0.32,0.04,0.06,0.11,0.25,6.53,22.18,0.73,0.20,68.72,0.35,0.45
Miao,0.26,0.08,0.05,0.21,0.05,0.07,0.76,82.49,14.62,0.38,0.80,0.19,0.04
Moldovan,23.31,31.19,15.42,9.57,14.52,1.81,0.97,0.63,1.41,0.46,0.42,0.12,0.18
Mongolian,2.93,4.38,1.13,7.15,1.42,0.54,1.22,30.75,48.10,1.67,0.58,0.05,0.08
Monguor,0.74,0.56,0.67,2.57,0.61,0.33,1.92,61.90,29.03,0.81,0.53,0.08,0.26
Montenegrin,24.13,26.54,18.30,9.74,17.15,2.10,0.23,0.26,0.68,0.40,0.32,0.07,0.06
Mordvin,22.53,47.66,6.87,7.66,3.52,0.71,1.62,1.04,6.12,1.30,0.53,0.24,0.20
Moroccan,9.39,0.16,25.34,0.01,25.50,17.75,0.00,0.69,0.03,0.04,0.18,12.01,8.89
Mozabite,10.30,0.16,24.17,0.02,26.45,15.66,0.01,0.45,0.09,0.01,0.08,10.48,12.13
Nakhi,0.13,0.15,0.07,0.09,0.03,0.06,3.30,69.43,25.37,0.10,0.87,0.13,0.27
Nanai,0.13,0.01,0.16,0.59,0.10,0.33,0.36,55.22,41.24,1.43,0.38,0.02,0.03
Nogai,9.25,13.23,6.43,31.31,10.06,0.46,2.77,9.16,15.03,1.24,0.51,0.34,0.21
Norwegian,51.14,28.61,9.91,5.60,1.73,0.43,0.42,0.36,0.64,0.91,0.15,0.01,0.10
Orcadian,51.33,24.44,12.68,4.97,2.50,0.31,1.00,0.23,1.05,0.81,0.39,0.08,0.20
Oromo_Ethiopia,0.04,0.00,1.16,0.05,14.96,21.12,0.02,0.73,0.00,0.05,0.10,54.95,6.82
Oroqen,0.01,0.75,0.14,0.03,0.03,0.00,0.27,27.38,70.00,1.28,0.10,0.01,0.00
Ossetian_North,6.39,11.93,7.27,48.78,14.62,1.38,1.74,2.27,4.59,0.62,0.30,0.06,0.05
Ossetian,7.84,7.30,9.08,48.98,14.05,1.99,2.74,2.92,4.19,0.56,0.21,0.13,0.01
Palestinian,3.85,0.23,10.74,16.62,43.55,16.13,1.56,0.42,0.14,0.45,0.03,4.89,1.37
Pamiri_Tajikistan,13.48,15.13,0,37.53,3.65,0.14,19.84,1.37,4.92,3.14,0.23,0.06,0.53
Papuan,0.03,0.02,0.02,0.02,0.02,0.07,2.35,1.77,0.49,0.22,94.59,0.20,0.20
Parsi_India,1.23,2.54,5.08,34.92,22.35,5.58,26.09,0.25,0.23,0.35,0.13,0.67,0.35
Pashtun_Afghanistan,8.26,10.18,0.26,40.21,7.01,0.97,25.38,1.49,3.82,1.30,0.47,0.07,0.59
Pashtun_Pakistan,3.25,10.13,0.23,37.28,4.70,0.50,39.03,0.27,2.24,1.74,0.17,0.09,0.39
Paswan,0.22,0.80,1.23,17.44,0.98,0.98,71.66,3.04,0.45,0.67,1.65,0.25,0.63
Pennsylvania_Dutch,42.26,21.26,17.6,5.58,9.87,1.37,0.81,0.09,0.83,0.57,0.88,0.22,0.13
Persian_Eastcentral,3.29,4.79,3.67,39.54,25.33,5.16,15.06,0.17,1.02,0.62,0.51,0.37,1.89
Persian_Hormozgan,1.22,5.00,1.58,39.40,17.21,4.19,19.92,0.00,0.19,1.09,0.71,2.73,6.66
Pima,0.69,1.32,0.94,0.24,0.25,0.14,0.73,0.99,5.18,89.14,0.23,0.02,0.14
Piramalai_Kallar,0.17,0.10,0.06,17.16,1.06,0.76,75.15,1.66,0.50,0.71,1.82,0.66,0.20
Polish,30.43,45.49,10.42,5.43,3.74,1.24,0.96,0.11,0.29,0.84,0.26,0.51,0.28
Pomak,19.31,25.61,16.73,12.57,20.79,2.59,0.22,0.52,0.87,0.33,0.38,0.10,0.03
Portuguese,38.54,11.51,25.32,2.43,13.90,3.63,0.42,0.14,0.25,0.44,0.67,1.72,1.04
Roma,10.30,10.26,12.79,16.48,18.84,2.76,24.72,1.36,0.82,0.24,0.91,0.42,0.12
Romanian,23.71,26.24,17.13,10.25,17.33,1.90,0.64,0.60,1.07,0.54,0.38,0.11,0.10
Russian,26.03,47.50,8.65,5.49,2.99,0.68,1.32,0.45,4.75,1.23,0.46,0.15,0.31
Samaritan,1.69,0.36,16.45,18.39,45.52,13.82,0.98,0.08,0.10,0.00,0.26,2.35,0.00
Sámi,24.03,45.83,0.01,1.43,0.00,0.75,0.63,1.04,22.64,2.93,0.54,0.03,0.18
San,0.09,0.03,0.02,0.63,0.11,0.19,0.07,0.01,0.02,0.03,0.68,39.70,58.43
Sandawe,0.15,0.06,0.73,0.04,7.61,5.09,0.15,0.28,0.10,0.02,0.49,48.50,36.79
Sardinian,23.14,1.64,49.58,0.38,22.02,2.41,0,0.13,0.03,0,0.31,0.26,0.1
Saudi,0.17,0.18,5.91,10.01,42.83,34.20,1.72,0.34,0.09,0.11,0.19,4.08,0.17
Scottish,51.37,23.36,12.70,6.44,2.73,0.57,1.18,0.16,0.32,0.63,0.27,0.14,0.05
Selkup,1.71,25.06,0.00,3.81,0.00,0.00,2.68,0.95,59.32,6.05,0.40,0.00,0.02
Serb,24.72,29.47,17.13,9.20,15.42,1.55,0.55,0.27,0.72,0.53,0.30,0.08,0.05
She,0.14,0.16,0.08,0.15,0.05,0.23,0.30,84.56,14.06,0.08,0.03,0.07,0.10
Shors,6.43,17.04,0.01,10.03,0.03,0.02,4.38,13.37,42.52,5.70,0.17,0.04,0.25
Sibe,0.62,0.29,0.30,1.72,0.85,0.14,0.12,55.61,39.46,0.35,0.26,0.25,0.04
Sindhi,3.30,3.82,0.06,39.57,3.85,0.51,45.20,0.17,0.58,1.41,0.43,0.48,0.62
Slovak,30.84,37.18,12.99,6.3,8,1.09,1.03,0.39,0.58,0.73,0.53,0.15,0.21
Slovenian,31.53,34.36,14.60,6.52,9.66,1.01,0.64,0.32,0.30,0.43,0.39,0.12,0.12
Somali,0.01,0.00,1.40,0.00,11.03,24.66,0.00,0.08,0.13,0.07,0.04,56.35,6.23
Sorb,33.21,41.31,10.56,4.96,6.56,0.56,1.15,0.46,0.26,0.59,0.16,0.10,0.12
Spanish,40.54,10.23,27.54,2.40,12.98,2.76,0.59,0.34,0.25,0.33,0.28,1.07,0.70
Sudanese,0.00,0.00,0.00,0.00,0.00,0.00,0.01,0.00,0.00,0.00,0.00,57.81,42.16
Swedish,48.45,30.99,9.81,3.64,2.43,0.84,1.41,0.21,0.68,0.56,0.40,0.32,0.23
Syrian,3.40,0.83,13.31,21.61,37.83,13.75,3.44,0.23,0.19,0.24,0.48,2.93,1.77
Tabasaran,13.72,15.78,1.26,46.45,12.21,0.80,5.67,0.29,1.31,1.95,0.21,0.03,0.32
Tajik,8.90,11.15,1.31,35.49,8.87,0.90,16.43,5.33,8.86,1.89,0.25,0.29,0.34
Talysh,2.55,5.71,5.33,40.11,29.8,4.18,8.07,1.31,1.62,0.55,0.24,0.46,0
Tatar_Crimea,13.17,20.04,7.55,16.36,8.88,1.83,3.23,10.25,16.40,1.28,0.47,0.27,0.21
Tatar_Volga,18.88,34.62,5.85,11.66,3.85,0.90,2.68,3.12,15.56,2.00,0.28,0.13,0.46
Tigrayan,0.09,0.01,2.17,0.02,22.70,26.62,0.00,0.00,0.01,0.00,0.26,45.95,2.16
Torbesh,21.55,17.67,22.34,10.48,23.69,2.25,0.00,0.51,0.48,0.79,0.25,0.00,0.00
Tujia,0.08,0.06,0.20,0.07,0.09,0.03,0.23,81.06,17.07,0.15,0.54,0.22,0.21
Tunisian,9.41,1.02,22.23,0.71,30.54,14.99,0.01,0.26,0.35,0.00,0.39,9.20,10.88
Turkish,6.02,5.27,11.79,32.45,28.56,4.17,3.28,2.55,4.58,0.43,0.44,0.26,0.14
Turkmen,7.21,5.91,2.52,32.73,19.76,1.31,11.21,6.87,10.08,1.88,0.32,0.08,0.11
Tuvan,2.35,7.30,0.57,4.02,0.24,0.55,1.60,23.23,56.57,2.50,0.71,0.05,0.29
Udmurt,18.51,36.69,0.51,12.56,0.01,0.17,4.09,0.51,23.10,2.89,0.57,0.12,0.29
Ukrainian,26.53,45.54,10.39,5.93,6.34,0.90,0.97,0.43,1.33,0.70,0.47,0.19,0.27
Upper_Silesia,33.01,43.21,9.27,6.4,5.21,0.26,0.67,0,1.04,0.31,0.58,0,0.06
Uttar_Pradesh_Hindu,2.94,3.28,1.36,15.83,0.42,0.72,69.02,2.79,1.41,0.69,0.98,0.31,0.26
Uyghur,7.18,9.70,0.87,18.93,4.66,0.18,10.42,24.33,20.48,2.35,0.42,0.26,0.21
Uzbek,8.55,11.84,2.11,23.96,8.12,0.77,9.98,13.84,18.76,1.66,0.15,0.09,0.17
Velama,0.15,0.19,0.13,21.78,2.62,0.26,70.10,1.58,0.89,0.31,1.27,0.38,0.35
Vietnamese,0.05,1.24,0.02,0.14,0.05,0.24,5.11,86.45,5.20,0.16,1.06,0.16,0.12
Welayta,0.60,0.01,0.43,0.08,13.09,19.47,0.07,0.49,0.30,0.19,0.16,59.32,5.79
Welsh,50.73,23.16,13.73,6.18,2.84,0.53,0.97,0.13,0.32,0.58,0.4,0.25,0.12
Yaghnobi_Tajikistan,11.33,16.37,1.51,39.59,10.16,0.93,12.83,0.64,4.02,1.89,0.05,0.44,0.23
Yakut,0.56,3.45,1.61,1.67,0.21,0.56,1.13,15.25,74.19,0.52,0.67,0.17,0.01
Yi,0.04,0.03,0.04,0.08,0.01,0.10,3.29,70.41,23.74,0.48,1.45,0.13,0.20
Yoruban,0.05,0.05,0.11,0.20,0.13,0.91,0.07,0.11,0.08,0.08,0.10,2.91,95.20
Zaza,3.92,4.49,8.58,38.61,29.32,5.55,7.3,0.27,0.73,0.63,0.13,0.29,0.1

I think it should be added to Vahaduo as "k13 updated - basic/simple version", it still needs a lot of editing, however.
the final version should include some subgroups like Pontic Greeks and Eastern Germans.

the current one should be renamed "k13 updated - advanced version" and here all microregions should be included, without any merging.

I think everybody kinda got it wrong what I argued: the only thing I argued is for a select few neighboring regions with a distance under 1.5 to each other to possibly be connected, since they are so samey, while all other regions should remain in the main sheet, since they have larger distance than that, like 1.5-2+, which already shows a certain amount of difference and can be valuable for the overall picture. I wouldn't want to delete regions at all from the main sheet, because they are very valuable.

At one point earlier I used to have separate averages for Transdanubia and Budapest, Transylvania and Székely, but then I realized that how useful it really is to have so similar to one another averages when I could easily group them together and thus making the results less cluttered and offering a bigger picture. When you get Transdanubia+Budapest, it means you mostly have a Western shifted Hungarian likeness, why should you get both results when they are so similar, hence one average is sufficient to describe this type of Hungarian.

**vbnetkhio** · 01-10-2022, 03:21 PM

Originally Posted by Dunai

I think everybody kinda got it wrong what I argued: the only thing I argued is for a select few neighboring regions with a distance under 1.5 to each other to possibly be connected, since they are so samey, while all other regions should remain in the main sheet, since they have larger distance than that, like 1.5-2+, which already shows a certain amount of difference and can be valuable for the overall picture. I wouldn't want to delete regions at all from the main sheet, because they are very valuable.

regardless, I still think something like this simplified sheet is much more useful for modeling.
Maybe leave the current sheet as it is, and add this one in the second place, as "k13 updated - basic version"?

**~~Dunai~~** · 01-10-2022, 04:05 PM

Originally Posted by vbnetkhio

regardless, I still think something like this simplified sheet is much more useful for modeling.
Maybe leave the current sheet as it is, and add this one in the second place, as "k13 updated - basic version"?

Yeah, a basic version can also have its place, even though for such genetically diverse countries like Russia, Spain, Romania, Poland, Greece, Germany, France, Italy, Ukraine, just to name the bigger ones, which have distances of 2-3 even among neighboring regions, it's good to also have the many regional averages.

**~~Ion Basescul~~** · 01-10-2022, 04:21 PM

Originally Posted by vbnetkhio

here's a hastily edited sheet with only one average per ethnicity:

Code:

Aari,0.43,0.14,0.32,1.97,2.23,9.70,1.41,0.23,0.53,0.20,0.37,74.12,8.35
Abhkaz,1.64,4.62,9.81,54.30,22.78,1.84,1.91,1.48,1.11,0.17,0.33,0.01,0.01
Aboriginal_Australian,0,0,0,0,0,0,14.73,11.06,4.79,0.2,65.9,3.33,0
Afrikaner,44.12,22.79,14.04,4.98,6.17,0.86,2.28,0.89,0.39,0.52,0.57,0.46,1.89
Alawite,5.95,1.56,13.93,24.33,39.43,9.69,1.82,0.42,0.76,0.21,0.35,1.28,0.23
Albanian,21.69,17.54,21.72,11.13,23.86,2.59,0.16,0.28,0.28,0.28,0.22,0.16,0.09
Algerian,13.95,0.61,24.25,0.00,27.47,14.21,0.00,0.31,0.12,0.10,0.39,8.89,9.66
Altai,4.25,9.58,0.55,8.32,0.14,0.23,2.94,21.39,48.62,3.21,0.51,0.01,0.25
Amerindian_North,0.00,1.64,0.00,0.01,0.00,0.01,1.03,1.61,21.97,73.72,0.02,0.00,0.00
Amhara,0.07,0.01,0.77,0.04,21.14,26.79,0.03,0.14,0.02,0.17,0.21,47.07,3.55
Anuak_Ethiopia,0.00,0.00,0.00,0.00,0.00,0.00,0.03,0.03,0.02,0.02,0.02,61.65,38.24
Armenian,3.13,2.22,12.06,37.82,35.29,5.75,2.77,0.24,0.10,0.13,0.35,0.17,0.16
Aromanian,21.26,20.34,19.00,11.77,22.61,3.09,0.18,0.47,0.47,0.41,0.38,0.04,0.00
Arunthathiyar,0.07,0.02,0.98,12.79,0.43,1.37,76.82,3.51,0.21,0.05,2.40,0.79,0.56
Assyrian,1.74,1.07,11.94,32.56,39.58,8.59,3.29,0.25,0.13,0.16,0.30,0.24,0.12
Austrian,37.21,29.87,14.58,7.23,8.23,1.56,0.78,0.07,0.16,0.12,0.11,0.07,0.00
Avar,14.40,16.11,1.05,49.59,8.76,0.69,5.74,0.06,1.74,1.37,0.27,0.02,0.19
Azerbaijani,5.54,4.68,6.92,34.81,28.48,5.51,7.13,2.28,2.92,0.54,0.54,0.35,0.29
Baka,0.00,0.01,0.00,0.00,0.00,0.00,0.01,0.02,0.05,0.01,0.35,21.06,78.49
Balkar,6.59,10.90,9.30,45.36,14.67,0.77,1.99,3.35,5.53,0.83,0.50,0.06,0.17
Baloch,2.96,3.55,0.24,53.45,5.02,3.15,29.58,0.00,0.17,0.63,0.04,0.32,0.90
Bamar,0.32,0.81,1.02,0.70,0.54,0.31,18.39,60.71,13.69,0.79,1.64,0.24,0.84
Bantu,0.06,0.08,0.05,0.12,0.24,0.37,0.11,0.23,0.16,0.20,0.20,17.75,80.43
Bashkir,13.65,24.98,2.13,13.63,1.26,0.28,3.45,8.71,27.40,3.25,0.41,0.58,0.27
Basque_France,52.62,6.10,35.86,0.35,3.07,0.31,0.32,0.65,0.06,0.08,0.30,0.22,0.04
Bedouin,1.25,1.19,11.06,14.43,38.15,21.40,1.85,0.25,0.69,0.27,0.21,6.33,2.91
Belarusian,29.37,49.40,7.59,3.87,4.98,1.44,0.97,0.18,1.32,0.18,0.38,0.20,0.13
Belgian,45.20,22.22,15.56,5.69,7.34,1.11,0.97,0.27,0.10,0.54,0.43,0.35,0.15
Bengali_Bangladesh,2.38,4.43,0.93,18.87,0.54,0.25,58.19,8.99,2.54,0.76,1.71,0.02,0.40
Beta_Israel,0,0,0.30,0,17.83,29.31,0,0,0.03,0.02,0.20,51.57,0.72
Bosniak,25.73,35.04,14.18,8.58,12.19,1.26,0.98,0.31,0.62,0.60,0.25,0.16,0.10
Brahmin_Uttar_Pradesh,7.52,8.07,0.41,23.86,0.12,0.07,55.38,0.65,0.74,1.88,0.85,0.23,0.23
Brahui,1.52,2.28,0.06,53.84,5.71,3.18,29.92,0.06,0.51,0.64,0.28,0.80,1.20
Bulgarian,21.80,24.15,17.82,11.65,19.51,2.40,0.53,0.42,0.77,0.38,0.33,0.11,0.08
Burusho,2.50,8.83,0.01,37.09,0.22,0.04,36.76,5.04,6.21,2.26,0.33,0.24,0.47
Buryat,0.47,3.04,1.11,5.10,1.22,0.73,0.74,26.85,58.82,1.44,0.26,0.21,0.01
Chamar,0.45,1.72,1.27,11.50,0.59,0.71,77.02,1.75,1.69,1.23,1.44,0.51,0.11
Chechen,10.14,15.25,4.48,46.45,13.11,1.36,3.47,1.34,1.73,1.32,1.05,0.18,0.12
Chenchu,0.75,0.34,1.51,12.87,1.46,0.37,71.14,6.32,1.84,0.81,1.92,0.32,0.35
Chukchi,0.02,3.65,0.00,0.05,0.00,0.00,1.28,8.84,60.79,24.71,0.65,0.00,0.00
Chuvash,14.88,43.07,2.02,8.74,1.29,0.85,2.28,2.66,20.08,2.77,0.44,0.55,0.36
Circassian,6.38,12.14,7.88,47.22,16.97,1.95,2.79,1.08,2.58,0.80,0.13,0.05,0.03
Croat,28.10,33.15,15.02,7.76,12.05,1.40,0.49,0.28,0.59,0.54,0.38,0.12,0.10
Csángó-Ceangău,27.60,29.46,15.34,8.91,11.04,1.51,0.87,1.07,2.64,0.81,0.47,0.15,0.15
Czech,33.53,37.14,12.43,5.94,7,0.9,1.18,0.14,0.66,0.59,0.26,0.19,0.13
Dai,0.03,1.07,0.03,0.16,0.01,0.01,4.19,90.46,1.69,0.55,1.41,0.10,0.28
Danish,50.61,28.70,10.19,5.00,2.12,0.52,0.99,0.19,0.42,0.59,0.23,0.12,0.17
Dargin,14.95,17.38,0.62,50.93,7.03,0.27,4.53,0.11,1.40,2.41,0.14,0.04,0.28
Dharkar,1.85,4.01,1.94,19.67,0.57,0.03,65.77,1.74,1.80,0.84,0.82,0.72,0.23
Dolgan,1.57,7.84,0.63,0.78,0.14,0.06,1.92,9.23,75.33,1.38,0.43,0.59,0.11
Dutch,49.05,25.20,12.14,4.99,4.00,1.13,0.94,0.39,0.51,0.60,0.42,0.26,0.29
Egyptian,3.00,0.09,11.72,7.86,39.56,18.84,0.09,0.14,0.30,0.10,0.23,11.83,6.24
English,49.68,23.44,13.70,5.62,3.96,0.71,1.03,0.15,0.29,0.57,0.39,0.21,0.17
Estonian,32.93,50.58,6.76,2.45,0.57,0.09,0.95,0.05,3.51,1.35,0.61,0.04,0.09
Even,0.14,3.03,0.90,0.48,0.37,0.38,0.37,10.18,80.93,2.43,0.61,0.18,0.01
Evenk,0.26,4.32,0.37,0.52,0.20,0.12,0.44,11.82,79.19,1.34,1.21,0.11,0.11
Finnish,34.17,47.69,4.43,2.21,0.65,0.42,0.53,0.96,6.48,0.90,0.81,0.50,0.26
Flemish,45.58,22.81,15.33,5.88,6.79,0.60,0.97,0.37,0.12,0.57,0.38,0.35,0.17
French,42.27,17.40,21.23,4.91,10.09,1.57,0.59,0.27,0.35,0.55,0.31,0.25,0.20
Gagauz,19.35,22.92,18.13,13.07,21.02,2.46,0.65,0.37,0.91,0.33,0.51,0.21,0.07
Georgian,3.72,5.52,10.13,52.14,21.85,3.22,1.80,0.65,0.37,0.42,0.12,0.03,0.03
German,43.00,27.31,13.88,5.81,6.40,0.94,0.94,0.15,0.34,0.46,0.36,0.15,0.13
Greek,15.76,11.62,19.89,17.55,29.18,3.91,0.40,0.37,0.40,0.26,0.33,0.22,0.07
Greenlandic_Inuit,0.96,7.75,0.01,0.46,0.01,0.01,2.40,6.87,41.49,39.74,0.18,0.08,0.06
Gujarati,4.22,6.43,0.04,27.49,0.40,0.18,58.04,0.65,1.25,0.37,0.49,0.11,0.33
Gumuz_Ethiopia,0.00,0.00,0.00,0.01,0.00,0.01,0.78,0.51,0.30,0.10,0.41,72.20,25.69
Hadza,0.41,0.32,0.01,0.97,0.14,1.32,2.66,0.05,0.25,0.12,0.55,61.84,31.36
Hazara_Afghanistan,7.36,7.11,0.59,23.61,5.37,0.96,13.56,17.57,20.94,2.12,0.35,0.12,0.31
Hazara,3.20,8.47,1.46,21.92,3.70,0.76,12.59,20.87,24.42,1.87,0.40,0.21,0.13
Ho,0.00,0.00,0.01,0.00,0.00,0.00,69.42,24.77,0.18,0.08,4.28,0.68,0.58
Hungarian,30.43,32.58,14.23,7.16,10.42,1.28,0.9,0.55,1.19,0.55,0.35,0.2,0.15
Icelandic,51.20,26.73,10.31,6.30,1.57,0.78,0.83,0.20,0.77,0.84,0.12,0.24,0.06
Ingush,8.91,11.47,6.17,48.35,15.47,1.35,2.13,1.56,2.88,1.09,0.59,0,0.13
Iranian,2.07,4.23,4.23,38.20,29.70,7.48,10.56,0.04,1.34,0.28,0.24,0.17,1.47
Iraqi,2.66,2.3,8.46,28.81,33.63,11.82,6.83,0.61,0.88,0.37,0.27,2.54,0.81
Irish,52.43,22.93,12.62,6.82,1.44,0.50,1.40,0.16,0.28,0.80,0.29,0.14,0.13
Italian,26.37,11.03,22.88,10.51,24.03,3.65,0.27,0.23,0.10,0.23,0.30,0.26,0.15
Japanese,0.01,0.00,0.01,0.00,0.02,0.01,0.22,65.93,31.72,0.83,0.62,0.32,0.30
Jat_Punjab,7.52,10.46,0.07,35.03,0.74,0.59,43.04,0.07,0.41,1.30,0.33,0.07,0.38
Jewish,9.30,2.70,15.95,17.34,39.29,10.09,1.53,0.42,0.28,0.20,0.41,2.07,0.42
Jordanian,2.45,0.69,10.94,18.25,40.75,14.70,1.48,0.40,0.16,0.61,0.50,6.96,2.12
Kabardian,7.04,13.45,8.22,44.99,13.16,1.89,2.40,2.32,5.14,0.72,0.23,0.24,0.19
Kalash,5.72,11.37,0.00,43.42,0.69,0.00,34.83,0.03,1.28,1.85,0.22,0.09,0.49
Kanjar,2.02,5.26,0.51,19.37,0.25,0.05,67.26,1.77,0.77,0.83,1.14,0.47,0.29
Kannada_North,0.28,4.26,0.35,15.05,0.64,0.05,72.33,2.12,1.82,0.61,1.48,0.40,0.61
Karakalpak,7.81,12.16,2.15,13.31,3.51,1.45,4.49,20.04,32.27,1.72,0.65,0.08,0.28
Karitiana,0.00,0.01,0.00,0.00,0.00,0.00,0.01,0.32,0.02,99.62,0.00,0.01,0.01
Kazakh,7.42,11.87,1.47,12.28,0.99,0.86,3.34,22.47,36.11,2.22,0.91,0.05,0.03
Ket,2.00,22.06,0.00,2.96,0.00,0.00,3.98,3.40,57.55,7.77,0.28,0.00,0.00
Khakas,3.88,16.30,0.23,9.81,0.02,0.06,3.33,17.07,44.91,3.88,0.15,0.14,0.21
Khanty,5.65,31.35,0.00,3.55,0.00,0.00,4.34,0.83,47.59,6.01,0.56,0.00,0.10
Khmer_Cambodia,0.08,1.82,0.49,0.33,0.16,0.40,14.67,76.89,0.84,0.30,3.19,0.49,0.33
Kirgiz,5.81,7.94,1.15,12.69,2.05,0.34,4.21,24.46,37.76,2.56,0.91,0.04,0.08
Kol,2.16,2.90,1.81,16.00,0.57,0.03,71.04,2.16,0.85,1.10,0.70,0.44,0.25
Komi,22.39,43.60,3.11,8.46,0.17,0.31,2.39,0.57,15.43,2.56,0.25,0.21,0.54
Koryak,0.02,3.90,0.00,0.24,0.00,0.00,0.93,10.91,66.39,17.42,0.16,0.00,0.02
Kshatriya,4.22,6.62,0.27,24.46,0.76,0.10,58.75,0.71,1.19,1.40,0.81,0.43,0.28
Kumyk,7.40,12.43,6.78,41.62,18.24,2.19,3.84,2.21,3.07,1.39,0.46,0.15,0.21
Kurd,3.67,3.55,6.20,40.33,29.77,5.69,8.07,0.36,1.01,0.49,0.28,0.52,0.07
Kurumba,0.92,0.05,0.42,20.26,0.77,0.60,70.73,1.53,1.69,0.28,1.63,0.71,0.40
Lahu,0.27,0.48,0.26,0.05,0.16,0.16,4.49,81.47,9.62,0.88,1.46,0.51,0.17
Lak,13.14,17.90,0.88,50.54,7.79,0.64,4.30,0.20,2.24,1.83,0.30,0.19,0.23
Latvian,26.74,58.36,6.41,2.73,0.78,1.1,0.77,0.09,1.43,0.73,0.32,0.33,0.22
Laz,1.47,1.72,14.18,45.4,32.17,3.04,0.88,0.51,0,0.11,0.38,0,0.09
Lebanese_Christian,1.47,0.19,15.36,20.76,47.26,12.40,0.77,0.59,0.19,0.01,0.17,0.83,0.01
Lebanese_Druze,5.04,1.19,10.62,21.22,48.65,9.37,1.61,0.45,0.53,0.01,0.42,0.58,0.30
Lebanese_Muslim,4.62,1.30,13.94,23.11,39.72,10.79,2.44,0.19,0.07,0.01,0.62,2.22,0.95
Lemko_Poland,27.74,37.63,14.89,7.34,9.48,0.24,0.42,0.58,0.56,0.60,0.52,0.00,0.00
Lezgin,11.19,15.66,1.70,47.07,15.17,1.06,4.19,0.77,1.51,1.04,0.40,0.13,0.11
Libyan,6.27,0.45,16.18,1.23,31.33,22.97,0.17,0.57,0.54,0.38,0.36,10.54,9.00
Lithuanian,28.87,53.90,7.17,3.91,1.48,0.76,1.34,0.06,0.82,0.77,0.41,0.29,0.22
Luhya,0.19,0.09,0.06,0.15,0.08,0.70,0.15,0.25,0.04,0.02,0.28,25.17,72.81
Lur,1.16,3.82,5.91,39.11,29.66,7.04,9.87,0.18,1.31,0.38,0.39,0.36,0.68
Maasai,0.23,0.09,0.62,0.14,2.81,11.37,0.02,0.05,0.05,0.05,0.45,53.34,30.78
Macedonian,23.12,20.72,20.37,10.94,20.81,2.30,0.26,0.38,0.34,0.42,0.31,0.03,0.03
Malay,0.17,2.99,0.07,0.15,0.05,0.02,16.44,73.60,0.08,0.57,5.15,0.34,0.36
Maltese,16.41,6.49,20.59,13.9,31.37,6.62,0.68,0.7,0.01,0,0.32,1.38,1.53
Mandaean,1.8,0.35,9.34,31.52,39.83,10.23,5.62,0.02,0.09,0.15,0.19,0.71,0.12
Mandinka,0.27,0.16,0.39,0.05,0.63,1.58,0.14,0.12,0.17,0.08,0.21,7.23,88.98
Mansi,8.34,30.51,0.00,4.75,0.00,0.00,4.24,1.92,43.90,5.26,0.81,0.14,0.13
Mari,13.18,42.21,1.21,6.31,0.63,0.45,4.35,0.87,26.26,3.33,0.38,0.15,0.67
Maya,1.71,0.40,5.07,0.10,0.18,0.17,0.09,1.09,2.53,86.31,0.26,0.32,1.78
Mbuti,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.01,0.00,0.01,0.14,33.21,66.64
Melanesian_Papuan,0.06,0.32,0.04,0.06,0.11,0.25,6.53,22.18,0.73,0.20,68.72,0.35,0.45
Miao,0.26,0.08,0.05,0.21,0.05,0.07,0.76,82.49,14.62,0.38,0.80,0.19,0.04
Moldovan,23.31,31.19,15.42,9.57,14.52,1.81,0.97,0.63,1.41,0.46,0.42,0.12,0.18
Mongolian,2.93,4.38,1.13,7.15,1.42,0.54,1.22,30.75,48.10,1.67,0.58,0.05,0.08
Monguor,0.74,0.56,0.67,2.57,0.61,0.33,1.92,61.90,29.03,0.81,0.53,0.08,0.26
Montenegrin,24.13,26.54,18.30,9.74,17.15,2.10,0.23,0.26,0.68,0.40,0.32,0.07,0.06
Mordvin,22.53,47.66,6.87,7.66,3.52,0.71,1.62,1.04,6.12,1.30,0.53,0.24,0.20
Moroccan,9.39,0.16,25.34,0.01,25.50,17.75,0.00,0.69,0.03,0.04,0.18,12.01,8.89
Mozabite,10.30,0.16,24.17,0.02,26.45,15.66,0.01,0.45,0.09,0.01,0.08,10.48,12.13
Nakhi,0.13,0.15,0.07,0.09,0.03,0.06,3.30,69.43,25.37,0.10,0.87,0.13,0.27
Nanai,0.13,0.01,0.16,0.59,0.10,0.33,0.36,55.22,41.24,1.43,0.38,0.02,0.03
Nogai,9.25,13.23,6.43,31.31,10.06,0.46,2.77,9.16,15.03,1.24,0.51,0.34,0.21
Norwegian,51.14,28.61,9.91,5.60,1.73,0.43,0.42,0.36,0.64,0.91,0.15,0.01,0.10
Orcadian,51.33,24.44,12.68,4.97,2.50,0.31,1.00,0.23,1.05,0.81,0.39,0.08,0.20
Oromo_Ethiopia,0.04,0.00,1.16,0.05,14.96,21.12,0.02,0.73,0.00,0.05,0.10,54.95,6.82
Oroqen,0.01,0.75,0.14,0.03,0.03,0.00,0.27,27.38,70.00,1.28,0.10,0.01,0.00
Ossetian_North,6.39,11.93,7.27,48.78,14.62,1.38,1.74,2.27,4.59,0.62,0.30,0.06,0.05
Ossetian,7.84,7.30,9.08,48.98,14.05,1.99,2.74,2.92,4.19,0.56,0.21,0.13,0.01
Palestinian,3.85,0.23,10.74,16.62,43.55,16.13,1.56,0.42,0.14,0.45,0.03,4.89,1.37
Pamiri_Tajikistan,13.48,15.13,0,37.53,3.65,0.14,19.84,1.37,4.92,3.14,0.23,0.06,0.53
Papuan,0.03,0.02,0.02,0.02,0.02,0.07,2.35,1.77,0.49,0.22,94.59,0.20,0.20
Parsi_India,1.23,2.54,5.08,34.92,22.35,5.58,26.09,0.25,0.23,0.35,0.13,0.67,0.35
Pashtun_Afghanistan,8.26,10.18,0.26,40.21,7.01,0.97,25.38,1.49,3.82,1.30,0.47,0.07,0.59
Pashtun_Pakistan,3.25,10.13,0.23,37.28,4.70,0.50,39.03,0.27,2.24,1.74,0.17,0.09,0.39
Paswan,0.22,0.80,1.23,17.44,0.98,0.98,71.66,3.04,0.45,0.67,1.65,0.25,0.63
Pennsylvania_Dutch,42.26,21.26,17.6,5.58,9.87,1.37,0.81,0.09,0.83,0.57,0.88,0.22,0.13
Persian_Eastcentral,3.29,4.79,3.67,39.54,25.33,5.16,15.06,0.17,1.02,0.62,0.51,0.37,1.89
Persian_Hormozgan,1.22,5.00,1.58,39.40,17.21,4.19,19.92,0.00,0.19,1.09,0.71,2.73,6.66
Pima,0.69,1.32,0.94,0.24,0.25,0.14,0.73,0.99,5.18,89.14,0.23,0.02,0.14
Piramalai_Kallar,0.17,0.10,0.06,17.16,1.06,0.76,75.15,1.66,0.50,0.71,1.82,0.66,0.20
Polish,30.43,45.49,10.42,5.43,3.74,1.24,0.96,0.11,0.29,0.84,0.26,0.51,0.28
Pomak,19.31,25.61,16.73,12.57,20.79,2.59,0.22,0.52,0.87,0.33,0.38,0.10,0.03
Portuguese,38.54,11.51,25.32,2.43,13.90,3.63,0.42,0.14,0.25,0.44,0.67,1.72,1.04
Roma,10.30,10.26,12.79,16.48,18.84,2.76,24.72,1.36,0.82,0.24,0.91,0.42,0.12
Romanian,23.71,26.24,17.13,10.25,17.33,1.90,0.64,0.60,1.07,0.54,0.38,0.11,0.10
Russian,26.03,47.50,8.65,5.49,2.99,0.68,1.32,0.45,4.75,1.23,0.46,0.15,0.31
Samaritan,1.69,0.36,16.45,18.39,45.52,13.82,0.98,0.08,0.10,0.00,0.26,2.35,0.00
Sámi,24.03,45.83,0.01,1.43,0.00,0.75,0.63,1.04,22.64,2.93,0.54,0.03,0.18
San,0.09,0.03,0.02,0.63,0.11,0.19,0.07,0.01,0.02,0.03,0.68,39.70,58.43
Sandawe,0.15,0.06,0.73,0.04,7.61,5.09,0.15,0.28,0.10,0.02,0.49,48.50,36.79
Sardinian,23.14,1.64,49.58,0.38,22.02,2.41,0,0.13,0.03,0,0.31,0.26,0.1
Saudi,0.17,0.18,5.91,10.01,42.83,34.20,1.72,0.34,0.09,0.11,0.19,4.08,0.17
Scottish,51.37,23.36,12.70,6.44,2.73,0.57,1.18,0.16,0.32,0.63,0.27,0.14,0.05
Selkup,1.71,25.06,0.00,3.81,0.00,0.00,2.68,0.95,59.32,6.05,0.40,0.00,0.02
Serb,24.72,29.47,17.13,9.20,15.42,1.55,0.55,0.27,0.72,0.53,0.30,0.08,0.05
She,0.14,0.16,0.08,0.15,0.05,0.23,0.30,84.56,14.06,0.08,0.03,0.07,0.10
Shors,6.43,17.04,0.01,10.03,0.03,0.02,4.38,13.37,42.52,5.70,0.17,0.04,0.25
Sibe,0.62,0.29,0.30,1.72,0.85,0.14,0.12,55.61,39.46,0.35,0.26,0.25,0.04
Sindhi,3.30,3.82,0.06,39.57,3.85,0.51,45.20,0.17,0.58,1.41,0.43,0.48,0.62
Slovak,30.84,37.18,12.99,6.3,8,1.09,1.03,0.39,0.58,0.73,0.53,0.15,0.21
Slovenian,31.53,34.36,14.60,6.52,9.66,1.01,0.64,0.32,0.30,0.43,0.39,0.12,0.12
Somali,0.01,0.00,1.40,0.00,11.03,24.66,0.00,0.08,0.13,0.07,0.04,56.35,6.23
Sorb,33.21,41.31,10.56,4.96,6.56,0.56,1.15,0.46,0.26,0.59,0.16,0.10,0.12
Spanish,40.54,10.23,27.54,2.40,12.98,2.76,0.59,0.34,0.25,0.33,0.28,1.07,0.70
Sudanese,0.00,0.00,0.00,0.00,0.00,0.00,0.01,0.00,0.00,0.00,0.00,57.81,42.16
Swedish,48.45,30.99,9.81,3.64,2.43,0.84,1.41,0.21,0.68,0.56,0.40,0.32,0.23
Syrian,3.40,0.83,13.31,21.61,37.83,13.75,3.44,0.23,0.19,0.24,0.48,2.93,1.77
Tabasaran,13.72,15.78,1.26,46.45,12.21,0.80,5.67,0.29,1.31,1.95,0.21,0.03,0.32
Tajik,8.90,11.15,1.31,35.49,8.87,0.90,16.43,5.33,8.86,1.89,0.25,0.29,0.34
Talysh,2.55,5.71,5.33,40.11,29.8,4.18,8.07,1.31,1.62,0.55,0.24,0.46,0
Tatar_Crimea,13.17,20.04,7.55,16.36,8.88,1.83,3.23,10.25,16.40,1.28,0.47,0.27,0.21
Tatar_Volga,18.88,34.62,5.85,11.66,3.85,0.90,2.68,3.12,15.56,2.00,0.28,0.13,0.46
Tigrayan,0.09,0.01,2.17,0.02,22.70,26.62,0.00,0.00,0.01,0.00,0.26,45.95,2.16
Torbesh,21.55,17.67,22.34,10.48,23.69,2.25,0.00,0.51,0.48,0.79,0.25,0.00,0.00
Tujia,0.08,0.06,0.20,0.07,0.09,0.03,0.23,81.06,17.07,0.15,0.54,0.22,0.21
Tunisian,9.41,1.02,22.23,0.71,30.54,14.99,0.01,0.26,0.35,0.00,0.39,9.20,10.88
Turkish,6.02,5.27,11.79,32.45,28.56,4.17,3.28,2.55,4.58,0.43,0.44,0.26,0.14
Turkmen,7.21,5.91,2.52,32.73,19.76,1.31,11.21,6.87,10.08,1.88,0.32,0.08,0.11
Tuvan,2.35,7.30,0.57,4.02,0.24,0.55,1.60,23.23,56.57,2.50,0.71,0.05,0.29
Udmurt,18.51,36.69,0.51,12.56,0.01,0.17,4.09,0.51,23.10,2.89,0.57,0.12,0.29
Ukrainian,26.53,45.54,10.39,5.93,6.34,0.90,0.97,0.43,1.33,0.70,0.47,0.19,0.27
Upper_Silesia,33.01,43.21,9.27,6.4,5.21,0.26,0.67,0,1.04,0.31,0.58,0,0.06
Uttar_Pradesh_Hindu,2.94,3.28,1.36,15.83,0.42,0.72,69.02,2.79,1.41,0.69,0.98,0.31,0.26
Uyghur,7.18,9.70,0.87,18.93,4.66,0.18,10.42,24.33,20.48,2.35,0.42,0.26,0.21
Uzbek,8.55,11.84,2.11,23.96,8.12,0.77,9.98,13.84,18.76,1.66,0.15,0.09,0.17
Velama,0.15,0.19,0.13,21.78,2.62,0.26,70.10,1.58,0.89,0.31,1.27,0.38,0.35
Vietnamese,0.05,1.24,0.02,0.14,0.05,0.24,5.11,86.45,5.20,0.16,1.06,0.16,0.12
Welayta,0.60,0.01,0.43,0.08,13.09,19.47,0.07,0.49,0.30,0.19,0.16,59.32,5.79
Welsh,50.73,23.16,13.73,6.18,2.84,0.53,0.97,0.13,0.32,0.58,0.4,0.25,0.12
Yaghnobi_Tajikistan,11.33,16.37,1.51,39.59,10.16,0.93,12.83,0.64,4.02,1.89,0.05,0.44,0.23
Yakut,0.56,3.45,1.61,1.67,0.21,0.56,1.13,15.25,74.19,0.52,0.67,0.17,0.01
Yi,0.04,0.03,0.04,0.08,0.01,0.10,3.29,70.41,23.74,0.48,1.45,0.13,0.20
Yoruban,0.05,0.05,0.11,0.20,0.13,0.91,0.07,0.11,0.08,0.08,0.10,2.91,95.20
Zaza,3.92,4.49,8.58,38.61,29.32,5.55,7.3,0.27,0.73,0.63,0.13,0.29,0.1

I think it should be added to Vahaduo as "k13 updated - basic/simple version", it still needs a lot of editing, however.
the final version should include some subgroups like Pontic Greeks and Eastern Germans.

the current one should be renamed "k13 updated - advanced version" and here all microregions should be included, without any merging.

It's too rudimentary. There are some homogeneous nations out there, and others that are simply not. In Moldova and Romania one could range from Bulgarian-like to Carpathian Ukrainian-like and everything in between like different types of South Slavs and Hungarians. Capturing all of that diversity with a single average is simply impossible.

**~~Dunai~~** · 01-10-2022, 08:14 PM

Originally Posted by Ion Basescul

It's too rudimentary. There are some homogeneous nations out there, and others that are simply not. In Moldova and Romania one could range from Bulgarian-like to Carpathian Ukrainian-like and everything in between like different types of South Slavs and Hungarians. Capturing all of that diversity with a single average is simply impossible.

I agree, that in such heterogenous nations we should keep all the regional averages (except those very-very close ones I previously wrote), but it's also quite cool if we have one national average too, both are good to have in the main sheet.

**Peterski** · 01-10-2022, 09:17 PM

Originally Posted by Ion Basescul

It's too rudimentary. There are some homogeneous nations out there, and others that are simply not. In Moldova and Romania one could range from Bulgarian-like to Carpathian Ukrainian-like and everything in between like different types of South Slavs and Hungarians. Capturing all of that diversity with a single average is simply impossible.

Truth be told, most nations range between all/most of their neighbours. Your example does not make Romania special in this aspect.

There are of course some exceptions - like Slovenia where no Slovene is Italian-like - but they are less numerous than the opposite.

Originally Posted by Ion Basescul

Capturing all of that diversity with a single average is simply impossible.

Are Hungarian-like Romanians equally numerous as Bulgarian-like Romanians? Maybe try to look at the numerical size of each group.

Then it might turn out that for example 4/5 of Romanians belong to "Central Romanian" group, and those others are just minorities.

**~~Ion Basescul~~** · 01-10-2022, 10:14 PM

Originally Posted by Tomenable

Truth be told, most nations range between all/most of their neighbours. Your example does not make Romania special in this aspect.

There are of course some exceptions - like Slovenia where no Slovene is Italian-like - but they are less numerous than the opposite.

Are Hungarian-like Romanians equally numerous as Bulgarian-like Romanians? Maybe try to look at the numerical size of each group.

Then it might turn out that for example 4/5 of Romanians belong to "Central Romanian" group, and those others are just minorities.

Among native Romanians, it's more typical of those in Northern latitudes (Maramures, Northern Crisana, Northern Transylvania, Bukovina, Northern Moldavia, ) and in the East (Republic fo Moldova). For example I'm one of those who plots closer to Csango and Transylvanian Hungarian+Szekely averages than to many regional averages of my ethnicity.

Distance to:	IonBasescul
2.93703933	Csángó-Ceangău
2.98968226	Romanian_North-Moldavia
3.19231891	Romanian_Maramureș
3.50794812	Hungarian_Transylvania+Székely
3.70978436	Moldovan_Central
3.85185670	Serb_Republika_Srpska
3.92462737	Moldovan
3.95326447	Serb_West
4.05120970	Croat_South
4.19824964	Serb_Croatia
4.34673441	Serb
4.85520339	Serb_Vojvodina
4.95957659	Serb_Central
5.02414172	Croat_West
5.20153823	Moldovan_North
5.31538334	Romanian_Crișana
5.56564462	Croat
5.62585105	Serb_Herzegovina
5.77230457	Serb_South
5.97866206	Romanian_South-Moldavia
6.10317131	Croat_East
6.31011886	Romanian_Transylvania
6.38485709	Hungarian_Alföld
6.40910290	Bosniak
6.64887960	Romanian

Further South in Transylvania there will be plenty too, but those are oftentimes obvious assimilated Hungarians.

In terms of who is more numerous, there are about 7 million people in Oltenia, Muntenia and Dobruja regions. That number doesn't include Bucharest which is a melting pot of people from all over the country, but mainly South. There live also many people from Republic of Moldova and former Romanian territories like Budjak and Northern Bukovina.
In Maramures, Northern Crisana, Northern Transylvania, Bukovina, Northern Moldavia, there are 6 million people. That leaves 4.5 million for rest of Transylvania and Banat. Bucharest counts for an additional 2.3 million.

And that is why the Romanian average lands somewhere in the region of Montenegrins/Southern Serbs, which can probably be modelled like 65% Bulgarian and 35% Transylvanians Hungarian.

**Jana** · 01-11-2022, 01:22 PM

New Czech average made of only full ethnic Czechs with gedcoms, and weighted for regional size (Bohemia>Moravia), people with partial eg. German or Jewish ancestry excluded.

Code:

Czech,32.33,37.42,11.45,5.60,8.50,1.59,1.15,0.44,0.51,0.91,0.00,0.05,0.06

**~~Aodhan~~** · 01-11-2022, 04:09 PM

I'm new to this, hope I'm doing everything right

Eurogenes K13 ANCIENT

Distance to :Aodhan
7.32120209 scy304_SG_Moldova_Scythian_SG
8.09207019 CL94_Italy_Langobard_1345_ybp
9.04945302 R109_Lazio_Rome_Italy_Late_Antiquity
9.11102080 col001_col001_
9.24721039 R474b_Civitavecchia_Etruscan._Iron_Age
9.36205106 E09538_Germany_Germany_Bell_Beaker_Augsburg_4288_y bp
9.45760012 CL23_longobard_north_italy
9.84957867 I3313_Croatia_Early_IA_2733_ybp
10.07869039 I4331_Croatia_MBA_3526_ybp
10.18078091 CL57_longobard_north_italy
10.36551977 I5759_Switzerland_Bell_Beaker_4178_ybp
10.39432056 I5524_Germany_Bell_Beaker_4250_ybp
10.61080110 STR535_Germany_Early_Medieval.SG_1491_ybp
10.62752558 I6581_Poland_Bell_Beaker_father.I6582_father.I6535 _4251_ybp
10.64149895 R1221_Lazio_Rome_Renaissance_Italy
10.68132014 I6582_Poland_Bell_Beaker_4151_ybp
10.70862269 I5520_Germany_Bell_Beaker_4250_ybp
10.74522685 R110_Lazio_Rome_Italy_Late_Antiquity
10.78718221 R105_Lazio_Rome_Italy_Late_Antiquity
10.87054736 I4885_Czech_Bell_Beaker_4166_ybp
10.89414981 I3590_Germany_Bell_Beaker_4191_ybp
10.94753397 R63_Lazio_Rome_Medieval_Italy
11.04532933 I12649_low_quality_
11.09194302 CL36_longobard_north_italy
11.16779746 I4332_Croatia_MBA_3516_ybp