Downloads 3.6kthis week

GitHub stars 4

Extension descriptor (YAML)

Efficiently standardizes scraped job titles to Bureau of Labor Statistics (BLS) titles using a high-performance TF-IDF algorithm.

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

Installing and Loading

INSTALL title_mapper FROM community;
LOAD title_mapper;

Example

-- Standardize a column
SELECT standardize_title(scraped_title_column) FROM your_table;

-- Standardize tech job titles
SELECT standardize_title('Sr. Software Eng') AS standardized_title;
-- Result: 'Software Engineer - Software Developers'

-- Standardize healthcare titles
SELECT standardize_title('RN - Emergency Room') AS standardized_title;
-- Result: 'Registered Nurse - Registered Nurses'

About title_mapper

DuckDB Title Mapper

duckdb-title-mapper is a highly optimized DuckDB extension written in Rust. It standardizes scraped job titles to BLS (Bureau of Labor Statistics) standard titles using a fast TF-IDF implementation.

What It Does

This extension transforms messy, inconsistent job titles from various sources into standardized BLS titles:

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.