回答編集履歴
4
追記
answer
CHANGED
|
@@ -34,4 +34,4 @@
|
|
|
34
34
|
df = df.loc[:, ~df.columns.str.contains('^Unnamed')]
|
|
35
35
|
```
|
|
36
36
|
|
|
37
|
-
これで読めます。
|
|
37
|
+
これで読めます。ただし、方法は他にもあると思います。
|
3
追記
answer
CHANGED
|
@@ -23,4 +23,15 @@
|
|
|
23
23
|
Animal Country Food Book
|
|
24
24
|
2 Tiger UK Ramen The Setting Sun
|
|
25
25
|
"""
|
|
26
|
-
```
|
|
26
|
+
```
|
|
27
|
+
|
|
28
|
+
### 追記
|
|
29
|
+
フォーマットが違うようなので追記。
|
|
30
|
+
|
|
31
|
+
```python
|
|
32
|
+
with open('text.csv', 'r') as f:
|
|
33
|
+
df = pd.read_table(f, sep="|", header=1)
|
|
34
|
+
df = df.loc[:, ~df.columns.str.contains('^Unnamed')]
|
|
35
|
+
```
|
|
36
|
+
|
|
37
|
+
これで読めます。
|
2
修正
answer
CHANGED
|
@@ -4,7 +4,7 @@
|
|
|
4
4
|
|
|
5
5
|
今回の例で書くとこんな感じです。
|
|
6
6
|
|
|
7
|
-
**
|
|
7
|
+
**text.csv**
|
|
8
8
|
```plain
|
|
9
9
|
Animal,Country,Food,Book
|
|
10
10
|
cat,America,Hamburger,War and Peace
|
1
追記
answer
CHANGED
|
@@ -4,10 +4,23 @@
|
|
|
4
4
|
|
|
5
5
|
今回の例で書くとこんな感じです。
|
|
6
6
|
|
|
7
|
+
**test.csv**
|
|
8
|
+
```plain
|
|
9
|
+
Animal,Country,Food,Book
|
|
10
|
+
cat,America,Hamburger,War and Peace
|
|
11
|
+
dog,Japan,Sashimi,I Am A Cat
|
|
12
|
+
Tiger,UK,Ramen,The Setting Sun
|
|
13
|
+
```
|
|
14
|
+
|
|
7
15
|
```python
|
|
8
16
|
import pandas as pd
|
|
9
17
|
|
|
10
18
|
with open('text.csv', 'r') as f:
|
|
11
19
|
df = pd.read_csv(f, header=0)
|
|
12
|
-
print(df[df["Food"] == "Ramen"])
|
|
20
|
+
print(df[df["Food"] == "Ramen"])
|
|
21
|
+
|
|
22
|
+
""" =>
|
|
23
|
+
Animal Country Food Book
|
|
24
|
+
2 Tiger UK Ramen The Setting Sun
|
|
25
|
+
"""
|
|
13
26
|
```
|