process-latvia-data

Convert Latvian ZVA registry JSON into sanitized per-product folders with metadata files.

5|1|Updated Dec 4, 2025
One-click install
npx skills add https://github.com/mi-erasmusmc/ema-authorised-to-rxnorm-mappings --skill process-latvia-data
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: process-latvia-data
Source: https://github.com/mi-erasmusmc/ema-authorised-to-rxnorm-mappings/tree/main/.claude/skills/process-latvia-data
Command: npx skills add https://github.com/mi-erasmusmc/ema-authorised-to-rxnorm-mappings --skill process-latvia-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Organizes raw Latvian ZVA medicinal product data into a consistent, discoverable per-product folder layout so researchers can reliably consume national product metadata for vocabulary mapping and review.

Core Features & Use Cases

  • Folder Organization: Groups products by active substance and brand and writes sanitized folder names suitable for repository use.
  • Metadata Generation: Produces an info.txt per product with standardized fields (short_name, active_substance, marketing_authorisation_holder, manufacturer, atc_code, package_leaflet, summary_of_product_characteristics).
  • Data Exports: Writes dated TSV files per product containing selected registry fields and emits warnings when INFO fields differ across grouped records.
  • Use Case: Prepare Latvian product data for manual or automated RxNorm/OMOP mapping by creating per-product directories under data/latvia/products/ that downstream scripts can consume.

Quick Start

Run the organize_products.py script to convert data/latvia/HumanProducts.json into sanitized product folders with info.txt and dated TSV files.

Frequently Asked Questions about process-latvia-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I structure Latvian ZVA product JSON data for vocabulary mapping?

To structure Latvian ZVA product JSON for vocabulary mapping, run a Python script that groups products by active substance and brand into sanitized per-product folders with metadata files. This creates a consistent directory layout under data/latvia/products/ for downstream mapping.

What is the process for organizing raw ZVA registry data into per-product folders?

Organizing raw ZVA registry data involves converting HumanProducts.json into sanitized product folders. The script generates an info.txt file with standardized fields like active_substance and atc_code, plus dated TSV exports for each grouped product.

How do I prepare Latvian drug registry data for RxNorm or OMOP mapping?

You prepare Latvian drug registry data for RxNorm or OMOP mapping by grouping products by active substance and brand. The script creates per-product directories containing standardized info.txt metadata and dated TSV files that downstream mapping scripts can consume.

Can I use Python to group ZVA products by active substance and brand?

Yes, you can use Python to group ZVA products by active substance and brand. The organize_products.py script processes HumanProducts.json locally within the repository, creating sanitized folder names and emitting consistency warnings when INFO fields differ across grouped records.

What metadata fields are generated when structuring Latvian ZVA product data?

When structuring Latvian ZVA product data, the script generates an info.txt file per product containing standardized fields including short_name, active_substance, marketing_authorisation_holder, manufacturer, atc_code, package_leaflet, and summary_of_product_characteristics.

Why does the ZVA data processing script emit consistency warnings?

The ZVA data processing script emits consistency warnings when INFO fields differ across grouped records within the same product. This alerts researchers to potential data discrepancies in the raw registry JSON before proceeding with downstream vocabulary mapping and review workflows.