回答編集履歴
1
Update
test
CHANGED
|
@@ -1,5 +1,6 @@
|
|
|
1
1
|
```python
|
|
2
2
|
import pandas as pd
|
|
3
|
+
import numpy as np
|
|
3
4
|
import io
|
|
4
5
|
|
|
5
6
|
csv_data = '''
|
|
@@ -9,15 +10,18 @@
|
|
|
9
10
|
'''
|
|
10
11
|
dataset = pd.read_csv(io.StringIO(csv_data), index_col=0)
|
|
11
12
|
|
|
12
|
-
df = dataset.apply(
|
|
13
|
+
df = dataset.apply(lambda x:
|
|
14
|
+
pd.Series(x.map({
|
|
13
|
-
'G': [2, 4, 6, 8, 10],
|
|
15
|
+
'G': [2, 4, 6, 8, 10],
|
|
14
|
-
'A': [3.2, 5.5, 7.6, 9.7, 11.1],
|
|
16
|
+
'A': [3.2, 5.5, 7.6, 9.7, 11.1],
|
|
15
|
-
}
|
|
17
|
+
}).sum()), axis=1)
|
|
16
18
|
|
|
17
|
-
|
|
19
|
+
df.to_csv('data.csv')
|
|
20
|
+
```
|
|
18
21
|
|
|
22
|
+
**data.csv**
|
|
19
|
-
|
|
23
|
+
```csv
|
|
20
|
-
|
|
24
|
+
,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19
|
|
21
|
-
1
|
|
25
|
+
1,2.0,4.0,6.0,8.0,10.0,2.0,4.0,6.0,8.0,10.0,2.0,4.0,6.0,8.0,10.0,2.0,4.0,6.0,8.0,10.0
|
|
22
|
-
2
|
|
26
|
+
2,2.0,4.0,6.0,8.0,10.0,2.0,4.0,6.0,8.0,10.0,3.2,5.5,7.6,9.7,11.1,3.2,5.5,7.6,9.7,11.1
|
|
23
27
|
```
|