Index error of CSV List in Python, even after getting output

Question

This is simple program of reading the csv file in form of list, Program is able to print as per index but at last there is a index error


import csv

with open('file.csv','r') as f:
    reader = csv.reader(f)
    for r in reader:
        lis = list(r)
        print (lis)
        file_dat  = lis[0]
        file_no   = lis[1]
        content    = lis[2]
        print (file_dat)
        print ("File Data Read Successful")
f.close()

and the output i get of this program is


['ASFDASD', '2019-10-19', 'horse']
ASFDASD
File Data Read Successful
[]
Traceback (most recent call last):
  File "C:\Users\KIRA\AppData\Local\Programs\Python\Python37-32\direction.py", line 14, in <module>
    file_dat  = lis[0]
IndexError: list index out of range

first check if list is not empty and has length of 3

Saleem Ali
– Saleem Ali

2019-10-21 16:12:02 +00:00
Commented Oct 21, 2019 at 16:12 — Saleem Ali
– Saleem Ali, Commented Oct 21, 2019 at 16:12

Nick Reed · Accepted Answer · 2019-10-21 16:11:59Z

1

Looks like your code is reading the last line of the input file as a completely empty line, resulting in an empty list. This empty list is printed out right below File Data Read Successful.

Maybe check to make sure the list isn't empty after you print it but before you assign it?

import csv

with open('file.csv','r') as f:
    reader = csv.reader(f)
    for r in reader:
        lis = list(r)
        if(lis.len() = 3):
          print (lis)
          file_dat  = lis[0]
          file_no   = lis[1]
          content    = lis[2]
          print (file_dat)
          print ("File Data Read Successful")
f.close()

answered Oct 21, 2019 at 16:11

Nick Reed

5,1094 gold badges19 silver badges39 bronze badges

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

Comments

Lior Cohen · Accepted Answer · 2019-10-21 16:14:44Z

0

you last lis is empty and you are trying to access lis[0]. check first that the list is not empty by if lis:

answered Oct 21, 2019 at 16:14

Lior Cohen

5,7202 gold badges18 silver badges33 bronze badges

Collectives™ on Stack Overflow

Index error of CSV List in Python, even after getting output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related