Hackers and Slackers (Page 13)

Active-X Gonna Give it to Ya

Active-X Gonna Give it to Ya

Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.

Cloud SQL: Relational Databases on Google Cloud

Cloud SQL: Relational Databases on Google Cloud

Create a database in Google Cloud using Cloud SQL, compare Cloud SQL to RDS, and learn the admin API.

Lazy Pandas and Dask

Lazy Pandas and Dask

Speed up data analysis by parallelizing your DataFrames.

Hacking Tableau to Handle ETL Workflows

Hacking Tableau to Handle ETL Workflows

Weaponizing APIs against tyrannical software.

Using MongoDB Atlas as your Flask Database

Using MongoDB Atlas as your Flask Database

Since you prefer using Python and Flask, I’ll assume we both prefer enjoyable dev.

All That Is Solid Melts Into Graphs

All That Is Solid Melts Into Graphs

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

Automagically Turn JSON into Pandas DataFrames

Automagically Turn JSON into Pandas DataFrames

Let Pandas do the heavy lifting for you when turning JSON into a DataFrame.

Hacking Your Tableau Linux Server

Hacking Your Tableau Linux Server

Cracking Tableau's master Postgres account.

A racoon Observing Bad Data Practices

Trash Pandas: Messy, Convenient Database Operations via Pandas

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

Your Invitation to the Excel Pivot Party

Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.