vcf转csv(vcf转csv格式)

import pymysqlimport csvimport codecsdef get_conn(): conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='', db='wealth', charset='utf8') return conndef insert(cur, sql, args): cur.execute(sql, args)def read_csv_to_mysql(filename): with codecs.open(filename=filename, mode='r', encoding='utf-8') as f: reader = csv.reader(f) head = next(reader) conn = get_conn() cur = conn.cursor() sql = 'insert into csv values(%s,%s,%s)' for item in reader: if item[1] is None or item[1] == '': # item[1]作为唯一键，不能为null continue args = tuple(item) print(args) insert(cur, sql=sql, args=args) conn.commit() cur.close() conn.close()if __name__ == '__main__': print("ceshi") #read_csv_to_mysql('d:\cardno.csv') #字符串转16进制 print(int('0x60278be3', 16)) #数字转字符串 str(16)

使用注意

本文标签：