質問編集履歴
1
コードを最新のものに変更，説明を付け足した
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -4,15 +4,17 @@
|
|
|
4
4
|
|
|
5
5
|
```python__イタリックテキスト__
|
|
6
6
|
．．．．．
|
|
7
|
+
with MySQLdb.connect(**args) as cur:
|
|
8
|
+
cur.execute("SELECT * FROM papers limit 100;")
|
|
7
|
-
|
|
9
|
+
result = cur.fetchall()
|
|
10
|
+
|
|
8
11
|
papers = []
|
|
9
12
|
for row in result:
|
|
10
|
-
i += 1
|
|
11
13
|
authors = row[2].split(',')
|
|
12
14
|
ano = 0
|
|
13
|
-
for aname in authors:
|
|
14
|
-
ano += 1
|
|
15
|
-
papers.append([row[0], str(
|
|
15
|
+
for aname in authors: # anameは著者名
|
|
16
|
+
ano += 1 # anoは著者番号
|
|
17
|
+
papers.append([row[0], row[1], row[2], str(ano), aname, row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13], row[14], row[15], row[16], row[17], row[18], row[19], row[20], row[21], row[22], row[23], row[24], row[25]])
|
|
16
18
|
print(papers)
|
|
17
19
|
```
|
|
18
20
|
例えば，
|