Substring Queries in Pandas (SQL LIKE & ILIKE) | Data Analyst Skill Tutorial #2

Published: 16 October 2022
on channel: Alex Sington
923
20

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


Watch video Substring Queries in Pandas (SQL LIKE & ILIKE) | Data Analyst Skill Tutorial #2 online, duration hours minute second in high quality that is uploaded to the channel Alex Sington 16 October 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 923 times and liked it 20 visitors.