Mike Diaz – Medium

1 day ago

What I Learned at Work this Week: python patch

It finally happened, we’re writing tests for the product that constantly breaks. It seems like an obvious move, but most readers have probably experienced deprioritizing a security measure in favor of work that will “move the needle.” After all, the script isn’t broken today, but clients are asking us to…

Mock

4 min read

What I Learned at Work this Week: pytest patch

Mock

4 min read

Mar 5

What I Learned at Work this Week: Import Errors and Docker

Almost a year ago, I wrote about learning to trigger a Python script with Airflow. Yesterday, I learned that over the course of that year, I may have been consistently missing a prevalent bug that has been giving us headaches while QAing the script. Let’s talk about the moduleNotFound error Local Testing …

Docker

4 min read

Docker

4 min read

Feb 12

What I Learned at Work this Week: The Query Plan

At my job, I’m considered an authority on one specific product — our Events ETL Report (extract, transform, load). I get a lot of questions about the report, so I probably check Airflow logs that run its script a dozen times a day. Clients like to have their data as…

MySQL

5 min read

What I Learned at Work this Week: The Query Plan

MySQL

5 min read

Jan 29

What I Learned at Work this Week: Airflow Operators

This week, a teammate asked me for design help as he considered adding a new row to an existing database table. As someone who has to work with a 26-column table every day, I wanted to help to see if there was a way to keep his from growing. …

Airflow

4 min read

Airflow

4 min read

Jan 15

What I Learned at Work this Week: JDBI

Last week, I wrote about my experience using gRPC to process an API call that would make a SQL update. Since we were focusing on the gRPC part, we didn’t closely examine how we were using Java to make the update. …

Java

5 min read

Java

5 min read

Jan 8

What I Learned at Work this Week: gRPC and Java

I had my first experience with gRPC over a year ago, as I discussed in this post from August 2021. I’m sorry to say that I haven’t been working consistently with it since then, so I’ve had to re-learn a lot of the concepts. Further complicating things, our most common…

Java

5 min read

Java

5 min read

Sep 25, 2022

What I Learned at Work this Week: Pandas Values considered “missing”

The last time I posted, I shared my experience debugging type adjustment with a pandas DataFrame. Around the same time I was writing that article, a friend of mine asked if I could do a presentation for one of our company’s Demo Days. …

Pandas

5 min read

Pandas

5 min read

Aug 14, 2022

What I Learned at Work this Week: pandas Asserts Floats

Python is my life now. Let that be a lesson to all the boot camp grads (like me) out there: I had never written a single line of Python code when I started my current job. Since then, I’ve taken one Udemy Python course and mostly learned through random docs…

Python

6 min read

What I Learned at Work this Week: pandas Asserts Floats

Python

6 min read

Jul 31, 2022

What I Learned at Work this Week: Executing Encryption

I spent a couple of days struggling with encryption this week, so the weekend seemed like a perfect time to brush up as I hope to close the door on my issue Monday. Then, a funny thing happened. …

Python

6 min read

What I Learned at Work this Week: Executing Encryption

Python

6 min read

Jul 3, 2022

What I Learned at Work this Week: Pandas Data Conversion Quirks

I’m getting better at my job. This week, I got a request to update the data formatting on a report that we generate to match the format of data elsewhere. I knew exactly where to find the SQL that generated the data and it didn’t take much time to update…

Pandas

7 min read

Pandas

7 min read