MySQLdb.connect( host="127.0.0.1", user="root", passwd="root") "SELECT * FROM 憑單輸入每日" Use xlwt to write This slideshow requires JavaScript.

MySQLdb.connect CREATE DATABASE IF NOT EXISTS testdb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_unicode_ci CREATE TABLE IF NOT EXISTS...

Use xlrd to open a sheet data , then …….  fill up the Nan to 0 isnull().sum() df.fillna(0) Use xlwd to write a new files