I'm writing a report in Markdown and for some reason this this one table from a csv has these comments before it while the rest of my tables don't. Below is what is being written before the table. How do I get this not to display and what is this called?
>##Rows: 6 Columns: 4
>##-- Column specification --------------------------------------------------------
>##Delimiter: ","
>##chr (1): Location
>##dbl (3): Total.area.sq.km, Protected.area.sq.km, Percent.Protected
>##i Use `spec()` to retrieve the full column specification for this data.
>##i Specify the column types or set `show_col_types = FALSE` to quiet this message.
This is the code I am running:
```
---
title: "Rural Cadaster Report v01"
author: "Name"
date: "9/09/2022"
output:
word_document:
number_sections: false
---
```
```{r setup, include=FALSE}
knitr::opts_chunk$set(echo = TRUE)
```
```{r Protected_area_stats, echo = FALSE}
library(tidyverse)
# Reads in Protected area stats table
PA<- read_csv("Tables/Results/ProtectedAreas_summary_stats_final.csv")
# Groups by location and sums data
PA<- PA %>%
group_by(Location) %>%
summarize('Total area sq km' = sum(Total.area.sq.km),
'Protected area sq km' = sum(Protected.area.sq.km),
'% Protected' = sum(Percent.Protected))
# Formats column 4 as percent
PA[4] <- sapply(PA[4], function(x) scales::percent(x, accuracy=.1))
# Writes tables and adds in thousands ,
knitr::kable(
PA,
format.args = list(big.mark = ",", scientific = FALSE),
caption = "Area of Colombian Protected areas"
)
```