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
The JSON module gives you the ability to convert between JSON and Python Objects.
Impressive Printing of JSON
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.
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
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
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.
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
How to Install and Setup Python on your Nexus
- Download the latest version of Nexus from our website. https://www.coffingdw.com/nexus-trial/
- 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.
You can view your Python directory by opening File Explorer and pasting in the following path:
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:
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.
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.