I'm having trouble retrieving a specific value from a CSV file based on certain criteria within a function. Although my program successfully fetches all the values, it fails to return the one linked to the input I provided. Any assistance would be greatly appreciated.
An example of the data is as follows:
rose,7.95
lily,3.95
begonia,5.95
The function I have written looks like this:
def retrieve_value(csv_file, flower):
import csv
file = open(csv_file)
for row in csv.reader(file):
if flower in row[0]:
print(row[1])
file.close()
When I executed the program with the following line:
retrieve_value("flowers.csv","rose")
The output displayed all the values present in the file:
7.95
3.95
5.95
However, the desired outcome should only show the value associated with the second entry:
7.95
Thank you for your help.