R Markdown Knitting

[Mohammad_Islam]

Hello there!

I'm trying to knit one of my report form R Markdown. But its showing that it can't find the data when I'm clicking on Knit. Its showing:

The data has already been imported, structured & analysed in RStudio.

Please help, anyone

Thanks in advance

[Equation]

It's difficult to know the exact nature of the problem without a reprex. Have you imported the data in the R Markdown file (in a code chunk)? It is not sufficient that the data has been "imported, structured & analysed in RStudio"; it must be done in the R Markdown file you are trying to knit.

[Mohammad_Islam]

Dear, thanks for your quick response. Sorry to say I don't know what do you mean by 'reprex'. And I also don't know how to import the data in R Markdown, because I already have imported it in the Environment pane & also have loaded it in the RStudio. I am attaching the full R Markdown screenshots here. Please see.

[Mohammad_Islam]

[Mohammad_Islam]

[Mohammad_Islam]

[andresrcs]

@Mohammad_Islam

Sorry to say I don't know what do you mean by 'reprex'.

This post explains what a [REPRoducible EXample (reprex)] is

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

@Mohammad_Islam

I also don't know how to import the data in R Markdown, because I already have imported it in the Environment pane

You have to include in your Rmd file the same commands you used to "import it" (to load it actually) into your working environment. The reason for this is that when you knit an Rmd document the code gets executed in a clean environment other than the one you are currently working on so the data you have loaded interactively doesn't exist in that environment.

@Mohammad_Islam

I am attaching the full R Markdown screenshots here.

Posting screenshots is considered a bad practice here, post formatted code instead. Here is how to do it.

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

[Mohammad_Islam]

Thanks. But could you please be a little more specific on how will I

@andresrcs

You have to include in your Rmd file the same commands you used to "import it" (to load it actually) into your working environment. The reason for this is that when you knit an Rmd document the code gets executed in a clean environment other than the one you are currently working on so the data you have loaded interactively doesn't exist in that environment.

Thanks. But could you please be a little more specific on how will I include my .xlsx file in the R Markdown? I imported it in the Environment pane & wrote View() code to load the data in the RStudio. But I didn't know that it wont work in the R Markdown.

[andresrcs]

@Mohammad_Islam

how will I include my .xlsx file in the R Markdown?

That's not what I said, I said that you need to include the commands to load the data into your working environment, I don't know with what packages you are working with but for example, if you use the readxl package to read an xlsx file, you will have to include a command like

Demo_Report <- read_excel("path\to\your\file.xlsx")

@Mohammad_Islam

wrote View() code to load the data in the RStudio.

The View() command is not for loading data, it is just to visualize data that it is already loaded into memory.

[Mohammad_Islam]

@andresrcs

Demo_Report <- read_excel("path\to\your\file.xlsx")

This is what I needed in the first place from you. Thanks a lot.

@andresrcs

That's not what I said

I felt offended by your words. This is upsetting. Thanks anyway.

[andresrcs]

I'm sorry you felt that way, it was not my intention to upset you, I honestly don't understand how those words can be offensive to you. Maybe the problem is that I am not a native English speaker and we come from very different cultural backgrounds so we interpret things differently.