(CkPython) Read Japanese utf-8 CSV File

Demonstrates how to read a utf-8 .csv file containing some Japanese characters.

Chilkat Python Downloads install with pip pip3 install chilkat or download... Python Module for Windows, MacOS, Linux, Alpine Linux, Solaris

import sys
import chilkat

# This example program loads a file (japanese.csv)
# that contains this content:
# 
# year,color,country,food
# 2001,red,France,cheese
# 2005,blue,"United States",hamburger
# 2008,green,Italy,pasta
# 1998,orange,Japan,sushi
# 2010,silver,"",""
# 

csv = chilkat.CkCsv()

# Prior to loading the CSV file, indicate that the 1st row
# should be treated as column names:
csv.put_HasColumnNames(True)

# Load the CSV records from the file.
# Important: Make sure to call LoadFile2 so that the charset (utf-8)
# of the CSV file can be indicated.
success = csv.LoadFile2("qa_data/csv/japanese.csv","utf-8")
if (success != True):
    print(csv.lastErrorText())
    sys.exit()

# Display the contents of the 3rd column

n = csv.get_NumRows()
for row in range(0,n):
    print(csv.getCell(row,2))