Pandas: Can you rewrite this line to use df.loc?

I have been working through Reindert-Jan Ekker excellent Plurasight course Pandas Playbook: Manipulating Data and right at the end of Demo: Detecting and Inspecting Missing Values, part of Module 5 Cleaning data, he asks the following question: # Can you rewrite this line to use df.loc? df[‘MIN_TEMP_GROUND’].drop(every_6th_row).isnull().all() True This code checks that data for MIN_TEMP_GROUND […]

Viewing Pandas DataFrame in VS Code

In this post I will show you how to access the Data viewer which is a useful tool to review, sort and filter data within a Pandas DataFrame. Required VS Code Extension If you have not already done so, add the Python extension for Visual Studio Code from Microsoft. Code Sample In the code example […]

Django: Using an Oracle database

This post will show you how to configure a Django application to use an Oracle database. Demo overview The goal of the Django project is to store episode information for the crime fiction television series Columbo. What you will need To build this demo I used the following: VS Code 1.5.6 Django 3.2.3 Python 3.9.1 Oracle Database […]

Python Regular expressions in four steps

This post shows you how to use Regular expressions in Python. Step 1 Import There is no native support within Python for Regular expressions so the first step is to import the re module Step 2 Compile The next step is to compile the Regular expression. The compile method accepts a Regular expression and returns […]

pytest: Different directories

This post describes a problem you may encounter when using pytest and the module and unit tests resided in different directories. In this post I used Python 3.6.1 and VS Code 1.52.1 running on Windows 10. The module and the unit tests can be found on GitHub. The code and the tests is a […]