Part 2 | Data Operations
// use your data to tell stories //Data operations are the tools you use to transform your data into a form that can be used to tell stories. We'll start with approaches for transforming your data using python and spreadsheets. You'll learn the tools to make your data more informative. This is where data can start to tell stories.
Part 2.1 ~ Cleaning Data
Turn messy data into something useful.
Concept 2.1 // Cleaning Data
Convert variable types; manipulte text; handle empty values.
Homework 2.1
Due on Friday Sept. 26 at 5PM on Gradescope
Part 2.2 ~ Transforming Data
Apply mathematical transformations to make variabls more informative.
Exercise 2.2 // Starbucks Hours Globally
Transforming global Starbucks hours data
Homework 2.2
Due on Friday, October 2 at 5PM on Gradescope
Part 2.3 ~ Filtering Data
Use logical operators (AND, OR, NOT) and comparison operators (>, <, ==) to create subsets. Filter rows based on conditions to focus analysis on specific groups.
Concept 2.3 // Filtering Data
Understand subsets of the data with logical conditions
Exercise 2.3 // Starbucks Hours
Filtering Starbucks location hours data
Homework 2.3
Due on Friday at 5PM on Gradescope
Part 2.4 ~ Grouping Data
Use group-by operations with aggregation functions (mean, sum, count) to calculate statistics by category. Create summary tables that show patterns across groups.
Exercise 2.4 // Starbucks Promotions
Analyzing promotional data by grouping
Homework 2.4
Due on Friday at 5PM on Gradescope
Part 2.5 ~ Merging Data
Combine two datasets using a linking variable.
Exercise 2.5 // Election Returns and Income
Homework 2.5
No homework this topic :)
MiniExams
MiniExam 2 covers everything in Part 2. You will begin to learn that if you understand the concepts and do the work in the examples and homework, you're going to be in good shape on the MiniExam.
MiniExams focuses on practical application of the concepts we've developed. Practice with Homework and Exercises to prepare effectively.