Python Forum

Full Version: CSV Reader
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi

I am a new programmer with Python and do appreciate any help or suggestions - a virtual beer is offered :)

I am running my program and get this error - 

Error:
Traceback (most recent call last):   File "C:\SFF\Code\SFF_Analyzer.py", line 229, in <module>     for row in reader:   File "C:\Program Files\Python35\lib\encodings\cp1252.py", line 23, in decode     return codecs.charmap_decode(input,self.errors,decoding_table)[0] UnicodeDecodeError: 'charmap' codec can't decode byte 0x8f in position 5582: character maps to <undefined>
My code is 

with open(prodfile, "r") as f_product:
     reader = csv.reader(f_product,delimiter=',')
     
     for row in reader:
         prod_list.append(row[0]) # we now have a Product list stored TAG 
         prod_1.append(row[2])  # we now have a Mono Cube list stored LONG DESCRIPTION
         prod_2.append(row[4])  # we now have a Mono Cube list stored PARENT TAG
         prod_3.append(row[6])  # we now have a Mono Cube list stored HIER NAME
         prod_4.append(row[7])  # we now have a Mono Cube list stored HIER LEVEL NUMBER
         prod_5.append(row[8])  # we now have a Mono Cube list stored HIER LEVEL NAME
         prodcount = prodcount + 1
         s.add(row[0]) # create a set 
I see in my data I have a Tilda char ~~~~~~~~~~~~~  so i think this may be the issue but i am not sure -any help is appreciated and im on PYTHON 3.5.3

Regards

Chris
Try:
with open(prodfile, "r") as f_product:
# To
with open(prodfile, encoding='utf-8') as f_product: