CSV File Operations: Writing and Updating

Active learning helps students grasp CSV operations because writing and updating files requires hands-on handling of data structures and file management. When students write and test code in real time, they immediately see how CSV files behave differently from spreadsheets or databases, making abstract concepts concrete through practice.

• Class 12
• Computer Science
• 4 activities
• 25 min–45 min

Learning Objectives

1. Create a Python script to write a list of dictionaries to a CSV file, ensuring correct header and data formatting.
2. Analyze the limitations of directly updating specific rows in a CSV file without reading the entire file.
3. Design a Python script that uses a temporary file to effectively update records in a large CSV dataset.
4. Evaluate the trade-offs between in-memory modification and temporary file usage for CSV updates based on dataset size.

Collaborative Problem-Solving

⏱ 30 min·Pairs

Pair Programming: Dictionary to CSV Writer

Pairs create a list of student dictionaries with keys like name, marks, grade. One partner dictates the code using csv.DictWriter, the other types and runs it to generate a CSV file. Switch roles, then verify output with a text editor and discuss header handling.

Prepare & details

Construct a Python script to write a list of dictionaries to a CSV file.

Facilitation Tip: In Pair Programming: Dictionary to CSV Writer, circulate and ask each pair to explain one line of their code to you before they run it, ensuring understanding of csv.writer and dictionary keys.

Setup: Flexible seating that allows clusters of 5-6 students; desks can be grouped in rows of three facing each other if fixed furniture limits rearrangement. Wall or board space for displaying group norm charts and the session agenda is helpful.

Materials: Printed problem brief cards (one per group), Role cards: Facilitator, Questioner, Recorder, Devil's Advocate, Communicator, Group norm chart (printable poster format), Individual reflection sheet and exit ticket, Timer visible to the class (board countdown or projected timer)

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Collaborative Problem-Solving

⏱ 45 min·Small Groups

Small Groups: Row Update Challenge

Groups read a sample CSV of inventory data, search for a product ID, update its price in a list, and rewrite the file. Compare results if done naively versus with a temporary file. Note time and memory differences.

Prepare & details

Analyze the challenges of updating specific rows in a CSV file directly.

Facilitation Tip: For Small Groups: Row Update Challenge, provide a printed sample CSV so groups can annotate it with their update strategy before coding, reducing trial-and-error errors.

Setup: Flexible seating that allows clusters of 5-6 students; desks can be grouped in rows of three facing each other if fixed furniture limits rearrangement. Wall or board space for displaying group norm charts and the session agenda is helpful.

Materials: Printed problem brief cards (one per group), Role cards: Facilitator, Questioner, Recorder, Devil's Advocate, Communicator, Group norm chart (printable poster format), Individual reflection sheet and exit ticket, Timer visible to the class (board countdown or projected timer)

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Collaborative Problem-Solving

⏱ 40 min·Whole Class

Whole Class: Large Dataset Simulation

Teacher shares a 1000-row CSV script. Class follows along to write it, then updates 10% of rows using temp files. Students vote on efficiency via show of hands and share one lesson learned.

Prepare & details

Justify the use of temporary files for modifying large CSV datasets.

Facilitation Tip: During Whole Class: Large Dataset Simulation, project the dataset on the board and simulate the memory constraints by limiting the number of rows groups can load at once, making the inefficiency of full rewrites tangible.

Setup: Flexible seating that allows clusters of 5-6 students; desks can be grouped in rows of three facing each other if fixed furniture limits rearrangement. Wall or board space for displaying group norm charts and the session agenda is helpful.

Materials: Printed problem brief cards (one per group), Role cards: Facilitator, Questioner, Recorder, Devil's Advocate, Communicator, Group norm chart (printable poster format), Individual reflection sheet and exit ticket, Timer visible to the class (board countdown or projected timer)

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Collaborative Problem-Solving

⏱ 25 min·Individual

Individual: Debug and Optimise

