Python .csv 编写器

发布于 2024-11-02 07:58:30 字数 644 浏览 1 评论 0原文

我在循环中使用 .writer() 方法，如 Python 文档中所示。我想逐行（或者更好地逐行）写入变量 u 的结果。

实际上它在解释器中工作得很好，但模块 writerow() 似乎不起作用。为什么？

from urlparse import urlparse
import csv
import re

ifile =open(ipath,'r')
ofile = open(opath, 'wb')
writer = csv.writer(ofile, dialect='excel')

url =[urlparse(u).netloc for u in file (ipath, "r+b")]
sitesource =  set([re.sub("www.", "", e) for e in url])
liste = [re.split(",'", e) for e in liste]


ofile
for row in file (ifile) :
    for u in sitesource:
        print ("Creation de:", u)
        writer.writerow(u) 

ofile.close()

我正在使用Python 2.7。

原文

I use a .writer() method in a loop, as shown in the Python documentation.
I want to write the results of the variable u, row by row (or better line by line).

Actually it works perfectly in the interpreter but the module writerow() doesn't seem to work. Why?

from urlparse import urlparse
import csv
import re

ifile =open(ipath,'r')
ofile = open(opath, 'wb')
writer = csv.writer(ofile, dialect='excel')

url =[urlparse(u).netloc for u in file (ipath, "r+b")]
sitesource =  set([re.sub("www.", "", e) for e in url])
liste = [re.split(",'", e) for e in liste]


ofile
for row in file (ifile) :
    for u in sitesource:
        print ("Creation de:", u)
        writer.writerow(u) 

ofile.close()

I'm using Python 2.7.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

冰火雁神 2024-11-09 07:58:31

猜测你的意思是，我会重写你的代码如下：

from urlparse import urlparse
import csv
import re

ifile =open(ipath,'r')
ofile = open(opath, 'wb')
writer = csv.writer(ofile, dialect='excel')

url =[urlparse(u).netloc for u in ifile]
sitesource =  set([re.sub("www.", "", e) for e in url])

for u in sitesource:
    print ("Creation de:", u)
    writer.writerow([u]) 

ofile.close()
ifile.close()

我删除了 liste 因为它没有被使用。我摆脱了 for row in file (ifile): 因为您在创建 url 时已经迭代了其内容。

我改为

url =[urlparse(u).netloc for u in file (ipath, "r+b")]

因为

url =[urlparse(u).netloc for u in ifile]

你已经打开了文件。我假设如果您正在读取字符串，您不想要二进制模式。

我更改了 writerow(u) 来编写序列：writerow([u])。这会在每行放置一个 u，这意味着您的 csv 文件中实际上不会包含任何逗号。如果您希望所有结果都在一行中，请使用此语句 writer.writerow(sitesource) 替换最终循环。

Guessing at you really mean, I would rewrite your code as follows:

from urlparse import urlparse
import csv
import re

ifile =open(ipath,'r')
ofile = open(opath, 'wb')
writer = csv.writer(ofile, dialect='excel')

url =[urlparse(u).netloc for u in ifile]
sitesource =  set([re.sub("www.", "", e) for e in url])

for u in sitesource:
    print ("Creation de:", u)
    writer.writerow([u]) 

ofile.close()
ifile.close()

I deleted liste as it's not used. I got rid of for row in file (ifile): as you already iterated over its contents when you created url.

I changed

url =[urlparse(u).netloc for u in file (ipath, "r+b")]

url =[urlparse(u).netloc for u in ifile]

because you already had the file open. I assumed you did not want binary mode if you are reading strings.

I changed writerow(u) to write a sequence: writerow([u]). This puts a single u per line, which means your csv file will not acutally have any commas in it. If you wanted all of your results in a single row, replace the final loop with this statment writer.writerow(sitesource).

回复收藏 0 原文