General Info
Import Export
Data Processing
Analysis
Machine Learning
Useful Snippets
×
- Use SQL to apply conditional logic
- Filter a DataFrame using Conditional Logic
- 10.0.1 Where Column Equals Value
- 10.0.2 Where Column Does NOT Equal Value
- 10.0.3 Where Column IN List
- 10.0.4 Where Column NOT IN List
- 10.0.5 Where Column is Null
- 10.0.6 Where Column is Not Null
- 10.0.7 Where multiple conditions are all true - AND Logic
- 10.0.8 Where one or more condition is true - OR Logic
- Create Columns with Conditional Logic
- Rank a column
10.0.4 Where Column NOT IN List
Example:
# Where column is NOT in a list of values (~)
DF_Filtered = [ ~( DF['B'].isin(['a','c']) ) ]