---
license: apache-2.0
title: Analyzedata
---
# Import necessary libraries
import streamlit as st
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

# Set the title of the app
st.title('Zali Ai')

# Allow the user to upload an Excel file
uploaded_file = st.file_uploader("Choose an Excel file", type='xlsx')

if uploaded_file is not None:
    # Load the Excel file into a pandas DataFrame
    data = pd.read_excel(uploaded_file)

    # Display the DataFrame
    st.dataframe(data)

    # Allow the user to select a column to visualize
    column_to_plot = st.selectbox('Select a column to visualize', data.columns)

    # Create a histogram for the selected column
    fig, ax = plt.subplots()
    sns.histplot(data[column_to_plot], ax=ax, kde=True)
    st.pyplot(fig)

    # Create a boxplot for the selected column
    fig, ax = plt.subplots()
    sns.boxplot(data[column_to_plot], ax=ax)
    st.pyplot(fig)

    # Create a violin plot for the selected column
    fig, ax = plt.subplots()
    sns.violinplot(data[column_to_plot], ax=ax)
    st.pyplot(fig)