资讯专栏INFORMATION COLUMN

开源的数据探查与可视化平台superset

1fe1se / 1975人阅读

摘要:安装远程主机强迫关闭了一个现有的连接。安装包测试连接参考数据可视化平台使用心得一小时建立数据分析平台

安装 pip superset
curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
python get-pip.py
λ pip install superset
Collecting superset
  Downloading https://files.pythonhosted.org/packages/80/98/8ffd47f4b68b11d00e0cad5a3a61b4e28a56bd79c47623c8c31e04faa8cb/superset-0.28.0.tar.gz (52.7MB)
    100% |████████████████████████████████| 52.7MB 88kB/s
Requirement already satisfied: bleach in d:pythonlibsite-packages (from superset) (2.1.4)
Requirement already satisfied: boto3==1.4.7 in d:pythonlibsite-packages (from superset) (1.4.7)
Requirement already satisfied: botocore<1.8.0,>=1.7.0 in d:pythonlibsite-packages (from superset) (1.7.48)
Requirement already satisfied: celery>=4.2.0 in d:pythonlibsite-packages (from superset) (4.2.1)
Requirement already satisfied: click==6.7 in d:pythonlibsite-packages (from superset) (6.7)

Requirement already satisfied: colorama==0.3.9 in d:pythonlibsite-packages (from superset) (0.3.9)
Requirement already satisfied: contextlib2 in d:pythonlibsite-packages (from superset) (0.5.5)
Requirement already satisfied: cryptography in d:pythonlibsite-packages (from superset) (2.3.1)
Requirement already satisfied: flask<1.0.0 in d:pythonlibsite-packages (from superset) (0.12.4)
Collecting flask-appbuilder>=1.12.0 (from superset)
  Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by "ProtocolError("Connection aborted.", ConnectionResetError(10054, "远程主机强迫
关闭了一个现有的连接。", None, 10054, None))": /simple/flask-appbuilder/
  Downloading https://files.pythonhosted.org/packages/ca/7b/a4c899095e1ca0eb732cca22934ce483b78b05329f37b97ae0e6e0e3f386/Flask-AppBuilder-1.12.1.tar.gz (2.3MB)
    100% |████████████████████████████████| 2.3MB 63kB/s
Requirement already satisfied: flask-caching in d:pythonlibsite-packages (from superset) (1.4.0)
Requirement already satisfied: flask-compress in d:pythonlibsite-packages (from superset) (1.4.0)
Requirement already satisfied: flask-migrate in d:pythonlibsite-packages (from superset) (2.2.1)
Requirement already satisfied: flask-wtf in d:pythonlibsite-packages (from superset) (0.14.2)
Requirement already satisfied: flower in d:pythonlibsite-packages (from superset) (0.9.2)
Requirement already satisfied: future<0.17,>=0.16.0 in d:pythonlibsite-packages (from superset) (0.16.0)
Requirement already satisfied: geopy in d:pythonlibsite-packages (from superset) (1.16.0)
Requirement already satisfied: gunicorn in d:pythonlibsite-packages (from superset) (19.9.0)
Requirement already satisfied: humanize in d:pythonlibsite-packages (from superset) (0.5.1)

Requirement already satisfied: idna in d:pythonlibsite-packages (from superset) (2.7)
Requirement already satisfied: isodate in d:pythonlibsite-packages (from superset) (0.6.0) Collecting markdown>=3.0 (from superset)
  Downloading https://files.pythonhosted.org/packages/7a/6b/5600647404ba15545ec37d2f7f58844d690baf2f81f3a60b862e48f29287/Markdown-3.0.1-py2.py3-none-any.whl (89kB)
    100% |████████████████████████████████| 92kB 38kB/s
Requirement already satisfied: pandas>=0.18.0 in d:pythonlibsite-packages (from superset) (0.23.4)
Requirement already satisfied: parsedatetime in d:pythonlibsite-packages (from superset) (2.4)
Requirement already satisfied: pathlib2 in d:pythonlibsite-packages (from superset) (2.3.2)

