[R] Help with locating error on import of data

Patrick (Malone Quantitative) m@|one @end|ng |rom m@|onequ@nt|t@t|ve@com
Tue Jun 23 17:08:57 CEST 2020


It looks like it's looking for column names in the first row of your Excel
sheet and not finding them. What does the first row contain?

On Tue, Jun 23, 2020 at 10:57 AM Ahson via R-help <r-help using r-project.org>
wrote:

> 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 using 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.
>


-- 
Patrick S. Malone, Ph.D., Malone Quantitative
NEW Service Models: http://malonequantitative.com

He/Him/His

	[[alternative HTML version deleted]]



More information about the R-help mailing list