在Azure Machine Learning Studio上从R或Python脚本模块读取Excel文件 [英] Reading excel files from R or Python script modules on Azure Machine Learning Studio

问题描述

嗨！

我想从R或Python脚本中读取excel文件，而无需事先导入/加载数据并将其连接到脚本模块的输入端口，而是使用诸如read_excel，read_xlsx之类的函数或体内任何R包中的类似函数的 脚本.

据我所知，不可能从ML Studio中的脚本模块访问本地文件.我通过尝试从本地工作目录中读取文件来进行检查，但R和Python均未成功.问题1，有什么办法吗?

一个想法可能是从云中读取文件，比方说Office 365上的Excel Online文件.问题2，有可能吗?我能够读取带有URL的在线csv或excel文件，例如http://github.com/.../filename.xls(x)或https://...xls(x)，但是 我需要的访问类型有所不同.欢迎所有建议.

提前谢谢！

Hi!

I want to read an excel file from an R or Python script, without previously importing/loading the data and connecting it to an input port of the script module, but using a function like read_excel, read_xlsx or similar from any R package within the body of the script. 

As far as I know it is not possible to access local files from script modules in ML Studio. I checked this by trying to read files from the local working directory, but without success both with R and Python. Question 1, is there any way to do this? 

One idea maybe could be reading the file from the cloud, let's say an Excel Online file on Office 365. Question 2, is it possible? I'm being able to read online csv or excel files with url's like http://github.com/.../filename.xls(x) or https://...xls(x), but the kind of access I need is different. All suggestions are welcomed.

Thanks in advance!

推荐答案

您可以尝试从R脚本导入数据，请参考以下AI画廊实验，它应该会有所帮助.

You can try import data from R script, please refer to following AI gallery experiment, it should help.

https://gallery.azure.ai/Tutorial/5-Custom-Scripts-R-and-Python-in-AML-1

https://gallery.azure.ai/Tutorial/5-Custom-Scripts-R-and-Python-in-AML-1

此致

雨桐

这篇关于在Azure Machine Learning Studio上从R或Python脚本模块读取Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！