can not knit rmd , error: object (data)not found.

[Pontuspapaoneone]

creating an article in rmarkdown. doing text before graphic . Knitting (without graphic)to either pdf or word ,no problem. Inserting plots. running each plot code in the rmarkdown file works fine.
When I try to knit to output I get the message below.
dfpop is a dataframe in global r environment.
Tried "the yellow pages" (other topics here/ stack overflow, Google) without result. Am not a data scientist .
All help appreciated.thank you

dfpop
#> Error in eval(expr, envir, enclos): object 'dfpop' not found

^{Created on 2021-05-13 by the reprex package (v2.0.0)}

[nirgrahamuk]

How are you bringing dfpop in? I.e. what's your code in the rmarkdown doc for doing that?

[jlugarrancho]

Hi,

You need to put the code for import your data in an chunk.

Maybe this post could give you some clues.

Load Excel file into RMarkdown

Hi, Purple: I suggest you to use the import dataset menu. You can click in the upper left menu File > Import Dataset > From Excel and select the file to import it. Then you can copy the code that appears in the R console with the code required for import the data in xlsx and then copy it in a R Markdown code chunk. [Captura de pantalla 2021-04-27 a las 19.33.37] Hope it helps. Greetings.

Hope it helps.

Greetings.

[Pontuspapaoneone]

Hello and thank you for answering.
it's exactly the point I'm not sure how or if I have done that. tried load(file)but the file could not be accessed ?
dfpop is an object I created by assigning a data frame to dfpop ,it´s in the general environment of R.

[Pontuspapaoneone]

hello and thank you for answering:
I get:

DFST1
#> Error in eval(expr, envir, enclos): object 'DFST1' not found

^{Created on 2021-05-13 by the reprex package (v2.0.0)}
and this is the code:

 library(readxl)
 DFST1 <- read_excel("~/Documents/Dokument – Pontuss iMac/Projektarbete/XLSX/DFST1.xlsx", 
    range = "B2:AJ101", na = "NA")
 View(DFST1)   
 reprex(DFST1)

DFST1 is the name of the excel
greetings

[nirgrahamuk]

Perhaps you are using a normal r script to read excel and prepare objects then going to your markdown and expecting those objects to be there to be knittable. That would be an incorrect assumption. Rmd should be self contained. I.e. move your read excel code into the rmarkdown also. You can hide the chunk from being rendered out, but it needs to be there.

[Pontuspapaoneone]

 library(readxl)
DFST1 <- read_excel("~/Desktop/DFST1.xlsx", 
    range = "B2:AJ101", na = "NA")
View(DFST1)

get the following message:
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
Quitting from lines 27-31 (Tryout1.Rmd)
Error in View(DFST1) : X11 dataentry cannot be loaded
Calls: ... withCallingHandlers -> withVisible -> eval -> eval -> View
Execution halted.
don´t know what I am doing wrong

thank your your comment

[jlugarrancho]

Hi,
I'm not completely sure but I think that you get this error because you can't use de View()function inside a R Markdown document. Then, remove the line View(DFST1) from your code.
You're welcome. Hope it helps.
Greetings.

[Pontuspapaoneone]

thank you jlugarrancho it did the trick.
thank you very much everybody.

kind regards