回答編集履歴
4
d
answer
CHANGED
|
@@ -1,5 +1,7 @@
|
|
|
1
1
|
`"得意先.str.lower() == '会社名'.lower()"` でできると思います。
|
|
2
2
|
|
|
3
|
+
query() するときに両方とも小文字にして比較
|
|
4
|
+
|
|
3
5
|
```python
|
|
4
6
|
import pandas as pd
|
|
5
7
|
|
3
d
answer
CHANGED
|
@@ -1,8 +1,8 @@
|
|
|
1
|
-
`"得意先.str.lower() == '
|
|
1
|
+
`"得意先.str.lower() == '会社名'.lower()"` でできると思います。
|
|
2
2
|
|
|
3
3
|
```python
|
|
4
4
|
import pandas as pd
|
|
5
5
|
|
|
6
6
|
df = pd.DataFrame({"得意先": ["ABC mart", "abc mart", "abc Mart"]})
|
|
7
|
-
df.query("得意先.str.lower() == 'abc mart'")
|
|
7
|
+
df2 = df.query("得意先.str.lower() == 'abc mart'.lower()")
|
|
8
8
|
```
|
2
d
answer
CHANGED
|
@@ -4,5 +4,5 @@
|
|
|
4
4
|
import pandas as pd
|
|
5
5
|
|
|
6
6
|
df = pd.DataFrame({"得意先": ["ABC mart", "abc mart", "abc Mart"]})
|
|
7
|
-
|
|
7
|
+
df.query("得意先.str.lower() == 'abc mart'")
|
|
8
8
|
```
|
1
d
answer
CHANGED
|
@@ -3,6 +3,6 @@
|
|
|
3
3
|
```python
|
|
4
4
|
import pandas as pd
|
|
5
5
|
|
|
6
|
-
df = pd.DataFrame({"
|
|
6
|
+
df = pd.DataFrame({"得意先": ["ABC mart", "abc mart", "abc Mart"]})
|
|
7
|
-
df.query("
|
|
7
|
+
print(df.query("得意先.str.lower() == 'abc mart'").to_markdown())
|
|
8
8
|
```
|