質問編集履歴
4
コードの追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -76,19 +76,29 @@
|
|
|
76
76
|
|
|
77
77
|
|
|
78
78
|
|
|
79
|
+
パターン①
|
|
80
|
+
|
|
79
81
|
```ここに言語を入力
|
|
80
82
|
|
|
81
83
|
df_3 = df_3[df_3['col3'] == 0] # 条件を指定
|
|
84
|
+
|
|
85
|
+
df_3['col4'] = 99 # 値を更新
|
|
86
|
+
|
|
87
|
+
df_3['col5'] = 'xx' # 値を更新
|
|
82
88
|
|
|
83
89
|
```
|
|
84
90
|
|
|
85
91
|
|
|
86
92
|
|
|
93
|
+
パターン②
|
|
94
|
+
|
|
87
95
|
```ここに言語を入力
|
|
88
96
|
|
|
89
|
-
df_3['col4'] = 99
|
|
97
|
+
df_3.loc[df_3['col3'] == 0, 'col4'] = 99
|
|
90
98
|
|
|
91
|
-
df_3['col5'] = 'xx'
|
|
99
|
+
df_3.loc[df_3['col3'] == 0, 'col5'] = 'xx'
|
|
100
|
+
|
|
101
|
+
df_3[df_3['col3'] == 0]
|
|
92
102
|
|
|
93
103
|
```
|
|
94
104
|
|
3
誤字の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -56,7 +56,35 @@
|
|
|
56
56
|
|
|
57
57
|
df_3 = pd.merge(df_1, df_2, on='col1', how='left')
|
|
58
58
|
|
|
59
|
+
```
|
|
60
|
+
|
|
61
|
+
|
|
62
|
+
|
|
63
|
+
df_3
|
|
64
|
+
|
|
65
|
+
|col1|col2|col3|col4|col5|
|
|
66
|
+
|
|
67
|
+
|:--|:--:|--:|
|
|
68
|
+
|
|
69
|
+
|a|1|0|0||
|
|
70
|
+
|
|
71
|
+
|b|2|0|0||
|
|
72
|
+
|
|
73
|
+
|c|3|1|1||
|
|
74
|
+
|
|
75
|
+
|d|4|0|0||
|
|
76
|
+
|
|
77
|
+
|
|
78
|
+
|
|
79
|
+
```ここに言語を入力
|
|
80
|
+
|
|
59
81
|
df_3 = df_3[df_3['col3'] == 0] # 条件を指定
|
|
82
|
+
|
|
83
|
+
```
|
|
84
|
+
|
|
85
|
+
|
|
86
|
+
|
|
87
|
+
```ここに言語を入力
|
|
60
88
|
|
|
61
89
|
df_3['col4'] = 99 # 値を更新
|
|
62
90
|
|
|
@@ -76,8 +104,6 @@
|
|
|
76
104
|
|
|
77
105
|
|b|2|0|99|xx|
|
|
78
106
|
|
|
79
|
-
|c|3|1|99|xx|
|
|
80
|
-
|
|
81
107
|
|d|4|0|99|xx|
|
|
82
108
|
|
|
83
109
|
|
2
誤字の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
|
|
3
3
|
|
|
4
4
|
|
|
5
|
-
|
|
5
|
+
下記のような２つのデータフレームを特定の条件で抽出し、
|
|
6
6
|
|
|
7
7
|
複数列の値を更新したいと考えています。
|
|
8
8
|
|
1
出力について追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -63,3 +63,23 @@
|
|
|
63
63
|
df_3['col5'] = 'xx' # 値を更新
|
|
64
64
|
|
|
65
65
|
```
|
|
66
|
+
|
|
67
|
+
|
|
68
|
+
|
|
69
|
+
df_3
|
|
70
|
+
|
|
71
|
+
|col1|col2|col3|col4|col5|
|
|
72
|
+
|
|
73
|
+
|:--|:--:|--:|
|
|
74
|
+
|
|
75
|
+
|a|1|0|99|xx|
|
|
76
|
+
|
|
77
|
+
|b|2|0|99|xx|
|
|
78
|
+
|
|
79
|
+
|c|3|1|99|xx|
|
|
80
|
+
|
|
81
|
+
|d|4|0|99|xx|
|
|
82
|
+
|
|
83
|
+
|
|
84
|
+
|
|
85
|
+
最終的に上記の結果をCSVファイルへ出力したいです。
|