Python Code Snippet Corner

Your occasional dose of Python tidbits for data science and analysis. Tutorials are BYOJ: bring your own Jupyter notebook.

Using Pandas and SQLAlchemy to Simplify Databases

Use SQLAlchemy with PyMySQL to make database connections easy.

6 min read

Set up CRON jobs to interact with Conda environments.

3 min read

Cleaning data in Pandas the dirty way.

8 min read

Using Pandas with databases wrong way, and how to clean it up with SQLAlchemy.

3 min read

Reshaping Pandas DataFrames with a real-life example, and graphing it with Altair.

6 min read

Parse dates and times from Excel .xlsx correctly when using Pandas.

1 min read

Import dates & times from Excel .xlsx files into Pandas!

2 min read

Tune the n_estimators parameter in for a Random Forests classifier in scikit-learn in Python.

4 min read

Tune the max_depth parameter in for a Random Forests classifier in scikit-learn in Python

2 min read

Tune the min_samples_leaf parameter in for a Random Forests classifier in scikit-learn in Python

4 min read