質問編集履歴
6
誤字
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
データを取り出し
|
1
|
+
データを取り出しグラフ化
|
test
CHANGED
File without changes
|
5
議事
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,15 +1,14 @@
|
|
1
1
|
|
2
|
-
Pythonで
|
2
|
+
Pythonでグラフを描くプログラムを作っています。
|
3
3
|
実装中に以下のエラーメッセージが発生しました。
|
4
4
|
|
5
5
|
### 実現したいこと
|
6
|
-
CSVファイルから欲しいデータ(数値)を取り出し、データから散布図、回帰曲線を表示させる。
|
7
|
-
できれば、取り出したデータから計算し
|
6
|
+
できれば、取り出したデータから計算しグラフ化して表示させたい。
|
8
7
|
便利な方法があれば知りたい。
|
9
8
|
|
10
9
|
### 発生している問題・エラーメッセージ
|
11
|
-
|
10
|
+
欲しいデータを取り出せない
|
12
|
-
データから
|
11
|
+
データからグラフ化を表示させる方法が分からない
|
13
12
|
|
14
13
|
エラーメッセージ
|
15
14
|
"None of [Index(['ops'], dtype='object')] are in the [columns]"
|
@@ -18,30 +17,4 @@
|
|
18
17
|
|
19
18
|
python
|
20
19
|
|
21
|
-
ソースコード
|
22
20
|
|
23
|
-
import csv
|
24
|
-
import numpy as np
|
25
|
-
import matplotlib.pyplot as plt
|
26
|
-
from sklearn.linear_model import LinearRegression
|
27
|
-
|
28
|
-
df = pd.read_csv('data.csv')
|
29
|
-
|
30
|
-
x = df[['ops']]
|
31
|
-
y = df[['score']]
|
32
|
-
|
33
|
-
model = LinearRegression()
|
34
|
-
model.fit(x,y)
|
35
|
-
|
36
|
-
plt.plot(x,y,'o')
|
37
|
-
plt.plot(x,model.predict(x))
|
38
|
-
plt.show()
|
39
|
-
|
40
|
-
print('a = ', model.coef_)
|
41
|
-
print('b = ', model.intercept_)
|
42
|
-
|
43
|
-
### 試したこと
|
44
|
-
|
45
|
-
取り出したデータからさらに計算して散布図、回帰曲線を描きたい。
|
46
|
-
|
47
|
-
|
4
書式の変更
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
|
1
|
+
データを取り出し、散布図、回帰曲線を図示
|
test
CHANGED
File without changes
|
3
不必要
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
CSVファイルからデータを取り出し、
|
1
|
+
CSVファイルからデータを取り出し、散布図、回帰曲線を図示させたい
|
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
便利な方法があれば知りたい。
|
9
9
|
|
10
10
|
### 発生している問題・エラーメッセージ
|
11
|
-
CSVファイルから欲しいデータ
|
11
|
+
CSVファイルから欲しいデータを取り出せない
|
12
12
|
データから散布図、回帰曲線を表示させる方法が分からない
|
13
13
|
|
14
14
|
エラーメッセージ
|
@@ -44,6 +44,4 @@
|
|
44
44
|
|
45
45
|
取り出したデータからさらに計算して散布図、回帰曲線を描きたい。
|
46
46
|
|
47
|
-
### 補足
|
48
|
-
CSVファイル
|
49
47
|
|
2
不必要
test
CHANGED
File without changes
|
test
CHANGED
@@ -46,4 +46,4 @@
|
|
46
46
|
|
47
47
|
### 補足
|
48
48
|
CSVファイル
|
49
|
-
|
49
|
+
|
1
補足の補足
test
CHANGED
File without changes
|
test
CHANGED
@@ -45,24 +45,5 @@
|
|
45
45
|
取り出したデータからさらに計算して散布図、回帰曲線を描きたい。
|
46
46
|
|
47
47
|
### 補足
|
48
|
-
CSVファイル
|
48
|
+
CSVファイル
|
49
|
-
打,打,本,安,単,2,3,出,長,O,得,得,得,試,打,打,得,四,死,企,盗,盗,企,犠,犠,犠
|
50
|
-
率,点,塁,打,打,塁,塁,塁,打,P,点,点,点,合,席,数,点,球,球,盗,塁,塁,犠,打,打,飛
|
51
|
-
,,打,数,,打,打,率,率,S,圏,圏,圏,数,数,,,,,塁,,成,打,,成,
|
52
|
-
,,,,,,,,,,打,安,打,,,,,,,,,功,,,功,
|
53
|
-
,,,,,,,,,,数,打,率,,,,,,,,,率,,,率,
|
54
|
-
0.25,606,174,"1,209",805,210,20,0.318,0.41,0.728,"1,140",288,0.253,143,"5,446","4,834",619,476,55,103,69,0.67,108,86,0.796,29
|
55
|
-
0.251,477,117,"1,190",833,228,12,0.308,0.378,0.686,"1,057",256,0.242,143,"5,275","4,746",497,381,54,88,49,0.557,125,102,0.816,22
|
56
|
-
0.243,462,84,"1,160",903,152,21,0.301,0.337,0.638,"1,100",265,0.241,143,"5,323","4,767",489,379,47,145,110,0.759,144,119,0.826,32
|
57
|
-
0.242,533,163,"1,161",785,199,14,0.309,0.392,0.701,"1,050",256,0.244,143,"5,341","4,788",548,454,36,95,64,0.674,94,73,0.777,15
|
58
|
-
0.257,524,91,"1,248",932,200,25,0.309,0.364,0.673,"1,141",329,0.288,143,"5,394","4,865",552,347,53,53,26,0.491,144,118,0.819,31
|
59
|
-
0.247,397,62,"1,172",875,208,27,0.301,0.341,0.642,"1,102",261,0.237,143,"5,284","4,750",414,344,57,87,66,0.759,143,123,0.86,30
|
60
|
-
0.246,466,89,"1,164",829,220,26,0.317,0.361,0.678,"1,153",293,0.254,143,"5,379","4,723",490,451,80,101,62,0.614,134,114,0.851,35
|
61
|
-
0.255,529,108,"1,218",887,189,34,0.32,0.377,0.697,"1,175",312,0.266,143,"5,384","4,772",555,430,51,129,86,0.667,138,110,0.797,31
|
62
|
-
0.229,441,118,"1,062",728,191,25,0.298,0.358,0.655,"1,011",230,0.227,143,"5,201","4,633",464,445,37,95,60,0.632,102,78,0.765,27
|
63
|
-
0.243,511,101,"1,150",841,179,29,0.325,0.357,0.682,"1,194",305,0.255,143,"5,458","4,738",533,548,60,138,97,0.703,117,95,0.812,30
|
64
|
-
0.231,474,97,"1,075",767,196,15,0.303,0.342,0.645,"1,093",265,0.242,143,"5,300","4,655",501,444,69,169,132,0.781,119,94,0.79,47
|
65
|
-
0.234,441,100,"1,091",751,214,26,0.292,0.356,0.647,"1,027",263,0.256,143,"5,177","4,661",463,370,39,159,95,0.597,116,98,0.845,27
|
66
|
-
0.254,603,142,"1,196",823,214,17,0.333,0.397,0.731,"1,202",313,0.26,143,"5,399","4,708",625,535,61,100,70,0.7,116,90,0.776,27
|
67
|
-
|
49
|
+
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2023-01-27/e2618a29-4108-46d4-9740-178178822ee8.png)
|
68
|
-
0.242,532,169,"1,137",750,207,11,0.31,0.399,0.709,"1,036",245,0.236,143,"5,241","4,692",552,453,43,102,65,0.637,63,48,0.762,27
|