DSCI 210 Course Notes¶
SECTION 1: Introduction¶
Below you will find a web interface for the DSCI 210 course notes. These notes were originally developed by Chris Malone and transferred to the web by Todd Iverson.
- 1. Processing Data with Excel
- 1.1. Storing Data in Excel
- 1.2. Formating Data
- 1.3. Common Spreadsheet Errors
- 1.4. Dates as Data
- 1.5. Quality Control
- 1.6. Exporting Data
- 1.7. Reading in Standard Data
- 1.8. Sorting and Filtering Data
- 1.9. Basic String Functions
- 1.10. Pivot Tables
- 1.11. Appending with the OFFSET() Function
- 1.12. Merge Tables with the MATCH() and INDEX() Functions
- 1.13. Application: Association Rules, i.e. Market Basket Analysis
- 2. Introduction to OpenRefine
- 3. Processing Data with Open Refine
- 4. Processing Data with a Text Editor
- 5. Processing Data with Bash
- 6. Processing Data with R
Section 2: Links¶
These notes are built using the tools provided by Runestone Interactive.
Runestone uses the restructuredText (rst) markup language. More information
can be found using the following links.
- restructuredText Docs
- Runestone Docs
- Join the discussion on our Google Group
- Tell us about problems on Github