1 / 10

Programming in R

In this session, learn the foundational commands of R for data importation, including how to directly enter data and read files from CSV, tab-delimited, and fixed-field formats. We will cover essential data types such as vectors, matrices, and data frames, along with crucial R commands like `c()`, `print()`, `read.csv()`, `read.table()`, and `read.fwf()`. Additionally, we will briefly explore options for importing data from Excel files and demonstrate how to save Excel files as CSV for seamless import into R.

armand-gutierrez
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Programming in R Getting data into R

  2. 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.

  3. 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.

  4. 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.

  5. 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)

  6. 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.

  7. 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.

  8. 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.

  9. CSV File

  10. Importing CSV file #~~~~~~~~~~~~~~~~~~~~~~~~# # code chunk 2 # # Import CSV File # #~~~~~~~~~~~~~~~~~~~~~~~~# widge <- read.csv("C:\\Path here\\WidgeOne.csv") head(widge)

More Related