Question

我有一个双栏杆,我通过一个超文本页面上载,用一只字眼书写。查阅服务器方面的档案,看来是一个很长的路要道,即用内容标注的文档。

col1,  col2  
x,y

工作已经结束。

( upfile ,  test.csv ,  col1,col2 	
x,y )

Col1 contains the data I want to operate on (i.e. x) and col 2 contains its identifier (y). Is there a better way of doing the uploading or do I need to manually extract the fields I want - this seems potentially very error-prone thanks

Answer 1

如果您重新使用<代码>cgi 在座标上,你应该能够做以下事情:

form = cgi.FieldStorage()
thefile = form[ upfile ]

reader = csv.reader(thefile.file)
header = reader.next() # list of column names
for row in reader:
    # row is a list of fields
    process_row(row)

See, for example, cgi program or the python cgi模块 docs.

Answer 2

你们能否利用钟式模块来进行这种教育? 这比你自己推出的情况好得多。

大致如下:

import csv
import cgi

form = cgi.FieldStorage()
thefile = form[ upfile ]

reader = csv.reader(thefile, delimiter= , )
for row in reader:
  for field in row:
    doThing()

www.un.org/Depts/DGACM/index_spanish.htm 更正我的回答如下。

Answer 3

Looks like your file is becoming modified by the HTML upload. Is there anything stopping you from just ftp ing in and dropping the csv file where you need it?

一旦CSV档案更加恰当,就是一个快速功能,将它纳入2D阵列:

def genTableFrCsv(incsv):
    table = []
    fin = open(incsv,  rb )
    reader = csv.reader(fin)
    for row in reader: 
        table.append(row)
    fin.close()
    return table

从这里看,你可以在整个名单上进行记忆,而不是从档案中抽取比照,就像在维德尔解决方案中那样。

Answer 4

The easy solution is rows = [row.split( ) for r in csv_string.split( )]. It s only error proned if you have users from different platforms submit data. They might submit comas or tabs and their line breaks could be , , , or ^M. The easiest solution is to use regular expressions. Book mark this page if you don t know regular expressions:

rel=“nofollow”>http://regexlib.com/CheatSheet.aspx

这里的解决办法是:

import re

csv_string =  col1,col2 	
x,y  #obviously your csv opening code goes here

rows = re.findall(r (.*?)[	,](.*?) ,csv_string)
rows = rows[1:] # remove header

现在,罗子是所有各行的les子清单。

友情链接