This project is an umbrella containing various web-apps using Streamlit. These are mostly small apps, with only few functions. They are listed as follows:
This app displays various features of a typical Sales Report Excel Spreadsheet - by collecting data using openpyxl and pandas, such as Total Sales, Average sales per transaction, etc. It uses plotly-express to display plots of Total Sales by hour, and Sales by product line. There is features to filter by city, customer-type, and gender - which is updated in real-time.
The Excel Spreadsheet used is supplied, supermarkt_sales.xlsx.
LIBRARIES USED: streamlit, plotly-express, pandas, openpyxl
This app allows the user to predict the expected salary of a Software Developer, given inputs like the Country, Education Level, and Years of Experience. The machine-learning model was created using scikit-learn, trained on data from the Stack Overflow Software Developer Survey 2022. This is a survey collecting relevant data from over 74k participants, as such, pandas was used to help with data handling and pre-processing. Some data-visualisation of the Salary vs Other Parameters was created using Matplotlib.
This app requires the user to download the survey file from the link above, and move the survey_results_public.csv file into the directory of this project. The user will have to run the SalaryPrediction.py file using the steps below to create a .pkl file which contains the Prediction model. Finally, the user can run the app.py file as below.
LIBRARIES USED: streamlit, scikit-learn, matplotlib, pandas, numpy
This app contains all streamlit widgets (within reasonable use). It does not contain explanations of all these widgets, it is simply meant to be a display of these as a way to learn what streamlit has to offer.
Helper files are supplied which are used, the user must download these.
LIBRARIES: streamlit, pandas, numpy, altair, plotly-expressm matplotlib
- Clone this project
- Create a virtual enviroment to be used, ideally in the same folder as this project
- Install the necessary libraries as detailed, using pip
pip install *library*
Note: ensure protobuf is of version 3.20.x or lower; usingpip install --upgrade protobuf==3.19.0
- Open the terminal in the directory of the desired script (CTRL + L, type
cmd
), or cd into it - Activate the Virtual Enviroment
*venv*\Scripts\activate
- Run the script using Streamlit
streamlit run *file*.py
Note: To close the app, CTRL + C on the terminal then close the browser