multi-dashboards

Automation dashboards using echarts+python+mysql (resposive web design)

The source data ('mortgage.csv' and 'Data_Product Hierarchy.xlsx') in sources/

1. readcsv.py: directly read and process data from 'mortgage.csv'. to check the result, just modify the app.py file as below:

2. mysql.sql: DDL statements, create tables 'Acct_perf', 'DATA_PRODUCT_MAPPING_LKP' and view 'VW_RESD_MTGE_OA_RISK' in mysql.

3. postgresql.sql: DDL statements, create tables 'Acct_perf', 'DATA_PRODUCT_MAPPING_LKP' and view 'VW_RESD_MTGE_OA_RISK' in postgresql. postgresql is case sensitive, create table "Test"... and create table Test... are different. In SqlAlchemy, any table name or column name including uppercase letters will be added "" autometicly.

4. models.py: ETL source data into database (mysql | postgresql).

5. readdatabase.py: read and process data from view 'VW_RESD_MTGE_OA_RISK'. to check the result, just modify the app.py file as below:

6. resposive web design:

keywords: echarts, javascript, jquery, ajax, html, css, python, pandas, flask, sqlalchemy, mysql, postgresql