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.

Practice

1. What is the main advantage of reading test data from a CSV file in Selenium Python tests?

easy

A. It allows running tests with multiple sets of data without changing the code.

B. It makes the test run faster by using CSV format.

C. It automatically fixes bugs in the test code.

D. It encrypts the test data for security.

Solution

1. Step 1: Understand the purpose of external test data

   Using CSV files lets you separate test data from test code, making tests flexible.

2. Step 2: Identify the benefit in test execution

   With CSV, you can run the same test multiple times with different inputs easily.

3. Final Answer:

   It allows running tests with multiple sets of data without changing the code. -> Option A

4. Quick Check:

   CSV externalizes data = flexible tests [OK]

Hint: CSV stores data separately for easy test reuse [OK]

Common Mistakes:

• Thinking CSV speeds up test execution
• Believing CSV fixes code bugs automatically
• Assuming CSV encrypts data

2. Which Python code snippet correctly opens a CSV file named data.csv for reading test data?

easy

A. file = open('data.csv', 'w')

B. file = open('data.csv', 'r')

C. file = open('data.csv', 'a')

D. file = open('data.csv')

Solution

1. Step 1: Identify the correct file mode for reading

   To read a file, use mode 'r' which stands for read-only.

2. Step 2: Check the options

   file = open('data.csv', 'r') uses 'r' mode correctly; others use write ('w'), append ('a'), or default mode which may not be explicit.

3. Final Answer:

   file = open('data.csv', 'r') -> Option B

4. Quick Check:

   Read mode = 'r' [OK]

Hint: Use 'r' mode to open files for reading [OK]

Common Mistakes:

• Using 'w' which overwrites the file
• Using 'a' which appends instead of reading
• Not specifying mode explicitly

3. Given the CSV file users.csv with content:

username,password
alice,pass123
bob,secure456

What will the output of this code be?

import csv
with open('users.csv', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        print(row)

medium

A. ('username', 'password')
('alice', 'pass123')
('bob', 'secure456')

B. username,password
alice,pass123
bob,secure456

C. Error: csv.reader cannot read files

D. ['username', 'password']
['alice', 'pass123']
['bob', 'secure456']

Solution

1. Step 1: Understand csv.reader output

   csv.reader reads each line as a list of strings split by commas.

2. Step 2: Analyze the print output

   Each row prints as a list, so header and data rows print as lists of strings.

3. Final Answer:

   ['username', 'password'] ['alice', 'pass123'] ['bob', 'secure456'] -> Option D

4. Quick Check:

   csv.reader returns lists per row [OK]

Hint: csv.reader returns list of strings per row [OK]

Common Mistakes:

• Expecting strings instead of lists
• Confusing tuples with lists
• Thinking csv.reader raises error on valid files

4. What is wrong with this code snippet that reads CSV data for Selenium tests?

import csv
file = open('testdata.csv')
reader = csv.reader(file)
for row in reader:
    print(row)
file.close()

medium

A. The file is not opened in read mode explicitly.

B. The file is not closed after reading.

C. Using open() without a context manager can cause resource leaks.

D. csv.reader cannot be used with open() function.

Solution

1. Step 1: Check file handling best practices

   Using open() without 'with' can cause the file to remain open if errors occur.

2. Step 2: Identify the issue in the code

   Though file.close() is called, if an error happens before, file may not close properly.

3. Final Answer:

   Using open() without a context manager can cause resource leaks. -> Option C

4. Quick Check:

   Use 'with' to auto-close files [OK]

Hint: Always use 'with' to open files safely [OK]

Common Mistakes:

• Thinking file.close() always prevents leaks
• Believing csv.reader can't work with open()
• Ignoring explicit read mode is optional

5. You want to run a Selenium test multiple times using usernames and passwords stored in credentials.csv. Which code snippet correctly reads the CSV and uses the data in a test function?

hard

A. import csv
with open('credentials.csv', 'r') as file:
reader = csv.DictReader(file)
for row in reader:
username = row['username']
password = row['password']
test_login(username, password)

B. import csv
file = open('credentials.csv', 'r')
reader = csv.reader(file)
for row in reader:
test_login(row[0], row[1])
file.close()

C. import csv
with open('credentials.csv') as file:
reader = csv.reader(file)
for row in reader:
test_login(row['username'], row['password'])

D. import csv
with open('credentials.csv', 'r') as file:
reader = csv.reader(file)
for row in reader:
test_login(row[0], row[1])

Solution

1. Step 1: Choose correct CSV reading method for named columns

   csv.DictReader reads CSV rows as dictionaries with column names as keys.

2. Step 2: Use dictionary keys to access username and password

   Accessing row['username'] and row['password'] matches CSV headers and passes correct data.

3. Final Answer:

   Using csv.DictReader and accessing row['username'] and row['password'] correctly. -> Option A

4. Quick Check:

   DictReader + keys = clean data access [OK]

Hint: Use csv.DictReader for named column access [OK]

Common Mistakes:

• Using csv.reader but accessing row by keys
• Not closing files without 'with' block
• Forgetting to specify read mode explicitly