rvest VS huxtable

You’re looking for the rvest package

Before diving into advanced machine learning algorithms or statistical models, we need to start with the basics: collecting and organizing data. Fortunately, both Python and R offer a wealth of libraries that make it easy to collect data from a variety of sources, including web scraping, APIs, and reading from files. Key libraries in Python include requests, BeautifulSoup, and pandas, while R has httr, rvest, and dplyr.

Tools: R + Rvest to scrape and clean the data. D3 to create the map. Svelte to put it all together.

so ik R has packages and native functions to help bypass this manual process. Eg scraping the wiki / gamepress unit list with Rvest may prove easier, furthermore you can specify web based sources when reading data. I'm not giga familiar with doing either myself, but maybe you can scrape data from the wikis or from repositories like the feh assets 1. But if youre able to set up a simple R script to read in new data and transform / clean it and save manual updates every 2 weeks

There are very similar tools in R that I cover in that tutorial. For example, rvest or xml2 should be able to do the job as both of them support XPath selectors (you can take the ones from the article - they should work in R too).

To get the data from the website, I need to use the package (a set of R code someone created and shared that's designed for a certain task) rvest, then I did a bunch of data munging in R to pull out the location/salary/age/etc. I saved that in a dataset and then used another package flexdashboard to make a webpage which I can essentially "one-click" publish using a free tool called RPubs.

It came up with the idea of how to combine Data Engineering with Cloud and automation. I needed to find a data source as it would be an automated pipeline, so I needed a dynamic source. At the same time, I wanted to find a site where I thought retrieving data would not be a problem and do practice with both rvest and dplyr. After I had no problems with my experiments with Carvago, I added the necessary data cleaning steps. Another thing I aimed for in the project was to keep the data in different ways in different environments. While raw (daily CSV) and processed data were written to the Github repo, I wrote the processed data to PostgreSQL on AWS RDS. In addition, I sync the raw and processed data to S3 to be able to use it with Athena. However, I have separated some stages for GitHub Actions to be a good practice. For example, in the first stage, I added synchronization with AWS S3 as a separate action while scraping data, cleaning, and printing fundamental analysis to a simple log file. If there is no error after all this, I added a report with RMarkdown and the action that will be published on github.io. Thus, I created an end-to-end data pipeline where the data from the source is made to offer basic reporting with simple processing.

I would try some more nuanced web scraping with a package like rvest

1) Use rvest to extract the contents of the XML file (i.e. loop over top-level nodes and pull any variable you're interested in into a column).

As for styling, I highly recommend the huxtable package. You can style rows, columns, and individual cells however you want. It uses dplyr pipelining, if you’re familiar with that, so it’s super intuitive to use too.

I wrote a little R package to write tables. I knew what HTML tables and Word tables could do. I wrote the interface to use all those features. LaTeX nerds were super proud of their tables. Should be easy to reimplement the features in TeX, right?

https://github.com/hughjonesd/huxtable/blob/master/R/latex.R

TeX is an abomination from hell.