91 Views

Download Presentation
##### Programming in R

**An Image/Link below is provided (as is) to download presentation**

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**Programming in R**Getting data into R**Importing data into R**In this session we will learn: • Some basic R commands • How to enter data directly into R • How to use commands to read data from CSV files, tab delimited files, and fixed field files.**R Data type**• Vectors – a single column (or row )of data • Example – a numeric vector containing test scores of students • Matrix – a collection of vectors but must all be of the same data type • Data frame – a special matrix that can contain both numeric and character columns.**R commands**• c() – creates a column vector • print – prints the contents of an object • read.csv – reads in a CSV file • read.table – more generic function that can read in files with any delimiter, such as tab delimited. • read.fwf– reads in fixed record formats.**Creating Data in R**• The easiest way to add data to R is to code it. names <- c("Bob","Gene","Valerie") print(names) age <- c(30, 40, 19) hometown <- c("Dallas, TX", "Little Rock, AR", "Dayton, OH") print(hometown)**Importing Data Into R**• In order to import data into R, we need to know how the file was created. • Excel file • SAS • SPSS • Delimited • Fixed-field or fixed record.**Importing Data Into R**• Base R cannot import data directly from Excel. • There are packages available that allow R to import directly from Excel. • We will learn about packages in the next session.**Importing Excel**• Need to save Excel as a CSV file. • Click File/Save As • On the next GUI, select CSV from the Save as type. • We will demonstrate it in a few minutes.**Importing CSV file**#~~~~~~~~~~~~~~~~~~~~~~~~# # code chunk 2 # # Import CSV File # #~~~~~~~~~~~~~~~~~~~~~~~~# widge <- read.csv("C:\\Path here\\WidgeOne.csv") head(widge)