Requirement already satisfied: polyline in d:pythonlibsite-packages (from superset) (1.3.2)

Requirement already satisfied: pydruid>=0.4.3 in d:pythonlibsite-packages (from superset) (0.4.5)
Requirement already satisfied: pyhive>=0.4.0 in d:pythonlibsite-packages (from superset) (0.6.0)
Requirement already satisfied: python-dateutil in d:pythonlibsite-packages (from superset) (2.7.3)
Requirement already satisfied: python-geohash in d:pythonlibsite-packages (from superset) (0.8.5)
Requirement already satisfied: pyyaml>=3.11 in d:pythonlibsite-packages (from superset) (3.13)
Requirement already satisfied: requests in d:pythonlibsite-packages (from superset) (2.19.1)
Requirement already satisfied: simplejson>=3.15.0 in d:pythonlibsite-packages (from superset) (3.16.0)
Requirement already satisfied: sqlalchemy in d:pythonlibsite-packages (from superset) (1.2.11)
Requirement already satisfied: sqlalchemy-utils in d:pythonlibsite-packages (from superset) (0.33.3)
Requirement already satisfied: sqlparse in d:pythonlibsite-packages (from superset) (0.2.4)

Collecting tableschema (from superset)
  Downloading https://files.pythonhosted.org/packages/28/29/2fd3744510a745bee4735bd34cb44f9a0cc02e646d929a40aa5b2f8b85d8/tableschema-1.2.5-py2.py3-none-any.whl (55kB)
    100% |████████████████████████████████| 61kB 77kB/s
Requirement already satisfied: thrift>=0.9.3 in d:pythonlibsite-packages (from superset) (0.11.0)
Requirement already satisfied: thrift-sasl>=0.2.1 in d:pythonlibsite-packages (from superset) (0.3.0)
Requirement already satisfied: unicodecsv in d:pythonlibsite-packages (from superset) (0.14.1)
Requirement already satisfied: unidecode>=0.04.21 in d:pythonlibsite-packages (from superset) (1.0.22)
Requirement already satisfied: html5lib!=1.0b1,!=1.0b2,!=1.0b3,!=1.0b4,!=1.0b5,!=1.0b6,!=1.0b7,!=1.0b8,>=0.99999999pre in d:pythonlibsite-packages (from bleach->superset) (1.0.1)
Requirement already satisfied: six in d:pythonlibsite-packages (from bleach->superset) (1.11.0)
Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in d:pythonlibsite-packages (from boto3==1.4.7->superset) (0.9.3)
Requirement already satisfied: s3transfer<0.2.0,>=0.1.10 in d:pythonlibsite-packages (from boto3==1.4.7->superset) (0.1.13)
Requirement already satisfied: docutils>=0.10 in d:pythonlibsite-packages (from botocore<1.8.0,>=1.7.0->superset) (0.14)
Requirement already satisfied: pytz>dev in d:pythonlibsite-packages (from celery>=4.2.0->superset) (2018.5)
Requirement already satisfied: billiard<3.6.0,>=3.5.0.2 in d:pythonlibsite-packages (from celery>=4.2.0->superset) (3.5.0.4)
Requirement already satisfied: kombu<5.0,>=4.2.0 in d:pythonlibsite-packages (from celery>=4.2.0->superset) (4.2.1)
Requirement already satisfied: asn1crypto>=0.21.0 in d:pythonlibsite-packages (from cryptography->superset) (0.24.0)
Requirement already satisfied: cffi!=1.11.3,>=1.7 in d:pythonlibsite-packages (from cryptography->superset) (1.11.5)
Requirement already satisfied: Jinja2>=2.4 in d:pythonlibsite-packages (from flask<1.0.0->superset) (2.10)
Requirement already satisfied: itsdangerous>=0.21 in d:pythonlibsite-packages (from flask<1.0.0->superset) (0.24)
Requirement already satisfied: Werkzeug>=0.7 in d:pythonlibsite-packages (from flask<1.0.0->superset) (0.14.1)
Requirement already satisfied: Flask-Babel<1,>=0.11.1 in d:pythonlibsite-packages (from flask-appbuilder>=1.12.0->superset) (0.11.1)
Collecting Flask-Login<0.5,>=0.3 (from flask-appbuilder>=1.12.0->superset)
  Downloading https://files.pythonhosted.org/packages/c1/ff/bd9a4d2d81bf0c07d9e53e8cd3d675c56553719bbefd372df69bf1b3c1e4/Flask-Login-0.4.1.tar.gz
