Coffing Data Warehousing Software

Understanding Advanced Python: Handling JSON Data

This post is the seventh part of a series on Advanced Python. In this series, we’ll take what we learned in our Understanding Python Basic series (Part One of that series found here) and expand on it to understand the more challenging parts of Python. In Part 7, you’ll be learning about handling JSON data. 

If you want to use the Nexus as your Python editor, then you will find instructions at the end of the blog on how to set this up!

Tera Tom here! Welcome to Part 7 of our lesson on Advanced Python! Before we jump into handling JSON data, let’s make sure you have everything you need to follow along with this lesson. If you have a Python editor you want to use then you are all ready to go, but if you want an easy way to try these examples and more then go to www.CoffingDW.com and download the Nexus.  Once you have it installed just look at the picture below and see where the Python editor of Nexus exists.  If you want to install Python so you can practice with Nexus then go to the last page of this blog for detailed instructions.

Mapping JSON Data Types to Python

JSON (JavaScript Object Notation) is a popular standard for uses between a server and a web application. The json() module gives you the ability to convert between JSON and Python Objects. Below, is a table for mapping conversions between the two.  

Convert JSON to Python Object (Dictionary/Map)

The JSON module gives you the ability to convert between JSON and Python Objects.

Impressive Printing of JSON

The JSON module gives you the ability to convert between JSON and Python Objects.  We used the JSON.dumps module to make the printing look nice.

Mapping JSON Data to a List

The JSON module gives you the ability to convert between JSON and Python Objects.  In our example below, our JSON data is directly mapping to a Python list.

Convert JSON to Python Object (float)

The JSON module gives you the ability to convert between JSON and Python Objects.  In our example below, Floating points can be mapped using the JSON decimal library.

Using JSON data on multiple objects

 

The JSON module gives you the ability to convert between JSON and Python Objects.  In our example below, our JSON data hold multiple objects, but this is how you print each name and the city in which they work.   

 

Using JSON data on multiple objects with Error Handling

In our example below, we have implemented error handling.  We then spelled ‘city’ wrong. Our error handling delivered the message.

JSON data on multiple objects with Error Handling Example

In our example below, we have implemented error handling, but this time, we made no mistakes.  Nailed it!

Convert Python Object (Dictionary) to JSON  

In our example below, we have converted a Python Object (Dictionary/Map) to JSON using the JSON.dumps() function.  

Python Dictionaries to JSON Strings with Sorting

In our example below, we have converted a Python Object (Dictionary/Map) to JSON using the JSON.dumps() function. Our first print example does not sort the new JSON string, but the second example shows you exactly how to sort.  

Python Objects to JSON  

In our examples below, we have converted four Python Objects (Tuple, List, String, and Boolean) to JSON using json.dumps().  

Python Numbers to JSON Numbers

In our examples below, we have converted three Python numbers to JSON numbers using json.dumps().

JSON strings to Python Dictionary

In our examples below, we have converted a JSON string to a Python Dictionary.

How to Install and Setup Python on your Nexus

  1. Download the latest version of Nexus from our website.  https://www.coffingdw.com/nexus-trial/
  2. Once installed download Python for Windows.  https://www.python.org/downloads/windows/

Your version number can vary, but you will want to download the Windows installers. So for Python for Windows 3.7.3 located here (https://www.python.org/downloads/release/python-373/) you will select one of these highlighted links:

Note:  Nexus comes in three versions:  Nexus 64-bit, Nexus 32-bit, and Nexus WOW-64 (For 64-bit machines with 32-bit Microsoft Office installed).X86-64 can be used for the 64-bit or Wow64 version of Nexus and x86 can be used only on the 32-bit version of Nexus.

When installing, if you have the option, select “Add Python to PATH”.


If you are using an older version of Python and do not have this option, then you will need to add the path to your python executable to your PATH environment variable. Be careful when editing this variable as it can affect many Windows functionality issues. If you don’t feel comfortable about this then consult with your desktop support.

Python 3.7.3 was installed in the following directory on our PC.

C:\Users\Todd\AppData\Local\Programs\Python\Python37

You can view your Python directory by opening File Explorer and pasting in the following path:

%LocalAppData%\Programs\Python

Once you have the path to the python.exe executable then add it to your Environment PATH variable by following the direction in this link:

https://www.computerhope.com/issues/ch000549.htm

And that is how you install Python into the Nexus Query Chameleon! 

Ready for more Python training? Make sure to check out our article about some helpful Tricks and Tips with Advanced Python! Or, if you’d prefer Tera-Tom to come teach at your organization, contact our team for booking information.