Question: 1-Write a script in Python that delete all data discrepancies from a file as follows. The next 2 entries need to be discarded because the

1-Write a script in Python that delete all data discrepancies from a file as follows.

The next 2 entries need to be discarded because the session ID and the 4^th character of the exercise ID do not match as illustrated in the next 2 lines.

4, 91, Es_5_2, TextEditor_Es_5_2, 13.11.2014 11:37:41, 13.11.2014 11:37:53, 27673, 6, 0, 2, 0, 252, 0

4, 91, Es_5_2, Other, 13.11.2014 11:37:54, 13.11.2014 11:37:59, 343, 0, 0, 4, 0, 171, 0

The next entry need NoT be discarded.

4, 91, Es_4_4, Blank, 13.11.2014 11:37:39, 13.11.2014 11:37:39, 0, 0, 0, 0, 0, 0, 0

- Note that the file contains hundreds of lines and these are only examples.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1-Write a script in Python that delete all data discrepancies from a file as follows. The next 2 entries need to be discarded because the session ID and the 4 th character of the exercise ID do not...

Write a code in Python that deletes all data discrepancies as follows: - Note that the file contains hundreds of lines " entries " and these are only examples. Write a script in Python delete all...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

Event Viewer By: Print Your Name Display Activities by Student ID Display Activities by Event ID Display All Activities Enter Option ( 0 to Exit ) : 5 Error. Please enter a valid option! Event Viewer...

Student Number: 1 7 7 3 7 7 Date Event ID Description 0 7 / 1 1 / 2 0 2 3 8 1 7 7 2 1 , Log in 0 7 / 1 1 / 2 0 2 3 9 0 0 0 1 5 Delete File 0 7 / 1 1 / 2 0 2 3 9 0 0 0 1 7 Open File 0 7 / 1 1 / 2 0 2...

Python Programming main.py, moneymanager.py, timemoneymanager.py have creating 3 file for running program successfully, provide successful running file and screen shorts. have more information given...

1 . 1 . Display Activities by Student ID 2 . Display Activities by Event ID 3 . Display All Activities Enter Option ( 0 to Exit ) : Traceback ( most recent call last ) : File " C: \ Users \ Desktop \...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

(a) Suppose for an initial investment of 1, you receive the nonnegative cash payments x1, . .. , Xn, with x; being received at the end of i periods. To determine if the rate of return of this...

What is the total pressure of a gas mixture containing these partial pressures: PNe 312 torr, PHe = 799 torr, and PAr = 831 torr?

Suppose you are considering buying stocks of two companies, ABC and XYZ . The return on your investment after one year is Normal ( 1 2 0 , 1 6 ) for ABC stocks and Normal ( 1 0 4 , 1 6 ) for XYZ...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

4. Trainees and their managers provide estimates of training benefits.

2. Place a value on the outcomes.

4. Obtain an annual amount of benefits (operational results) from training by comparing results after training to results before training (in dollars).