ETL POWER QUERY and Python

Hello Syndicate_Admin ,

Thanks for your message, you're right to ask this question.
I'd like to learn Python in the hope of doing everything you can do with VBA, Power Query and DAX.
For example, automatically generate an Excel file after :
    . combining several other .xlsx files.
    . modify certain columns
    . add new data or columns

Until then, Power Query can do it without any problem.

But in this file there is another tab which contains certain parameters useful for Power Query, such as the path to the folder, the sub-folder with the name of the month, which must be adapted each month, etc.

The final result of the file corresponds to accounting entries which must then be transferred automatically to SAP

The problem is that this file must not contain any other Excel sheets or formulas....
The current solution is to copy/paste into another .xlsx template file and then transfer it to SAP.

This is just one example. I know that Power Query doesn't do conditional formatting. So you have to use VBA, which I'm not very good at.
Python seems more powerful than Power Query and VBA and I was interested in learning it.
I've found quite a few other interesting links, I'll post them here if anyone's interested.

But with all that, I don't know where to start and the best way to install Python.
Should I use an Anaconda environment?
How do I set up this environment properly?
In short, it's going to take me 10 or 15 years to get my head around all this 😀.

https://www.youtube.com/@coreyms/videos
https://pandas.pydata.org/docs/
https://openpyxl.readthedocs.io/en/stable/tutorial.html
https://wesmckinney.com/book/
https://automatetheboringstuff.com/
https://realpython.com/

And I have 1 or 2 forums with a Python section

Sorry if my English isn't clear, I used deepl to do the translation

Best Regards