回答編集履歴
4
修正
test
CHANGED
|
@@ -12,11 +12,13 @@
|
|
|
12
12
|
csvreader = csv.reader(f)
|
|
13
13
|
|
|
14
14
|
for row in csvreader:
|
|
15
|
+
row_0_value = float(row[0].replace(",", ""))
|
|
16
|
+
row_1_value = float(row[1].replace(",", ""))
|
|
15
|
-
row_0.append(row
|
|
17
|
+
row_0.append(row_0_value)
|
|
16
|
-
row_1.append(row
|
|
18
|
+
row_1.append(row_1_value)
|
|
17
|
-
row_01_multi.append(row
|
|
19
|
+
row_01_multi.append(row_0_value*row_1_value)
|
|
18
|
-
row_0_square.append(row
|
|
20
|
+
row_0_square.append(row_0_value**2)
|
|
19
|
-
row_1_square.append(row
|
|
21
|
+
row_1_square.append(row_1_value**2)
|
|
20
22
|
print(row)
|
|
21
23
|
|
|
22
24
|
# ・row[0]の列の合計
|
3
ご質問者様の意図をくんだコードに変更
test
CHANGED
|
@@ -1,25 +1,32 @@
|
|
|
1
|
-
scikit-learnを使えば簡単に算出できますよ
|
|
2
|
-
https://scikit-learn.org/stable/modules/generated/sklearn.metrics.r2_score.html
|
|
3
|
-
|
|
4
|
-
以下でインストールできます
|
|
5
|
-
pip install scikit-learn
|
|
6
|
-
|
|
7
|
-
|
|
8
1
|
```python
|
|
9
2
|
import csv
|
|
10
|
-
from sklearn.metrics import r2_score
|
|
11
3
|
|
|
12
|
-
|
|
4
|
+
row_0 = []
|
|
13
|
-
|
|
5
|
+
row_1= []
|
|
6
|
+
row_01_multi = []
|
|
7
|
+
row_0_square = []
|
|
8
|
+
row_1_square = []
|
|
14
9
|
#データの読み込み
|
|
15
10
|
filename='test.csv'
|
|
16
11
|
with open(filename,'r',encoding='utf-8-sig')as f:
|
|
17
12
|
csvreader = csv.reader(f)
|
|
18
13
|
|
|
19
14
|
for row in csvreader:
|
|
20
|
-
|
|
15
|
+
row_0.append(row[0])
|
|
21
|
-
|
|
16
|
+
row_1.append(row[1])
|
|
17
|
+
row_01_multi.append(row[0]*row[1])
|
|
18
|
+
row_0_square.append(row[0]**2)
|
|
19
|
+
row_1_square.append(row[1]**2)
|
|
22
20
|
print(row)
|
|
23
21
|
|
|
22
|
+
# ・row[0]の列の合計
|
|
23
|
+
print(sum(row_0))
|
|
24
|
+
# ・row[1]の列の合計
|
|
25
|
+
print(sum(row_1))
|
|
26
|
+
# ・row[0]＊row[1]を計算し、その列の合計
|
|
27
|
+
print(sum(row_01_multi))
|
|
28
|
+
# ・row[0]^2を計算し、その列の合計
|
|
24
|
-
print(r
|
|
29
|
+
print(sum(row_0_square))
|
|
30
|
+
# ・row[1]^2を計算し、その列の合計
|
|
31
|
+
print(sum(row_1_square))
|
|
25
32
|
```
|
2
決定係数を出力するように修正
test
CHANGED
|
@@ -21,5 +21,5 @@
|
|
|
21
21
|
y_pred.append(row[1])
|
|
22
22
|
print(row)
|
|
23
23
|
|
|
24
|
-
r2_score(y_true, y_pred)
|
|
24
|
+
print(r2_score(y_true, y_pred))
|
|
25
25
|
```
|
1
修正
test
CHANGED
|
@@ -1,7 +1,25 @@
|
|
|
1
1
|
scikit-learnを使えば簡単に算出できますよ
|
|
2
2
|
https://scikit-learn.org/stable/modules/generated/sklearn.metrics.r2_score.html
|
|
3
3
|
|
|
4
|
+
以下でインストールできます
|
|
5
|
+
pip install scikit-learn
|
|
6
|
+
|
|
7
|
+
|
|
4
8
|
```python
|
|
9
|
+
import csv
|
|
5
10
|
from sklearn.metrics import r2_score
|
|
11
|
+
|
|
12
|
+
y_true = []
|
|
13
|
+
y_pred= []
|
|
14
|
+
#データの読み込み
|
|
15
|
+
filename='test.csv'
|
|
16
|
+
with open(filename,'r',encoding='utf-8-sig')as f:
|
|
17
|
+
csvreader = csv.reader(f)
|
|
18
|
+
|
|
19
|
+
for row in csvreader:
|
|
20
|
+
y_true.append(row[0])
|
|
21
|
+
y_pred.append(row[1])
|
|
22
|
+
print(row)
|
|
23
|
+
|
|
6
|
-
r2_score(r
|
|
24
|
+
r2_score(y_true, y_pred)
|
|
7
25
|
```
|