回答編集履歴
4
d
answer
CHANGED
|
@@ -48,4 +48,37 @@
|
|
|
48
48
|
|あ|111|222|333|
|
|
49
49
|
|え|111|222|333|
|
|
50
50
|
|き|111|222|333|
|
|
51
|
-
|こ|111|222|333|
|
|
51
|
+
|こ|111|222|333|
|
|
52
|
+
|
|
53
|
+
data.csv
|
|
54
|
+
```csv
|
|
55
|
+
品物,A,B,C
|
|
56
|
+
あ,111,222,333
|
|
57
|
+
い,111,222,333
|
|
58
|
+
う,111,222,333
|
|
59
|
+
え,111,222,333
|
|
60
|
+
お,111,222,333
|
|
61
|
+
か,111,222,333
|
|
62
|
+
き,111,222,333
|
|
63
|
+
く,111,222,333
|
|
64
|
+
け,111,222,333
|
|
65
|
+
こ,111,222,333
|
|
66
|
+
さ,111,222,333
|
|
67
|
+
し,111,222,333
|
|
68
|
+
```
|
|
69
|
+
|
|
70
|
+
hoge.csv
|
|
71
|
+
|
|
72
|
+
```csv
|
|
73
|
+
Z
|
|
74
|
+
111
|
|
75
|
+
222
|
|
76
|
+
333
|
|
77
|
+
111
|
|
78
|
+
222
|
|
79
|
+
333
|
|
80
|
+
111
|
|
81
|
+
222
|
|
82
|
+
333
|
|
83
|
+
111
|
|
84
|
+
```
|
3
d
answer
CHANGED
|
@@ -45,7 +45,7 @@
|
|
|
45
45
|
|
|
46
46
|
|品物|A|B|C|
|
|
47
47
|
|:--|:--:|--:|--:|
|
|
48
|
-
|
|
|
48
|
+
|あ|111|222|333|
|
|
49
|
-
|
|
|
49
|
+
|え|111|222|333|
|
|
50
|
-
|
|
|
50
|
+
|き|111|222|333|
|
|
51
|
-
|
|
|
51
|
+
|こ|111|222|333|
|
2
dd
answer
CHANGED
|
@@ -27,4 +27,25 @@
|
|
|
27
27
|
# 出力
|
|
28
28
|
filtered = lst[(lst % 2 == 0) & (lst % 3 == 0) & (lst > 10)]
|
|
29
29
|
print(filtered) # [12, 18, 24]
|
|
30
|
-
```
|
|
30
|
+
```
|
|
31
|
+
|
|
32
|
+
## 追記
|
|
33
|
+
|
|
34
|
+
追記の例ですと、pandas の機能を使えばよいと思います。
|
|
35
|
+
|
|
36
|
+
```python
|
|
37
|
+
import pandas as pd
|
|
38
|
+
|
|
39
|
+
data = pd.read_csv('data.csv')
|
|
40
|
+
comp = pd.read_csv('hoge.csv')
|
|
41
|
+
|
|
42
|
+
# data.csv の A 列が hoge.csv の Z 列と一致するもののみ抽出
|
|
43
|
+
data[data['A'] == comp['Z']]
|
|
44
|
+
```
|
|
45
|
+
|
|
46
|
+
|品物|A|B|C|
|
|
47
|
+
|:--|:--:|--:|--:|
|
|
48
|
+
|0|あ|111|222|333|
|
|
49
|
+
|3|え|111|222|333|
|
|
50
|
+
|6|き|111|222|333|
|
|
51
|
+
|9|こ|111|222|333|
|
1
dd
answer
CHANGED
|
@@ -26,5 +26,5 @@
|
|
|
26
26
|
|
|
27
27
|
# 出力
|
|
28
28
|
filtered = lst[(lst % 2 == 0) & (lst % 3 == 0) & (lst > 10)]
|
|
29
|
-
print(filtered)
|
|
29
|
+
print(filtered) # [12, 18, 24]
|
|
30
30
|
```
|