con = sqlite3.connect("testDB") # DB 생성
cur = con.cursor() # DB 연결
cur.execute("create table jejutourist2(\ # 테이블, 스키마 생성
    ...
)

wb = xlrd.open_workbook('C:/data/jejuall.xls') # 엑셀 열기

# 엑셀 -> DB insert
i=0
while i < wb.nsheets:
    sh = wb.sheet_by_index(i)
    print(sh.name, sh.nrows, sh.ncols)
    cur.execute("insert into jejutourist2 values (?,?,?,?,?,?,\
                                           ?,?,?,?,?,\
                                           ?,?,?,?,?,\
                                           ?,?,?,?)", 
                (i+1,\
                 (((str(sh.cell(2,6))).split("'"))[1])[:4],\
                 (((str(sh.cell(0,0))).split())[1]).rstrip("월"),\
                 ...

if a=='2016':
    for row in cur.execute("select year,max(sum(f_japan), sum(f_china), sum(f_hongkong), sum(f_taiwan), sum(f_singapore), sum(f_malasia), sum(f_usa)) as dum_of_d_group \
                            from jejutourist2\
                            where year=2016;"):

fig=plt.figure() # plot 초기 생성
a=fig.add_subplot(1,3,1) # subplot
cur.execute("select sum(f_japan), sum(f_china), sum(f_hongkong), sum(f_taiwan), sum(f_singapore), sum(f_malasia), sum(f_usa) as dum_of_d_group \
                            from jejutourist2\
                            where year=2016;")
rows = cur.fetchall() # 위에서 추가한 모든 데이터 가져오기
print(rows)
ratio = rows
labels = ['japan','china','hongkong','taiwan','singapore','malasia','usa']
plt.pie(ratio, labels=labels, autopct='%1.1f%%', shadow=True, startangle=90)