Total runs:
344.0K
Run Growth:
130.7K
Growth Rate:
37.72%
Sponsored by
iMean AI Trip Planner
mrm8488 / t5-small-finetuned-wikiSQL
Model's Last Updated: March 31 2023
text-generation
Introduction of t5-small-finetuned-wikiSQL
Model Details of t5-small-finetuned-wikiSQL
T5-small fine-tuned on WikiSQL
Google's T5 small fine-tuned on WikiSQL for English to SQL translation .
Details of T5
The T5 model was presented in Exploring the Limits of Transfer Learning with a Unified Text-to-Text Transformer by Colin Raffel, Noam Shazeer, Adam Roberts, Katherine Lee, Sharan Narang, Michael Matena, Yanqi Zhou, Wei Li, Peter J. Liu in Here the abstract:
Transfer learning, where a model is first pre-trained on a data-rich task before being fine-tuned on a downstream task, has emerged as a powerful technique in natural language processing (NLP). The effectiveness of transfer learning has given rise to a diversity of approaches, methodology, and practice. In this paper, we explore the landscape of transfer learning techniques for NLP by introducing a unified framework that converts every language problem into a text-to-text format. Our systematic study compares pre-training objectives, architectures, unlabeled datasets, transfer approaches, and other factors on dozens of language understanding tasks. By combining the insights from our exploration with scale and our new “Colossal Clean Crawled Corpus”, we achieve state-of-the-art results on many benchmarks covering summarization, question answering, text classification, and more. To facilitate future work on transfer learning for NLP, we release our dataset, pre-trained models, and code.
Details of the Dataset 📚
Dataset ID:
wikisql
from
Huggingface/NLP
| Dataset | Split | # samples |
|---|---|---|
| wikisql | train | 56355 |
| wikisql | valid | 14436 |
How to load it from nlp
train_dataset = nlp.load_dataset('wikisql', split=nlp.Split.TRAIN)
valid_dataset = nlp.load_dataset('wikisql', split=nlp.Split.VALIDATION)
Check out more about this dataset and others in NLP Viewer
Model fine-tuning 🏋️
The training script is a slightly modified version of this Colab Notebook created by Suraj Patil , so all credits to him!
Model in Action 🚀
from transformers import AutoModelWithLMHead, AutoTokenizer
tokenizer = AutoTokenizer.from_pretrained("mrm8488/t5-small-finetuned-wikiSQL")
model = AutoModelWithLMHead.from_pretrained("mrm8488/t5-small-finetuned-wikiSQL")
def get_sql(query):
input_text = "translate English to SQL: %s </s>" % query
features = tokenizer([input_text], return_tensors='pt')
output = model.generate(input_ids=features['input_ids'],
attention_mask=features['attention_mask'])
return tokenizer.decode(output[0])
query = "How many millions of params there are in HF-hub?"
get_sql(query)
# output: 'SELECT COUNT Params FROM table WHERE Location = HF-hub'
Created by Manuel Romero/@mrm8488 | LinkedIn
Made with ♥ in Spain
Runs of mrm8488 t5-small-finetuned-wikiSQL on huggingface.co
154
Total runs
0
24-hour runs
95
3-day runs
106
7-day runs
120
30-day runs
More Information About t5-small-finetuned-wikiSQL huggingface.co Model
Url of t5-small-finetuned-wikiSQL
t5-small-finetuned-wikiSQL huggingface.co Url
Provider of t5-small-finetuned-wikiSQL huggingface.co
Other API from mrm8488
Updated:January 21 2024
Total runs:
32.5K
Run Growth:
-1.2K
Growth Rate:
-3.71%
Total runs:
15.8K
Run Growth:
-29.8K
Growth Rate:
-187.50%
Total runs:
13.3K
Run Growth:
1.0K
Growth Rate:
7.64%
Total runs:
9.6K
Run Growth:
-59
Growth Rate:
-0.62%
Total runs:
9.5K
Run Growth:
4.9K
Growth Rate:
50.91%
Total runs:
8.7K
Run Growth:
5.2K
Growth Rate:
62.87%
Total runs:
8.7K
Run Growth:
5.7K
Growth Rate:
65.22%
Total runs:
5.9K
Run Growth:
73
Growth Rate:
1.23%
Total runs:
4.6K
Run Growth:
-23.7K
Growth Rate:
-511.66%
Total runs:
3.8K
Run Growth:
2.8K
Growth Rate:
75.60%
Total runs:
3.0K
Run Growth:
2.7K
Growth Rate:
90.40%
Total runs:
2.2K
Run Growth:
-3.3K
Growth Rate:
-147.76%
Total runs:
1.8K
Run Growth:
1.2K
Growth Rate:
66.12%
Total runs:
1.4K
Run Growth:
-49
Growth Rate:
-3.58%
Total runs:
987
Run Growth:
435
Growth Rate:
43.90%
Total runs:
982
Run Growth:
-2.1K
Growth Rate:
-219.09%
Total runs:
929
Run Growth:
-1.1K
Growth Rate:
-118.49%
Total runs:
895
Run Growth:
238
Growth Rate:
26.62%
Total runs:
767
Run Growth:
-151
Growth Rate:
-19.41%
Total runs:
764
Run Growth:
-294
Growth Rate:
-38.28%
Total runs:
682
Run Growth:
335
Growth Rate:
49.12%
Total runs:
634
Run Growth:
178
Growth Rate:
28.12%
Total runs:
482
Run Growth:
-579
Growth Rate:
-112.87%
Total runs:
469
Run Growth:
3
Growth Rate:
0.65%
Total runs:
466
Run Growth:
-554
Growth Rate:
-135.78%
Total runs:
464
Run Growth:
366
Growth Rate:
78.88%
Total runs:
380
Run Growth:
15
Growth Rate:
4.09%
Total runs:
366
Run Growth:
57
Growth Rate:
15.57%
Total runs:
348
Run Growth:
-214
Growth Rate:
-62.94%
Total runs:
333
Run Growth:
326
Growth Rate:
85.12%
Total runs:
330
Run Growth:
128
Growth Rate:
38.79%
Total runs:
326
Run Growth:
88
Growth Rate:
26.99%
Total runs:
300
Run Growth:
-48
Growth Rate:
-16.00%
Total runs:
269
Run Growth:
24
Growth Rate:
8.92%
Total runs:
269
Run Growth:
177
Growth Rate:
63.90%
Total runs:
260
Run Growth:
255
Growth Rate:
98.08%
Total runs:
250
Run Growth:
-122
Growth Rate:
-48.80%
Total runs:
242
Run Growth:
-17
Growth Rate:
-7.02%
Total runs:
227
Run Growth:
-197
Growth Rate:
-86.78%
Total runs:
194
Run Growth:
67
Growth Rate:
35.26%
Total runs:
192
Run Growth:
62
Growth Rate:
33.33%
Total runs:
191
Run Growth:
-50
Growth Rate:
-26.74%
Total runs:
167
Run Growth:
-74
Growth Rate:
-44.05%
Total runs:
155
Run Growth:
96
Growth Rate:
61.15%
Total runs:
147
Run Growth:
88
Growth Rate:
57.89%
Total runs:
132
Run Growth:
112
Growth Rate:
82.96%
Total runs:
129
Run Growth:
122
Growth Rate:
96.06%
Total runs:
117
Run Growth:
34
Growth Rate:
28.81%
Total runs:
116
Run Growth:
38
Growth Rate:
32.76%
Total runs:
112
Run Growth:
24
Growth Rate:
21.43%
Total runs:
110
Run Growth:
91
Growth Rate:
83.49%
Total runs:
109
Run Growth:
33
Growth Rate:
30.28%
Total runs:
108
Run Growth:
-138
Growth Rate:
-127.78%
Total runs:
104
Run Growth:
9
Growth Rate:
9.00%
Total runs:
103
Run Growth:
78
Growth Rate:
78.00%
Total runs:
100
Run Growth:
70
Growth Rate:
79.55%
Total runs:
100
Run Growth:
64
Growth Rate:
73.56%
Total runs:
98
Run Growth:
93
Growth Rate:
95.88%
Total runs:
95
Run Growth:
-8
Growth Rate:
-8.42%
Total runs:
92
Run Growth:
68
Growth Rate:
73.91%
Total runs:
88
Run Growth:
80
Growth Rate:
91.95%
Total runs:
87
Run Growth:
59
Growth Rate:
71.08%
Total runs:
86
Run Growth:
-28
Growth Rate:
-33.33%
Total runs:
83
Run Growth:
22
Growth Rate:
26.51%
Total runs:
83
Run Growth:
76
Growth Rate:
95.00%
Total runs:
82
Run Growth:
-40
Growth Rate:
-48.78%
Total runs:
82
Run Growth:
-29
Growth Rate:
-35.37%
Total runs:
82
Run Growth:
57
Growth Rate:
69.51%
Total runs:
81
Run Growth:
73
Growth Rate:
90.12%
Total runs:
79
Run Growth:
-34
Growth Rate:
-43.04%
Total runs:
76
Run Growth:
-121
Growth Rate:
-159.21%
Total runs:
76
Run Growth:
47
Growth Rate:
61.84%
Total runs:
74
Run Growth:
-20
Growth Rate:
-27.03%
Total runs:
73
Run Growth:
31
Growth Rate:
42.47%
Total runs:
71
Run Growth:
-4
Growth Rate:
-5.63%
Total runs:
67
Run Growth:
21
Growth Rate:
32.31%
Total runs:
64
Run Growth:
-19
Growth Rate:
-29.69%
Total runs:
63
Run Growth:
41
Growth Rate:
65.08%
Total runs:
62
Run Growth:
47
Growth Rate:
85.45%
Total runs:
61
Run Growth:
-102
Growth Rate:
-167.21%
Total runs:
59
Run Growth:
54
Growth Rate:
93.10%
Total runs:
58
Run Growth:
20
Growth Rate:
36.36%
Total runs:
56
Run Growth:
45
Growth Rate:
84.91%
Total runs:
55
Run Growth:
47
Growth Rate:
85.45%
Total runs:
55
Run Growth:
51
Growth Rate:
92.73%
Total runs:
53
Run Growth:
35
Growth Rate:
72.92%
Total runs:
52
Run Growth:
39
Growth Rate:
75.00%
Total runs:
49
Run Growth:
24
Growth Rate:
48.98%
Total runs:
48
Run Growth:
-2
Growth Rate:
-4.17%
Total runs:
48
Run Growth:
-98
Growth Rate:
-213.04%
Total runs:
48
Run Growth:
48
Growth Rate:
100.00%