The purpose of this project is to develop a series of screen displays in the form of a web application to illustrate and visualize data from the Tailong Finance School of Zhejiang Gongshang University. This project leverages MySQL for data storage, Python for data processing, and Dash for data visualization and web application development.
- MySQL: For storing and managing the data.
- Python: For data processing and analysis.
- Dash: For creating interactive web applications to display the data.
The project is organized into the following folders:
- Assets: Contains materials, figures, and other useful resources.
- Code: Contains the code developed for the screen displays.
- Data: Contains some sample data and data descriptions.
Ensure you have the following installed on your system:
- Python 3.x
- MySQL
- pip (Python package installer)
Install the required Python libraries using pip:
pip install dash plotly pandas sqlalchemy mysql-connector-python
Set up a MySQL database and import your data. Update the database connection details in your code as necessary.
-
Set Up the Database:
- Ensure your MySQL database is running and contains the required data.
- Update the database connection details in the code files.
-
Run the Dash Application:
- Navigate to the
Code
directory. - Run the main application file (e.g.,
app.py
):python app.py
- Navigate to the
-
Access the Application:
- Open a web browser and navigate to
http://127.0.0.1:8050/
orhttp://localhost:8050/
to view the application.
- Open a web browser and navigate to
This folder contains materials, figures, and other useful resources used in the project. This may include images, icons, and other media files that are displayed in the web application.
This folder contains the Python code developed for the screen displays. Each file in this directory corresponds to different parts of the web application. Below is a brief description of key files:
app.py
: The main application file that initializes and runs the Dash app.data_processing.ipynb
: Contains functions and scripts for processing data from the MySQL database.dash_trial.ipynb
: Contains functions for generating various plots and visualizations using Dash and Plotly.
This folder contains sample data and data descriptions. It is used for testing and demonstration purposes. Below is a brief description of key files:
sample_data.csv
: A sample dataset used for initial testing and development.data_access.ipynb
: A text file describing the sample data and its structure.
This project is licensed under the MIT License. See the LICENSE file for more details.
For any questions or further information, please contact:
- Xinyu Song, Kun Yu, He Ni
- Tailong Finance School, Zhejiang Gongshang University