Reading test data from CSV in Selenium Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main purpose of reading test data from a CSV file in Selenium tests?

To separate test data from test scripts, making tests easier to maintain and allowing multiple data sets to be tested without changing the code.

beginner

Which Python module is commonly used to read CSV files for test data?

The built-in csv module is commonly used to read CSV files in Python.

beginner

How do you open a CSV file safely in Python to read test data?

Use a with open('filename.csv', newline='') block to open the file. This ensures the file is properly closed after reading.

beginner

What is a simple way to loop through rows of a CSV file to use as test data?

Use csv.reader(file) to get rows, then loop with for row in reader: to access each row's data.

beginner

Why is it better to use CSV files for test data instead of hardcoding data in Selenium scripts?

CSV files allow easy updates to test data without changing code, support multiple test cases, and help keep tests clean and organized.

Which Python module helps read CSV files for Selenium test data?

A json

B csv

C os

D sys

The csv module is designed to read and write CSV files easily.

What does the 'newline' parameter do when opening a CSV file in Python?

A Prevents extra blank lines when reading CSV files

B Specifies the file encoding

C Sets the file mode to write

D Closes the file automatically

Using newline='' prevents extra blank lines when reading CSV files on some platforms.

How do you access each row of data when reading a CSV file?

A Using open() without csv module

B Using json.loads()

C Using Selenium WebDriver

D Using a for loop over csv.reader object

csv.reader returns an iterable that you can loop through to get each row.

Why is separating test data from test scripts useful?

A It makes tests easier to update and reuse

B It slows down test execution

C It makes code harder to read

D It requires more coding

Separating data allows updating test inputs without changing test code.

Which of these is NOT a benefit of using CSV files for test data?

A Easy to edit test data

B Supports multiple test cases

C Automatically runs Selenium tests

D Keeps test code clean

CSV files store data but do not run tests automatically.

Explain how to read test data from a CSV file in a Selenium Python test script.

Think about file handling and looping through data.

Why is it a good practice to keep test data in CSV files instead of hardcoding it in Selenium scripts?

Consider maintenance and reusability.