Recasting Low-Cardinality Columns as Categoricals

Downcast strings in Pandas to their proper data-types using HDF5.
Code Snippet Corner
3 min read
June 03

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.
Excel
6 min read
June 02

Removing Duplicate Columns in Pandas

Dealing with duplicate column names in your Pandas DataFrame.
Code Snippet Corner
3 min read
May 28

Using Hierarchical Indexes With Pandas

Use Panda's Multiindex to make your data work harder for you.
Pandas
12 min read
May 28

Managing Flask Session Variables

Using Flask-Session and Flask-Redis to store user session variables.
Flask
7 min read
May 27

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.
Excel
4 min read
May 25

Reshaping Pandas DataFrames

A guide to DataFrame manipulation using groupby, melt, pivot tables, pivot, transpose, and stack.
Pandas
12 min read
May 21

Structured Streaming in PySpark

Become familiar with building a structured stream in PySpark using the Databricks interface.
Spark
10 min read
May 14

DataFrame Transformations in PySpark (Continued)

Continuing to apply transformations to Spark DataFrames using PySpark.
Spark
8 min read
May 07

Fixing your NPM Installation

Fixing an npm installation gone wrong when 'sudo' is misused.
NodeJS
6 min read
May 06