When writing Python code, it’s good to know where your working directory (or current working directory) lives. When you perform file operations without specifying a… Read More »Understanding Your Working Directory When Working With Python
Exporting to Excel is a very common task in Python, especially when developing. You might need to see an entire data set and be able… Read More »Exporting to Excel with Python Using df.to_excel & pd.ExcelWriter
First, this post is not a tutorial on how to use window functions in Denodo. I’ll come back and do that later. Rather, this post… Read More »Troubleshooting Window Functions in Denodo
What is Parquet & Why First, let’s start with what the Parquet format and why is it used. Parquet is an Apache open-source storage format… Read More »How to Convert .parquet Files to Excel With Python
When you grab a file path from the file explorer, you get a path with backward slashes (in Windows). However, you can’t just copy and… Read More »Handling File Paths in Python
I’m writing this blog post because I ran into an error today that I will surely run into again and not remember how to solve. So, this post explains how to fix the error – “Could not connect to your data gateway”. Now, the next time I have this problem, I’ll Google it, and Google will show me my own writing. It’s kinda fun when that happens. Read on to learn more.
Read More »How to Fix Data Gateway Error in Power Automate
When I first started working with Power Automate, I misunderstood a few key concepts. If I got the wrong idea, then I am willing to bet other people are working under the same misconceptions. That’s why I wrote this post on four things I misunderstood about Power Automate. Read on to learn more about these common misconceptions.
Read More »4 Things I Misunderstood About Power AutomateAs you build larger and more complex cloud flows, you might want to keep certain parts of the flow going, even when other parts fail. Not only is this possible, but it’s very easy to set up. Read on to learn how to keep Power Automate running after a failure.
Read More »Resilient Cloud Flows: How to Keep Power Automate Running After FailureThis is my second post discussing a large PDF processing automation project. In the first post, I focused on how to bring data into PAD from Excel, transform that data from a table to a list, and remove nulls from the list. Now, I want to talk about how I use OCR in Power Automate Desktop to translate PDFs to text and look for specific keywords. Check out this post for the details.
Read More »The Power of OCR in Power Automate DesktopThe first tutorial I ever watched on writing expressions in Power Automate used the Compose action. So, I used Compose actions anytime I needed to write an expression until I ran into problems. But, Compose isn’t the only action you can use. This post explains three things you should take into consideration when choosing which action to use for writing expressions in Power Automate. Read on to learn more.
Read More »Where Do You Write Expressions in Power Automate?