VLOOKUP in Power Query (merge) x Python (merge) [join tables]
Learn how to perform the famous Excel VLOOKUP (merge) in Power Query and also in Python.
This lesson aims to teach you how to join similar tables in both tools.
By mastering these techniques, you will be able to join tables efficiently, expanding your analytical capabilities and making the decision-making process more informed and data-driven.
This lesson complements the article on my BLOG 👉 https://url.joviano.com/iu1v9
📣 VISIT OUR PAGE TO LEARN MORE 👇
👩🎓 POWER QUERY 2.0 TRAINING
🆓 Free weekly lesson [with certificate]
🆓 Free course on Power Query, Python, Web Scraping and more!
✅ Curated content [books]
💾 Supporting material [if this class contains it]
👉 https://url.joviano.com/wbvu9
_
📁 SUPPORTING MATERIAL
💾 20230222_procv_pq_py.zip
_
🎬 Class Outline
00:00 Presentation
00:30 Introduction
02:15 How to do VLOOKUP in Power Query [Merge Queries] with only 1 column
08:53 Data Duplicates in Power Query Data Merge
10:00 Solution for Data Duplicates in Power Query Table Merge
12:00 Merging tables in Power Query with multiple columns as keys (composite columns)
15:00 Databases that will be used for VLOOKUP (merge) in Python
16:00 How to use Python without Install nothing (Google Colab)
17:40 Invoking Power Query from Python (PANDAS)
19:52 Importing CSV (TXT) data into Python with Pandas
22:00 VLOOKUP in Python using the PANDAS MERGE method (one column)
25:00 VLOOKUP in Python using the PANDAS MERGE method (multiple columns - composite columns)
26:25 When will you use Power Query and Python - Learning Path
29:30 Final Considerations