I can't convert csv file(AppleStore.csv) into list of list

Screen Link: <!http://localhost:8890/notebooks/Untitled21.ipynb?kernel_name=python3#>

<<< open_file = open(“AppleStore.csv”) >>>
<<<open_file>>>

<<< from csv import reader >>>
<<< 6 reader_file = reader(open_file)>>>
----> <<<7 ios = list (reader_file)>>>
<<<8 ios_header = ios[0]>>>

C:\anaconda\lib\encodings\cp1252.py in decode(self, input, final)
21 class IncrementalDecoder(codecs.IncrementalDecoder):
22 def decode(self, input, final=False):
—> 23 return codecs.charmap_decode(input,self.errors,decoding_table)[0]
24
25 class StreamWriter(Codec,codecs.StreamWriter):

UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x9d in position 7122: character maps to

somebody help please I am stuck. I thought the display could have been the header row.

<<< print (ios_header)>>>
[‘id’, ‘track_name’, ‘size_bytes’, ‘currency’, ‘price’, ‘rating_count_tot’, ‘rating_count_ver’, ‘user_rating’, ‘user_rating_ver’, ‘ver’, ‘cont_rating’, ‘prime_genre’, ‘sup_devices.num’, ‘ipadSc_urls.num’, ‘lang.num’, ‘vpp_lic’]

Hello @brayanopiyo18,

Add encoding in the open statement For example:

opened_file = open('AppleStore.csv', encoding='utf8')

1 Like

Thank you, it’s working now.