模型:
microsoft/tapex-large-finetuned-wikisql
TAPEX是由 Qian Liu、Bei Chen、Jiaqi Guo、Morteza Ziyadi、Zeqi Lin、Weizhu Chen、Jian-Guang Lou 于 TAPEX: Table Pre-training via Learning a Neural SQL Executor 年提出的。原始存储库可在 here 找到。
TAPEX(表格预训练通过执行)是一种概念简单、经验证明强大的预训练方法,用于赋予现有模型表格推理能力。TAPEX通过学习一个在合成语料库上执行SQL查询的神经网络SQL执行器来实现表格预训练,合成语料库是通过自动合成可执行的SQL查询获得的。
TAPEX基于BART架构,是一种转换器编码器-编码器(seq2seq)模型,具有双向(类似BERT)编码器和自回归(类似GPT)解码器。
该模型是在 WikiSQL 数据集上微调的 tapex-base 模型。
您可以在相对简单的问题上使用该模型进行表格问答。以下是一些可解决的问题示例(对应的表格暂未显示):
| Question | Answer |
|---|---|
| tell me what the notes are for south australia | no slogan on current series |
| what position does the player who played for butler cc (ks) play? | guard-forward |
| how many schools did player number 3 play at? | 1.0 |
| how many winning drivers in the kraco twin 125 (r2) race were there? | 1.0 |
| for the episode(s) aired in the u.s. on 4 april 2008, what were the names? | "bust a move" part one, "bust a move" part two |
以下是在transformers中使用此模型的方法:
from transformers import TapexTokenizer, BartForConditionalGeneration
import pandas as pd
tokenizer = TapexTokenizer.from_pretrained("microsoft/tapex-large-finetuned-wikisql")
model = BartForConditionalGeneration.from_pretrained("microsoft/tapex-large-finetuned-wikisql")
data = {
"year": [1896, 1900, 1904, 2004, 2008, 2012],
"city": ["athens", "paris", "st. louis", "athens", "beijing", "london"]
}
table = pd.DataFrame.from_dict(data)
# tapex accepts uncased input since it is pre-trained on the uncased corpus
query = "In which year did beijing host the Olympic Games?"
encoding = tokenizer(table=table, query=query, return_tensors="pt")
outputs = model.generate(**encoding)
print(tokenizer.batch_decode(outputs, skip_special_tokens=True))
# [' 2008.0']
请查找评估脚本 here 。
@inproceedings{
liu2022tapex,
title={{TAPEX}: Table Pre-training via Learning a Neural {SQL} Executor},
author={Qian Liu and Bei Chen and Jiaqi Guo and Morteza Ziyadi and Zeqi Lin and Weizhu Chen and Jian-Guang Lou},
booktitle={International Conference on Learning Representations},
year={2022},
url={https://openreview.net/forum?id=O50443AsCP}
}