Module 04 · Accessing Databases using Python
Summary: Accessing databases using Python课程总结：使用 Python 访问数据库
Congratulations! You have completed this lesson. At this point in the course, you know:
恭喜！您已完成本课学习。至此，您已掌握以下知识点：
- Magic commands are special commands that provide special functionalities.
魔法命令是提供特殊功能的特殊指令。 - Cell magics are commands prefixed with two %% characters and operate on multiple input lines.
单元格魔法命令以两个%%字符为前缀，可对多行输入进行操作。 - DB APIs are commands prefixed with two %% characters and operate on multiple input lines.
数据库 API 命令以两个%%字符为前缀，可对多行输入进行操作。 - The two main concepts in the Python DB API are Connection Objects and Query Objects.
Python 数据库 API 中的两个核心概念是连接对象和查询对象。 - A database cursor is a control structure that enables traversal over the records in a database.
数据库游标是一种控制结构，用于遍历数据库中的记录。 - Pandas’ methods are equipped with common mathematical and statistical methods.
Pandas 库的方法配备了常见的数学和统计方法。 - The
pandas.read_csv()function is used to read the database CSV file.pandas.read_csv()函数用于读取数据库 CSV 文件。 - The sqlite3.connect() function is used to connect to a database.
sqlite3.connect()函数用于连接数据库。 - To use pandas to retrieve data from the database tables, load data using the read_sql method and select the SQL Select Query
要使用 pandas 从数据库表中检索数据，可通过 read_sql 方法加载数据并选择 SQL 查询语句 - A categorical scatterplot is created using the swarmplot() method by the seaborn package.
通过 seaborn 包的 swarmplot()方法可创建分类散点图