xxxxxxxxxx
- Open the file in regular notepad
- Select save as
- Select encoding "UTF-8" (Not "UTF-8 (With BOM)")
- Save the file.
xxxxxxxxxx
# try this if you get the error utf-8 codec can't decode byte
# Assuming your file is pipe delimited otherwise remove sep='|'
pd.read_csv(r'C:\path\to\file.csv', sep='|', encoding = "ISO-8859-1")
xxxxxxxxxx
import pandas as pd
data=pd.read_csv("C:\\Employess.csv",encoding=''unicode_escape')
print(data.head())