Course Description
Introduces students to advanced data operations using the Pandas package in Python. Several data-related topics are covered including data transformation and data wrangling with a focus on ETL (extract, transform, load) operations. Introduces students to structured data analytics and machine learning.
Athena Title
Python Prog Bus Analytics II
Non-Traditional Format
This course will be taught 95% or more online.
Pre or Corequisite
BUSN 3030E
Grading System
S/U (Satisfactory/Unsatisfactory)
Course Objectives
Learning Outcomes * Advanced Python programming constructs * Data operation, transformation, and aggregation * Combining data sets * Advanced data types: missing values, text, and regular expressions * Machine learning: regression, classification, and clustering
Topical Outline
Data wrangling with Pandas * Data indexing and selection * Operating on data in Pandas * Handling missing data * Hierarchical indexing * Combining datasets: concat and append * Merging datasets: merge and join * Aggregation and grouping Text and manipulation * Regular expressions * Vectorized string operations Machine Learning * Introduction to machine learning * Linear regression * Decision trees * Clustering Putting it together * Data wrangling exercise * Machine learning exercise
Syllabus