Requirement already satisfied: Flask-OpenID<2,>=1.2.5 in d:pythonlibsite-packages (from flask-appbuilder>=1.12.0->superset) (1.2.5)
Collecting Flask-SQLAlchemy<3,>=2.3 (from flask-appbuilder>=1.12.0->superset)
  Downloading https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Requirement already satisfied: alembic>=0.7 in d:pythonlibsite-packages (from flask-migrate->superset) (1.0.0)
Requirement already satisfied: WTForms in d:pythonlibsite-packages (from flask-wtf->superset) (2.2.1)
Requirement already satisfied: tornado>=4.2.0 in d:pythonlibsite-packages (from flower->superset) (5.1)
Requirement already satisfied: babel>=1.0 in d:pythonlibsite-packages (from flower->superset) (2.6.0)
Requirement already satisfied: geographiclib<2,>=1.49 in d:pythonlibsite-packages (from geopy->superset) (1.49)
Requirement already satisfied: numpy>=1.9.0 in d:pythonlibsite-packages (from pandas>=0.18.0->superset) (1.15.1)
Requirement already satisfied: certifi>=2017.4.17 in d:pythonlibsite-packages (from requests->superset) (2018.8.24)
Requirement already satisfied: chardet<3.1.0,>=3.0.2 in d:pythonlibsite-packages (from requests->superset) (3.0.4)
Requirement already satisfied: urllib3<1.24,>=1.21.1 in d:pythonlibsite-packages (from requests->superset) (1.23)
Requirement already satisfied: jsonschema<3.0,>=2.5 in d:pythonlibsite-packages (from tableschema->superset) (2.6.0)
Requirement already satisfied: rfc3986<2.0,>=1.1.0 in d:pythonlibsite-packages (from tableschema->superset) (1.1.0)
Collecting tabulator<2.0,>=1.3 (from tableschema->superset)
  Downloading https://files.pythonhosted.org/packages/63/a6/33d0b08ce84fd1cdf0fb57e81bc822345007dd698cc5273b7ef916fce5ed/tabulator-1.17.0-py2.py3-none-any.whl (50kB)
    100% |████████████████████████████████| 51kB 168kB/s
Requirement already satisfied: pure-sasl>=0.3.0 in d:pythonlibsite-packages (from thrift-sasl>=0.2.1->superset) (0.5.1)
Requirement already satisfied: webencodings in d:pythonlibsite-packages (from html5lib!=1.0b1,!=1.0b2,!=1.0b3,!=1.0b4,!=1.0b5,!=1.0b6,!=1.0b7,!=1.0b8,>=0.99999999pre->bleach->superset) (0.5.1)
Requirement already satisfied: amqp<3.0,>=2.1.4 in d:pythonlibsite-packages (from kombu<5.0,>=4.2.0->celery>=4.2.0->superset) (2.3.2)
Requirement already satisfied: pycparser in d:pythonlibsite-packages (from cffi!=1.11.3,>=1.7->cryptography->superset) (2.18)
Requirement already satisfied: MarkupSafe>=0.23 in d:pythonlibsite-packages (from Jinja2>=2.4->flask<1.0.0->superset) (1.0)
Requirement already satisfied: python3-openid>=2.0 in d:pythonlibsite-packages (from Flask-OpenID<2,>=1.2.5->flask-appbuilder>=1.12.0->superset) (3.1.0)
Requirement already satisfied: python-editor>=0.3 in d:pythonlibsite-packages (from alembic>=0.7->flask-migrate->superset) (1.0.3)
Requirement already satisfied: Mako in d:pythonlibsite-packages (from alembic>=0.7->flask-migrate->superset) (1.0.7)
Requirement already satisfied: xlrd<2.0,>=1.0 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: linear-tsv<2.0,>=1.0 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: jsonlines<2.0,>=1.1 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.2.0)
Requirement already satisfied: openpyxl<2.5,>=2.4 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (2.4.11)
Collecting cchardet<3.0,>=1.0 (from tabulator<2.0,>=1.3->tableschema->superset)
  Downloading https://files.pythonhosted.org/packages/dd/6a/6b54a269caa3518b6eaab3aec0fa4fa9eaa8019b4ae84a7c3ef66b1f9be0/cchardet-2.1.4-cp37-cp37m-win32.whl (89kB)
    100% |████████████████████████████████| 92kB 184kB/s
