Question

Sangeeta is a Python programmer working in a computer hardware company. She has to maintain the records of the peripheral devices. She created a csv file named Peripheral.csv to store the details. Structure of Peripheral.csv:

\begin{tabular}{|c|c|c|} \hline \textbf{P\_id} & \textbf{P\_name} & \textbf{Price} \\ \hline \end{tabular}

• P\_id is the Peripheral device ID (integer).
• P\_name is the Peripheral device name (string).
• Price is the Peripheral device price (integer).

Sangeeta wants to write the following user-defined functions:

1. Add\_Device(): To accept a record from the user and add it to the CSV file, Peripheral.csv.
2. Count\_Device(): To count and display the number of peripheral devices whose price is less than 1000.

Hint:

Use csv.writer to write data to a CSV file and csv.reader to read data from a CSV file. Handle exceptions for invalid or header rows when processing numeric values.

Answer 1

The Add_Device() function:

• Opens Peripheral.csv in append mode.
• Prompts the user for peripheral device details (P_id, P_name, Price).
• Appends the new record as a row to the CSV file using csv.writer().

The Count_Device() function:

• Opens Peripheral.csv in read mode.
• Iterates through each row, checking if the Price (third column) is less than 1000.
• Tallies devices meeting this price criterion and displays the final count.