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

preview_player
Показать описание
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:

Contact me:

Intro: 0:00
  1. Alex Sington
  2. Pandas
  3. Python
  4. Tutorial
  5. Substring Query
Рекомендации по теме
Substring Queries in 0:19:14

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

Pandas dataframe query 0:03:05

Pandas dataframe query to SQL LIKE WITHOUT using engine python

String Function in 0:08:15

String Function in SQL || SQL Server || Charindex || Substring || Length #sql #sqlserver #database

Data Cleaning: SQL 0:24:31

Data Cleaning: SQL v Python Pandas v Power BI Power Query: Cleaning Text Strings

How to Use 0:05:07

How to Use Parameters in a SQLite SQL Statement in Python SQLite3 Tutorial in Python

Coding for 1 0:00:24

Coding for 1 Month Versus 1 Year #shorts #coding

Senior Programmers vs 0:00:34

Senior Programmers vs Junior Developers #shorts

Advanced String Searching 0:12:37

Advanced String Searching including RegEx (Pandas Tutorials 06)

SQL : DISTINCT 0:14:43

SQL : DISTINCT , CONCAT, SUBSTRING

Master Using SQL 0:34:42

Master Using SQL with Python: Lesson 4 - Using SQLite for Data Analysis

Shradha didi at 0:00:16

Shradha didi at lpu 🤩 #apna college #viralshorts

Database query using 0:36:05

Database query using sql | Class 12 | Informatics Practices | Unit - 2 | Video - 1

Learn to query 0:20:29

Learn to query pandas dataframe in just one lesson | pandas DataFrame query | SuMyPyLab

SQL to Count 0:04:03

SQL to Count Occurrence of a Character/Word in a String

Use STRING_AGG Function 0:01:00

Use STRING_AGG Function to Solve SQL Questions

13.1 - String 0:44:16

13.1 - String manipulation SQL functions

Pandas Find | 0:04:29

Pandas Find | pd.Series.str.find

SQL for Data 0:19:10

SQL for Data Science #3b: SQLite+pandas to analyze 10 million NYC citibike records

018 - SQL 0:09:08

018 - SQL for Data Analysts and Data Scientists - SQL - SUBSTRING Function

Partial String Match 0:14:01

Partial String Match when merging Power BI Queries using DAX and Pandas

Query Method Pandas 0:17:17

Query Method Pandas A-Z Python Urdu / Hindi

SQL query parsing 0:40:51

SQL query parsing using ansible and python library Part 3

Data Cleaning: SQL 0:28:58

Data Cleaning: SQL v Python Pandas v Power BI Power Query: Splitting Columns

Samay Raina : 0:00:13

Samay Raina : 'Does Size Matter?' #shorts

Комментарии
Автор

Hey Alex thanks for this video...

as i followed this "Tutorial" type video, i was wondering if there was a way to set up something like a lookup table and match those values to conduct a search...
for example if you had items in this dataset for sale lets say under the catergory of Soft drinks and snacks and each item(s) was being sold by independent vendors
so each vendor gets an ID. and sells multiple items and the same items can be assigned to all vendors, so
Main Vendor Department belongs to the TEAM

Laker's Vendors (Top ID 1000L, L for Lakers or something)
Cocacola sold by Vendor1...ID = 2000
Cheetos sold by Vendor1...ID = 2001

Cocacola sold by Vendor2...ID = 3001
Cheetos sold by Vendor2...ID = 3002..etc

is there a way to create a look up type table so i can search vendors and filter by ID so i can get the name of the vendor and item they sell?

i hope this makes sense, your videos are awesome and create lots of ideas and questions...
Thanks for your videos as always..

FredyArg