Requirement already satisfied: ijson<3.0,>=2.0 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (2.3)
Requirement already satisfied: vine>=1.1.3 in d:pythonlibsite-packages (from amqp<3.0,>=2.1.4->kombu<5.0,>=4.2.0->celery>=4.2.0->superset) (1.1.4)
Requirement already satisfied: defusedxml in d:pythonlibsite-packages (from python3-openid>=2.0->Flask-OpenID<2,>=1.2.5->flask-appbuilder>=1.12.0->superset) (0.5.0)
Requirement already satisfied: jdcal in d:pythonlibsite-packages (from openpyxl<2.5,>=2.4->tabulator<2.0,>=1.3->tableschema->superset) (1.4)
Requirement already satisfied: et-xmlfile in d:pythonlibsite-packages (from openpyxl<2.5,>=2.4->tabulator<2.0,>=1.3->tableschema->superset) (1.0.1)
Installing collected packages: Flask-Login, Flask-SQLAlchemy, flask-appbuilder, markdown, cchardet, tabulator, tableschema, superset
  Found existing installation: Flask-Login 0.2.11
    Uninstalling Flask-Login-0.2.11:
      Successfully uninstalled Flask-Login-0.2.11
  Running setup.py install for Flask-Login ... done
  Found existing installation: Flask-SQLAlchemy 2.1
    Uninstalling Flask-SQLAlchemy-2.1:
      Successfully uninstalled Flask-SQLAlchemy-2.1
  Found existing installation: Flask-AppBuilder 1.10.0
    Uninstalling Flask-AppBuilder-1.10.0:
      Successfully uninstalled Flask-AppBuilder-1.10.0
  Running setup.py install for flask-appbuilder ... done
  Found existing installation: Markdown 2.6.11
    Uninstalling Markdown-2.6.11:
      Successfully uninstalled Markdown-2.6.11
  Running setup.py install for superset ... done
Successfully installed Flask-Login-0.4.1 Flask-SQLAlchemy-2.3.2 cchardet-2.1.4 flask-appbuilder-1.12.1 markdown-3.0.1 superset-0.28.0 tableschema-1.2.5 tabulator-1.17.0
You are using pip version 18.0, however version 18.1 is available.
You should consider upgrading via the "python -m pip install --upgrade pip" command.

# 创建管理员帐号
fabmanager create-admin --app superset
Username [admin]: xxx
User first name [admin]: xxx
User last name [user]: xxx
Email [admin@fab.org]: xxx@qq.cn
Password:
Repeat for confirmation:
Recognized Database Authentications.
Admin User xxx created.

