はてなブックマーク

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

import cv2 def capture_camera(mirror=True, size=None): """Capture video from camera""" # カメラをキャプチャする cap = cv2.VideoCapture(0) # 0はカメラのデバイス番号 while True: # retは画像を取得成功フラグ ret, frame = cap.read() # 鏡のように映るか否か if mirror is True: frame = frame[:,::-1] # フレームをリサイズ # sizeは例えば(800, 600) if size is not None and len(size) == 2: frame = cv2.resize(frame, size) # フレームを表示する cv2.imshow('camera capture', frame

"""Get data from MySQL with pandas library.""" import MySQLdb import pandas.io.sql as psql con = MySQLdb.connect(db='work', user='root', passwd='') # DB接続 sql = """SELECT product_id, product_nm, product_features FROM electronics""" df = psql.read_sql(sql, con) # pandasのDataFrameの形でデータを取り出す con.close()