下载与Python .csv文件 [英] Download a .csv file with Python
问题描述
我在Windows上使用Python 3.3。我试图找出如何下载从雅虎财经.csv文件。这是历史价格的文件。
I am using Python 3.3 on Windows. I am trying to figure out how to download a .csv file from yahoo finance. It is a file for the Historical Prices.
这是源$ C $ C，其中的链接，我试图访问。
This is the source code where the link is I'm trying to access.
<p>
<a href="http://ichart.finance.yahoo.com/table.csv?s=AAPL&d=1&e=1&f=2014&g=d&a=8&b=7&c=1984&ignore=.csv">
<img src="http://l.yimg.com/a/i/us/fi/02rd/spread.gif" width="16" height="16" alt="" border="0">
<strong>Download to Spreadsheet</strong>
</a>
</p>
这里是code我写的做到这一点。
And here is the code I wrote to do it.
from urllib.request import urlopen
from bs4 import BeautifulSoup
website = "http://ichart.finance.yahoo.com/table.csv?s=AAPL&d=1&e=1&f=2014&g=d&a=8&b=7&c=1984&ignore=.csv"
html = urlopen(website)
soup = BeautifulSoup(html)
当我跑了code，我期待它开始下载，并把它变成我的下载文件夹中，但它不会做任何事情。它运行，然后停止。没有csv文件在我的下载显示出来。所以我觉得我失去了这个code别的东西。
When I ran the code, I was expecting it to start the download and put it into my downloads folder, but it doesn't do anything. It runs and then stops. No csv file shows up in my downloads. So I think I'm missing something else in this code.
推荐答案
您可以只使用的urllib做到这一点。下面code下载.csv文件并把内容放到一个名为CSV字符串。然后，它保存字符串的文件：
You can do this with just urllib. The following code downloads the .csv file and puts the contents into a string named 'csv'. Then it saves the string to a file:
from urllib import request
# Retrieve the webpage as a string
response = request.urlopen("http://ichart.finance.yahoo.com/table.csv?s=AAPL&d=1&e=1&f=2014&g=d&a=8&b=7&c=1984&ignore=.csv")
csv = response.read()
# Save the string to a file
csvstr = str(csv).strip("b'")
lines = csvstr.split("\\n")
f = open("historical.csv", "w")
for line in lines:
f.write(line + "\n")
f.close()
这篇关于下载与Python .csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
