Westonci.ca is the Q&A platform that connects you with experts who provide accurate and detailed answers. Join our platform to connect with experts ready to provide precise answers to your questions in different areas. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.
Sagot :
Answer:
import pandas as pd
filename = input("Enter file name with the extension included: ")
data = {}
with open("filename", "r") as file:
content = file.readlines()
for line in content:
line_list = line.strip().split(" ")
data[line_list[0]] = line_list[1] * line_list[2]
del line_list
report = pd.DataFrame(list(data.items()), columns = ["lastname", "wages paid"])
print(report)
Explanation:
The python module prompts the user for the file name and opens the text file to extract the employee data with the python open function. It iterates over the file content and saves the last name and the wages paid to the employees ( the hours worked multiplied by the hourly rate) in the dictionary "data".
The dictionary is converted to a dataframe with the Pandas python package and displays the data in tabular format on the screen.
Following are the required code to make a report in tabular format by using the appropriate headers:
Python code:
file_name = input('Enter input filename: ')#defining a variable file_name that inputs file value
try:#defining try block that uses thr open method to open file
file = open(file_name, 'r')#defining file variable that opens file
except:#defining exception block when file not found
print('Error opening file ' , file_name)#print message
exit()#calling exit method to close program
print('{:<12s} {:>10s} {:>10s}'.format('Name', 'Hours', 'Total Pay'))#using print method to print headers
for l in file.readlines():#defining loop that holds file value and calculate the value
name, hour, wages = l.split()#defining variable that holds the value of file
hour = int(hour)#holiding hour value
wages = float(wages)#holiding wages value
total = hour * wages#defining variable total variable that calculates the total value
print('{:<12s} {:>10d} {:>10.2f}'.format(name, hour, total))#print calculated value with message
file.close()#close file
Required file (data.txt) with the value:
Database 34 99
base 30 90
case 34 99
Program Explanation:
- Defining the variable "file_name" that uses the input method to input the file name with an extension.
- Using the exception handling to check the file, with using the try block and except block.
- In the try block check file, and in except block print message with the exit method when file not found.
- In the next line, a print method has used that prints the header and uses a loop to read the file value.
- Inside the loop, a header variable is used that splits and holds the file value, calculates the value, prints its value with the message, and closes the file.
Output:
Please find the attached file.
Find out more information about the Program code here:
brainly.com/question/18598123
Visit us again for up-to-date and reliable answers. We're always ready to assist you with your informational needs. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.
