Python CSV Files and 2D Arrays - How to Read and Process CSV Files into Python 2 Dimensional Arrays

Subscribe to our Channel to get regular Video Lessons in Python Programming.

Because we are a slow talker, we recommend you use the YouTube "Tools Cog" on the player bar to watch the video at a speed of 1.5x or even 1.75x.

In this Lesson we learn about How To Read an External CSV File into a multi-dimensional Array in Python by making a Super Market Price Checker, and a Quote of the Day Program.


Resources Download Link:
https://tinyurl.com/wwhluj7

You do not have to use PyScripter for our Course. All of the program code will run in Python 3.7 or higher.
So if you want to use other popular Python IDE’s like PyCharm or MU, that will be okay.

In this Python Lesson we create a program that provides a Price Check for a Supermarket Item.

There is also a Challenge Task where you will make a program to provide a Random Quote of the Day.

The Python Learning which this Lesson will provide is:

- How to create a Comma Separated CSV Input File using Windows Notepad.
- How to Read the CSV File Line By Line into a Python Program.
- How to place each line of the CSV File into an Array in Program Memory.
- How to extract Specific Items from the Array by Processing a 2 dimensional Array.
- How to Print the extracted records and fields in a Rows and Columns output format.


Using logically organised subroutines driven from a Main Process is a critical part of programming in all computer languages.
It is vitally important to study and understand the program code, as well as the organisation structure of the program.

Because we are a slow talker, we recommend you use the YouTube "Tools Cog" on the player bar to watch the video at a speed of 1.5x or even 1.75x.

If you are a Teacher watching this video then click the downloads link and get all of the lesson materials for your students.
These include detailed Step by Step Instructions including Pseudocode and a Challenge Task, and the Input CSV Files to save students typing time.
https://tinyurl.com/wwhluj7

Give these resources to your students and we think you will find that some of them will "get it" very quickly. The other students need to watch this video which goes through everything in full detail slowly step by step with repetition of examples.

This is a detailed video, if you want to fast track learning, then just Download and quickly work through the PDF of Step by Step Instructions using the Link given further down below.

There is also an Introduction and Overview PDF document giving a set of Learning Objectives for the Lesson included in the Lesson Downloads.

Then for anything you do not fully understand in these two documents, simply use the Timeline Index below to go and watch the relevant section of Video explanation.

If you have the time it will be extremely beneficial to watch the entire video to maximize learning outcomes.

VIDEO TIMELINE INDEX:

(Click on the time number to jump to that section of the video).

00:00 to 00:58 Introduction and Preview of Finished Challenge Task
00:58 to 03:45 Introduction and Preview of Finished Program
03:45 to 05:32 Overview of CSV Files and Python Processing
05:32 to 06:47 Structure of a CSV File
06:47 to 09:49 Creating and Editing CSV Files using Windows Notepad
09:49 to 11:14 Adding and Deleting CSV File Data using Notepad
11:14 to 14:21 Python 2D Array Structure for Storing CSV Records
14:21 to 17:41 Python CSV File 2D Array Processing Summary
17:41 to 18:58 Overview of Quote of the Day Challenge Task
18:58 to 20:39 V1-Setting up a Loop for Repeated Price Check Requests
20:39 to 24:05 V2-Load Input CSV File Records into a 2D Array
24:05 to 26:12 V3-User Selects Category for Price Check
26:12 to 29:38 V4-Process User Selection and Print Price List
29:38 to 32:51 V5-Price Check Using Separate Category Arrays
32:51 to 35:06 Challenge Task - Random Quote of the Day
35:06 to 35:35 Our Website Python Programming Course
35:35 to 35:55 Video Wrap Up and Outro


This video will be useful for anyone learning Computing, especially students doing VCE Applied Computing or VCE Software Development or HSC Computing high school courses in Australia, and GCSE in the UK.

Check with your Teacher or Instructor before getting any Downloads from our Website, as they may already have these materials for you.

You can download a hard copy of the Step By Step Instructions Guide, and the Full Program Code at the following link:
https://tinyurl.com/wwhluj7

Check with your Teacher or Instructor first, as they may already have these Download materials for you.

You can check out our full Python Programming Course at the following link:
http://passyworldofict.com/python

We are planning to make a number of Structured Programming Videos that will be a great course for people to learn how to Program in Python.

Like this video if you found it helpful.

Subscribe to our Channel to get notified of our weekly video updates.

Enjoy,
Passy