Drop Pandas DataFrame columns only if they exist

TL, DR Sometimes you need to drop columns in a Pandas DataFrame, but you may not be sure they actually exist. Here a few snippets to do it without raising errors. Safely Dropping Columns That Might Not Exist Sometimes, your dataset might include placeholder or optional columns such as “Unknown”, “Other”, or “None”. You may… Continue reading Drop Pandas DataFrame columns only if they exist

Calculate metrics on numeric columns only for Pandas DataFrames

TL, DR Sometimes you need to calculate averages, minimums, or other metrics from numeric-only columns in a Pandas DataFrame. Here a few snippets to do it. Select numeric columns and calculate metrics You often want to calculate summary statistics like the mean , median , or standard deviation — but you only care about numeric… Continue reading Calculate metrics on numeric columns only for Pandas DataFrames