Hugging Face's logo

Spaces:
Abbasid
/
TableQA
Running

App Files Community
TableQA
File size: 2,859 Bytes 
c3b0ed3
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
 
#!/usr/bin/env python
# coding: utf-8

# ## Using Gradio to create a simple interface.
# 
# Check out the library on [github](https://github.com/gradio-app/gradio-UI) and see the [getting started](https://gradio.app/getting_started.html) page for more demos.

# We'll start with a basic function that greets an input name.

# In[1]:


get_ipython().system('pip install -q gradio')


# Now we'll wrap this function with a Gradio interface.

# In[2]:


from transformers import pipeline
import pandas as pd

tqa = pipeline(task="table-question-answering", model="google/tapas-large-finetuned-wtq")


# In[ ]:


tsqa = pipeline(task="table-question-answering", model="google/tapas-large-finetuned-sqa")


# In[ ]:


mstqa = pipeline(task="table-question-answering", model="microsoft/tapex-large-finetuned-wikisql")


# In[ ]:


mswtqa = pipeline(task="table-question-answering", model="microsoft/tapex-large-finetuned-wtq")


# In[6]:


table2 = pd.read_excel("/content/Sample.xlsx").astype(str)
table3 = table2.head(20)


# In[7]:


table3


# In[ ]:


#t4 = table3.reset_index()
table4


# In[9]:


query = "what is the highest delta onu rx power?"
query2 = "what is the lowest delta onu rx power?"
query3 = "what is the most frequent login id?"
query4 = "how many rows with nan values are there?"
query5 = "how many S2 values are there"


# In[11]:


result = tsqa(table=table3, query=query5)["answer"]
result


# In[12]:


from collections import Counter
Counter(result)


# In[13]:


#mstqa(table=table4, query=query1)["answer"]


# In[14]:


mswtqa(table=table3, query=query5)["answer"]


# In[15]:


def main(filepath, query):

  table5 = pd.read_excel(filepath).head(20).astype(str)
  result = tsqa(table=table5, query=query)["answer"]
  return result

#greet("World")


# In[16]:


import gradio as gr

iface = gr.Interface(
    fn=main,
    inputs=[
        gr.File(type="filepath", label="Upload XLSX file"),
        gr.Textbox(type="text", label="Enter text"),
    ],
    outputs=[gr.Textbox(type="text", label="Text Input Output")],
    title="Multi-input Processor",
    description="Upload an XLSX file and/or enter text, and the processed output will be displayed.",
)

# Launch the Gradio interface
iface.launch()


# In[21]:


get_ipython().system('pip install notebook')


# In[34]:


import os
import subprocess

# Use subprocess to execute the shell command
subprocess.run(["jupyter", "nbconvert", "--to", "script", "--format", "script", "--output", "/content/", "/content/drive/MyDrive/Colab Notebooks/NEW TableQA-GRADIO: Hello World.ipynb"])


# In[19]:


get_ipython().system('gradio deploy')


# In[32]:


from google.colab import drive
drive.mount('/content/drive')


# That's all! Go ahead and open that share link in a new tab. Check out our [getting started](https://gradio.app/getting_started.html) page for more complicated demos.