Skip to content
Coffing Data Warehousing Software

Understanding Advanced Python Part 3

This post is the third 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 3, you’ll be learning about Loops in Python. 

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 3 of our lesson on Advanced Python! Before I begin discussing what you can do with Loops in Python, 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.

Looping using a For Loop on Literals  

The example below is designed to show a “For” loop.  The keyword ‘for’ causes the loop. For each value in the list of numbers, we are printing out each value line by line.

Looping using a For Loop on a List

The example below is designed to show a “For” loop.  The keyword ‘for’ causes the loop. For each value in the list named Fibonacci_List we are printing out each value line by line.

Using a Range

The example below uses a range between 0 and 8.  Although it says 0 to 9, Python will go from 0 up to 8 and excludes 9.

Using a Range and Printing on the Same Line  

The example below uses a range between 0 and 8.  Although it says 0 to 9, Python will go from 0 up to 8 and excludes 9.  In our first range we print vertically, but in the other two ranges we print horizontally on the same line.  Notice that our end = statement of either two double quotes or two single quotes eliminates a newline.

Looping using a For Loop on Lists Within Lists  

The example below is designed to show a “For” loop.  The keyword ‘for’ causes the loop. For each value in the list of numbers we are printing out each value line by line.

Explaining Looping using a For Loop on Lists Within Lists

The example below is designed to show a “For” loop in greater detail.  The keyword ‘for’ causes the loop and notice we have two for loops. This example tells Python that for x we have two lists in our Num_List_2 list.  For y tells Python that in each list we have three numbers. We then print out [x] (both lists) and [y] (all three numbers per list.

Looping using a For Loop on Lists Within Lists

The example below is designed to show a “For” loop.  The keyword ‘for’ causes the loop. For each value in the list of numbers, we are printing out each value line by line.

Looping using a For Loop on Lists Within Lists – Tricky

The example below is designed to show a “For” loop.  The keyword ‘for’ causes the loop. For each value in the list of numbers, we are printing out each value line by line.

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? Check out our Youtube Tutorials that will be coming out in the following weeks! Or, if you’d prefer Tera-Tom to come teach at your organization, contact our team for booking information.