使用python 读写文件

#读取文件,拼接成sql

list1 = ['zhihu', 'dongqiudi','zhongqingkandian']
# list1 = ['zhihu1']
result = 'D:/00files/result'
start = 'insert into media_user_profile(adx_id, adx_sub_id, device_type, device_id, positive_crowd, negative_crowd, is_white, is_black, has_user_id, is_credit, is_positive_app_installed, is_negative_app_Installed, has_erised, erised_score, is_negative_erised_profile, click) values (';
index = 0;
for item in list1:
    name = 'D:/00files/' + item + '.text'
    result = 'D:/00files/result' + item + '.text'
    # 读取文件
    fp = open(name)
    #写入
    mon = open(result, 'a')
    id = 0;
    for line in fp.readlines():
        #print(id)
        # with open(result, 'a') as mon:
        sql = '(';
        end = '),\n'
        arr = line.split('\t')
        arrsql = '';
        for arrItem in arr:
            arrsql += '"' + arrItem + '",'
        arrsql += '"false"'
        if id % 300 == 0:
            sql = start
        if id % 300 == 299:
            end = ');\n'
        if index == 1:
            sql += '"18","1",' + arrsql + end;
            mon.write(sql)
        if index == 2:
            sql += '"18","2",' + arrsql + end;
            mon.write(sql)
        if index == 0:
            sql += '"19","-1",' + arrsql + end;
            mon.write(sql)
        id += 1
    index += 1