Question

Query= sectiona
>Fruits
Yes = (50%) No = (25%) Maybe = (25%)
Query= sectionb
>Vegetables
Yes = (25%) No = (50%) Maybe = (25%)
Query= sectionc
>Dairy
Yes = (12%) No = (18%) Maybe = (70%)
Query= sectiond
>Meat
Yes = (60%) No = (20%) Maybe = (20%)

The above is in a separate file named 'Example.txt' that has to be opened. Using Python, Write a script that opens the file and creates an output in the format given below so that only the query with the highest percent yes is given without just extracting strings, solve for it.

Query Food Percentyes

sectiond meat 60%

Answer 1

Here is the completed code for this problem. Comments are included, go through it, learn how things work and let me know if you have any doubts. Make sure that you maintain proper indentations while pasting the below code into your program, I’m also attaching the code in both text and image formats, so in case if the indentation is messed up, you can refer the image and maintain proper spacing in each and every line. Thanks

If you are satisfied with the solution, please rate the answer.

#code

import re
#method to open the queries file and display the results
def openFile(filename):
    #opening file
    f=open(filename)
    #loading lines into a list, after removing newline characters
    lines=[x.strip() for x in f]
    #variable to store the highest percentage for yes
    highestPercentYes=-1
    #list variable to store the query, result and yes percent for the highest percentage yes
    queryHighest=[]
    i=0
    #looping until all lines are read, assuming input file is valie
    #and does not contain blank lines
    while i<len(lines):
        #getting line
        line=lines[i]
        #removing 'Query=' and saving the query in a variable
        query=re.sub('Query=','',line).strip()
        #moving to next line
        i+=1
        line=lines[i]
        #extracting the result after removing '>' symbol
       result=re.sub('>','',line).strip()
        #moving to next line
        i+=1
        line = lines[i]
        #finding the percentage for yes (it'll be in the first pair of parantheses)
        #and converting into integer
        yes=int(line[line.find("(")+1:line.find(")")][:-1])
        #checking if yes is greater than current highestPercentage
        if yes>highestPercentYes:
            #making this as the new highest percentage yes
            highestPercentYes=yes
            #storing the details on a list
            queryHighest=[query,result,yes]
        i+=1 #next line

    #displaying the query with highest percent yes in a tab seperated format
    print('Query\tResult\tPercentyes')
    print('{:s}\t{:s}\t{:d}%'.format(queryHighest[0],queryHighest[1],queryHighest[2]))
#opening and displaying queries from a file named 'Example.txt'
openFile('Example.txt')

#code screenshot

#output

Query Result Percentyes

sectiond            Meat    60%