If you’ve opened Azure Data Studio recently, you probably noticed a message saying that support for the IDE will end on February 28, 2026 (read full announcement). Microsoft says it wants to simplify the development of data developer tools. And that means integrating...
The Polars Cast Function The Polars Cast Function lets you change column data types on a Polars DataFrame. There are several scenarios where you might need to change a column’s data type: Ensuring Compatibility: Some operations require specific data types. Optimizing...
Package Dependencies When developing your own python packages, you may run into instances where you want to use an existing library rather than create certain functionalities from scratch. Integrating modules and functions from other libraries into your own introduces...
Introduction A while back I was working on a project where I was bringing new data into a database. This would be one of many files that would come in about once a month. While automating the process in Polars, I ran into an issue with the data types that were being...
Introduction When it comes to python package development tools, there are an increasing number of options available. You may have heard of tools like hatch and poetry, but there’s a new kid on the block. UV enables you to create python projects, manage environments,...
Introduction UNIX timestamps are commonly used in computing. They usually represent the number of seconds that have elapsed since epoch which is January 1, 1970. In this article, we show you how to work with this unique data type in polars. If you’d prefer a video...
Hash functions are powerful tools in data security, especially when dealing with sensitive or personally identifiable information (PII). This article provides an overview of using hash functions in Python, with examples focused on data security using the Polars...
Frame SQL is one of the best features available in Polars and is a considerable step up from how data is queried in libraries like Pandas. Those familiar with Pandas will tell you that querying data takes some getting used to. Rather than using SQL, you must use a...
Why Use Regular Expressions Regular expressions in polars allow you to search for specific patterns within unstructured text. This capability helps you extract valuable insights from what might initially seem like random, disorganized data. By identifying patterns,...
https://youtu.be/4ihTtl54ybQ Combining multiple CSV files into a single dataset is a common task in data analysis, especially when working with data that spans multiple time periods or categories. With Polars, this process becomes incredibly straightforward. In this...
Image Source: Polars GitHub Project Polars has been on an extremely fast development path for the past couple of years. The development team impressed us with faster speed and performance. Now they’ve officially released polars version 1.0.0! Here are some of the new...
Preparing for the GitHub Foundations exam was a wake up call for me. I’ve used GitHub for years, but was shocked by how many features I didn’t even know about. Regardless of if I even passed the exam, there was an immediate benefit to how I utilized GitHub. That said,...
I’ve been using GitHub for a number of years now. But GitHub recently launched its certification program and I became curious. Is it worth my time to obtain some of these certifications? That curiosity lead me to research the 4 available exams. I wanted to see which...
Recently, I was tasked with creating a report to track how much our loan officers were spending on customer credit pulls. This data did not previously exist in our SQL Server database, but we did have about 6 months of raw invoice data contained in CSV files. In order...
Replaced or Improved Job Security? If you believe that Generative AI will replace programmers in the next 20 years, you might want to challenge that belief! Generative AI does a great job assisting with code development. I’ve personally used it to help on a number of...
You might have heard about the advantages of getting your SQL development team onto a version control system, but may be stuck on how to get there. This article is here to help you implement version control on your SQL Server database!
Based on my experience working as a Business Intelligence Professional, I have a suspicion that many SQL Development teams do not keep track of changes to their code using a version control system. If this is you or your organization, you need to consider the...
Introduction JavaScript Object Notation (JSON) is a data format that's used to transport data across the web. Python has built in data structures and types that are very similar to JSON's, but in order for us to interact with JSON data in python we need to deserialize...
https://www.youtube.com/watch?v=iz1VsZkCpgM read csv Files Using Polars In this article, we're going to walk through how to read csv files into a polars dataframe. To do this we'll be utilizing a function called read_csv. This function comes with a number of arguments...
In this article, we'll demonstrate how to write to a database using the polars write_database function. This function allows users to write data into a variety of databases. Let's explore the various options available when working with this feature in Polars. Writing...