我在從下面的 CSV 文件中獲取行值時(shí)遇到了一些問題CSVminzoom, maxzoom0,55,1010,18我的代碼：i = 0for line in open("C:/Marine/lookup/distinct_lookup_scales.csv"): i = i + 1 if (i > 1): #Skip header print("Line: " + line) #csv_row = line.split(',') minzoom = str(line[0]) maxzoom = str(line[2]) print("Minzoom:" + minzoom) print("Maxzoom:" + maxzoom) readShpFile(minzoom, maxzoom)minzoom和maxzoom 的返回值是0 55 11 ,我曾使用行拆分但又恢復(fù)嘗試從行中獲取項(xiàng)目不確定這是否是最好的方法
2 回答
弒天下
TA貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超8個(gè)贊
這不是你應(yīng)該如何閱讀 csv 文件。查看csv 模塊文檔。
一個(gè)例子：
import csv
with open('C:/Marine/lookup/distinct_lookup_scales.csv', 'r') as csvfile:
csvreader = csv.reader(csvfile)
csvreader.next() #skip header
for row in csvreader:
minzoom = int(row[0])
maxzoom = int(row[1])
print('minzoom : {}'.format(minzoom))
print('maxzoom : {}'.format(maxzoom))
您還可以使用 DictReader，它將使用您的標(biāo)題行來生成字典。
import csv
with open('C:/Marine/lookup/distinct_lookup_scales.csv', 'r') as csvfile:
csvreader = csv.DictReader(csvfile)
for row in csvreader:
minzoom = int(row['minzoom'])
maxzoom = int(row['maxzoom'])
print('minzoom : {}'.format(minzoom))
print('maxzoom : {}'.format(maxzoom))
www說
TA貢獻(xiàn)1775條經(jīng)驗(yàn) 獲得超8個(gè)贊
你可以試試 numpy.genfromtxt，比如：
import numpy as np
data = np.genfromtxt("C:/Marine/lookup/distinct_lookup_scales.csv", delimiter = ",",
skip_header = 1)
minzooms = data[:,0]
maxzooms = data[:,1]
添加回答
舉報(bào)
0/150
提交
取消