Code Snippet Corner (page 2)
Real-world examples of Python snippets used to solve complex data problems, primarily leveraging Pandas and related libraries.
Importing Excel Datetimes Into Pandas, Part I
Parse dates and times from Excel .xlsx correctly when using Pandas.
Lazy Pandas and Dask
Speed up data analysis by parallelizing your DataFrames.
All That Is Solid Melts Into Graphs
Reshaping Pandas DataFrames with a real-life example, and graphing it with Altair.
Trash Pandas: Messy, Convenient Database Operations via Pandas
Using Pandas with databases wrong way, and how to clean it up with SQLAlchemy.
A Dirty Way of Cleaning Data (ft. Pandas & SQL)
Cleaning data in Pandas the dirty way.
Getting Conda Environments To Play Nicely With Cron
Set up CRON jobs to interact with Conda environments.
Using Pandas and SQLAlchemy to Simplify Databases
Use SQLAlchemy with PyMySQL to make database connections easy.