Test 1

Date, Time, & Location

Tuesday, February 18, 3:30pm-4:45pm, PM 251

Overview

Test 1 will cover all material from the beginning of the semester through data transformation (Thursday, February 13). The material will cover the assigned readings and the topics we discussed in class.

Format

• Multiple Choice (20-25)
• Free Response (3-4 questions)
• CS680 Students will have additional questions

Topics

• Python
• numpy
• pandas
• Data (items, attributes, attribute types, semantics, metadata)
• Data Wrangling
• Data Cleaning
• Data Transformation

Readings

Free Response Example Questions

• Given a dataset, (a) identify an item, attribute, and cell; (b) state, for each column, whether it is categorical, ordered, or quantitative.
• In the following Python code, identify all errors.

    // print the numbers from 1 to 100
    int counter = 1 
    while counter < 100 { 
        print counter 
        counter++
    }

• Given the following numpy array, write two different ways to index the highlighted sub-array
  
• Given the following two data frames, write a sequence of pandas operations to transform the first into the second. Exact syntax is not important, explain (and be specific) if you do not recall a particular operation or function name.

• State three distinct ways in which Wrangler helps users trying wrangle raw datasets.
• Compare Foofah’s example-based data cleaning with Wrangler’s interactive data cleaning.