Skip every particular 2 rows in whole csv file using python

Question

I have a csv file which contain some data example of a csv file below

these file is crypted with "asdfg"
Name,Status,Time
abc,failed,7:30

these file is crypted with "asdfgghklm"
Name,Status,Time
def,running,12:30

Output -

Name,Status,Time
abc,failed,7:30
def,running,12:30

i want to skip some line present in whole csv file using python is there any way to do it? Thanks for the help

Have you looked at this: stackoverflow.com/questions/549674/… and this: stackoverflow.com/questions/49266463/… ? — Kirtiman Sinha
– Kirtiman Sinha, Commented Aug 25, 2020 at 19:38
link these gives every line in list so how can i skip the list i don't want in my csv? — Sumeet Singh
– Sumeet Singh, Commented Aug 25, 2020 at 19:46
If it's every second line you can use a modulus operation on the loop counter. Did you have a look at the first link I posted? — Kirtiman Sinha
– Kirtiman Sinha, Commented Aug 25, 2020 at 19:47

LeviTheDegu · Accepted Answer · 2020-08-25 19:54:36Z

-1

Reading a csv in python is just taking in a dictionary containing the lines consider the following:

import csv
with open('mycsv.csv', mode='r') as file:
    mycsv = csv.DictReader(file)

you can then look at specific elements within the dicts, script ones you dont like. based on your example if you're trying to get rid of a line like these file is crypted with "asdfgghklm" you can just check to see if there's a second element and if not dump it, or you can ignore it when you're looping

If your file structure is exactly as you mentioned above the dictionary should come out looking like this

OrderedDict([('these file is crypted with "asdfg"', 'Name'), (None, ['Status', 'Time'])])        
OrderedDict([('these file is crypted with "asdfg"', 'abc'), (None, ['failed', '7:30'])])
OrderedDict([('these file is crypted with "asdfg"', 'these file is crypted with "asdfgghklm"')]) 
OrderedDict([('these file is crypted with "asdfg"', 'Name'), (None, ['Status', 'Time'])])        
OrderedDict([('these file is crypted with "asdfg"', 'def'), (None, ['running', '12:30'])])

This is based on the code:

import csv
with open('file.csv', mode='r') as file:
    mycsv = csv.DictReader(file)
    for line in mycsv :
        print(line)

from here we can look at the output and use an if statement it terminate what you don't want and print what you do want. You will need to make adjustments based on your actual output, I like to use the print command first to guarantee i know how the system will see my csv file and then adapt my code to filter based on that formatting.

answered Aug 25, 2020 at 19:54

LeviTheDegu

2951 gold badge2 silver badges10 bronze badges

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

1 Comment

Kirtiman Sinha Over a year ago

this isn't the complete solution i.e. doesn't answer the skipping the csv lines based on occurrence or regex. It'd be great if you could edit your answer to add that information.

Collectives™ on Stack Overflow

Skip every particular 2 rows in whole csv file using python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related