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

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...

Albenii Port Authority has had a long-term relationship with a nearby lumber company, which ships a significant amount of lumber through the port. To help finance the lumber companys operations,...

The financial statements of Hershey Foods appear in Appendix B, following the financial statements for Tootsie Roll in Appendix A. Instructions (a) Based on the information contained in these...

In May ( current year ) , HBO hosted a premiere for Season 2 of The Last of Us . To encourage a large attendance for the premiere broadcast, HBO gave out "swag" bags to all attendees who stayed until...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Use your demand schedule for a public good, determined in question 1, and the following supply schedule to ascertain the optimal quantity of this public good. Why is this the optimal...

Demographers have been very surprised that total fertility rates have fallen below 2.0, especially because most people in most countries tell pollsters that they would like to have two children. Can...

KEY QUESTION On the basis of the three individual demand schedules below, and assuming these three people are the only ones in the society, determine ( a ) the market demand schedule on the...