"Unknown or uninitialised column" error

General
1

hi everybody,
I have 2 problems.
first, the description file that creates does not have any observation.
second, when I try to use the table function I get this error
Unknown or uninitialised column: MattressType.

setwd("C:/Users...../request")

E<-read_excel("Baseline_BC.xlsx", "Exposure", skip = 2, n_max=2000)
variables<- rbind(E)
Baseline_BC<- variables %>% filter(Selection!="X")
# cleaning Baseline/ exposure ------------------------------------------------------
setwd("C:/Users.......data/raw/baseline")
bb = list.files(path = "./raw/baseline",pattern="*.xlsx")

dfg <-read_excel('C:/...../raw/baseline/Mother_Exposure_HomeAlergies.xlsx')
##
names<-Baseline_BC$"Variable name"
df<-dfg %>% select(any_of(names))
description<-as.data.frame(names(df))
description<-left_join(description, Baseline_BC[,], by=c("names(df)"="Variable name"))

Anyone can help me?

2

A reprex would be great so we can help you. See here welcome post here: Welcome to the RStudio Community!

install.packages('reprex')
library(reprex)

Copy all of your code, including the libraries, and run command reprex() in the console. Then copy paste the results here. Feel free to censure your directory names with ... as you did before.

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.