How can I turn the following text file into a nice RMarkDown table?
Checster
I have several .txt files that I would like to convert into a nice table in RMarkDown. An example of one would be a file containing the following text:
|name|Tin|Tout|Hin|Hout|DT min/2|alpha|
|-----|-----|-----|-----|-----|-----|-----|
|airHEATER_1|3.09|55|0|834|5|1|
|airHEATER_2|4.35|60|0|894.47|5|1|
|airHEATER_3|35.63|70|0|553.51|5|1|
|airHEATER_4|59.78|75|0|245.52|5|1|
|airHEATER_5|78.49|85|0|104.97|5|1|
I have tried everything. The kable function returns nonsense, I have also tried readLines() and read.table() but no luck. I tried converting the .txt file contents into a dataframe with the as.data.drame() function but I get a one-column dataframe with the .txt whole lines as rows, instead of 7 columns.
How would you do it ? I ran out of options here :/
stefan
Using read.table with sep="|" and some data cleaning you could do:
---
output: html_document
date: "2022-11-09"
---
```{r}
dat <- read.table(text = "|name|Tin|Tout|Hin|Hout|DT min/2|alpha|
|-----|-----|-----|-----|-----|-----|-----|
|airHEATER_1|3.09|55|0|834|5|1|
|airHEATER_2|4.35|60|0|894.47|5|1|
|airHEATER_3|35.63|70|0|553.51|5|1|
|airHEATER_4|59.78|75|0|245.52|5|1|
|airHEATER_5|78.49|85|0|104.97|5|1|", sep = "|", header = TRUE, check.names = FALSE)
```
```{r}
dat <- dat[-c(1, ncol(dat))]
dat <- dat[!grepl("^-", dat[[1]]), ]
```
```{r}
knitr::kable(dat)
```
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Could someone please explain what the following lines of this code do?
- Next: Webscraping R: no applicable method for 'read_xml' applied to an object of class "list"
Related
TOP Ranking
- 1
pump.io port in URL
- 2
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 3
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 4
Inner Loop design for webscrapping
- 5
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 6
ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements
- 7
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)
- 8
Removed zsh, but forgot to change shell back to bash, and now Ubuntu crashes (wsl)
- 9
Ambiguous use of 'init' with CFStringTransform and Swift 3
- 10
Resetting Value of <input type="time"> in Firefox
- 11
Execute ./script.sh with a crontab
- 12
Converting a class method to a property with a backing field
- 13
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 14
How to update azerothcore-wotlk docker container
- 15
How to set tab order for array of cluster,where cluster elements have different data types in LabVIEW?
- 16
Grails with Oracle thick OCI driver authenticate to Oracle with wrong user
- 17
How to pass data to the ng2-bs3-modal?
- 18
Making Array From Page Elements in jQuery
- 19
Retrieve Element Tag Value XML Using Bash
- 20
Laravel's ORM sync with timestamps doesn't update timestamps
- 21
Do animations stop css changes after animation completion?
Comments