Computer Science

comma-separated values are a plaintext data file                where each value is separated by a single comma

displaying data in a grid of rows and columns

a Python method which removes any leading, and trailing whitespaces or characters that you specify

a Python method which is used to break a string into a list based on a specified delimiter

Reading CSV files

This unit introduces pupils to the new data structures of records and dictionaries. They will develop a Caesar cipher encryption program using a dictionary as a cipher wheel. Pupils will explore how data can be read from and written to files and how this data can be used within a program.

Programming: dictionaries and data files

Which Python method is used to remove leading and trailing spaces from a string?

What type of structure does a CSV file follow?

In a CSV file, each {{}} represents a new record.

The default delimiter in a CSV file is a {{}}.

Which Python method is used to break a string based on a specific delimiter?

Which method reads the entire content of a file as a single string?

adds content to a file and overwrites any existing data

adds content to the end of an existing file

opens the file for writing and overwrites existing content

opens the file for writing without overwriting.

What does the "w" mode do when opening a file?

Which method is used to free up system resources?

What mode should be used to read a file without modifying it?

What is the correct way to write multiple lines to a file in Python?

This lesson will be removed by end of Summer Term 2025.

Reading CSV files

Lesson outcome

This lesson will be removed by end of Summer Term 2025.