Cool web based data analytical platform

Yesterday, I enjoyed mishima.syk#9. 😉 I hope all participants also enjoyed the meeting.
BTY, I found cool platform for data analysis, named “Superset”.
https://github.com/airbnb/superset
You can see cool review in README.md.
If reader who want to install superset, it is very easy.
For example in MacOS. Only use pip !

# Install superset
pip install superset
# Create an admin user
fabmanager create-admin --app superset
# Initialize the database
superset db upgrade
# Load some data to play with
superset load_examples
# Create default roles and permissions
superset init
# Start the web server on port 8088
superset runserver -p 8088
# To start a development web server, use the -d switch
# superset runserver -d

Now you can access localhost:8088.

The web app can easily connect database via SQLalchemy. So, I connect local ChEMBL DB for test.
Configuration is very simple. I used pyscopg2
dbconfig
And push the test connection, I got list of tables.
dbconfig2

Next, I tried to retrieve data from chembldb and visualize it. To do it, I wrote SQL query from SQLLab.
SQLLAB
SQL Lab return the results interactively! Coool.
Test SQL is follwing.

SELECT molregno, mw_freebase, alogp, psa, ro3_pass
FROM public.compound_properties
LIMIT 500

Then made dashboard, push the visualize button and set parameters. I used bubble chart for plot alogp vs mw.
I worked fine!
bubble chart
Also users can make many type of visualization from their own dataset. Including bar chart, sankey diagram, pie chart, line chart…. ( I did not try the visualizations. )

dash board

It is surprising for me, there are many nice open source tools. Javascript and python is good partner I think. ;-D

広告

コメントを残す

以下に詳細を記入するか、アイコンをクリックしてログインしてください。

WordPress.com ロゴ

WordPress.com アカウントを使ってコメントしています。 ログアウト / 変更 )

Twitter 画像

Twitter アカウントを使ってコメントしています。 ログアウト / 変更 )

Facebook の写真

Facebook アカウントを使ってコメントしています。 ログアウト / 変更 )

Google+ フォト

Google+ アカウントを使ってコメントしています。 ログアウト / 変更 )

%s と連携中