python csv文件 查找删除_python – 提取.csv文件的列并查找其索引

我有一个大的csv,文件,我想得到它的所有值,存储在我知道名称的特定列中.

不知怎的,我不明白该怎么做,但我想我很接近:(

import codecs

import csv

import json

import pprint

import re

FIELDS = ["name", "timeZone_label", "utcOffset", "homepage","governmentType_label", "isPartOf_label", "areaCode", "populationTotal",

"elevation", "maximumElevation", "minimumElevation", "populationDensity", "wgs84_pos#lat", "wgs84_pos#long",

"areaLand", "areaMetro", "areaUrban"]

index=[]

with open('/Users/stephan/Desktop/cities.csv', "r") as f:

mycsv=csv.reader(f)

results=[]

headers=None

for row in mycsv:

for i, col in enumerate(row):

if col in FIELDS:

index.append(i)

print row[i]

print index

我的列表索引,我认为是正确的,并给我正确的值(列索引)

我必须添加到我的代码才能使其工作？