|
--- |
|
library_name: transformers |
|
license: apache-2.0 |
|
datasets: |
|
- gretelai/synthetic_text_to_sql |
|
- NickyNicky/synthetic_text_to_sql_format_chatML_gemma |
|
language: |
|
- en |
|
|
|
widget: |
|
- text: | |
|
<bos><start_of_turn>system |
|
You are a helpful AI assistant. |
|
you are a sql expert who responds in json format.<end_of_turn> |
|
<start_of_turn>user |
|
## prompt: |
|
What is the total gold production by 'Site B' in the 'production' table? |
|
|
|
|
|
CREATE TABLE production (id INT, site VARCHAR(50), year INT, gold_production INT, silver_production INT);<end_of_turn> |
|
<start_of_turn>model |
|
--- |
|
|
|
|
|
<p align="center"> |
|
<img src="https://cdn-uploads.huggingface.co/production/uploads/641b435ba5f876fe30c5ae0a/Fy2GvAheKCnd3Jj3TbrPG.png" alt="" style="width: 95%; max-height: 750px;"> |
|
</p> |
|
|
|
## Metrics. |
|
``` |
|
TrainOutput(global_step=2509, |
|
training_loss=0.2509715025906736, |
|
metrics={'train_runtime': 22783.0743, |
|
'train_samples_per_second': 8.81, |
|
'train_steps_per_second': 0.11, |
|
'total_flos': 1.820581902144553e+18, |
|
'train_loss': 0.2509715025906736, |
|
'epoch': 2.01 |
|
} |
|
) |
|
``` |
|
|
|
## Take dataset. |
|
``` |
|
gretelai/synthetic_text_to_sql |
|
``` |
|
|
|
## Dataset format gemma fine tune. |
|
``` |
|
NickyNicky/synthetic_text_to_sql_format_chatML_gemma |
|
``` |
|
|
|
## colab examples and Gradio. |
|
``` |
|
https://colab.research.google.com/drive/1-0PsRAqTum2UuvsXb9JtXxLISIUWd8zv?usp=sharing |
|
``` |
|
|
|
## gradio colab. |
|
<p align="center"> |
|
<img src="https://cdn-uploads.huggingface.co/production/uploads/641b435ba5f876fe30c5ae0a/X2rf3Z7jJ2WUI7LANw4IH.png" alt="" style="width: 95%; max-height: 750px;"> |
|
</p> |
|
|
|
## $ train |
|
<p align="center"> |
|
<img src="https://cdn-uploads.huggingface.co/production/uploads/641b435ba5f876fe30c5ae0a/tLhUyV2uW44-Cf0vwXFbd.png" alt="" style="width: 95%; max-height: 750px;"> |
|
</p> |