How to Scrape Word Documents with R

Written by Matt Dancho on September 16, 2020



This article is part of a R-Tips Weekly, a weekly video tutorial that shows you step-by-step how to do common R coding tasks.

Today we discuss an awesome skill for automating data collection from word documents:

(Click image to play video)


Here’s a common situation, you’re company has LOTS OF WORD FILES.

They contain tables of information that look like this:

Word Tables


Thinking like a programmer, you can extract this data using officer:


With a little bit of data wrangling with the tidyverse, you’ve got your table extracted & formatted:


Then you use ggplot2 to make a sweet plot:


Whoa - Look at 201! Getting a high “Activity Ratio” - Ratio of Lessons completed to Number of Students Enrolled:


You’ve just automated extracting word tables in R. BOOM! 💥💥💥


SETUP R-TIPS WEEKLY PROJECT

  1. Get the Code

  2. Check out the R-Tips Setup Video.

Once you take these actions, you’ll be set up to receive R-Tips with Code every week. =)



👇 Top R-Tips Tutorials you might like:

  1. mmtable2: ggplot2 for tables
  2. ggdist: Make a Raincloud Plot to Visualize Distribution in ggplot2
  3. ggside: Plot linear regression with marginal distributions
  4. DataEditR: Interactive Data Editing in R
  5. openxlsx: How to Automate Excel in R
  6. officer: How to Automate PowerPoint in R
  7. DataExplorer: Fast EDA in R
  8. esquisse: Interactive ggplot2 builder
  9. gghalves: Half-plots with ggplot2
  10. rmarkdown: How to Automate PDF Reporting
  11. patchwork: How to combine multiple ggplots
  12. Geospatial Map Visualizations in R

Want these tips every week? Join R-Tips Weekly.