Microsoft Outlook - merge two attached files using Python

[Anonymous]

I have a connection to my corp email and that works good, but I want to make a Python Script to take the last two emails attachements (Excel files) and merge them together.

Is that possible?

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can install pandas library and use pandas function

pandas.DataFrame.merge

 Please also refer to doc:
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html#pandas.DataFrame.merge

About how to run python script in power bi, you can refer to:

https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.