EPISODE · Apr 19, 2023 · 3 MIN
Python for Excel Matches #53
from The Show with Xander · host Xander Gr
https://youtu.be/YdO_6U39SyA Remember if you like it a free thumbs up via Spotify 5 star is greatly appreciated https://github.com/XanderGr/EXCEL/blob/main/Python_matching # Define the search criteria for the column use the placeholder # Read the excel file into a pandas DataFrame # Filter the DataFrame for rows where the placeholder column matches one of the search criteria # Check if there are any matching rows # If there are no matching rows, create a text file to indicate there are no matches # If there are matching rows, write the filtered DataFrame to a new excel file
What this episode covers
https://youtu.be/YdO_6U39SyA Remember if you like it a free thumbs up via Spotify 5 star is greatly appreciated https://github.com/XanderGr/EXCEL/blob/main/Python_matching # Define the search criteria for the column use the placeholder # Read the excel file into a pandas DataFrame # Filter the DataFrame for rows where the placeholder column matches one of the search criteria # Check if there are any matching rows # If there are no matching rows, create a text file to indicate there are no matches # If there are matching rows, write the filtered DataFrame to a new excel file
NOW PLAYING
Python for Excel Matches #53
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m