从Web URL导入数据慢 [英] Import data from Web URL Slow

问题描述

我正在尝试对从Alpha Vantage提取的财务数据进行实时分析.当我从浏览器中访问URL时，CSV文件将立即加载.当我从ML Studio运行它时，导入需要10秒钟的时间.如何制作CSV 文件立即加载到环境中?

I am trying to do some real time analysis of financial data that I pull from Alpha Vantage. When I hit the url from my browser the CSV file loads immediately. When I run it from ML Studio it takes 10 seconds for the import to run. How can I make the CSV file load immediately into the environment?

我输入的URL是

https://www.alphavantage.co/query?function=FX_INTRADAY&from_symbol=EUR&to_symbol=USD&interval=5min&apikey=demo&datatype=csv

https://www.alphavantage.co/query?function=FX_INTRADAY&from_symbol=EUR&to_symbol=USD&interval=5min&apikey=demo&datatype=csv

推荐答案

恐怕这些文件不可比，尤其是对于小文件.您的计算机直接到达终点；在Studio中运行时，幕后还有许多中间步骤在发生.使用较大的数据集，您应该会看到很多 差异更少，甚至相反.

I am afraid that these are not comparable especially with small files. Your computer is hitting the endpoint directly; when running in Studio there are a lot more intermediary steps happening behind the scene. With a larger dataset you should see much less discrepancy, or even the reverse.  

这篇关于从Web URL导入数据慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！