Hackers and Slackers

Data

23 Posts
All things data related. Pretty much redundant, considering this is a blog about data.

Extract Nested Data From Complex JSON

The Pythonic way of working with JSON objects

We're all data people here, so you already know the scenario: it happens perhaps once a day, perhaps 5, or even more. There's an API you're working with, and it's great. It contains all the information you're looking for, but

Python Author imageTodd Birchard Author imagetodd Oct 10
Read

Reading and Writing to CSVs in Python

Playing with tabular data the native Python way.

Tables. Cells. Two-dimensional data. We here at Hackers & Slackers know how to talk dirty, but there's one word we'll be missing from our vocabulary today: Pandas.Before the remaining audience closes their browser windows in fury, hear me out.

Python Author imageTodd Birchard Author imagetodd Sep 27
Read

I Owe My Job to Mr. Robot

Entering the Dataverse

What's up data gang? If you've been reading along throughout this journey, you'll realize that all of my posts have something in common (other than Excel...smartass), they all assume that you're already working with data...even if it's just

Data Author imageMax Mileaf Author imagesnacks Aug 14
Read

Abusing Tableau to Handle ETL Workflows

Weaponizing APIs against tyrannical software

Before we get into the specifics of how to sadistically abuse Tableau, let's clear the air: there's something about inaccessible, expensive, proprietary enterprise software that tends to put me in a touchy mood. As we know, B2B software pricing has

Tableau Author imageTodd Birchard Author imagetodd Aug 03
Read

Hacking Your Tableau Linux Server

Turning a BI tool into your data GUI slave

Let's say you're a Data Scientist. Well maybe not a data scientist... I mean, those online data analysis courses were definitely worth it, and you'd made it this far without being quizzed on Bayesian linear regression. So maybe you're analyst

Tableau Author imageTodd Birchard Author imagetodd Jul 26
Read

Data Could Save Humanity if it Weren't for Humanity

A compelling case for robot overlords.

A decade has passed since I stumbled into technical product development. Looking back, I've spent that time almost exclusively in the niche of data-driven products and engineering. While it seems obvious now, I realized in the 2000s that you could

Data Author imageTodd Birchard Author imagetodd Jul 20
Read

Extract Massive Amounts of Data from APIs in Python

Abusing APIs for all they’re worth

Taxation without representation. Colonialism. Not letting people eat cake. Human beings rightfully meet atrocities with action in an effort to change the worked for the better. Cruelty by mankind justifies revolution, and it is this writer's opinion that API limitations

Python Author imageTodd Birchard Author imagetodd Jul 04
Read

Yes...If(And))

Adventures in Excel

If you've been following along on our proverbial Hogwarts for budding Excel wizardry, you would know that we recently crossed an important Rubicon upon which all Excel, and indeed all computer programming languages are built: The mighty IF statement. Remember,

Excel Author imageMax Mileaf Author imagesnacks Jun 20
Read

Working with XML trees in Python

Because you'll probably have to

Life is filled with things we don't want to do; you're a developer so you probably understand this to a higher degree than most people. Sometimes we waste weeks off our lives thanks to an unreasonable and unknowledgable stakeholder. Other

Python Author imageTodd Birchard Author imagetodd Jun 19
Read