Read Excel with data in Hindi in Python Pandas

The problem shouldn't occur if the file is read in using the same encoding it was created with.

If you get "???", it means the csv or excel file was saved with a different encoding.

Here is a table of the standard encodings.

Also, you could open your file in an appropriate program, and save it with UTF-8, in order to read with your code.

Also See:

• SO: Encoding Error in Panda read_csv

Do not create csv file, instead use excel file in .xlsx format. Python will read the hindi text. I did this and it worked.

dataset = pd.read_excel("Data.xlsx") 

Here the Data.xlsx contains all the hindi text that you gave.

Best of luck

Assuming that your Excel/CSV file has a content similar to this:

मिशल
बहादुर
मेरी
जेन
जॉन
स्मिथ

The encoding type is correct. It's just that you have to iterate through the data to get it back.

For .CSV

import csv

with open('customers.csv', 'r', encoding='utf-8') as file:
    data = csv.reader(file)
    for row in data:
        print(row)

For .XLSX

with open('customers.xlsx', 'r', encoding='utf-8') as file:
    data = file.readlines()
    for row in data:
        print(row.strip())