Extract Cities and Countries from Text in Power Query Using Python
Discover how to leverage Python within Power Query to extract city and country names from text data. In this video, we walk you through the process of integrating Python scripts to parse and identify geographical names in your datasets. Learn how to set up your Python environment in Power Query, write scripts for text extraction, and apply these techniques to clean and organize your data effectively. Ideal for data professionals looking to enhance their data transformation workflows with Python.
00:00 Introduction
00:40 Write script
01:45 Result of Python code