Creating conditional columns numpy.where

Filtering with multiple conditions '&' operator Filtering Boolean indexing with square brackets Filtering Boolean indexing with .loc Filtering with multiple conditions 'or' operator Agreggation Groupby #1: get total sum Agreggation Groupby #2: get the highest date Pivoting data Creating conditional columns numpy.where Conditional columns with list comprehension Aggregation with multiple functions groupby