Python CSV不会将数据写入文件(Python CSV not writing data to file)

 我正在碰壁。 我是使用python编写CSV文件的新手，并且已经阅读了很多关于该主题的不同帖子，但现在我遇到了这个并且可以使用一点帮助。 
 
import csv
#headers from the read.csv file that I wan't to parse and write to the new file.
headers = ['header1', 'header5', 'header6', 'header7']
#open the write.csv file to write the data to
with open("write.csv", 'wb') as csvWriter:
    writer = csv.writer(csvWriter)
#open the main data file that I want to parse data out of and write to write.csv
with open('reading.csv') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',' )
    csvList = list(readCSV)
    #finds where the position of the data I want to pull out and write to write.csv
    itemCode = csvList[0].index(headers[0])
    vendorName = csvList[0].index(headers[1])
    supplierID = csvList[0].index(headers[2])
    supplierItemCode = csvList[0].index(headers[3])
    for row in readCSV:
        writer.writerow([row[itemCode], row[vendorName], row[supplierID], row[supplierItemCode]])
    csvWriter.close()
 
 ---更新---我做了修改建议并尝试评论代码的以下部分并将'wb'更改为'w'并且程序正常运行。 但是，我不明白为什么，以及如何设置它以便我可以列出我想要提取的标题？ 
 
csvList = list(readCSV)
itemCode = csvList[0].index(headers[0])
vendorName = csvList[0].index(headers[1])
supplierID = csvList[0].index(headers[2])
supplierItemCode = csvList[0].index(headers[3])
 
 这是我更新的代码： 
 
 headers = ['header1', 'header5', 'header6', 'header7']
    #open the write.csv file to write the data to
    with open("write.csv", 'wb') as csvWriter, open('reading.csv') as csvfile:
        writer = csv.writer(csvWriter)
        readCSV = csv.reader(csvfile, delimiter=',' )
        """csvList = list(readCSV)
        #finds where the position of the data I want to pull out and write to write.csv
        itemCode = csvList[0].index(headers[0])
        vendorName = csvList[0].index(headers[1])
        supplierID = csvList[0].index(headers[2])
        supplierItemCode = csvList[0].index(headers[3])"""
        for row in readCSV:
            writer.writerow([row[0], row[27], row[28], row[29]])

I am running into a wall with this. I am new to writing CSV files with python and have been reading lots of different posts on the topic, but now I ran into a wall with this and could use a little help.
 
import csv
#headers from the read.csv file that I wan't to parse and write to the new file.
headers = ['header1', 'header5', 'header6', 'header7']
#open the write.csv file to write the data to
with open("write.csv", 'wb') as csvWriter:
    writer = csv.writer(csvWriter)
#open the main data file that I want to parse data out of and write to write.csv
with open('reading.csv') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',' )
    csvList = list(readCSV)
    #finds where the position of the data I want to pull out and write to write.csv
    itemCode = csvList[0].index(headers[0])
    vendorName = csvList[0].index(headers[1])
    supplierID = csvList[0].index(headers[2])
    supplierItemCode = csvList[0].index(headers[3])
    for row in readCSV:
        writer.writerow([row[itemCode], row[vendorName], row[supplierID], row[supplierItemCode]])
    csvWriter.close()
 
---UPDATE--- I made the changes suggested and tried commenting out the following part of the code & changing 'wb' to 'w' and the program worked. However, I don't understand why, and how do I set this up so that I can list the header I want to pull out?
 
csvList = list(readCSV)
itemCode = csvList[0].index(headers[0])
vendorName = csvList[0].index(headers[1])
supplierID = csvList[0].index(headers[2])
supplierItemCode = csvList[0].index(headers[3])
 
Here is my updated code:
 
 headers = ['header1', 'header5', 'header6', 'header7']
    #open the write.csv file to write the data to
    with open("write.csv", 'wb') as csvWriter, open('reading.csv') as csvfile:
        writer = csv.writer(csvWriter)
        readCSV = csv.reader(csvfile, delimiter=',' )
        """csvList = list(readCSV)
        #finds where the position of the data I want to pull out and write to write.csv
        itemCode = csvList[0].index(headers[0])
        vendorName = csvList[0].index(headers[1])
        supplierID = csvList[0].index(headers[2])
        supplierItemCode = csvList[0].index(headers[3])"""
        for row in readCSV:
            writer.writerow([row[0], row[27], row[28], row[29]])

原文：https://stackoverflow.com/questions/44792921