DavidD003's picture
Update app.py
19841de
raw
history blame contribute delete
No virus
1.86 kB
import gradio as gr
import codeFile as cd
import openpyxl as pyxl
def myFunction(dtaFl,shNm,nC,nR):
flNm=cd.rowWise(dtaFl,shNm,nC,nR)
return flNm
demo = gr.Interface(
myFunction,
[
#gr.Radio(["Yes", "No"],label="Assign OT to WWF? (If 'yes', WWF will be considered for filling in slots beyond their prescribed shifts in the Assignment List"),
#gr.CheckboxGroup(["Friday", "Monday"], label="Check the boxes as appropriate if scheduling long weekend"),
#gr.Radio([32, 40],label="Regular Work Hours This Week?"),
#gr.Radio(["Bud","Blue"],label="Which crew is on A shift this week?"),
#gr.File(label="Assignments List"),
# gr.File(label="Required Jobs List"),
#gr.File(label="Full Time Refusal Sheet - COPY OF SHEET WITH VALUES, NO FORMULAS"),
#gr.File(label="Temp Refusal Sheet - COPY OF SHEET WITH VALUES, NO FORMULAS"),
gr.File(label="Data File"),
gr.Textbox(label="Sheet Name"),
gr.Number(label="Number of Rows",precision=0),
gr.Number(label="Number of Columns",precision=0)
],
[
#gr.Dataframe(
# headers=["Date", "trsxn", "symbol", "qt","price"],
# datatype=["str", "str", "str", "number", "number"],
# ),
#gr.Textbox(label="dynamic import test"),
gr.File(label="File With Transformed Data")
],
description="Enter excel file, sheet name, the excel row at which the table ends, and the column number at which the table ends, to have the data changed into a row-wise orientation. This function expects the table to start at A1, expects the first field to be the unique x1 value, and proceeding fields to have unique 'x2' headers, with cell containing the dependent y for x1 and x2. Then it returns a much longer list with only 3 columns: x1,x2,y",
)
demo.launch()#Nice!