UnicodeDecodeError: "utf-8" codec can't decode byte in position : invalid start byte

+2 votes

While I importing the file it shows

UnicodeDecodeError: "utf-8" codec can"t decode byte 0xa0 in position 10: invalid start byte

Code:

import pandas as pd
a = pd.read_csv("filename.csv")
Jul 23, 2019 in Python by Hari
62,274 views
Beautiful. Thanks, that worked for me. Opening the file in Python and sniffing the encoding gave the wrong one.

1 answer to this question.

+3 votes
Best answer

You have to use the encoding as latin1 to read this file as there are some special character in this file, use the below code snippet to read the file,

import pandas as pd

data=pd.read_csv("C:\\Users\\akashkumar\\Downloads\\Customers.csv",encoding='latin1')

print(data.head())
answered Jul 23, 2019 by Kunal

selected Dec 24, 2019 by Kalgi
Thanks. it is working.

could you explain? What is the reason for this problem and what that "encoding ='latin1' " mean?
Kunal you're awesome! That was driving me mad

Hey, @Brij Mohan,

 "encoding ='latin1' " mean means that dev tools are sourcing the files as latin1 instead of the UTF-8 files that they are. This happens irrespective of the Encoding: UTF-8.

thank you, its works
thanks for saving my day

Related Questions In Python

0 votes
2 answers
0 votes
1 answer

UnicodeDecodeError: 'utf-8' codec can't decode byte 0x89 in position 0: invalid start byte

Hi, @hala, Regarding your query, you can go ...READ MORE

answered Jun 29 in Python by Niroj
• 68,560 points
2,113 views
0 votes
2 answers

UnicodeDecodeError: 'utf-8' codec can't decode byte 0x8b in position 1: invalid start byte

Hey,  @Himanshu. It's still most likely gzipped data. ...READ MORE

answered Jul 27 in Python by Gitika
• 42,520 points
976 views
0 votes
0 answers

utf-8' codec can't decode byte 0xa0 in position 10: invalid start byte

my code import wordcloud import numpy as np from matplotlib ...READ MORE

Mar 29 in Python by anonymous
• 120 points
1,475 views
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 6, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 1,476 views
0 votes
0 answers
+4 votes
6 answers

Lowercase in Python

You can simply the built-in function in ...READ MORE

answered Apr 11, 2018 in Python by hemant
• 5,800 points
1,108 views
+2 votes
1 answer
0 votes
1 answer