When I import an excel file the character column comes out with numbers

Question

I am uploading an excel database to R and some data from the column that has characters appears with numbers. This is my code.

p <- read_excel("Raw_Data/31-01-2018.xls", sheet = 10,range = "A8:E24")

This is the output. Output

How could I solve this problem?

Answer 1

Try with the xlsx package. It looks like an issue with the merged cells. With the next code you are able to load it and then assign a name for the merged cells:

library(xlsx)
p <- read.xlsx("31-01-2018.xls",sheetIndex =  10,startRow = 8,endRow = 24,colIndex = c(1:7),encoding = 'UTF-8')
names(p)[1] <- 'Modalidad delictiva'
names(p)[c(6,7)]<-c('Total','Participación %')

Output (Image):