DANL 210-01: Data Preparation and Management, Spring 2025
- Instructor: Byeong-Hak Choe Email | Brightspace
Welcome! ๐
\(-\) Explore, Learn, and Grow with Data Analytics! ๐
\(\bullet\,\) Lecture Slides ๐
| Title | Subtitle | Date |
|---|---|---|
| Lecture 1 | Syllabus, Course Outline, and Introduction | January 22, 2025 |
| Lecture 2 | Prologue; DANL Tools; Building a Website; Markdown | January 24, 2025 |
| Lecture 3 | Getting Started with Jupyter Notebook and Quarto | January 27, 2025 |
| Lecture 4 | Python Basics - Variables; Assignments; Data Types; Operators; Casting Values; Data Containers | January 31, 2025 |
| Lecture 5 |
Python Basics - if-else Chains; Slicing; Functions; while & for loops; List & Dictionary Methods; try-except Blocks
|
February 3, 2025 |
| Lecture 6 |
pandas Basics - Loading Data
|
February 10, 2025 |
| Lecture 7 |
pandas Basics - Getting a Summary of Data; Selecting Variables; Counting Methods; Sorting Methods
|
February 12, 2025 |
| Lecture 8 |
pandas Basics - Sorting Methods; Setting a New Index; Locating Observations/Values
|
February 14, 2025 |
| Lecture 9 |
pandas Basics - Mathematical & Vectorized Operations; Adding, Removing, & Renaming Variables; Data Types
|
February 17, 2025 |
| Lecture 10 |
pandas Basics - Filtering by a Condition
|
February 19, 2025 |
| Lecture 11 |
pandas Basics - Missing Values; Duplicates
|
February 21, 2025 |
| Lecture 12 |
pandas Basics - Reshaping DataFrames
|
February 24, 2025 |
| Lecture 13 |
pandas Basics - Joining DataFrames; Concatenating DataFrames
|
February 26, 2025 |
| Lecture 14 |
Spyder IDE; Scrapping Web-tables with pd.read_html()
|
March 10, 2025 |
| Lecture 15 | Primer on Web-scrapping | March 12, 2025 |
| Lecture 16 |
Web-scrapping with Python selenium
|
March 14, 2025 |
| Lecture 17 | Data Collection with APIs | April 11, 2025 |
| Lecture 18 |
Data Visualization with seaborn
|
April 25, 2025 |
| Lecture 19 | Group Operations | April 30, 2025 |
No matching items
\(\bullet\,\) Classwork โจ๏ธ
| Title | Subtitle | Date |
|---|---|---|
| Classwork 1 | Building a Personal Website using Git, GitHub, and RStudio with Quarto | January 24, 2025 |
| Classwork 2 | Markdown Basics | January 24, 2025 |
| Classwork 3 | Quarto Website Basics | January 27, 2025 |
| Classwork 4 | Python Basics | January 29, 2025 |
| Classwork 5 | Pandas Basics - Loading, Summarizing, Selecting, Counting, Sorting, and Indexing Data | February 12, 2025 |
| Classwork 6 | Pandas Basics - Convering Data Types; Filtering Data; Dealing with Missing Values/Duplicates | February 17, 2025 |
| Classwork 7 | Pandas Basics - Reshaping DataFrames; Joining DataFrames; Concatenating Rows and Columns | February 24, 2025 |
| Classwork 8 |
Scrapping Web-tables with pd.read_html()
|
March 10, 2025 |
| Classwork 9 |
Scrapping Data with Python selenium
|
March 24, 2025 |
| Classwork 10 |
Advanced Techniques for Python selenium
|
March 28, 2025 |
| Classwork 11 | Data Collection with APIs | April 9, 2025 |
| Classwork 12 |
Data Visualization with seaborn
|
April 25, 2025 |
| Classwork 13 | Group Operation I | April 27, 2025 |
| Classwork 14 | Group Operation II | May 5, 2025 |
No matching items
\(\bullet\,\) Homework ๐ป
| Title | Subtitle | Date |
|---|---|---|
| Homework 1 | Survey, Personal Website, and Python Basics | February 5, 2025 |
| Homework 2 | Pandas Basics | February 19, 2025 |
| Homework 3 |
Python selenium & Pandas Basics
|
March 30, 2025 |
| Homework 4 |
Python selenium, APIs, & Pandas Basics
|
April 10, 2025 |
| Homework 5 | Pandas Group Operations | May 1, 2025 |
No matching items
\(\bullet\,\) Exam ๐
| Title | Subtitle | Date |
|---|---|---|
| Final Exam Practice |
Data Wrangling with pandas
|
May 6, 2025 |
| Midterm Exam I | Spring 2025, DANL 210-01 | March 5, 2025 |
| Midterm Exam II | Spring 2025, DANL 210-01 | April 21, 2025 |
No matching items