Forum Discussion

Mederic's avatar
Mederic
Post Patron
2 years ago

ETL POWER QUERY and Python

Hello, I would like to learn the Python language for Excel but I have a lot of questions, in particular about the comparison between the Python ETL tool and the Power Query tool. It seems to me tha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Mederic 

The difference between Python and Power query is depend on the situation, the power query is friendly for the people without coding and it can help connect and transform data. the Python a powerful programming language, it offer more options for the complex data processing,  you can learn the related knowledge on the youtube.You can refer to the following link.

Bing Videos

 

Best Regards!

Yolo Zhu

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

 

Mederic's avatar
Mederic
Post Patron
2 years ago

Hello Anonymous ,
Thank you for your reply and the link for the videos,
Power Query is indeed friendly.
I'm afraid that for very complex cases, you need to have a very good level of Python. It may take a long time to learn.
I don't know if there are any forums on Python but I'm going to look there too.

Have a good year
Best Regards

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Hi, could you please give some examples of cases where you'd need to use Python instead of Power Query? I can't find anything concrete so far.