Forum Discussion
The pandas code read_excel() does not work in Python/Excel, unlike in native Python.
That's data security, more details in related post.
I don't think that's a big issue. You may Power Query external file (or any other source) and do nothing with it, just save as connection only. Next on Python
df=xl("MyConnectionName")
and do all transformations with Python.
Thanks for your reply. It is unfortunate. Do you know the reason why ?
Python is easier (more flexible) than Power Query for ETL (from my point of view).
That's data security, more details in related post.
I don't think that's a big issue. You may Power Query external file (or any other source) and do nothing with it, just save as connection only. Next on Python
df=xl("MyConnectionName")
and do all transformations with Python.
- That's à nice advice, thanks. I haven't thought about it from that angle. Let me try it.
It works. Some initial transformation in Power Query could be useful, e.g. "Use first row as header" if you load from csv or unstructured sheet.
- I tried it and it works, indeed.
Sometimes, the behaviour of the dataframe in an Excel sheet is quite unstable, showing the full data where the Python object is expected but I assume it is due to the beta environment.
Thank you very much for your help and support.
In my case it is a big issue) Power Query doesn't see difference between hidden and unhidden rows in excel files, however pandas.read_excel can do that. And I hoped that introducing Pandas in Excel would enable this functionality.
Not sure. At least now pandas in Excel work with values, not with properties.
