library(readxl) library(reshape2) setwd("C:/R-studio") df_db <- read_excel("Working_X.xlsx", sheet = "Accounts_DB") col <- colnames(df_db[,1:18]) m_db <- melt(df_db, col, na.rm = TRUE, value.name = "Value" )
Created on 2020-05-10 by the reprex package (v0.3.0)
After reading an excel file I get a tibble on which I can see the characters written in my native language(Armenian). But after I melt the tibble, the characters become messed. I guess the issue is about encoding, and I need to change encoding to UTF-8, but whatever I searched for and tried I could not manage to conduct the change.