skills.rest
mi-erasmusmc
mi-erasmusmcOFFICIAL
Explore all skills by this author →
GitHub

process-ema-data

Parse EMA Authorised Presentations PDFs into structured TSV files.

5|1|Updated Dec 4, 2025
Search Tags:#automation#pdf#ema#data-extraction#batch-processing#tsv#drug-mapping
One-click install
npx skills add https://github.com/mi-erasmusmc/ema-authorised-to-rxnorm-mappings --skill process-ema-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: process-ema-data
Source: https://github.com/mi-erasmusmc/ema-authorised-to-rxnorm-mappings/tree/main/.claude/skills/process-ema-data
Command: npx skills add https://github.com/mi-erasmusmc/ema-authorised-to-rxnorm-mappings --skill process-ema-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, beautifulsoup4, pandas, openpyxl, and includes scripts (resource) components.

What problem does it solve?

Parsing EMA Authorised Presentations PDFs is time-consuming and error-prone when done manually; this Skill automates extraction of packaging, strength, route, content, pack size, and product identifiers into machine-readable TSV files to support vocabulary mapping and downstream data workflows.

Core Features & Use Cases

  • Single-file parsing: Extract table fields from an Authorised Presentations PDF and write a parsed_data_<date>.tsv beside the source PDF.
  • Batch parsing: Prepare self-contained batch prompts for parallel subagents using prepare_parse_batch.py to parse multiple products reliably.
  • Data fetching & maintenance: Detect latest PDF dates, download updated PDFs from EMA, convert the medicines report to TSV, and generate ema-info metadata with a single command.
  • Use Case: A researcher rebuilding EMA→RxNorm mappings can fetch updates, parse new PDFs into per-product TSVs, and regenerate overview mappings without manual file inspection.

Quick Start

Run python3 .claude/skills/process-ema-data/scripts/fetch_ema_updates.py to download updated EMA presentations, generate ema-info metadata, and produce combined parsed TSV overviews.

Frequently Asked Questions about process-ema-data

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

FAQPage Schema
How do I extract data from EMA Authorised Presentations PDFs?▼

To extract data from EMA Authorised Presentations PDFs, you can automate parsing to pull fields like ma_number, strength, route_of_administration, and pack_size into structured TSV files. This eliminates manual inspection and supports downstream vocabulary mapping workflows.

Can I batch parse multiple EMA product PDFs into TSV files?▼

Yes, you can batch parse multiple EMA product PDFs into TSV files. The skill provides scripts to prepare self-contained batch prompts for parallel subagents, enabling reliable bulk extraction of packaging and product identifiers without manual file processing.

How do I download updated EMA medicines data automatically?▼

To download updated EMA medicines data automatically, run the fetch_ema_updates.py script. It detects latest PDF dates, performs retryable HTTP downloads from EMA, converts the medicines report to TSV, and generates ema-info metadata in a single command.

Does this PDF data extraction tool require pandas and beautifulsoup4?▼

Yes, the PDF data extraction workflow requires pandas, beautifulsoup4, requests, and openpyxl. These dependencies support HTTP downloading, HTML parsing, and structured tabular data handling for converting EMA presentations into machine-readable TSV outputs.

What is the best way to map EMA product numbers to downstream vocabularies?▼

The best way to map EMA product numbers to downstream vocabularies is to automate extraction into structured TSV files first. Generating per-product parsed TSVs with consistent fields like ema_product_number and product_name allows seamless integration into vocabulary mapping pipelines.

Why does my EMA PDF parsing fail on certain product files?▼

EMA PDF parsing can fail if the source files are outdated or if HTTP downloads encounter intermittent errors. The skill addresses this by detecting latest PDF dates and implementing retryable HTTP requests to ensure you parse the most current EMA documents reliably.

Related Skills

Explore More Data & Analytics Skills→
mi-erasmusmcmi-erasmusmc
5

map-ema-drugs

Map EMA product presentations to RxNorm concepts in mapping.tsv files.

Official
Intermediate
swaruplabswaruplab
94

kegg-database

Query KEGG REST endpoints for pathway, gene, compound, and drug data.

Community
Advanced
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate
freekmurzefreekmurze
997

pdf

Extract text and tables from PDFs using pypdf and pdfplumber.

Community
Advanced