SQLLITE Tool

可以從下列網址找到適合的 安裝版本

https:\/\/www.sqlite.org\/download.html

import json
import pprint
import sqlite3

filepath_db = "clickstream.db"

conn = sqlite3.connect(filepath_db)cursor = conn.cursor()

sql = "SELECT domain, creation_datetime, date_type, duration, active_duration, loading_duration, page_view, user_view, count_failed, count_session, count_logic, count_function, count_intention FROM stats_website LIMIT 100"

rows = cursor.execute(sql)
for row in rows:
    logic = json.loads(row[10])
    pprint.pprint(logic)

cursor.close()
conn.close()

D3.js

https:\/\/d3js.org

http:\/\/bl.ocks.org\/mbostock\/4062085

http:\/\/bl.ocks.org\/mbostock\/raw\/4062085\/population.csv

SimilarWeb

https:\/\/www.similarweb.com

Basic Python Tutorial

http:\/\/www.learnpython.org\/