import csv
import pandas as pd
db = input("Enter the dataset name:")
table = db+".csv"
df = pd.read_csv(table)
df = df.sample(frac=1).reset_index(drop=True)
with open(table,'rb') as f:
data = csv.reader(f)
for row in data:
rows = row
break
print(rows)
I am trying to read all the columns from the csv file.
ERROR: UnicodeDecodeError: 'utf-8' codec can't decode byte 0x96 in position 15: invalid start byte
You need to check encoding of your csv file.
For that you can use print(f),
with open('file_name.csv') as f:
print(f)
The output will be:
<_io.TextIOWrapper name='file_name.csv' mode='r' encoding='utf8'>
Open csv with the encoding as mentioned in the above output,
with open(fname, "rt", encoding="utf8") as f:
As mentioned in comments,
your encoding is cp1252
so,
with open(fname, "rt", encoding="cp1252") as f:
...
and for .read_csv,
df = pd.read_csv(table, encoding='cp1252')
with open(fname, "rt", encoding="cp1252") as f: If it solved your issue, don't forget to accept.df = pd.read_csv(table) Traceback (most recent call last): File "stack.py", line 5, in <module> df = pd.read_csv(table)df = pd.read_csv(table, encoding='cp1252')