糖心vlog官网观看

This module focuses on acquiring data using APIs, as well as applying numerical cleaning techniques. You鈥檒l learn how to retrieve data from web-based APIs, handle authentication securely, and transform raw JSON responses into usable dataframes. The module also covers techniques for cleaning and preparing numerical data, including scaling, binning, normalization, and outlier handling.

This module introduces the fundamentals of data storage and retrieval using databases and SQL. You鈥檒l learn how data is structured in relational systems; explore core concepts like entities, relationships, and schemas; and gain hands-on experience writing SQL queries. You鈥檒l also explore how to query databases from a Python notebook, as well as how generative AI tools can support SQL-based tasks.

In this module, you鈥檒l expand your SQL skills into data preprocessing, validation, and joins (combining tables). You鈥檒l learn how to use SQL for filtering, conditional logic, and handling missing values, and apply validation techniques using aggregation and grouping. The module also explores different types of joins and demonstrates how to use them to combine and analyze data across multiple tables鈥攅specially in real-world scenarios like analyzing sports performance data.