Pandas in jupyter

June 17, 2018

Read data from mysql and draw a chart.

%matplotlib inline
import pymysql
import pandas as pd
import pandas.io.sql as sql

conn = pymysql.connect(host='192.168.56.1', user='root', passwd='qwer-1235', db='pdss')

s = 'select number_value from quality_data_item_record where item_id = 11'
df = sql.read_sql_query(s, conn)

df.plot()