list contains NULL byte, CSV DictReader

Question

How can I remove NULL bytes using DictReader method? The following code produce error as Error: line contains NULL byte

with open('excelfile.csv', 'r', encoding="ISO-8859-1") as file:

reader = csv.DictReader(file, fieldnames=('BANK','IFSC', 'BRANCH', 'ADDRESS'))
for row in reader: 
    frame = {'bank': row['BANK'], 'ifsc': row['IFSC'], 'branch': row['BRANCH'], 'address': row['ADDRESS'] } 
    framelist.append(frame)

Edit your Question and show one line with "NULL byte".

stovfl
– stovfl

2019-03-09 15:59:55 +00:00
Commented Mar 9, 2019 at 15:59 — stovfl
– stovfl, Commented Mar 9, 2019 at 15:59
Your encoding is likely wrong, maybe utf16?

Mark Tolonen
– Mark Tolonen

2019-03-09 17:08:57 +00:00
Commented Mar 9, 2019 at 17:08 — Mark Tolonen
– Mark Tolonen, Commented Mar 9, 2019 at 17:08

Eduardo Soares · Accepted Answer · 2019-03-09 12:20:29Z

2

You can replace your NULL bytes by an empty string. Like this:

 reader = csv.DictReader(x.replace('\0', '') for x in file)

Example:

with open('excelfile.csv', 'r', encoding="ISO-8859-1") as file:

   reader = csv.DictReader(x.replace('\0', '') for x in file)
   for row in reader: 
     frame = {'bank': row['BANK'], 'ifsc': row['IFSC'], 'branch': row['BRANCH'], 'address': row['ADDRESS'] } 
     framelist.append(frame)

answered Mar 9, 2019 at 12:20

Eduardo Soares

1,0004 silver badges14 bronze badges

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

1 Comment

Mark Tolonen Over a year ago

If there are NULL bytes in the input, it is more likely the encoding is wrong. encoding=utf16 is more likely the solution.

Collectives™ on Stack Overflow

list contains NULL byte, CSV DictReader

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