質問編集履歴
1
コードを最新のものに変更,説明を付け足した
test
CHANGED
File without changes
|
test
CHANGED
@@ -10,23 +10,27 @@
|
|
10
10
|
|
11
11
|
.....
|
12
12
|
|
13
|
+
with MySQLdb.connect(**args) as cur:
|
14
|
+
|
15
|
+
cur.execute("SELECT * FROM papers limit 100;")
|
16
|
+
|
13
|
-
|
17
|
+
result = cur.fetchall()
|
18
|
+
|
19
|
+
|
14
20
|
|
15
21
|
papers = []
|
16
22
|
|
17
23
|
for row in result:
|
18
24
|
|
19
|
-
i += 1
|
20
|
-
|
21
25
|
authors = row[2].split(',')
|
22
26
|
|
23
27
|
ano = 0
|
24
28
|
|
25
|
-
for aname in authors:
|
29
|
+
for aname in authors: # anameは著者名
|
26
30
|
|
27
|
-
ano += 1
|
31
|
+
ano += 1 # anoは著者番号
|
28
32
|
|
29
|
-
papers.append([row[0],
|
33
|
+
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]])
|
30
34
|
|
31
35
|
print(papers)
|
32
36
|
|