Skip to main content
 首页 » 编程设计

python之在python中写入csv文件时如何跳过一列

2025年02月15日13yyy_WW

很抱歉,如果有人问过这个问题,但是在写入 csv 文件时是否可以跳过一列?

这是我的代码:

with open("list.csv","r") as f: 
    reader2 = csv.reader(f) 
    for row in reader2: 
        url = 'http://peopleus.intelius.com/results.php?ReportType=33&qi=0&qk=10&qp='+row 
        req = urllib.request.Request(url) 
        response = urllib.request.urlopen(req) 
        html = response.read() 
        retrieved_name = b'class="singleName">(.*?)<\/h1' 
        retrieved_number = b'<div\sclass="phone">(.*?)<\/div' 
        retrieved_nothing = b"(Sorry\swe\scouldn\\'t\sfind\sany\sresults)" 
        if re.search(retrieved_nothing,html): 
            noth = re.search(retrieved_nothing.decode('utf-8'),html.decode('utf-8')).group(1) 
            add_list(phone_data, noth) 
        else: 
            if re.search(retrieved_name,html): 
                name_found = re.search(retrieved_name.decode('utf-8'),html.decode('utf-8')).group(1) 
            else: 
                name_found = "No name found on peopleus.intelius.com" 
            if re.search(retrieved_number,html): 
                number_found = re.search(retrieved_number.decode('utf-8'),html.decode('utf-8')).group(1) 
            else: 
                number_found = "No number found on peopleus.intelius.com" 
            add_list(phone_data, name_found, number_found) 
        with open('column_skip.csv','a+', newline='') as mess: 
            writ = csv.writer(mess, dialect='excel') 
            writ.writerow(phone_data[-1]) 
        time.sleep(10) 

假设 column_skip.csv 的前三行有数据,我可以让我的程序开始在第 4 列写入它的信息吗?

请您参考如下方法:

是啊,不要用csv.writer方法,写成简单的文件写操作:

  `file_path ='your_csv_file.csv' 
   with open(file_path, 'w') as fp: 
       #following are the data you want to write to csv 
       fp.write("%s, %s, %s" % ('Name of col1', 'col2', 'col4')) 
       fp.write("\n")` 

我希望这有助于...