Substring Queries in Pandas (SQL LIKE & ILIKE) | Data Analyst Skill Tutorial #2
This tutorial will teach you how to query and analyze Pandas data frames in Python with substrings -- including how to manage case sensitivity and multiple "OR" inputs with basic regular expressions (regex).
List of functions in the tutorial:
pd.Series.str.contains(), pd.Series.str.endswith(), pd.Series.str.startswith(), pd.Series.str.count(), pd.Series.str.len(), pd.Series.str.replace()
Contact me:
[email protected]
/ alex-sington-b7751a181
Intro: 0:00
Series.str.contains(): 2:12
Series.str.startswith() & .endswith(): 9:17
Series.str.count(): 13:16
Series.str.len() :15:26
Series.str.replace(): 16:00