Each student gets a buggy update script with errors like unclosed files or wrong modes. Fix it, test on provided data, and add temp file logic. Submit optimised version with comments.

Prepare & details

Construct a Python script to write a list of dictionaries to a CSV file.

Setup: Flexible seating that allows clusters of 5-6 students; desks can be grouped in rows of three facing each other if fixed furniture limits rearrangement. Wall or board space for displaying group norm charts and the session agenda is helpful.

Materials: Printed problem brief cards (one per group), Role cards: Facilitator, Questioner, Recorder, Devil's Advocate, Communicator, Group norm chart (printable poster format), Individual reflection sheet and exit ticket, Timer visible to the class (board countdown or projected timer)

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Teaching This Topic

Teachers should model the entire CSV writing process step by step, including header handling and quoting, while narrating each decision aloud. Avoid demonstrating 'magic' functions without breaking them down, as students need to see the mechanics of file handling to debug their own scripts. Research shows that students learn file operations best when they experience firsthand the consequences of forgetting to close files or mismanaging delimiters, so planned errors in live coding help solidify correct practices.

What to Expect

By the end of these activities, students should confidently write CSV files from dictionaries, explain why direct row updates are inefficient, and use temporary files or in-memory edits to modify data safely. Successful learning is visible when scripts run without errors and produce correctly formatted files that can be opened in any spreadsheet application.

Watch Out for These Misconceptions

Common Misconception

During Pair Programming: Dictionary to CSV Writer, some students may assume CSV files can be edited like spreadsheets, leading them to attempt direct row modifications.

What to Teach Instead

Have pairs attempt to write a script that directly changes a row in the CSV file without reading the entire file first. When their script fails, guide them to observe the error message and discuss why CSV files require full reads and rewrites, then provide a corrected version using a temporary file approach.

Common Misconception

During Pair Programming: Dictionary to CSV Writer, students might use print() statements to output data, assuming it formats correctly for CSV.

What to Teach Instead

Ask pairs to compare the output of print() and csv.writer() side by side on a small dataset. Have them note differences in line breaks and quotes, then modify their script to use csv.writer() exclusively, reinforcing proper CSV formatting.

Common Misconception

During Individual: Debug and Optimise, students may omit closing files, assuming Python handles it automatically.

What to Teach Instead

Provide a script with an intentionally missing file close statement and simulate a crash mid-write. Students will observe incomplete or corrupted files, leading them to revise the script with a with statement or explicit close() call, and explain why it matters in their reflection.

Assessment Ideas

Quick Check

After Pair Programming: Dictionary to CSV Writer, ask students to submit their 'students.csv' file and a screenshot of their Python script. Check if the file contains all data rows with correct headers and proper quoting.

Exit Ticket

After Small Groups: Row Update Challenge, ask students to write a 2-3 sentence response explaining why directly editing a CSV file is problematic and describing the alternative method their group used (e.g., temp file rewrite).

Peer Assessment

During Individual: Debug and Optimise, have students swap scripts with a partner and review each other’s code for logical errors, correct file handling, and use of temporary files. Each student must provide one constructive suggestion for improvement and justify it.

Extensions & Scaffolding

• Challenge students to write a script that updates only rows matching a specific condition (e.g., students with grades below 40) without using any external libraries like pandas.
• For struggling students, provide a partially completed script with comments guiding them through the steps of reading, modifying, and writing the CSV.
• Deeper exploration: Ask students to research and implement a method to append new data to an existing CSV without rewriting the entire file, comparing its efficiency with full rewrites in their notebooks.

Key Vocabulary

CSV (Comma Separated Values)	A plain text file format where data is organized in rows, with values in each row separated by a comma or other delimiter.
Dictionary (Python)	A collection of key-value pairs in Python, useful for representing structured data where keys can map to specific values, like column headers to data.
Delimiter	A character, such as a comma or tab, used to separate distinct values within a line of text in a file.
Temporary File	A file created by a program for short-term storage during an operation, often used as an intermediate step before writing the final output.