Question

I need help with one small part of the following question. I think I know how to do all the things the question is asking I just can’t figure out how to get it to open the text file. I tried Filename =input “vacation.txt” but that didn’t open the file. Does the program have to direct it to "find" the program? HERE IS THE COMPLETE QUESTION: Create a Python program that: Opens a file and reads the contents of the following file: vacation.txt -The file contains several lines of data, with each data item separated by commas. The data is: a. A vacation date b. The amount of fuel used on the vacation c. The number of miles traveled in the vacation. For each of the lines of data in the file, separate the data items and put them in appropriate variables (the file contents are in strings so you must convert the numbers in the data into the proper type) 1.Calculate the fuel mileage achieved on each vacation and display on a single line: a. Vacation date b. Amount of fuel used c. Number of miles traveled d. Fuel mileage calculated for each vacation 2.Create a new file to save the data read and the fuel mileage calculated for the vacation a. Write the data on separate lines and for each vacation in the data with each item separated by commas (remember that all the data must be saved in the string form) 3. Remember that the program should: a. Use variables with reasonable names b. Display easily understood prompts when collecting user input c. Prompt the user for the name of the file to read the data from and the name of the file to store the revised data d. Have comments explaining what each part of the program is doing Here is the data in the file vacation.txt 12-2-2019, 13, 244 12-23-2019, 17, 303 1-16-2020, 12, 210 2-10-2020, 25, 560 2-20-2020. 17, 412

Answer 1

python code for above problem is attached below :-

filename = input('Enter the file name in txt format: ');

filename = filename+'.txt'

data = [] #empty list to collect data from file

with open(filename) as fp: #openning file as fp

    line = fp.readline().strip() #reading file line by line and removing any extra spaces

    data.append(line)   #adding this read line to the data List

    while line: #continue reading until line is found

        line = fp.readline().strip() #reading file line by line and removing any extra spaces

        data.append(line) #adding this read line to the data List

data.remove('') #removing any empty space read from the file and stored in list

f= open("output.txt","w+") #file object to write data to another file named "output.txt"

for i in data: #iterating over data list

    s = i.split(',') #splitting the data on the delimiter ',' and making a list

    fuel_used = int(s[1].strip()) #taking 2nd item removing any extra space from the list items

    miles_travelled = int(s[2].strip()) #Taking 3 item and removing any extra space from the list items

    fuel_mileage = miles_travelled/fuel_used #calculating fuel mileage for each date

    # displaying information on console as specified in question

    print("for Vacation date : {0}, Amount of fuel used: {1}, Number of miles traveled: {2}, fuel mileage: {3}".format(s[0],s[1],s[2],fuel_mileage))

    # writing vacation date,fuel used,miles travelled, and fuel mileage to output.txt file separated by a ','

    f.write("{0}, {1}, {2},  {3} \n".format(s[0],s[1],s[2],fuel_mileage))  

# closing file output.txt

f.close();

code screenshot : -

input file: -

vacation.txt

output : -

output file (output.txt ) : -

if my answer helped then please upvote and comment for any queries

Thankyou !