How to read CSV file in python?

Question

Is there a better way to do that:

def Read_CSV_File(filename):
 file = open(filename, "r")
 reader = csv.DictReader(file)
 line = 1
 for row in reader:
 if line < 6:
 reader.next()
 line++
# process the CSV

Comments

This one is giving me a compilation error.

    [root@satya user]# python sample.py
      File "sample.py", line 9
        line++
             ^
    SyntaxError: invalid syntax

Answer 1

You can use the following way to do this using "with" operator.

def Read_CSV_File(filename):       with open(filename, "r") as csvfile:
          csvreader = csv.DictReader(csvfile)
           line = 1
          for row in csvreader:
               if line < 6:
                 reader.next()
                  line++                 continue
     # process the CSV

Rest of the things are pretty much straightforward.

Answer 2

line++
is a syntax error in Python. If you fix that

line = 1
for row in reader:
 if line < 6:
 reader next()
 line += 1

You are still reading the complete csv file. Assuming
(1) the first row of the csv contains the column names
(2) you want to skip the first five rows of data

you'd have to write

reader = csv.Reader(file)
line = 0
while line < 5:
 next(reader)
 line += 1
for row in reader:
 .... # process csv row

A simpler alternative is to use itertools.islice():

for row in itertools.islice(reader, 5, None):
 ... # process csv row

Answer 3

If you want to read line 6th row use this :

file = open("satya.csv","r")
reader = csv.reader(file)
line = 1
for row in reader:
        if line == 6:
                print row
        line = line+1