Annotating Columns with Pre-trained Language Models
About
Inferring meta information about tables, such as column headers or relationships between columns, is an active research topic in data management as we find many tables are missing some of this information. In this paper, we study the problem of annotating table columns (i.e., predicting column types and the relationships between columns) using only information from the table itself. We develop a multi-task learning framework (called Doduo) based on pre-trained language models, which takes the entire table as input and predicts column types/relations using a single model. Experimental results show that Doduo establishes new state-of-the-art performance on two benchmarks for the column type prediction and column relation prediction tasks with up to 4.0% and 11.9% improvements, respectively. We report that Doduo can already outperform the previous state-of-the-art performance with a minimal number of tokens, only 8 tokens per column. We release a toolbox (https://github.com/megagonlabs/doduo) and confirm the effectiveness of Doduo on a real-world data science problem through a case study.
Related benchmarks
| Task | Dataset | Result | Rank | |
|---|---|---|---|---|
| Column Type Annotation | PublicBI to GitTables | SW F167.5 | 32 | |
| Column Type Annotation | Semtab low-resource 2019 | SW F159.4 | 26 | |
| Column Type Annotation | PublicBI to VizNet 25% (3745 col) | SW F1 Score86.3 | 10 | |
| Column Type Annotation | PublicBI to VizNet 100% (14980 col) | SW F191.1 | 10 | |
| Column Type Annotation | PublicBI to VizNet (50% (7490 col)) | SW F187.2 | 10 | |
| Column Type Annotation | VizNet to Semtab2019 50% (2725 col) | SW F177.8 | 10 | |
| Column Type Annotation | VizNet to Semtab 2019 (100% (5450 col)) | SW F10.808 | 10 | |
| Column Type Annotation | VizNet to Semtab 25% (1363 col) 2019 | SW F173.6 | 10 | |
| Column Type Annotation | PublicBI to VizNet transfer 864 col 5.9% (low4) | SW F10.742 | 10 | |
| Column Type Annotation | PublicBI to VizNet transfer 2.5% (364 col) (low2) | SW F1 Score56.9 | 10 |