data(smartphone): derive os_version from os field (48,462 records) - #111
Merged
Merged
Conversation
Normalizes the launch OS version already present in each record's `os` string into the structured `os_version` field (e.g. "Android 4.0.3 (Ice Cream Sandwich)" -> "4.0.3"). Deterministic parse of existing data — no new/external data. Takes the shipped version, not "upgradeable to" ones. Symbian excluded (Series/UI numbers are ambiguous). os_version coverage ~6% -> ~58%. Refs #1
Member
Author
🤖 TechEngine · data validation
No schema change — normalizes a field the schema already defines. |
Member
Author
🤖 TechEngine · verify (Tier 0)Not a data import — a derivation from data already in the record:
|
Seungpyo1007
added a commit
that referenced
this pull request
Jul 9, 2026
… fields Applies the same two derivations used for smartphones (#111, #112) to the tablet/watch/pda catalogues: parse launch os_version from the `os` string, and compute display.ppi = round(sqrt(w^2+h^2)/size_inch). Deterministic, no new data. tablet +2656 os_version / +2080 ppi; watch +202 / +279; pda +16 / +54. Refs #1
Seungpyo1007
added a commit
that referenced
this pull request
Jul 9, 2026
… fields Applies the same two derivations used for smartphones (#111, #112) to the tablet/watch/pda catalogues: parse launch os_version from the `os` string, and compute display.ppi = round(sqrt(w^2+h^2)/size_inch). Deterministic, no new data. tablet +2656 os_version / +2080 ppi; watch +202 / +279; pda +16 / +54. Refs #1
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1 participant
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Summary
Normalizes the launch OS version that is already present in each smartphone's
osstring into the structuredos_versionfield — a deterministic parse of existing data, no new/external data and no fabrication.os_version~6% → ~58%)."Android 4.0.3 (Ice Cream Sandwich)"→4.0.3;"Microsoft Windows Mobile 6.5 Professional"→6.5;"iOS v26"→26."upgradeable to X"follow-ons.Series 60/S60 rel. 3.2/Symbian^3strings mix platform/UI numbers with OS versions and can't be parsed unambiguously (would have produced wrong values like60/90).Records already having
os_version(6,104) untouched; records whoseoshas no parseable version (38,830 — feature phones, "Proprietary", Symbian) left empty.All
verified: false. Validation passes. Dump regenerated — 48,462 changed smartphone detail pages.Closes #1