to remove specific rows in a csv file using python

Question

i want ro remove specific lines from the following csv file :

"Title.XP PoseRank" 

1VDV-constatomGlu-final-NoGluWat. 

1VDV-constatomGlu-final-NoGluWat. 

P6470-Usha.1 

P6470-Usha.2 

P6470-Usha.3 

P6470-Usha.4 

P6470-Usha.5 

P6515-Usha.1 

P6515-Usha.2 

P6517.1 

P6517.2 

P6517.3 

P6517.4 

P6517.5 

P6553-Usha.1 

P6553-Usha.2 

P6553-Usha.3

i want to remove the lines that begin with 1VDV-constatomGlu-final-NoGluWat.

Is it just me, or is that a comma separated value file without any commas or separation? — detly
– detly, Commented Jul 12, 2010 at 6:27
This particular task would probably be easier to accomplish with sed or awk. (Although it's not a hard thing to do in any language) — David Z
– David Z, Commented Jul 12, 2010 at 6:40

Mykola Kharechko · Accepted Answer · 2010-07-12 06:27:28Z

2

The right solution is to use csv parser(i didn't test this code):


writer = csv.writer(open('corrected.csv'))
for row in csv.reader('myfile.csv'):
    if not row[0].startswith('1VDV-constatomGlu-final-NoGluWat.'):
        writer.writerow(row)
writer.close()

You can use also regular expression or some string manipulations but there is the risk that after your transformations the file will be no longer in csv format

answered Jul 12, 2010 at 6:27

Mykola Kharechko

3,2475 gold badges34 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

to remove specific rows in a csv file using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related