Spaces:
Sleeping
Sleeping
| import pandas as pd | |
| import gradio as gr | |
| #import openpyxl | |
| def compute_mode_openmarket(file): | |
| # Read the Excel file | |
| df = pd.read_excel(file) | |
| opm=df[df['Outlet Channel']=='OPEN MARKET'] | |
| # Compute the mode of each column | |
| modes = opm.mode() | |
| # Convert the result to a new Excel file | |
| modes.to_excel("modes.xlsx", index=False) | |
| return "modes.xlsx" | |
| def compute_mode_wholesale(file): | |
| # Read the Excel file | |
| df = pd.read_excel(file) | |
| wholesale=df[df['Outlet Channel']=='WHOLESALE'] | |
| # Compute the mode of each column | |
| modes = wholesale.mode() | |
| # Convert the result to a new Excel file | |
| modes.to_excel("modes.xlsx", index=False) | |
| return "modes.xlsx" | |
| def compute_mode_Large_supermarkets(file): | |
| # Read the Excel file | |
| df = pd.read_excel(file) | |
| opm=df[df['Outlet Channel']=='Large supermarkets'] | |
| # Compute the mode of each column | |
| modes = opm.mode() | |
| # Convert the result to a new Excel file | |
| modes.to_excel("modes.xlsx", index=False) | |
| return "modes.xlsx" | |
| def compute_mode_Small_Supermarkets(file): | |
| # Read the Excel file | |
| df = pd.read_excel(file) | |
| opm=df[df['Outlet Channel']=='Small Supermarkets'] | |
| # Compute the mode of each column | |
| modes = opm.mode() | |
| # Convert the result to a new Excel file | |
| modes.to_excel("modes.xlsx", index=False) | |
| return "modes.xlsx" | |
| def compute_mode_Neighbourhood_grocery(file): | |
| # Read the Excel file | |
| df = pd.read_excel(file) | |
| opm=df[df['Outlet Channel']=='Neighbourhood grocery'] | |
| # Compute the mode of each column | |
| modes = opm.mode() | |
| # Convert the result to a new Excel file | |
| modes.to_excel("modes.xlsx", index=False) | |
| return "modes.xlsx" | |
| # Create a Gradio interface | |
| inputs = gr.File(label="Upload Excel File") | |
| outputs = gr.File(label="Download Mode File") | |
| iface1 = gr.Interface(fn=compute_mode_openmarket, inputs=inputs, outputs=outputs, title="Excel Mode Calculator") | |
| # Create a Gradio interface | |
| inputs = gr.File(label="Upload Excel File") | |
| outputs = gr.File(label="Download Mode File") | |
| iface2 = gr.Interface(fn=compute_mode_wholesale, inputs=inputs, outputs=outputs, title="Excel Mode Calculator") | |
| # Create a Gradio interface | |
| inputs = gr.File(label="Upload Excel File") | |
| outputs = gr.File(label="Download Mode File") | |
| iface3 = gr.Interface(fn=compute_mode_Small_Supermarkets, inputs=inputs, outputs=outputs, title="Excel Mode Calculator") | |
| # Create a Gradio interface | |
| inputs = gr.File(label="Upload Excel File") | |
| outputs = gr.File(label="Download Mode File") | |
| iface4 = gr.Interface(fn=compute_mode_Large_supermarkets, inputs=inputs, outputs=outputs, title="Excel Mode Calculator") | |
| # Create a Gradio interface | |
| inputs = gr.File(label="Upload Excel File") | |
| outputs = gr.File(label="Download Mode File") | |
| iface5 = gr.Interface(fn=compute_mode_Neighbourhood_grocery, inputs=inputs, outputs=outputs, title="Excel Mode Calculator") | |
| # Launch the interface | |
| gr.TabbedInterface([iface1,iface2,iface3,iface4,iface5],tab_names=['Open Market','Wholesale','Small Supermarkets','Large Supermarkets','Neighbourhood Grocery']).launch(share=True) | |