Data Files and The Text Editor | Correlation Using the R Statistical Package - Part 2: Data Preparation

The majority of data loggers and sensors output their data in simple text file formats. This next discussion is targeted towards understanding two common formats - the CSV and the Tab delimited data.

A simple text editor is a very helpful utility (tool) to use while working on data analysis projects. It will help you when looking at the raw data In this discussion we will also review a common text editor that you will find helpful for both a Windows and a Mac platform.

NOTE: You will notice that text editors may not have a filetype dropdown option "CSV" for saving the file. However you can always add ".csv" as the extension to the file name.

Click here to access the PPT slides used in the presentation

Click here to download the CSV file used

Quiz

Question

You should never try to open a comma or a tab delimited file with a text editor.

True

Incorrect: Explanation: A comma or a tab delimited file is a simple text file; understanding the structure in which the data is stored in the data file is the first step in identifying the steps involved in data analysis

False

Correct: Explanation: A comma or a tab delimited file is a simple text file; understanding the structure in which the data is stored in the data file is the first step in identifying the steps involved in data analysis

Looks Good! Correct: Explanation: A comma or a tab delimited file is a simple text file; understanding the structure in which the data is stored in the data file is the first step in identifying the steps involved in data analysis