Converting RTF Files to TXT in R

Recently I downloaded a large number of RTF files. Wanting to analyze this text data in R, I first needed to strip RTF encoding. In this video I use the striprtf library to loop through a folder of files, convert them to .TXT, and save those .TXT files to another folder. The code is pasted […]

R for Excel Users: The XLView() Function

It’s time for another post about R. I’ll admit, these days most of my work is done in R. But, I still love using Excel, and I really do enjoy teaching and blogging about it. Fortunately, these two platforms work great together… they collide, in a good way. And XLView() is a great example. Subscribe […]

R Explained for Excel Users: What is a Directory?

Like Excel, R can read in files and create new files based on your commands. R will assume these files will be read from and written to your directory.  This is a common stumbling block for new R users, but pretty easy to understand with a couple of basic functions. In the below example, I created […]

R Explained for Excel Users: What is a Data Frame?

Like in Excel, data in R comes in different shapes and sizes. In Excel, there are cells, ranges, worksheets and so forth. R does things a bit differently. Ultimately, these difference come down to the use of a vector as its information building block.  Picture a table in Excel. If you know how to design […]

R Explained for Excel Users: Assigning Variables

The single-greatest difference? R and Excel are both powerful tools for the analyst. A good analyst uses each when appropriate. Many analysts haven’t used R, for different reasons. For one, it has a steeper learning curve than Excel. It is also less likely to be used by your boss. But it is a very powerful […]