I have a csv file named Qid-NamedEntityMapping.csv having data like this:

```
Q1000070    b'Myron V. George'
Q1000296    b'Fred (footballer, born 1979)'
Q1000799    b'Herbert Greenfield'
Q1000841    b'Stephen A. Northway'
Q1001203    b'Buddy Greco'
Q100122     b'Kurt Kreuger'
Q1001240    b'Buddy Lester'
Q1001867    b'Fyodor Stravinsky'

```

The second column is 'ascii' encoded, and when I am reading the file using the following code, then also it not being read properly:

```
import chardet
import pandas as pd

def find_encoding(fname):
    r_file = open(fname, 'rb').read()
    result = chardet.detect(r_file)
    charenc = result['encoding']
    return charenc

my_encoding = find_encoding('datasets/KGfacts/Qid- 
NamedEntityMapping.csv')
df = pd.read_csv('datasets/KGfacts/Qid- 
NamedEntityMapping.csv',error_bad_lines=False, encoding=my_encoding)

```

But the output looks like this:
![output](https://i.stack.imgur.com/v5ale.png)

Also, I tried to use encoding='UTF-8'. but still, the output is the same.
What can be done to read it properly?