From the course: R Programming in Data Science: High Variety Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Write a workbook to Excel

Write a workbook to Excel

From the course: R Programming in Data Science: High Variety Data

Start my 1-month free trial

Write a workbook to Excel

“

- [Instructor] R provides a lot of packages that will allow you to export data out to an Excel workbook. And I'm going to demonstrate one of them, it's called rio. Before I start, make sure that you have set your working directory to point to chapter zero one, and then I'll need some data to export, so I'm going to use the data command, and use the CO2 and ChickWeight datasets. Now I have two data frames, ChickWeight and CO2, and I'd like to export those out to a workbook and I'll use rio for that. Be sure that if you haven't already installed rio, use the install.packages command with rio, and use library rio to make rio available for use. Now, to export those two data frames out to a workbook is fairly simple. You use the export command, part of rio, parenthesis, and then you feed it a list of datasets you'd like to export, in this case list, and we'll call up the CO2 data frame, and the ChickWeight data frame. You'll need to tell the export command where to put that file. And to do…

Contents