Introduction For those who are learning R and who may be well-versed in SQL, thesqldf package provides a mechanism to manipulate R data frames using…
View More Manipulating Data Frames Using sqldf – A Brief OverviewCategory: R
readWorksheet-methods {XLConnect}
Reading data from worksheets Package: XLConnect Version: 0.2-7 Description Reads data from worksheets of a workbook. Usage ## S4 method for class ‘workbook,numeric’: readWorksheet((object,sheet,startRow,startCol,endRow,endCol,autofitRow,autofitCol, region,header,rownames,colTypes,forceConversion,dateTimeFormat,check.names,…
View More readWorksheet-methods {XLConnect}readWorksheetFromFile Reading data from worksheets in an Excel file (wrapper function)
Examples # multiregion xlsx file from demoFiles subfolder of # package XLConnect demoExcelFile <- system.file(“demoFiles/multiregion.xlsx”, package = “XLConnect”) # Read single area from first sheet…
View More readWorksheetFromFile Reading data from worksheets in an Excel file (wrapper function)Read Excel files from R
Many people still save their data into Microsoft Excel files. This is an unhappy choice for many reasons but many was already written about this…
View More Read Excel files from RR Programming/Text Processing
This page includes all the material you need to deal with strings in R. The section on regular expressions may be useful to understand the…
View More R Programming/Text Processing10 R packages which will master you in R Tool
R can be more prickly and obscure than other languages like Python or Java. The good news is that there are tons of packages which…
View More 10 R packages which will master you in R ToolR Regular Expression
R has various functions for regular expression based match and replaces. The grep,grepl, regexpr and gregexpr functions are used for searching for matches, while sub…
View More R Regular ExpressionText Mining the Complete Works of William Shakespeare
I am starting a new project that will require some serious text mining. So, in the interests of bringing myself up to speed on the…
View More Text Mining the Complete Works of William ShakespearePDF-2-text-or-CSV.r
# Here are a few methods for getting text from PDF files. Do read through # the instructions carefully! NOte that this code is written…
View More PDF-2-text-or-CSV.rConvert PDFs to text files or CSV files (DfR format) with R
# download pdftotxt from # ftp://ftp.foolabs.com/pub/xpdf/xpdfbin-win-3.03.zip # and extract to your program files folder # here is a pdf for mining url <- “http://www.noisyroom.net/blog/RomneySpeech072912.pdf” dest…
View More Convert PDFs to text files or CSV files (DfR format) with R