New to R - I've been entering code to import and merge some Excel files. But the Posit Cloud console commands are not getting results - numerous attempts all give error messages (or zero characters when I try the list command to see my computer's csv files). I have Excel 2007 - is that too old to be recognized? Here is the code and error messages when trying to import after installing tidyverse, readr, and here. I tried different extensions to see if something would work.
library(tidyverse)
── Attaching core tidyverse packages ─────────────── tidyverse 2.0.0 ──
dplyr 1.1.2 readr 2.1.4
forcats 1.0.0 stringr 1.5.0
ggplot2 3.4.2 tibble 3.2.1
lubridate 1.9.2 tidyr 1.3.0
purrr 1.0.1
── Conflicts ───────────────────────────────── tidyverse_conflicts() ──
dplyr::filter() masks stats::filter()
dplyr::lag() masks stats::lag()
Use the conflicted package to force all conflicts to become errors
install.packages("here")
Installing package into ‘/cloud/lib/x86_64-pc-linux-gnu-library/4.3’
(as ‘lib’ is unspecified)
also installing the dependency ‘rprojroot’
trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/rprojroot_2.0.3.tar.gz'
Content type 'application/x-gzip' length 101201 bytes (98 KB)
downloaded 98 KB
trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/here_1.0.1.tar.gz'
Content type 'application/x-gzip' length 52764 bytes (51 KB)
downloaded 51 KB
- installing binary package ‘rprojroot’ ...
- DONE (rprojroot)
- installing binary package ‘here’ ...
- DONE (here)
The downloaded source packages are in
‘/tmp/Rtmpqo5CVD/downloaded_packages’
library(here)
here() starts at /cloud/project
library(readr)
DF <- read_csv("cyclistic_july.csv")
Error: 'cyclistic_july.csv' does not exist in current working directory ('/cloud/project').
d <- read_csv("cyclistic_july.csv")
Error: 'cyclistic_july.csv' does not exist in current working directory ('/cloud/project').
DF <- read_csv("202207-divvy-tripdata.csv")
Error: '202207-divvy-tripdata.csv' does not exist in current working directory ('/cloud/project').
d <- read_csv("202207-divvy-tripdata.csv")
Error: '202207-divvy-tripdata.csv' does not exist in current working directory ('/cloud/project').
library(readxl)
df <- read_excel("path/to/202207-divvy-tripdata.xlsx")
Error:path
does not exist: ‘path/to/202207-divvy-tripdata.xlsx’
df <- read_excel("path/to/Cyclistic - July 2022.xlsb")
Error:path
does not exist: ‘path/to/Cyclistic - July 2022.xlsb’
df1 <- read_excel("path/to/Cyclistic - July 2022.xlsb")
Error:path
does not exist: ‘path/to/Cyclistic - July 2022.xlsb’
df1 <- read_excel("path/to/Cyclistic-July 2022.xlsb")
Error:path
does not exist: ‘path/to/Cyclistic-July 2022.xlsb’
list.files(pattern = "csv")
character(0)
list.files(pattern = "xlsb")
character(0)