質問編集履歴
3
誤記修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -144,6 +144,8 @@
|
|
|
144
144
|
|
|
145
145
|
concatedDf = pd.concat([columnDf, table1Df, table3Df], keys=['ID'])
|
|
146
146
|
|
|
147
|
+
print(concatedDf)
|
|
148
|
+
|
|
147
149
|
|
|
148
150
|
|
|
149
151
|
結果
|
|
@@ -159,6 +161,10 @@
|
|
|
159
161
|
# merge
|
|
160
162
|
|
|
161
163
|
mergedDf = columnDf.merge(table1Df, on='ID')
|
|
164
|
+
|
|
165
|
+
mergedDf = mergedDf.merge(table3Df, on='ID')
|
|
166
|
+
|
|
167
|
+
print(mergedDf)
|
|
162
168
|
|
|
163
169
|
|
|
164
170
|
|
2
誤記修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,7 +58,7 @@
|
|
|
58
58
|
|
|
59
59
|
ｉｄ３ ｇ３ ｈ３ ｉ３
|
|
60
60
|
|
|
61
|
-
ｉｄ
|
|
61
|
+
ｉｄ４ ｇ４ ｈ４ ｉ４
|
|
62
62
|
|
|
63
63
|
|
|
64
64
|
|
1
記載に誤記があったので修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -32,13 +32,13 @@
|
|
|
32
32
|
|
|
33
33
|
テーブル１
|
|
34
34
|
|
|
35
|
-
ＩＤ Ａ
|
|
35
|
+
ＩＤ Ａ Ｂ Ｃ
|
|
36
36
|
|
|
37
|
-
|
|
37
|
+
ｉｄ１ ａ１ ｂ１ ｃ１
|
|
38
38
|
|
|
39
|
-
|
|
39
|
+
ｉｄ２ ａ２ ｂ２ ｃ２
|
|
40
40
|
|
|
41
|
-
|
|
41
|
+
ｉｄ３ ａ３ ｂ３ ｃ３
|
|
42
42
|
|
|
43
43
|
|
|
44
44
|
|
|
@@ -50,15 +50,15 @@
|
|
|
50
50
|
|
|
51
51
|
テーブル３
|
|
52
52
|
|
|
53
|
-
ＩＤ Ｇ
|
|
53
|
+
ＩＤ Ｇ Ｈ Ｉ
|
|
54
54
|
|
|
55
|
-
|
|
55
|
+
ｉｄ１ ｇ１ ｈ１ ｉ１
|
|
56
56
|
|
|
57
|
-
|
|
57
|
+
ｉｄ２ ｇ２ ｈ２ ｉ２
|
|
58
58
|
|
|
59
|
-
|
|
59
|
+
ｉｄ３ ｇ３ ｈ３ ｉ３
|
|
60
60
|
|
|
61
|
-
|
|
61
|
+
ｉｄ ｇ４ ｈ４ ｉ４
|
|
62
62
|
|
|
63
63
|
|
|
64
64
|
|
|
@@ -66,15 +66,15 @@
|
|
|
66
66
|
|
|
67
67
|
統合テーブル（ほしい結果）
|
|
68
68
|
|
|
69
|
-
ＩＤ Ａ Ｂ Ｃ Ｄ Ｅ Ｆ Ｇ Ｈ Ｉ
|
|
69
|
+
ＩＤ Ａ Ｂ Ｃ Ｄ Ｅ Ｆ Ｇ Ｈ Ｉ
|
|
70
70
|
|
|
71
|
-
|
|
71
|
+
ｉｄ１ ａ１ ｂ１ ｃ１ ｇ１ ｈ１ ｉ１
|
|
72
72
|
|
|
73
|
-
|
|
73
|
+
ｉｄ２ ａ２ ｂ２ ｃ２ ｇ２ ｈ２ ｉ２
|
|
74
74
|
|
|
75
|
-
|
|
75
|
+
ｉｄ３ ａ３ ｂ３ ｃ３ ｇ３ ｈ３ ｉ３
|
|
76
76
|
|
|
77
|
-
|
|
77
|
+
ｉｄ４ ｇ４ ｈ４ ｉ４
|
|
78
78
|
|
|
79
79
|
|
|
80
80
|
|
|
@@ -186,4 +186,4 @@
|
|
|
186
186
|
|
|
187
187
|
２ ｉｄ３ ａ３ ｂ３ ｃ３ ＮａＮ ＮａＮ ＮａＮ ｇ３ ｈ３ ｉ３
|
|
188
188
|
|
|
189
|
-
３ ｉｄ
|
|
189
|
+
３ ｉｄ４ ＮａＮ ＮａＮ ＮａＮ ＮａＮ ＮａＮ ＮａＮ ｇ４ ｈ４ ｉ４
|