parquet languages
Reading
This dataset catalogues 19,401 world languages, each identified by a unique Glottocode and name, with attributes like geographic coordinates, macroarea, language family, ISO code, and phoneme count. Two things stand out for closer inspection: phoneme_count is missing for 88.8% of rows and is heavily right-skewed (mean ~38, max 231), so any analysis of phonological inventories will rely on a small subsample with notable outliers. Latitude and longitude are also null for 59.1% of rows, which will limit mapping coverage. On the categorical side, macroarea is well-distributed across six regions but dominated by Africa (32%), while the status column is uninformative since every language is labelled 'living'.
citing: phoneme_count · latitude · longitude · macroarea · status · name · glottocode
Charts the summary said to look at first
Show data table
| value | count | share |
|---|---|---|
| Africa | 5955 | 30.7% |
| Eurasia | 5028 | 25.9% |
| Papunesia | 4847 | 25.0% |
| South America | 1095 | 5.6% |
| North America | 1035 | 5.3% |
| Australia | 602 | 3.1% |
Show data table
| bin | count |
|---|---|
| 11 – 16.5 | 19 |
| 16.5 – 22 | 208 |
| 22 – 27.5 | 460 |
| 27.5 – 33 | 285 |
| 33 – 38.5 | 348 |
| 38.5 – 44 | 233 |
| 44 – 49.5 | 200 |
| 49.5 – 55 | 115 |
| 55 – 60.5 | 116 |
| 60.5 – 66 | 51 |
| 66 – 71.5 | 45 |
| 71.5 – 77 | 14 |
| 77 – 82.5 | 21 |
| 82.5 – 88 | 14 |
| 88 – 93.5 | 14 |
| 93.5 – 99 | 9 |
| 99 – 104.5 | 2 |
| 104.5 – 110 | 3 |
| 110 – 115.5 | 2 |
| 115.5 – 121 | 3 |
| 121 – 126.5 | 3 |
| 126.5 – 132 | 2 |
| 132 – 137.5 | 1 |
| 137.5 – 143 | 2 |
| 143 – 148.5 | 0 |
| 148.5 – 154 | 1 |
| 154 – 159.5 | 0 |
| 159.5 – 165 | 1 |
| 165 – 170.5 | 0 |
| 170.5 – 176 | 0 |
| 176 – 181.5 | 0 |
| 181.5 – 187 | 0 |
| 187 – 192.5 | 0 |
| 192.5 – 198 | 0 |
| 198 – 203.5 | 0 |
| 203.5 – 209 | 0 |
| 209 – 214.5 | 0 |
| 214.5 – 220 | 0 |
| 220 – 225.5 | 0 |
| 225.5 – 231 | 1 |
Show data table
| bin | count |
|---|---|
| -55.27 – -52.06 | 5 |
| -52.06 – -48.85 | 1 |
| -48.85 – -45.64 | 1 |
| -45.64 – -42.43 | 4 |
| -42.43 – -39.22 | 7 |
| -39.22 – -36.01 | 16 |
| -36.01 – -32.8 | 29 |
| -32.8 – -29.59 | 26 |
| -29.59 – -26.38 | 47 |
| -26.38 – -23.17 | 77 |
| -23.17 – -19.96 | 125 |
| -19.96 – -16.75 | 141 |
| -16.75 – -13.54 | 280 |
| -13.54 – -10.33 | 256 |
| -10.33 – -7.121 | 495 |
| -7.121 – -3.911 | 788 |
| -3.911 – -0.7005 | 681 |
| -0.7005 – 2.51 | 378 |
| 2.51 – 5.72 | 468 |
| 5.72 – 8.93 | 663 |
| 8.93 – 12.14 | 710 |
| 12.14 – 15.35 | 303 |
| 15.35 – 18.56 | 384 |
| 18.56 – 21.77 | 233 |
| 21.77 – 24.98 | 318 |
| 24.98 – 28.19 | 371 |
| 28.19 – 31.4 | 167 |
| 31.4 – 34.61 | 143 |
| 34.61 – 37.82 | 178 |
| 37.82 – 41.03 | 113 |
| 41.03 – 44.24 | 138 |
| 44.24 – 47.45 | 79 |
| 47.45 – 50.66 | 77 |
| 50.66 – 53.87 | 76 |
| 53.87 – 57.08 | 46 |
| 57.08 – 60.29 | 21 |
| 60.29 – 63.5 | 41 |
| 63.5 – 66.71 | 23 |
| 66.71 – 69.93 | 14 |
| 69.93 – 73.14 | 6 |
Show data table
| bin | count |
|---|---|
| -178.8 – -169.8 | 13 |
| -169.8 – -160.9 | 4 |
| -160.9 – -151.9 | 10 |
| -151.9 – -143 | 11 |
| -143 – -134 | 10 |
| -134 – -125.1 | 17 |
| -125.1 – -116.1 | 123 |
| -116.1 – -107.2 | 47 |
| -107.2 – -98.21 | 78 |
| -98.21 – -89.26 | 280 |
| -89.26 – -80.31 | 59 |
| -80.31 – -71.36 | 235 |
| -71.36 – -62.41 | 218 |
| -62.41 – -53.45 | 150 |
| -53.45 – -44.5 | 60 |
| -44.5 – -35.55 | 40 |
| -35.55 – -26.6 | 0 |
| -26.6 – -17.64 | 4 |
| -17.64 – -8.692 | 105 |
| -8.692 – 0.2605 | 275 |
| 0.2605 – 9.213 | 443 |
| 9.213 – 18.17 | 751 |
| 18.17 – 27.12 | 322 |
| 27.12 – 36.07 | 429 |
| 36.07 – 45.02 | 228 |
| 45.02 – 53.97 | 126 |
| 53.97 – 62.93 | 35 |
| 62.93 – 71.88 | 79 |
| 71.88 – 80.83 | 210 |
| 80.83 – 89.78 | 207 |
| 89.78 – 98.74 | 269 |
| 98.74 – 107.7 | 454 |
| 107.7 – 116.6 | 239 |
| 116.6 – 125.6 | 497 |
| 125.6 – 134.5 | 316 |
| 134.5 – 143.5 | 598 |
| 143.5 – 152.4 | 667 |
| 152.4 – 161.4 | 122 |
| 161.4 – 170.4 | 186 |
| 170.4 – 179.3 | 12 |
Show data table
| chars | count |
|---|---|
| 1 – 2 | 52 |
| 2 – 4 | 455 |
| 4 – 5 | 4355 |
| 5 – 7 | 2890 |
| 7 – 8 | 3995 |
| 8 – 10 | 1115 |
| 10 – 11 | 813 |
| 11 – 12 | 1417 |
| 12 – 14 | 724 |
| 14 – 15 | 1264 |
| 15 – 17 | 439 |
| 17 – 18 | 524 |
| 18 – 20 | 214 |
| 20 – 21 | 175 |
| 21 – 22 | 343 |
| 22 – 24 | 143 |
| 24 – 25 | 173 |
| 25 – 27 | 58 |
| 27 – 28 | 86 |
| 28 – 30 | 26 |
| 30 – 31 | 26 |
| 31 – 32 | 43 |
| 32 – 34 | 12 |
| 34 – 35 | 24 |
| 35 – 37 | 11 |
| 37 – 38 | 8 |
| 38 – 39 | 3 |
| 39 – 41 | 1 |
| 41 – 42 | 2 |
| 42 – 44 | 1 |
| 44 – 45 | 3 |
| 45 – 47 | 1 |
| 47 – 48 | 2 |
| 48 – 49 | 1 |
| 49 – 51 | 0 |
| 51 – 52 | 0 |
| 52 – 54 | 0 |
| 54 – 55 | 0 |
| 55 – 57 | 0 |
| 57 – 58 | 2 |
Schema
11 columns| Alerts | ||||
|---|---|---|---|---|
| glottocode | text | 0.0% | 19,401 |
near_unique
one_word
short_text
|
| iso_639_3 | unknown | 0.0% | — |
skipped
|
| name | text | 0.0% | 19,401 |
near_unique
one_word
|
| family_name | unknown | 0.0% | — |
skipped
|
| family_glottocode | unknown | 0.0% | — |
skipped
|
| macroarea | categorical | 4.3% | 6 |
|
| latitude | numeric | 59.1% | 7,786 |
null_rate
|
| longitude | numeric | 59.1% | 7,745 |
null_rate
|
| status | categorical | 0.0% | 1 |
imbalance
|
| speakers_count | unknown | 0.0% | — |
skipped
|
| phoneme_count | numeric | 88.8% | 100 |
null_rate
high_skew
|
glottocode
text identifier near_unique one_word short_textThis column holds Glottocodes, the standard 8-character identifiers for languages in the Glottolog catalogue (e.g. 'aala1237', 'aari1239'). Every one of the 19,401 rows is unique with length exactly 8 and a single token, and there are no nulls or duplicates, consistent with a primary key over languages. Nothing anomalous: the column is a clean identifier rather than analysable text. Treatment: Use as the primary key; left-join other language metadata on this code rather than modelling it.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- 19,401
- len_min
- 8
- len_max
- 8
- len_mean
- 8
- len_median
- 8
- len_p95
- 8
- word_mean
- 1
- word_median
- 1
- n_empty
- 0
- n_duplicates
- 0
- duplicate_rate
- 0
- vocab_size
- 19,401
- readability_flesch_mean
- 93.3
- emoji_rate
- 0
- url_rate
- 0
- one_word_rate
- 1
- allcaps_rate
- 0
- boilerplate_rate
- 0
iso_639_3
unknown metadata skippedThis column is named iso_639_3, suggesting it should hold ISO 639-3 three-letter language codes. Saturn skipped profiling (kind=unknown), so no uniqueness or value distribution is available; only the row count of 19401 and a 0.0 null rate are confirmed. Without cardinality or sample values, the actual contents and their alignment with the ISO 639-3 standard cannot be verified here. Treatment: Re-profile with explicit string typing to recover cardinality, then use as a categorical language tag.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- —
name
text identifier near_unique one_wordThis is a short-text 'name' field with 19401 entirely unique values (n_unique equals n) and no nulls or duplicates. Entries are mostly single tokens — 71.7% are one_word and word_median is 1 — averaging 9.2 characters and capping at 58. The top vocabulary (nuclear, sign, language, central, southern, western, northern, eastern) suggests these are labels for things like categories, regions, or articles rather than person names. Treatment: Treat as a unique key — join or display only, do not use as a model feature.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- 19,401
- len_min
- 1
- len_max
- 58
- len_mean
- 9.211
- len_median
- 7
- len_p95
- 20
- word_mean
- 1.369
- word_median
- 1
- n_empty
- 0
- n_duplicates
- 0
- duplicate_rate
- 0
- vocab_size
- 17,861
- readability_flesch_mean
- 60.53
- emoji_rate
- 0
- url_rate
- 0
- one_word_rate
- 0.7169
- allcaps_rate
- 0
- boilerplate_rate
- 0
family_name
unknown other skippedThis column is named family_name and was skipped by the profiler, so no type, uniqueness, or value statistics are available beyond a row count of 19401 and a null rate of 0.0. The name suggests surnames or a taxonomic family label, but without distribution evidence the actual content cannot be confirmed. The only notable signal is the explicit 'skipped' alert, meaning downstream consumers are flying blind on this field. Treatment: Re-run profiling with this column included before deciding how to use it.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- —
family_glottocode
unknown foreign_key skippedThe column was skipped by the profiler, so beyond a complete absence of nulls across 19,401 rows there is no distributional evidence to draw on. The name family_glottocode points to Glottolog family identifiers (a linguistic taxonomy code), but uniqueness, cardinality, and value distribution are all unknown here. Treatment: Re-profile with string handling enabled, then left-join to a Glottolog reference table.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- —
macroarea
categorical featureSix-valued geographic grouping that bins records into continental-scale macroareas (Africa, Eurasia, Papunesia, South America, North America, Australia), suggesting linguistic or biogeographic data. Distribution is uneven: Africa leads at 32.1% of rows while Australia holds only 602, and entropy ratio of 0.84 confirms moderate but not extreme imbalance. About 4.3% of rows are null. Treatment: One-hot encode and impute or flag the 4.3% nulls.
- n
- 19,401
- nulls
- 839 (4.3%)
- unique
- 6
- top_value
- Africa
- top_rate
- 0.3208
- cardinality
- 6
- entropy
- 2.176
- entropy_ratio
- 0.8418
latitude
numeric feature null_rateThis is a geographic latitude coordinate, with values spanning -55.2748 to 73.1354 and a median of 6.2918, consistent with degrees north/south of the equator. Nearly 59% of rows are null, which is the dominant concern; among present values, the distribution is mildly right-skewed (0.54) and roughly centered north of the equator (mean 8.16). Only 7,786 unique values across 19,401 rows suggests repeated locations rather than per-row precise coordinates. Treatment: Pair with longitude for geospatial features; impute or flag missingness given the 59% null rate before modelling.
- n
- 19,401
- nulls
- 11,472 (59.1%)
- unique
- 7,786
- min
- -55.27
- max
- 73.14
- mean
- 8.164
- median
- 6.292
- std
- 18.96
- q1
- -5.139
- q3
- 19.27
- iqr
- 24.41
- skew
- 0.5425
- kurtosis
- 0.3048
- n_outliers
- 135
- outlier_rate
- 0.01703
- zero_rate
- 0
longitude
numeric feature null_rateGeographic longitude in decimal degrees, with values spanning -178.785 to 179.306 and a median of 47.57 consistent with a global coordinate range. The distribution is mildly left-skewed (-0.48) and platykurtic (-0.78), with only 13 outliers (0.16%), but 59.13% of rows are null, meaning location is missing for most records. Of 19,401 rows, 7,745 unique values suggest repeated locations rather than per-record GPS fixes. Treatment: Pair with latitude for geospatial features; impute or add a missingness flag given the high null rate.
- n
- 19,401
- nulls
- 11,472 (59.1%)
- unique
- 7,745
- min
- -178.8
- max
- 179.3
- mean
- 51.22
- median
- 47.57
- std
- 81.15
- q1
- 7.18
- q3
- 124.1
- iqr
- 117
- skew
- -0.4814
- kurtosis
- -0.7765
- n_outliers
- 13
- outlier_rate
- 0.00164
- zero_rate
- 0
status
categorical metadata imbalanceThis is a single-value categorical field where every one of the 19,401 rows is "living". With cardinality 1 and entropy 0, it carries no information and cannot discriminate between records. Treatment: Drop; constant column with zero entropy.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- 1
- top_value
- living
- top_rate
- 1
- cardinality
- 1
- entropy
- 0
- entropy_ratio
- 0
speakers_count
unknown other skippedThe column is named speakers_count, which suggests a numeric tally of speakers per record, but saturn skipped profiling and returned no type, uniqueness, or distribution stats. The only confirmed signals are 19401 rows and a 0.0 null rate. Without kind or summary statistics, nothing further can be said about its actual contents. Treatment: Re-profile this column with type inference forced before deciding on downstream use.
- n
- 19,401
- nulls
- 0 (0.0%)
- unique
- —
phoneme_count
numeric feature null_rate high_skewCounts of phonemes per record, ranging 11 to 231 with median 34 and IQR 20. The distribution is heavily right-skewed (skew 2.32, kurtosis 11.5) with 79 outliers (3.6%), and critically 88.8% of rows are null so only ~2,170 values are present. Treatment: Impute or flag missingness and log-transform before modelling given the 88.8% null rate and skew of 2.32.
- n
- 19,401
- nulls
- 17,228 (88.8%)
- unique
- 100
- min
- 11
- max
- 231
- mean
- 38.2
- median
- 34
- std
- 17.78
- q1
- 26
- q3
- 46
- iqr
- 20
- skew
- 2.325
- kurtosis
- 11.54
- n_outliers
- 79
- outlier_rate
- 0.03636
- zero_rate
- 0