<jupyter_start><jupyter_text>**Table for Django**Django Web 서비스를 위한 Table 만들기 **1 Loading the table**엑셀 원본데이터 불러오기<jupyter_code>from glob import glob
file_list = sorted(glob("../Arterior/*.csv"))
file_list<jupyter_output><empty_output><jupyter_text>**2 Artist Table**작가 테이블로 나누기```pythonsqlite3.connect('./db.sqlite3')con = sqlite3.connect('./db.sqlite3').cursor()con.execute('DELETE from arterior_artist')con.fetchall()```<jupyter_code>import pandas as pd
file = '../Arterior/artist.csv'
table = pd.read_csv(file, header=None)
table[3] = table[3].fillna('000-000-0000')
table[4] = table[4].fillna('<EMAIL>')
# table.to_csv(file.replace('.csv', 'v2.csv'), header=None, index=None)
name_index = {_ : no+1 for no, _ in enumerate(table.iloc[:,0].to_list())}
table.head(2)<jupyter_output><empty_output><jupyter_text>**2 Store Table**작가 테이블로 나누기<jupyter_code># Artist Index Table 만들기
file = '../Arterior/store.csv'
table = pd.read_csv(file)
table = table.drop(columns=['fix','no'])
table = table.loc[:, ['title','artist','type','ceo','phone',\
    'address','addressfull','addressroad','lon','lat']]
table.to_csv(file.replace('.csv', 'v2.csv'), header=None, index=None)
table.head(3)<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.20447019867549668, 'fraction_numerical': 0.022350993377483443, 'mean_word_length': 7.697841726618705, 'pattern_counts': {'":': 0, '<': 14, '<?xml version=': 0, '>': 14, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '398642', 'license': 'Unlicense', 'n_tokens_mistral': 500, 'n_tokens_neox': 516, 'n_words': 73, 'path': 'jupyters/at7_dataset.ipynb', 'repo_name': 'Cobaltscoop/Machine-Learning', 'size': '1216'}