Help with locating error on import of data
Hello,
Try setting argument col.names = FALSE, it seems that the function is
not find column headers and is choosing its own.
Balance_sheet <- read_excel("Y:/All Documents/Training/Data/Routines for
consolidating all the data/Individual tables/AIM
companies/Balance_sheet.xlsx", na = "", col_names = FALSE)
Hope this helps,
Rui Barradas
?s 15:56 de 23/06/2020, Ahson via R-help escreveu:
I have imported data from an Excel file and I am getting errors:
library(readxl)
Balance_sheet <- read_excel("Y:/All Documents/Training/Data/Routines for consolidating all the data/Individual tables/AIM companies/Balance_sheet.xlsx", na = "")
New names: * `` -> ...6 * `` -> ...7 * `` -> ...9 * `` -> ...10 * `` -> ...11 * ... and 22 more problems How can I find where the error is originating? What does New names mean? Thanks in advance for your help. Sent from Mail for Windows 10 [[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Este e-mail foi verificado em termos de v?rus pelo software antiv?rus Avast. https://www.avast.com/antivirus