Try to operate DB with Python and visualize with d3

Do you know Kappa Sushi? It is a restaurant where you can eat various kinds of sushi at a low price. In this industry, conveyor belt sushi is called dynamic sushi or dynamic sushi. I like this kappa sushi very much, especially thick roasted eggs and egg heaven. I also like the Shinkansen. Recently I wanted to touch d3, so I tried it with Kappa Sushi.

environment

Python2.7
PostgreSQL
d3.js
Vagrant

Implementation

Source code I wanted suitable data, so I created random data with createcsv.py I'm a minor, so I omitted drinks with alcohol. See data.csv for details Let PostgreSQL read csv and create a new csv again with select sum (price), timestamp from kappa_count order by timestamp;. Load a new csv with d3.js, make a statistical graph like that, and finish. There may have been a more efficient way to create suitable random data.

Recommended Posts

Try to operate DB with Python and visualize with d3

Try to operate Facebook with Python

Try to bring up a subwindow with PyQt5 and Python

Try to reproduce color film with Python

Operate Jupyter with REST API to extract and save Python code

Fractal to make and play with Python

Try to operate Excel using Python (Xlwings)

Quickly try to visualize datasets with pandas

Try to display google map and geospatial information authority map with python

Operate home appliances with Python and IRKit

[Python] Try to recognize characters from images with OpenCV and pyocr

Try to make foldl and foldr with Python: lambda. Also time measurement

Try to poke DB on IBM i with python + JDBC using JayDeBeApi

[Python] Visualize and identify slow parts with pytest

Scraping tabelog with python and outputting to CSV

MessagePack-Try to link Java and Python with RPC

Try to solve the man-machine chart with Python

Try to extract Azure document DB document with pydocumentdb

Try to draw a life curve with python

Try to communicate with EV3 and PC! (MQTT)

Try to make a "cryptanalysis" cipher with Python

Try to automatically generate Python documents with Sphinx

Try to make a dihedral group with Python

Try to detect fish with python + OpenCV2.4 (unfinished)

Try scraping with Python.

Operate Kinesis with Python

Operate Blender with Python

Operate Excel with Python (1)

Operate Excel with Python (2)

Try to make BOT by linking spreadsheet and Slack with python 2/2 (python + gspread + slackbot)

Try to make BOT by linking spreadsheet and Slack with python 1/2 (python + gspread + slackbot)

I wanted to visualize 3D particle simulation with the Python visualization library Matplotlib.

WEB scraping with python and try to make a word cloud from reviews

Procedure to load MNIST with python and output to png

Try to solve the programming challenge book with python3

[First API] Try to get Qiita articles with Python

Try to make a command standby tool with python

I want to handle optimization with python and cplex

Try to visualize the room with Raspberry Pi, part 1

Try to solve the internship assignment problem with Python

Install selenium on Mac and try it with python

Visualize the range of interpolation and extrapolation with python

Parse and visualize JSON (Web application ⑤ with Python + Flask)

Try to automate pdf format report creation with Python

[Python] How to create a 2D histogram with Matplotlib

Something to enjoy with Prim Pro (X-Play) and Python

How to operate Discord API with Python (bot registration)

[Automation] Operate GitLab with Python to facilitate inquiry management

Perform a Twitter search from Python and try to generate sentences with Markov chains.

Connect realsense D435 to a PC with ubuntu 16.04 installed and save depth videos with python

Operate Excel with Python openpyxl

Try to factorial with recursion

Connect to BigQuery with Python

Encryption and decryption with Python

Operate Db2 container with Go

Operate TwitterBot with Lambda, Python

Python and hardware-Using RS232C with Python-

Try to understand Python self

Create 3d gif with python3

Try Python output with Haxe 3.2

Connect to Wikipedia with Python