1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
aleksandrvk [35]
3 years ago
11

"Create a Python program named detect_column_level_data_entry_errors. When complete, you will run this program to produce a diag

nostic report that shows data entry errors that cause column totals in the data to be out of balance. You will be expected to edit the cleaned_data.txt input file and make corrections until running this program shows that all column-level errors have been resolved."
Computers and Technology
1 answer:
11111nata11111 [884]3 years ago
8 0

Answer:

See explaination

Explanation:

Code for detect_column_level_data_entry_errors.py:

# File: detect_column_level_data_entry_errors.py

# The program will produce a diagnostic report that shows data entry errors that cause column

# totals in the data to be out of balance. Will need to fix cleaned_data.txt until errors resolved.

def main():

input_filename = input('Please enter the input filename: ')

infile = open(input_filename, 'r', encoding='utf8')

total_males = 0

total_females = 0

sum_total = 0

print('\n{0:^40}'.format('Column-Level Data Entry Errors'))

print('\n{0:<10}{1:>10}{2:>10}{3:>10}'.format(

'Age Group', 'Males', 'Females', 'Total'))

for line in infile:

age_group, males, females, total = line.split()

males = int(males)

females = int(females)

total = int(total)

print('{0:<10}{1:>10,}{2:>10,}{3:>10,}'.format(

age_group, males, females, total))

if age_group != 'Total':

total_males = males + total_males

total_females = females + total_females

sum_total = total + sum_total

else:

print('{0:<10}{1:>10,}{2:>10,}{3:>10,}'.format(

'Error', (males-total_males), (females-total_females), (total-sum_total)))

infile.close()

main()

You might be interested in
Until 2015, each new Roblox user automatically had one friend. What was he called?
RUDIKE [14]

Until 2015, each new Roblox user automatically had one friend and the friend was called Builderman

Builderman is the friend that is provided automatically for all users until 2015

<h2>Further Explanation</h2>

The builderman welcomes each new Roblox user, send a message to them and automatically follows every user until when it was discontinued in 2014. The role of the Builderman was to introduce the game experience to each new Roblox user.

Roblox is an online game and serves as a platform where users can also create their own games. Roblox gives its users the platform to design their own games and allow its user to different kinds of games that are created by other users on the platform

Roblox hosts numerous games designed by its users and virtual worlds which covers different genres, such as traditional racing, obstacle courses and many more.

Roblox has millions of users worldwide, its monthly active users are over 100million. Roblox also allows its users to create virtual items for sale. This also implies, its users can create virtual items and sell them for other users

Roblox was founded by David Baszucki and Erik Cassel; it was released on September 1, 2006. It is a platform that allows single-player and multiplayer.

LEARN MORE:

  • Until 2015, each new Roblox user automatically had one friend. What was he called?  brainly.com/question/12694552
  • What is the programming language of Roblox called?  brainly.com/question/13166316

KEYWORDS:

  • roblox
  • builderman
  • friend
  • message
  • automatically
  • david baszucki
  • erik cassel
6 0
3 years ago
Read 2 more answers
True or false? malware problems and other compromises of your computer information are rare.
Marina86 [1]
I think that is false I am not 100% sure.
3 0
3 years ago
What was the job of the Committee of Correspondence? WILL GIVE BRANLEST AND 40 POINT
Wewaii [24]

Answer:

how many of these information have you shared

5 0
2 years ago
How many binary digits are in 10^100.
Basile [38]

Answer:

333 binary digits.

Explanation:

8 0
2 years ago
An organization needs to maintain data files of its employees in the form of tables. They also need to access and update over th
QveST [7]
DBMS (DataBase Management System)
6 0
3 years ago
Read 2 more answers
Other questions:
  • The term composite would be used to describe an image that was altered by the Crop tool.
    15·1 answer
  • The house had a wonderful pool of ... (his/its/our) own.​
    5·1 answer
  • Based on the passage​ and/or drawing on your prior​ knowledge, you realize that an HMO is​ what?
    9·1 answer
  • Once a graph has been created, you would need to start over to make any changes to it?
    5·1 answer
  • Write a program in Python that reads in investment amount, annual interest rate, and number of years, and displays the future in
    6·1 answer
  • Caleb is a big fan of science fiction, so he loves picturing the ________ gland as the captain of his personal starship, pulling
    9·1 answer
  • What stylistic device does Reverend Jesse Jackson use in the following statement: "We must relate instead of debate; we must ins
    10·1 answer
  • The remove() method in the Queue interface ________. Group of answer choices retrieves, but does not remove, the head of this qu
    14·1 answer
  • Pleaseeeeeeeee I will give a brainliest
    7·1 answer
  • Help me and i'll mark brainliest
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!