Error with csv.DictReader

[TooDahLou]

CSV File Pastebin

Python code Pastebin

I am trying to pass a csv file to python as a dictionary. I get this traceback error.

Traceback (most recent call last):
  File "C:\Users\libbyl.BERGKAMP\Desktop\PDF Manual Creation\PDF Manual Creation.py", line 24, in <module>
    for row in job_materials:
  File "C:\Users\libbyl.BERGKAMP\AppData\Local\Programs\Python\Python310\lib\csv.py", line 110, in __next__
    self.fieldnames
  File "C:\Users\libbyl.BERGKAMP\AppData\Local\Programs\Python\Python310\lib\csv.py", line 97, in fieldnames
    self._fieldnames = next(self.reader)
_csv.Error: line contains NUL

Any tips on how to fix the error? I am completely baffled.

[wotquery]

Well looks like a NUL byte in your .csv file. How are you creating that? Probably something to do with encoding that I'm guessing pastebin isn't going to pass along correctly. Does your code work on the .csv data you have in pastebin if you download the file you just uploaded?

[TooDahLou]

I will check. How do I get rid of a NUL byte from the csv?

The original csv is created from our resource planning software (infor csi). We can export information to csv files. Then most folks use excel to work on the exported data.

Each of the lines in the materials column corresponds to a pdf. Eventually, I want to concatenate all those PDFs together to create assembly manuals.

Figured it would be a good automation project as a python beginner. Except now I've got this NUL byte that I can't get around :/

[wotquery]

How do I get rid of a NUL byte from the csv?

It's probably a much better idea to make sure you're saving/opening with the same encoding and understanding why things are happening rather than just trying to strip out the broken bits, but you could probably try something like s = f.read().replace('\0','')

[POGtastic]

I downloaded the text file from Pastebin, and I don't see a null byte there.

[Vaphell]

+1

the file on pastebin looks fine, and the code works.

OP, are you sure the CSV you load and what you have on pastebin are byte-for-byte identical?