2020-08-13 12:00:20 +02:00
|
|
|
---
|
|
|
|
id: 5e9a093a74c4063ca6f7c161
|
2021-07-15 13:04:11 +05:30
|
|
|
title: 读取数据简介
|
2020-08-13 12:00:20 +02:00
|
|
|
challengeType: 11
|
|
|
|
videoId: cDnt02BcHng
|
2021-10-04 07:27:38 -07:00
|
|
|
bilibiliIds:
|
|
|
|
aid: 548023524
|
|
|
|
bvid: BV1Nq4y1K7iV
|
|
|
|
cid: 409020187
|
2021-01-13 03:31:00 +01:00
|
|
|
dashedName: reading-data-introduction
|
2020-08-13 12:00:20 +02:00
|
|
|
---
|
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
# --description--
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2021-07-15 13:04:11 +05:30
|
|
|
*在视频中我们使用的编辑器工具是在 notebook.ai 这个平台,你也可以选择用其他的平台,比如说 Google Colab 也是一个不错的选择。*
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2021-07-15 13:04:11 +05:30
|
|
|
以下有更多的资料:
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2021-10-04 07:27:38 -07:00
|
|
|
- [在 GitHub 平台的 Notebooks](https://github.com/krishnatray/RDP-Reading-Data-with-Python-and-Pandas)
|
2021-07-15 13:04:11 +05:30
|
|
|
- [如何使用 Google Colab 来打开 GitHub 上的 Notebooks](https://colab.research.google.com/github/googlecolab/colabtools/blob/master/notebooks/colab-github-demo.ipynb)
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
# --question--
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
## --text--
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2021-07-15 13:04:11 +05:30
|
|
|
文件 `certificates.csv` 有以下内容:
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2021-02-06 04:42:36 +00:00
|
|
|
<pre>
|
2020-12-16 00:37:30 -07:00
|
|
|
Name$Certificates$Time (in months)
|
|
|
|
Tom$8$16
|
|
|
|
Kris$2$5
|
|
|
|
Ahmad$5$9
|
|
|
|
Beau$6$12
|
2021-02-06 04:42:36 +00:00
|
|
|
</pre>
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2021-07-15 13:04:11 +05:30
|
|
|
请填写以下缺失的参数:
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
```py
|
|
|
|
import csv
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
with open(__A__, 'r') as fp:
|
|
|
|
reader = csv.reader(fp, delimiter=__B__)
|
|
|
|
next(reader)
|
|
|
|
for index, values in enumerate(reader):
|
|
|
|
name, certs_num, months_num = values
|
|
|
|
print(f"{name} earned {__C__} certificates in {months_num} months")
|
|
|
|
```
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
## --answers--
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
A: `'certificates.csv'`
|
2020-08-13 12:00:20 +02:00
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
B: `'-'`
|
|
|
|
|
|
|
|
C: `values`
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
A: `'certificates.csv'`
|
|
|
|
|
|
|
|
B: `'$'`
|
|
|
|
|
|
|
|
C: `certs_num`
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
A: `'certificates'`
|
|
|
|
|
|
|
|
B: `'$'`
|
|
|
|
|
|
|
|
C: `certs_num`
|
|
|
|
|
|
|
|
## --video-solution--
|
|
|
|
|
|
|
|
2
|
|
|
|
|