Question: 1-Write a script in Python that delete all entries from a file where the 3 rd column from the left matches ES. For example: 1,

1-Write a script in Python that delete all entries from a file where the 3rd column from the left matches ES.

For example:

1, 1, Es, Other, 2.10.2014 11:25:33, 2.10.2014 11:25:34, 0, 0, 0, 0, 0, 84, 0

1, 1, Es, Aulaweb, 2.10.2014 11:25:35, 2.10.2014 11:25:42, 218, 0, 0, 4, 0, 397, 0

The next 2 lines need NOT to be deleted.

1, 1, Es_1_1, Study_Es_1_1, 2.10.2014 11:27:18, 2.10.2014 11:27:45, 165188, 0, 0, 4, 0, 715, 0

1, 1, Es_1_1, Deeds_Es_1_1, 2.10.2014 11:27:46, 2.10.2014 11:27:49, 234, 0, 0, 2, 0, 214, 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!

Q:

1-Write a script in Python that delete all entries from a file where the 3 rd column from the left matches ES. For example: 1, 1, Es, Other, 2.10.2014 11:25:33, 2.10.2014 11:25:34, 0, 0, 0, 0, 0, 84,...

Q:

1-Write a script in Python that delete all entries from a file where the 3 rd column from the left matches ES. For example: 1, 1, Es_1_1, Study_Es_1_1, 2.10.2014 11:27:18, 2.10.2014 11:27:45, 165188,...

Q:

Write a script using python that delete all entries in a file where the 3rd column from the left matches ES. For instance the next 2 lines need to be deleted. 1, 1, Es, Other, 2.10.2014 11:25:33,...

Q:

Write a script that delete all entries where the 3 rd column from the left matches ES. For instance the next 2 lines need to be deleted. 1, 1, Es, Other, 2.10.2014 11:25:33, 2.10.2014 11:25:34, 0, 0,...

Q:

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

Q:

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

Q:

Introduction A PDB file contains information obtained experimentally about a macromolecule, usually by either Xray crystallography, NMR spectroscopy, or cryoelectron microscopy. The PDB file...

Q:

Option #1: Integrating MySQL Table Data with a Python Script In this assignment, you will write a Python script to increase the population of each city in the world_x database by 10% (rounded)....

Q:

In this assignment, you will write a Python script to increase the population of each city in the world_x database by 10% (rounded). First, add a new column to the world_x city table using the...

Q:

Download the classicmodels database from the following MySQL website: http://www.mysqltutorial.org/mysql-sample-database.aspx write a Python script that deducts one percent from the amounts paid for...

Q:

Amy, Beth, and Meg each own 100 of the 300 outstanding shares of Theta Corporation stock. Amy wants to sell her shares, which have a $40,000 basis and a $100,000 FMV. Either Beth and/or Meg can...

Q:

An heiress receives an income stream from a will at a rate of f(t) = 50,000e0.024 dollars per year. She invests this income and earns 4.5% interest (compounded continuously). (Round your answers to...

Q:

The tax that beneficiaries pay to the state when they receive an estate is called: Question 6 options: a ) An estate tax. b ) An estate and trust federal income tax. c ) A gift tax. d ) An...

Q:

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

Q:

Strong understanding of technology and systems, and business process improvement

Q:

3. Describe how Great-Wests invoice approvals process changed after the mobile application was deployed.

Q:

13-5 What are new approaches for system building in the digital firm era?