python中csv文件通过什么表示字符_使用python在CSV文件中搜索字符串并写入结果

#!/usr/bin/python

import csv

import re

string_1 = ('OneTouch AT')

string_2 = ('LinkRunner AT')

string_3 = ('AirCheck')

#searched = ['OneTouch AT', 'LinkRunner AT', 'AirCheck']

print "hello Pythong! "

#def does_match(string):

# stringl = string.lower()

# return any(s in stringl for s in searched)

inFile = open('data.csv', "rb")

reader = csv.reader(inFile)

outFile = open('data2.csv', "wb")

writer = csv.writer(outFile, delimiter='\t', quotechar='"', quoting=csv.QUOTE_ALL)

for row in reader:

found = False

for col in row:

if col in [string_1, string_2, string_3] and not found:

writer.writerow(row)

found = True

#for row in reader:

# if any(does_match(col) for col in row):

# writer.writerow(row[:2]) # write only 2 first columns

inFile.close()

outFile.close()

I'm trying to figure out how to search a CSV file for 3 items. If those items exist print the row. Ideally I would like only Columns 1 and 3 to print to a new file.

Sample Data File

LinkRunner AT Video,10,20

Wireless Performance Video OneTouch AT,1,2

Wired OneTouch AT,200,300

LinkRunner AT,200,300

AirCheck,200,300

解决方案I'm trying to figure out how to search a CSV file for 3 items. If

those items exist print the row. Ideally I would like only Columns 1

and 3 to print to a new file.

Try this:

import csv

search_for = ['OneTouch AT','LinkRunner AT','AirCheck']

with open('in.csv') as inf, open('out.csv','w') as outf:

reader = csv.reader(inf)

writer = csv.writer(outf, delimiter='\t', quotechar='"', quoting=csv.QUOTE_MINIMAL)

for row in reader:

if row[0] in search_for:

print('Found: {}'.format(row))

writer.writerow(row)