Hello R Community,
I'm working on my first analysis and have been trying to figure out how to get rid of these error messages. (see below) How can I get past this? Or do I need to restart and go back to Excel? I previously worked on the csv through Excel using power query and saved it as an xlsx.
Any help/ advice is appreciated!
library(readxl)
setwd("~/Desktop/r studio xlsx")
Oct21 <- read_xlsx("oct21-bikeshare.xlsx")
There were 50 or more warnings (use warnings() to see the first 50)
Nov21 <- read_xlsx("nov21-bikeshare.xlsx")
There were 37 warnings (use warnings() to see them)
Dec21 <- read_xlsx("dec21-bikeshare.xlsx")
Jan22 <- read_xlsx("jan22-bikeshare.xlsx")
Feb22 <- read_xlsx("feb22-bikeshare.xlsx")
March22 <- read_xlsx("march22-bikeshare.xlsx")
Warning messages:
1: Expecting date in N184214 / R184214C14: got '###############################################################################################################################################################################################################################################################'
2: Expecting date in N187391 / R187391C14: got '###############################################################################################################################################################################################################################################################'
April22 <- read_excel("april22-bikeshare.xlsx")
May22 <- read_xlsx("may22-bikeshare.xlsx")
Warning message:
Expecting date in N592387 / R592387C14: got '###############################################################################################################################################################################################################################################################'
June22 <- read_xlsx("june22-bikeshare.xlsx")
There were 12 warnings (use warnings() to see them)
July22 <- read_xlsx("july22-bikeshare.xlsx")
There were 16 warnings (use warnings() to see them)
Aug22 <- read_xlsx("aug22-bikeshare.xlsx")
There were 15 warnings (use warnings() to see them)
Sep22 <- read_xlsx("sep22-bikeshare.xlsx")
There were 50 or more warnings (use warnings() to see the first 50)