我正在尝试更改下面的代码,以便它在 Python 3.4 中工作。但是,我在行 line.replace(",", "\t") 中收到错误 AttributeError: 'int' object has no attribute 'replace'。我试图了解如何重写这部分代码。
import os
import gzip
from io import BytesIO
import pandas as pd
try:
import urllib.request as urllib2
except ImportError:
import urllib2
baseURL = "http://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?file="
filename = "data/irt_euryld_d.tsv.gz"
outFilePath = filename.split('/')[1][:-3]
response = urllib2.urlopen(baseURL + filename)
compressedFile = BytesIO()
compressedFile.write(response.read())
compressedFile.seek(0)
decompressedFile = gzip.GzipFile(fileobj=compressedFile, mode='rb')
with open(outFilePath, 'w') as outfile:
outfile.write(decompressedFile.read().decode("utf-8", errors="ignore"))
#Now have to deal with tsv file
import csv
csvout = 'C:/Sidney/ECB.tsv'
outfile = open(csvout, "w")
with open(outFilePath, "rb") as f:
for line in f.read():
line.replace(",", "\t")
outfile.write(line)
outfile.close()
谢谢
请您参考如下方法:
您正在使用 'w' 模式编写 ASCII(默认情况下),但是您从中获取该内容的文件正在使用 'rb' 模式。使用 'r' 打开该文件。
然后,正如 Sebastian 所建议的,只需使用 for line in f: 遍历文件对象。使用 f.read() 会将整个内容读入单个字符串,因此如果您对其进行迭代,您将迭代文件的每个字符。严格来说,由于您所做的只是替换单个字符,因此最终结果将是相同的,但首选遍历文件对象(使用更少的内存)。
让我们更好地利用 with 构造并从这里开始:
outfile = open(csvout, "w")
with open(outFilePath, "rb") as f:
for line in f.read():
line.replace(",", "\t")
outfile.write(line)
outfile.close()
为此:
with open(outFilePath, "r") as f, open(csvout, 'w') as outfile:
for line in f:
outfile.write(line.replace(",", "\t"))
此外,我应该注意到,在您选择的文本编辑器中使用查找和替换更容易做到这一点(我喜欢 Notepad++)。
