New names: * `` -> `..18` message in R console

r readxl
Stupid_Intern picture Stupid_Intern · Mar 16, 2019 · Viewed 10.3k times · Source

I ran a Rshiny app and it works as expected but in console I get the following message:

New names:
* `` -> `..18`

what does it mean?

It occurs when I try to do this

> data1<-read_excel("CUMMULATIVE COLLECTION POS_UPLOAD.xls")
New names:
* `` -> `..18`

When I do the same operation again it doesn't gives the message

> data2<-read_excel("DATA.xlsx")

Answer

Santiago Capobianco picture Santiago Capobianco · Mar 16, 2019

The message is telling you that some of the columns have no names and its giving them one. The second excel simply must have all the column names defined. It also appears to me since the last update of the readxl package. Worth noting that the format of the created names have change, wich force me to charge previous codes.

Related questions

Error: could not find function "read_excel" using R on Mac

I am trying to link up my excel data set to R for statistical analysis. I am running on OSX Sierra (10.12.6) with R studio (1.0.153) and Java 8 (update 144). The function "read_excel" was able to open my excel document a week …

Read More
Reading Excel: evaluation error with zip file '..file.xlsx' cannot be opened

I am using R with readxl package. I try to import an Excel file with the following command: library(readxl) city_codes <- read_excel("./data/file.xlsx", sheet = "city_codes") It says it is a zip file and …

Read More
Error message using read_excel "Error: std::bad_alloc"

I'm trying to open an Excel file with the read_excel() function from the readxl package. But I don't know how to specify the path to the Excel file. When I enter the file path by following the steps given …

Read More