Your occasional dose of Python tidbits for data science and analysis. Tutorials are BYOJ: bring your own Jupyter notebook.
Python Code Snippet Corner
1
Using Pandas and SQLAlchemy to Simplify Databases
Use SQLAlchemy with PyMySQL to make database connections easy.
6 min read
2
Getting Conda Environments To Play Nicely With Cron
Set up CRON jobs to interact with Conda environments.
3 min read
3
A Dirty Way of Cleaning Data (ft. Pandas & SQL)
Cleaning data in Pandas the dirty way.
8 min read
4
Trash Pandas: Messy, Convenient Database Operations via Pandas
Using Pandas with databases wrong way, and how to clean it up with SQLAlchemy.
3 min read
5
All That Is Solid Melts Into Graphs
Reshaping Pandas DataFrames with a real-life example, and graphing it with Altair.
6 min read
6
Importing Excel Datetimes Into Pandas, Part I
Parse dates and times from Excel .xlsx correctly when using Pandas.
1 min read
7
Importing Excel Datetimes Into Pandas, Part II
Import dates & times from Excel .xlsx files into Pandas!
2 min read
8
Tuning Machine Learning Hyperparameters with Binary Search
Tune the n_estimators parameter in for a Random Forests classifier in scikit-learn in Python.
4 min read
9
Tuning Random Forests Hyperparameters: max_depth
Tune the max_depth parameter in for a Random Forests classifier in scikit-learn in Python
2 min read
10
Tuning Random Forests Hyperparameters: min_samples_leaf
Tune the min_samples_leaf parameter in for a Random Forests classifier in scikit-learn in Python
4 min read
11
Using Random Forests for Feature Selection with Categorical Features
Python helper functions for adding feature importance, and displaying them as a single variable.
2 min read
12
Downcast Numerical Data Types with Pandas
Using an Example Where We Downcast Numerical Columns.
5 min read
13
Removing Duplicate Columns in Pandas
Dealing with duplicate column names in your Pandas DataFrame.
3 min read
14
Recasting Low-Cardinality Columns as Categoricals
Downcast strings in Pandas to their proper data-types using HDF5.
3 min read
15
Splitting Columns With Pandas
Split columns containing multiple values in your Pandas DataFrame into multiple columns, each containing a single value.
7 min read
16
Being REALLY Lazy With Multiple Aggregations in Pandas
Perform multiple aggregate functions simultaneously with Pandas 0.25
3 min read