Bird
0
0

You want to read a CSV file where the first row contains column names, and then write a new CSV file with only rows where the 'Age' column is greater than 25. Which approach is correct?

hard📝 Application Q15 of 15
Python - Structured Data Files
You want to read a CSV file where the first row contains column names, and then write a new CSV file with only rows where the 'Age' column is greater than 25. Which approach is correct?
AUse csv.reader to read, skip first row manually, filter rows, then write with csv.writer.
BUse csv.writer to read and write files directly without filtering.
CUse csv.reader to read all rows, convert 'Age' to int, then write with csv.DictWriter without header.
DUse csv.DictReader to read rows as dictionaries, filter by 'Age' key, then write with csv.DictWriter including header.
Step-by-Step Solution
Solution:

  1. Step 1: Choose reading method with headers

    csv.DictReader reads CSV rows as dictionaries using the first row as keys, making it easy to filter by column names like 'Age'.

  2. Step 2: Filter and write with headers

    Filter rows where 'Age' > 25, then write using csv.DictWriter with fieldnames to include headers properly.

  3. Final Answer:

    Use csv.DictReader to read rows as dictionaries, filter by 'Age' key, then write with csv.DictWriter including header. -> Option D

  4. Quick Check:

    DictReader + DictWriter for header and filtering [OK]
Quick Trick: Use DictReader/DictWriter for header-based filtering [OK]
Common Mistakes:
  • Skipping header manually instead of using DictReader
  • Writing without headers causing missing columns
  • Using csv.writer without filtering logic

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Python Quizzes
Classes and Object Lifecycle - Class attributes - Quiz 13medium Context Managers - Automatic resource cleanup - Quiz 3easy Custom Exceptions - Adding custom attributes - Quiz 3easy Custom Exceptions - Extending built-in exceptions - Quiz 15hard Exception Handling Fundamentals - Why exceptions occur - Quiz 6medium File Handling Fundamentals - Appending data to files - Quiz 5medium File Handling Fundamentals - Opening and closing files - Quiz 14medium File Reading and Writing Strategies - Writing multiple lines - Quiz 7medium Magic Methods and Operator Overloading - Arithmetic operator overloading - Quiz 14medium Polymorphism and Dynamic Behavior - Purpose of polymorphism - Quiz 3easy