Reading csv file with Japanese characters into R

Question

I am struggling to have R read in a csv file which has some of its columns in standard English characters, some numerical and some fields in Japanese characters.Here is how the data looks like:

category,desc,otherdesc,volume
UPC - 31401 Age Itameabura,かどや製油　純白ごま油,OIL_OTHERS_SML_ECO,83.0
UPC - 31401 Age Itameabura,オレインリッチ,OIL_OTHERS_MED,137.0
UPC - 31401 Age Itameabura,ＴＶキャノーラ油,OIL_CANOLA_OTHERS_LRG,3026.0 

Keeping the R's language setting as English, the japanese characters are converted into some gibberish. When I change the language setting in R to Japanese, Sys.setlocale("LC_CTYPE", "japanese"), I see the file is not read in at all. R gives an error saying:

Error in make.names(col.names, unique = TRUE) : invalid multibyte string at 'ｻcategory'

I have no clue what's wrong with my csv file or the header names. Can you guide me as to how can I go about reading this csv file into R so that everything is displayed just as they do in the csv file?

Thanks! Vish

Answer 1

For japanese the below works for me:

df <- read.csv("your_file.csv", fileEncoding="cp932")