質問編集履歴
2
カラム名書き忘れたので追記…
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -66,7 +66,7 @@
|
|
|
66
66
|
|
|
67
67
|
↓元データ
|
|
68
68
|
|
|
69
|
-
|
|
69
|
+
index close_time open_price high_price low_price close_price volume
|
|
70
70
|
|
|
71
71
|
1,1556746080,590047,590047,589758,589758,0.141
|
|
72
72
|
|
|
@@ -90,7 +90,9 @@
|
|
|
90
90
|
|
|
91
91
|
↓こうしたい
|
|
92
92
|
|
|
93
|
+
index close_time open_price high_price low_price close_price volume
|
|
93
94
|
|
|
95
|
+
close_dt
|
|
94
96
|
|
|
95
97
|
2019-05-02 06:29:00 2.0 1.556746e+09 589604.0 589985.0 589604.0 589981.0 1.128050
|
|
96
98
|
|
1
元データと目標とする値を追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -57,3 +57,55 @@
|
|
|
57
57
|
データは全部で40万行ほどあり、欠損している範囲もバラバラです。
|
|
58
58
|
|
|
59
59
|
どなたか知恵をお貸しください、よろしくお願い致します…
|
|
60
|
+
|
|
61
|
+
|
|
62
|
+
|
|
63
|
+
以下追記です。
|
|
64
|
+
|
|
65
|
+
|
|
66
|
+
|
|
67
|
+
↓元データ
|
|
68
|
+
|
|
69
|
+
|
|
70
|
+
|
|
71
|
+
1,1556746080,590047,590047,589758,589758,0.141
|
|
72
|
+
|
|
73
|
+
2,1556746140,589604,589985,589604,589981,1.12805
|
|
74
|
+
|
|
75
|
+
3,1556746200,589977,589977,589309,589962,1.765
|
|
76
|
+
|
|
77
|
+
5,1556746320,589343,589932,589318,589917,1.254
|
|
78
|
+
|
|
79
|
+
6,1556746380,589899,589899,589400,589859,1.011
|
|
80
|
+
|
|
81
|
+
7,1556746440,589844,589844,589407,589834,0.489
|
|
82
|
+
|
|
83
|
+
8,1556746500,589818,589820,589303,589811,2.77141
|
|
84
|
+
|
|
85
|
+
9,1556746560,589799,589800,589778,589779,0.744002
|
|
86
|
+
|
|
87
|
+
10,1556746620,589778,589783,589307,589780,1.93781
|
|
88
|
+
|
|
89
|
+
|
|
90
|
+
|
|
91
|
+
↓こうしたい
|
|
92
|
+
|
|
93
|
+
|
|
94
|
+
|
|
95
|
+
2019-05-02 06:29:00 2.0 1.556746e+09 589604.0 589985.0 589604.0 589981.0 1.128050
|
|
96
|
+
|
|
97
|
+
2019-05-02 06:30:00 3.0 1.556746e+09 589977.0 589977.0 589309.0 589962.0 1.765000
|
|
98
|
+
|
|
99
|
+
2019-05-02 06:31:00 NaN NaN NaN NaN NaN NaN NaN
|
|
100
|
+
|
|
101
|
+
2019-05-02 06:32:00 5.0 1.556746e+09 589343.0 589932.0 589318.0 589917.0 1.254000
|
|
102
|
+
|
|
103
|
+
2019-05-02 06:33:00 6.0 1.556746e+09 589899.0 589899.0 589400.0 589859.0 1.011000
|
|
104
|
+
|
|
105
|
+
2019-05-02 06:34:00 7.0 1.556746e+09 589844.0 589844.0 589407.0 589834.0 0.489000
|
|
106
|
+
|
|
107
|
+
2019-05-02 06:35:00 8.0 1.556746e+09 589818.0 589820.0 589303.0 589811.0 2.771410
|
|
108
|
+
|
|
109
|
+
2019-05-02 06:36:00 9.0 1.556747e+09 589799.0 589800.0 589778.0 589779.0 0.744002
|
|
110
|
+
|
|
111
|
+
2019-05-02 06:37:00 10.0 1.556747e+09 589778.0 589783.0 589307.0 589780.0 1.937810
|