In this video, Mark Niemann-Ross shows how to write data from R to Excel. Learn how to create an Excel file and write data to a new sheet.
- Writing a row or a column to an Excel spreadsheet…is exactly the same as…writing a range to an Excel spreadsheet.…So, let's step through the process.…We're going to use Open XLSX,…but rather than just duplicate the process…we went through before in Chapter 0105,…let's do a couple of different things.…To set up, be sure that you've set your working directory…to Chapter 01, and if you haven't already,…install packages for Open XLXS, go ahead and do that,…and then, use the library command, library(openxlsx),…to make sure that the library is available for you.…
Now, I'm going to need some data to write in,…so I'm going to use Small Table for range,…and create a data frame into that vector,…and now, we're ready to start writing out rows.…This time, rather than writing to an existing workbook,…I'm going to create a brand new Excel workbook.…So, I need to set up a vector to save a reference to it,…so I'm going to create something called workingXLSX,…and into that vector, I'm going to create a workbook,…and this is an Open XLSX command.…
- Name the three types of big data.
- List three considerations used to determine the appropriate R package for Excel.
- Determine the best package used to import entire Excel workbooks.
- Explain how to import standard text files using base R and tidyverse.
- Define the purpose of the foreign language package for R.
- Recognize restrictions when working on SAS files in the foreign language package.
- Identify the problems involved with extracting data from a PDF in R.
Skill Level Intermediate
R Programming in Data Science: High Volume Datawith Mark Niemann-Ross1h 25m Intermediate
1. Use R with Excel
2. Importing Text Files
3. Understanding the Foreign Package
4. Use R with Popular Data Formats
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.