# 初始化数据库 (windows下,先进入到
Python安装目录(或者virtualEnv的虚拟目录)下,libsite-packagessupersetin下)
cd /d/python/lib/site-packages/superset/bin
Python superset db upgrade
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL
# 加载例子(后续操作都需要在libsite-packagessupersetin下)
Python superset load_examples
2018-10-18 20:36:31,358:INFO:root:Creating database reference
2018-10-18 20:36:31,401:INFO:root:Database.get_sqla_engine(). Masked URL: sqlite:///C:Usersxxx.supersetsuperset.db
2018-10-18 20:36:42,164:INFO:root:Creating database reference
2018-10-18 20:36:44,521:INFO:root:Creating database reference
2018-10-18 20:36:45,654:INFO:root:Creating database reference
2018-10-18 20:37:02,201:INFO:root:Creating database reference
2018-10-18 20:37:02,378:INFO:root:Creating database reference
2018-10-18 20:37:02,547:INFO:root:Creating database reference
2018-10-18 20:37:04,243:INFO:root:Creating database reference
2018-10-18 20:37:04,380:INFO:root:Creating database reference
2018-10-18 20:37:08,631:INFO:root:Creating database reference
2018-10-18 20:37:08,789:INFO:root:Creating database reference
2018-10-18 20:37:19,065:INFO:root:Creating database reference
2018-10-18 20:37:21,217:INFO:root:Creating database reference
Loading examples into 
Creating default CSS templates
Loading energy related dataset
Creating table [wb_health_population] reference
Loading [World Bank"s Health Nutrition and Population Stats]
Creating table [wb_health_population] reference
Creating slices
Creating a World"s Health Bank dashboard
Loading [Birth names]
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
Creating some slices
Creating a dashboard
Loading [Random time series data]
Done loading table!
--------------------------------------------------------------------------------
Creating table [random_time_series] reference
Creating a slice
Loading [Random long/lat data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
Creating a slice
Loading [Country Map data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
Creating a slice
Loading [Multiformat time series]
Done loading table!
--------------------------------------------------------------------------------
Creating table [multiformat_time_series] reference
Creating Heatmap charts
Loading [Paris GeoJson]
Creating table paris_iris_mapping reference
Loading [San Francisco population polygons]
Creating table sf_population_polygons reference
Loading [Flights data]
Done loading table!
Loading [BART lines]
Creating table bart_lines reference
Loading [Multi Line]
Creating table [wb_health_population] reference
Creating slices
Creating a World"s Health Bank dashboard
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
Creating some slices
Creating a dashboard
Loading [Misc Charts] dashboard
Creating the dashboard
Loading DECK.gl demo
Loading deck.gl dashboard
Creating Scatterplot slice
Creating Screen Grid slice
Creating Hex slice
Creating Grid slice
Creating Polygon slice
Creating Arc slice
Creating Path slice
Creating a dashboard

# 初始化角色和权限
Python superset init
2018-10-18 20:38:30,683:INFO:root:Creating database reference
2018-10-18 20:38:30,690:INFO:root:Syncing role definition
2018-10-18 20:38:30,697:INFO:root:Syncing Admin perms
2018-10-18 20:38:30,771:INFO:root:Syncing Alpha perms
2018-10-18 20:38:30,845:INFO:root:Syncing Gamma perms
2018-10-18 20:38:30,919:INFO:root:Syncing granter perms
2018-10-18 20:38:30,993:INFO:root:Syncing sql_lab perms
2018-10-18 20:38:31,072:INFO:root:Fetching a set of all perms to lookup which ones are missing
2018-10-18 20:38:31,174:INFO:root:Creating missing datasource permissions.
2018-10-18 20:38:31,182:INFO:root:Creating missing database permissions.
2018-10-18 20:38:31,184:INFO:root:Creating missing metrics permissions
2018-10-18 20:38:31,216:INFO:root:Cleaning faulty perms
$ python superset runserver
2018-10-18 20:38:48,839:INFO:root:The Gunicorn "superset runserver" command is deprecated. Please use the "gunicorn" command instead.
Traceback (most recent call last):
  File "d:pythonlib
unpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "d:pythonlib
unpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "D:pythonScriptsgunicorn.exe\__main__.py", line 5, in 
  File "d:pythonlibsite-packagesgunicornappwsgiapp.py", line 9, in 
    from gunicorn.app.base import Application
  File "d:pythonlibsite-packagesgunicornappase.py", line 12, in 
    from gunicorn import util
  File "d:pythonlibsite-packagesgunicornutil.py", line 9, in 
    import fcntl
ModuleNotFoundError: No module named "fcntl"
Starting server with command:
gunicorn -w 2 --timeout 60 -b  0.0.0.0:8088 --limit-request-line 0 --limit-request-field_size 0 superset:app
# 启动服务,端口 8088, 使用 -p 更改端口号。
Python superset runserver -d
2018-10-18 20:40:14,223:INFO:werkzeug: * Restarting with stat
2018-10-18 20:40:17,704:WARNING:werkzeug: * Debugger is active!
2018-10-18 20:40:17,720:INFO:werkzeug: * Debugger PIN: 139-127-258
2018-10-18 20:40:17,732:INFO:werkzeug: * Running on http://0.0.0.0:8088/ (Press CTRL+C to quit)
安装MySQL包
λ pip install mysqlclient
Collecting mysqlclient
  Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f7344d1cb31f128e6dbba70c5975c9e57896815dbb1988ad/mysqlclient-1.3.13.tar.gz
Installing collected packages: mysqlclient
  Running setup.py install for mysqlclient ... error
    Complete output from command d:pythonpython.exe -u -c "import setuptools, tokenize;__file__="C:UsersxxxxAppDataLocalTemppip-install-wmrhs8m3mysqlclientsetup.py";f=getattr(tokenize, "open", open)(__file__);code=f.read().replace("
", "
");f.close();exec(compile(code, __file__, "exec"))" install --record C:UsersxxxxAppDataLocalTemppip-record-z4r5l4fyinstall-record.txt --single-version-externally-managed --compile:
    d:pythonlibdistutilsdist.py:274: UserWarning: Unknown distribution option: "long_description_content_type"
      warnings.warn(msg)
    running install
    running build
    running build_py
    creating build
    creating buildlib.win32-3.7
    copying _mysql_exceptions.py -> buildlib.win32-3.7
    creating buildlib.win32-3.7MySQLdb
    copying MySQLdb\__init__.py -> buildlib.win32-3.7MySQLdb
    copying MySQLdbcompat.py -> buildlib.win32-3.7MySQLdb
    copying MySQLdbconnections.py -> buildlib.win32-3.7MySQLdb
    copying MySQLdbconverters.py -> buildlib.win32-3.7MySQLdb
    copying MySQLdbcursors.py -> buildlib.win32-3.7MySQLdb
    copying MySQLdb
elease.py -> buildlib.win32-3.7MySQLdb
    copying MySQLdb	imes.py -> buildlib.win32-3.7MySQLdb
    creating buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstants\__init__.py -> buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstantsCLIENT.py -> buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstantsCR.py -> buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstantsER.py -> buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstantsFIELD_TYPE.py -> buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstantsFLAG.py -> buildlib.win32-3.7MySQLdbconstants
    copying MySQLdbconstantsREFRESH.py -> buildlib.win32-3.7MySQLdbconstants
    running build_ext
    building "_mysql" extension
    error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": http://landinghub.visualstudio.com/visual-cpp-build-tools

    ----------------------------------------
Command "d:pythonpython.exe -u -c "import setuptools, tokenize;__file__="C:UsersxxxAppDataLocalTemppip-install-wmrhs8m3mysqlclientsetup.py";f=getattr(tokenize, "open", open)(__file__);code=f.read().replace("
", "
");f.close();exec(compile(code, __file__, "exec"))" install --record C:UsersxxxAppDataLocalTemppip-record-z4r5l4fyinstall-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:UsersxxxAppDataLocalTemppip-install-wmrhs8m3mysqlclient

$ curl https://download.lfd.uci.edu/pythonlibs/h2ufg7oq/mysqlclient-1.3.13-cp37-cp37m-win32.whl -o  mysqlclient-1.3.13-cp37-cp37m-win32.whl
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 1211k  100 1211k    0     0   2087      0  0:09:54  0:09:54 --:--:-- 26499

$ pip install mysqlclient-1.3.13-cp37-cp37m-win32.whl
Processing d:codemysqlclient-1.3.13-cp37-cp37m-win32.whl
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.3.13
测试连接

参考

http://timd.cn/superset/
https://www.v2ex.com/amp/t/43...
https://blog.csdn.net/qq_3344...
https://zhuanlan.zhihu.com/p/...
https://www.cnblogs.com/calmz...
https://www.cnblogs.com/calmz...
https://www.jianshu.com/p/b37...
https://stackoverflow.com/que...
https://www.cnblogs.com/shaos...
https://blog.csdn.net/qq27368...
https://www.jianshu.com/p/a6f...
https://github.com/apache/inc...
数据可视化平台superset使用心得
一小时建立数据分析平台

文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。

转载请注明本文地址:https://www.ucloud.cn/yun/44921.html

相关文章

  • [原]解密Airbnb 自助BI神器:Superset 颠覆 Tableau

    摘要:概述我非常认同前百度数据工程师现神策分析创始人桑老师最近谈到的数据分析三重境界统计计数多维分析机器学习数据分析的统计计数和多维分析,我们通常称之为数据探索式分析,这个步骤旨在了解数据的特性,有助于我们进一步挖掘数据的价值。 showImg(https://camo.githubusercontent.com/f98421e503a81176b003ddd310d97e1e1214625...

    Keagan 评论0 收藏0
  • Superset搭建及其简单使用

    摘要:背景老板一直反馈说我们给不了他想要的关键每次他想要的都不一样每实现一个新功能他就想要一堆相关的信息我要将这些信息都给他做成网页用图表展示出来各种维度搜索这还不得累死这帮开发小伙伴所以对于他这种需求我基本都予以回绝坚决不做不过口头说不做也深知 背景 老板一直反馈说我们给不了他想要的, 关键每次他想要的都不一样, 每实现一个新功能, 他就想要一堆相关的信息, 我要将这些信息都给他做成网页,...

    YPHP 评论0 收藏0
  • Linux下安装Superset

    Superset是开源的数据分析与可视化平台。 在安装Superset时遇到很多坑: 1.环境:Windows,Python3,各种花式报错,数都数不过来,还装了好几遍VS2015、VS2017都失败告终 2.环境:Centos7,Python3,安装时只要报错,一般就卡在那装不下去 成功安装:环境:Centos7,Python2.7,就是系统自带的Python版本 安装步骤(感谢superset...

    sunny5541 评论0 收藏0
  • Apache Superset使用分享

    摘要:请原谅我以下所有截图中都是使用的中文,有些地方翻译略显生硬。本来系统是使用的英文,奈何领导要求中文呀。时间字段的表示时间属性必须勾选上一般会时间列默认勾选。可根据来排查问题所在,并且系统为用户提供版的查询工具来操作数据库。Superset简介 Superset是一个受Apache软件基金会支持的处于孵化阶段的企业级数据可视化web项目。具有以下特点: 内含丰富的数据图表样式 支持多种数据源...

    mdluo 评论0 收藏0
  • k8s数据分析--利用redash做自助数据分析

    摘要:通过数据分析和挖掘,让数据产生价值。数据可视化是大数据的最后一公里,做好可视化是对于数据分析是重要的。今天,主要介绍这款数据分析的利器。相比除了上手简单,支持等时序数据库。这点对于监控数据分析很有优势。数据源包括时序数据库,和业务库。 前言 在之前文章中,一直讲prometheus的metrics以及apm的指标的重要性,多侧重于收据的收集和存储。如果不对这些数据进行数据分析,那么就没...

    lykops 评论0 收藏0

发表评论

0条评论

最新活动
阅读需要支付1元查看
<