Web Scraping & Bots · 课时

将数据存储为 CSV/JSON

学习将抓取的数据保存为 CSV 和 JSON 等常见文件格式，便于移植和分析。

第 1 / 4 课11 个步骤

将数据存储为 CSV/JSON 是 CoddyKit 上的免费 Web Scraping & Bots 课时。这是第 1 节课，共 4 节。你可以在下方免费阅读本课时的完整内容 — 然后在浏览器中使用内置代码编辑器和全天候 AI 导师进行实践。这是 Web Scraping & Bots 学习路径的一部分，你的进度在网页和 CoddyKit 应用中同步。 Web Scraping & Bots 课程共包含 4 节课。

本课时的部分内容尚未翻译，以英文显示。

Storing Your Scraped Data

After scraping, raw data is often in memory. To use it later, share it, or analyze it, you need to save it permanently.

This lesson introduces two popular file formats: CSV and JSON. They are simple, human-readable, and widely supported.

Meet CSV: Comma-Separated Values

CSV stands for Comma-Separated Values. It's a plain text file format used to store tabular data, like a spreadsheet.

Each line in a CSV file is a data record. Each record consists of one or more fields, separated by commas.

CSV: Simple Table Format

Imagine a simple table. Each row becomes a line, and each column value is separated by a comma. The first line often contains the column headers.

name,age,city
Alice,30,New York
Bob,24,London

Writing to CSV with Python

Python's built-in csv module makes writing data to CSV files easy. We'll use csv.writer and writerow().

The 'w' mode opens the file for writing. newline='' prevents extra blank rows.

import csv

# Data to save
data = [
    ["name", "age", "city"],
    ["Alice", 30, "New York"],
    ["Bob", 24, "London"]
]

# Open the file in write mode
with open("people.csv", "w", newline="") as file:
    writer = csv.writer(file)
    writer.writerows(data) # Write all rows at once

print("Data saved to people.csv")

JSON: JavaScript Object Notation

JSON (JavaScript Object Notation) is another popular, human-readable format. It's often used for sending data between web servers and web applications.

JSON organizes data into key-value pairs, similar to Python dictionaries, and lists.

JSON: Key-Value Pairs

JSON data is structured using objects ({}) and arrays ([]).

An object holds key-value pairs (e.g., "name": "Alice").
An array holds an ordered list of values (e.g., [{}, {}]).

[
  {
    "name": "Alice",
    "age": 30,
    "city": "New York"
  },
  {
    "name": "Bob",
    "age": 24,
    "city": "London"
  }
]

Writing to JSON with Python

Python's built-in json module handles JSON data. We'll use json.dump() to write a Python dictionary or list to a file.

indent=2 makes the output file more readable by adding indentation.

import json

# Data to save (list of dictionaries)
data = [
    {"name": "Alice", "age": 30, "city": "New York"},
    {"name": "Bob", "age": 24, "city": "London"}
]

# Open the file in write mode
with open("people.json", "w") as file:
    json.dump(data, file, indent=2)

print("Data saved to people.json")

Choosing the Right Format

Both CSV and JSON are great for data storage, but they excel in different scenarios:

CSV: Best for simple tabular data, like spreadsheets. Easy to import into databases or Excel.
JSON: Ideal for complex, hierarchical data. Great for APIs and when data structure might vary.

Reading Data Back

Just as you can write data, you can also read it back! Both csv and json modules provide functions for this.

csv.reader() for CSV files.
json.load() for JSON files.

This allows you to load your scraped data back into Python for further processing.

Data Format Quiz

Which file format is generally better suited for storing hierarchical data with nested structures, like a list of products where each product has multiple attributes and possibly sub-items?

在交互式课程中回答

Lesson Summary

You've learned how to persist your scraped data!

CSV: Ideal for tabular data, easy with Python's csv module.
JSON: Great for hierarchical data, handled by Python's json module.
Choose the format that best fits your data's structure and how you plan to use it.

Saving data is crucial for analysis and future use.

免费开始

用 AI 导师学习 Python — 免费

在浏览器中编写并运行真实代码，获得全天候 AI 导师的即时帮助，并在网页或应用中继续学习。

课程: 12
课程: 48

免费开始学习查看完整课程

常见问题解答

「将数据存储为 CSV/JSON」课时是免费的吗？

是的 — 「将数据存储为 CSV/JSON」的完整文本可在网页上免费阅读。要进行交互式练习（内置代码编辑器和全天候 AI 导师）并解锁 Web Scraping & Bots 课程的其余内容，请升级到 CoddyKit PRO。 Web Scraping & Bots 课程共包含 4 节课。

「将数据存储为 CSV/JSON」这节课中我会学到什么？

学习将抓取的数据保存为 CSV 和 JSON 等常见文件格式，便于移植和分析。你通过在浏览器中直接运行的动手代码来练习 Web Scraping & Bots，全天候 AI 导师会在你学习这节课的过程中回答你的问题。

学习 Web Scraping & Bots 需要有经验吗？

无需任何先前经验。CoddyKit 上的 Web Scraping & Bots 课程适合初学者到高级学习者，你可以从这里开始或从头开始，按照自己的节奏学习。这是第 1 节课，共 4 节。

「将数据存储为 CSV/JSON」课时需要多长时间？

大多数 CoddyKit 课程大约需要 5–10 分钟。每节课都很精短且互动，所以你能稳步进步，并在网页和应用中从离开的地方继续。

我能在这节 Web Scraping & Bots 课中编写并运行代码吗？

能。每节 Web Scraping & Bots 课都包含内置代码编辑器，你可以在浏览器中直接编写并运行真实代码，并获得即时 AI 反馈 — 无需本地设置。

此课程中的所有课时

← 返回 Web Scraping & Bots