As an entrepreneur, product designer and product manager for people management and predictive analytics software, I have seen a number of problems related to creating useful products, and getting things done. I decided to keep track of some common scenarios. All views are mine. Not my employers'.
Friday, November 07, 2014
R Code for Reading a Specific Portion of an Excel File
Most data sharing in organizations is done using Microsoft Excel. So the code to import Excel data into R for manipulation is a good thing to know. The import function is powerful enough to let you read a specific section of an Excel file and load it into a dataframe..
Here is the sample code.
mydata <- read.xlsx("file.xlsx",sheetIndex=1,colIndex=7:15, rowIndex=18:23)
The sample code reads an Excel file and imports data from columns 7 to 15 and rows 18 to 23 into a dataframe. An R dataframe is a table of data.