로또 결과확인

import pandas as pd

import sqlite3

from tqdm import tqdm

from urllib.request import urlopen

import json

 

def lotto(chasu):

    url="http://www.dhlottery.co.kr/common.do?method=getLottoNumber&drwNo="+str(chasu)

 

    result_data = urlopen(url)

    result = result_data.read()

 

    data = json.loads(result)

    data_1 = pd.DataFrame.from_dict(data,orient='index')

    data_1=data_1.transpose()

 

    return data_1

 

for i in tqdm(range(1,100)):

    data_1=lotto(i)

    if data_1.loc[0,"returnValue"]=="fail":

        pass

    else:

        con = sqlite3.connect("본인디렉토리/data/lotto.db")

        data_1.to_sql('lent', con, if_exists='append', index=False)

        con.close()