R Warning message:In read_fun(path=enc2native(normalizePath(path)),sheet_i = sheet,:Expecting numer

R 语言 read_excel Warning message:In read_fun(path = enc2native(normalizePath(path)), sheet_i = sheet,:Expecting numeric in A1 / R1C1: got ‘values’ 问题解决：

问题描述：

mydata <- read_excel("/Users/xxx/Desktop/xxx/xxx.xlsx",
                     col_names = c("numeric", "text", "txt"),
                     col_types = c("numeric", "text", "text"))

报错：
Warning message:
In read_fun(path = enc2native(normalizePath(path)), sheet_i = sheet, :
Expecting numeric in A1 / R1C1: got ‘values’

原因分析：

这里由于采用了col_names所以第一行原本是列名，结果现在第一行文字也进入表格变成内容了，所以与原有后面的数据格式冲突，固有警告信息

解决方案：

加入skip参数跳过第一行

mydata <- read_excel("/Users/guoshuyu/Desktop/显著性差异P值/190109-7+5 nanog pdgfra distance VP.xlsx",
                     col_names = c("numeric", "text", "txt"),
                     #skip =1,
                     col_types = c("numeric", "text", "text"))