Emergency R: Importing data from spreadsheet software
If you have data in a spreadsheet, this tutorial can help you to import that data into R. It covers how to clean up your data using Microsoft Excel, then how to read it into a data frame in your R environment.
For your copying and pasting pleasure, the Excel formula that I used to check for badly formatted numbers was =NOT(OR(ISNUMBER(J2), ISBLANK(J2), J2="NA"))
Datasets are available at: https://github.com/lvclark/R_Python_v...
Next video: Exploring a data frame: • Emergency R: Exploring a data frame
Importing two-dimensional data with read.table: • Emergency R: Importing two-dimensional dat...
Table of Contents:
00:00 - Introduction
00:00 - Introduction
00:24 - Alternatives to this video
01:12 - Cleaning the spreadsheet
02:35 - Missing data
03:54 - Correcting non-numeric values
11:43 - Exporting to CSV
12:56 - Importing into R
17:01 - Checking the data
20:04 - NSF Acknowledgment