create account

cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python) by minari

View this thread on: hive.blogpeakd.comecency.com
· @minari · (edited)
$6.37
cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)
cryptocompare의 API를 통해 국내 거래소 데이터를 수신할 경우, 서버 오류로 인해 발생한 것으로 추정되는 피크 데이터가 그대로 남아있어 데이터 분석에 방해가 됩니다.
When the Korean exchange data is received through the API of cryptocompare, the peak data presumably caused by the server error is left intact and interferes with the data analysis.

그래서 최소한의 노력을 들여 간단히 특이값을 제거해 보기로 합니다.
So I will try to remove the singular value simply by minimizing the effort.

먼저 XRP의 1시간 단위 데이터를 받습니다.
First, it receives XRP 1-hour data.
![coins_-_2017-06-28_14.55.45.png](https://steemitimages.com/DQmQoP25zF8yGFEir6qu4D5nCAs1bFcpNedmeBiJncfN2hv/coins_-_2017-06-28_14.55.45.png)

아래와 같은 형태로 데이터를 수신하였습니다.
The data was received in the following form.
![coins_-_2017-06-28_14.55.57.png](https://steemitimages.com/DQmbDfRfJNi6hJkwJs1AxNocpegav4K2NGB1KUJngvtDBy3/coins_-_2017-06-28_14.55.57.png)

차트를 그려보니 역시 특이값이 존재하는 것을 확인할 수 있습니다.
I tried drawing the chart, I can see that there is a singular value.
![coins_-_2017-06-28_14.56.46.png](https://steemitimages.com/DQmfNuuwTMoijN825ScyDeNL34SowB7KkMMLRimWv2FTvAA/coins_-_2017-06-28_14.56.46.png)

최소한의 노력으로  최대한의 효과를 보고자 특이값이 종가의 두배가 되는 경우에 그냥 종가로 치환하기로 합니다. 절대 귀찮니즘이 아나라 경제효용적 관점에서의 결정입니다. :)
To get the maximum effect with minimal effort, if the specific value is twice the closing price, it will be replaced with the closing price.
![coins_-_2017-06-28_15.04.34.png](https://steemitimages.com/DQmeRsnnvvmDnQwYYJvfSbwbKeTfPcbEgbtAVQC4dkfyJib/coins_-_2017-06-28_15.04.34.png)

다시 차트를 그려보면 이쁘게 보이는 것을 확인할 수 있습니다.
I tried drawing the chart again. It is confirmed that it looks beautiful.
![coins_-_2017-06-28_14.57.04.png](https://steemitimages.com/DQmb9w41ixEx6z6JWphJfbkbRFavcxs9TtZGrk6V62Lh1jT/coins_-_2017-06-28_14.57.04.png)

파이썬이라는 언어는 정말 간편하군요. 
The language Python is really simple.

문의사항은 코멘트 달아주세요.
Any questions, comment please.
👍  , , , , , , , , , , , ,
properties (23)
authorminari
permlinkcryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python
categorykr
json_metadata{"tags":["kr","kr-newbie","coinkorea","kr-dev","python"],"image":["https://steemitimages.com/DQmQoP25zF8yGFEir6qu4D5nCAs1bFcpNedmeBiJncfN2hv/coins_-_2017-06-28_14.55.45.png","https://steemitimages.com/DQmbDfRfJNi6hJkwJs1AxNocpegav4K2NGB1KUJngvtDBy3/coins_-_2017-06-28_14.55.57.png","https://steemitimages.com/DQmfNuuwTMoijN825ScyDeNL34SowB7KkMMLRimWv2FTvAA/coins_-_2017-06-28_14.56.46.png","https://steemitimages.com/DQmeRsnnvvmDnQwYYJvfSbwbKeTfPcbEgbtAVQC4dkfyJib/coins_-_2017-06-28_15.04.34.png","https://steemitimages.com/DQmb9w41ixEx6z6JWphJfbkbRFavcxs9TtZGrk6V62Lh1jT/coins_-_2017-06-28_14.57.04.png"],"app":"steemit/0.1","format":"markdown"}
created2017-06-28 06:17:00
last_update2017-07-04 13:30:03
depth0
children9
last_payout2017-07-05 06:17:00
cashout_time1969-12-31 23:59:59
total_payout_value4.846 HBD
curator_payout_value1.519 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,806
author_reputation18,256,774,154,134
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,438,582
net_rshares736,462,579,299
author_curate_reward""
vote details (13)
@coinkorea ·
개발 관련태그로 #kr-dev 를 추가해주시면 더 많은 분들이 보실 수 있을것 같습니다 :)
properties (22)
authorcoinkorea
permlinkre-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t083245916z
categorykr
json_metadata{"tags":["kr-dev","kr"],"app":"steemit/0.1"}
created2017-06-28 08:32:45
last_update2017-06-28 08:32:45
depth1
children1
last_payout2017-07-05 08:32:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length51
author_reputation34,890,178,701,093
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,449,278
net_rshares0
@minari ·
아, 이런 태그도 있었네요, 감사합니다.
properties (22)
authorminari
permlinkre-coinkorea-re-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t112032849z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 11:20:21
last_update2017-06-28 11:20:21
depth2
children0
last_payout2017-07-05 11:20:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length22
author_reputation18,256,774,154,134
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,464,057
net_rshares0
@dyuryul · (edited)
이런 분야에는 문외해 알아듣지 못하겠네요 혹시 이거에 대한 기초적인부분을 볼수있는 블로거가 있을까요? 좋은 정보임은 확신합니다
properties (22)
authordyuryul
permlinkre-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t074952192z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 07:49:51
last_update2017-06-28 10:57:00
depth1
children4
last_payout2017-07-05 07:49:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length70
author_reputation9,322,456,020,735
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,445,974
net_rshares0
@minari ·
네, 오후에 졸다가 만들었습니다. 어떻게 아셨는지 신기....ㅎㅎ
properties (22)
authorminari
permlinkre-dyuryul-re-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t105526198z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 10:55:27
last_update2017-06-28 10:55:27
depth2
children1
last_payout2017-07-05 10:55:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length36
author_reputation18,256,774,154,134
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,461,830
net_rshares0
@dyuryul ·
아......좋은 좋은 좋은 정보입니다. 다행입니다 졸으셔서ㅎㅎ 제가 맞는말 한겁니다!
properties (22)
authordyuryul
permlinkre-minari-re-dyuryul-re-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t105753301z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 10:57:51
last_update2017-06-28 10:57:51
depth3
children0
last_payout2017-07-05 10:57:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length48
author_reputation9,322,456,020,735
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,462,029
net_rshares0
@minari ·
아, 그리고 '데이터분석 python' 이렇게 구글에서 검색하시면 훨씬 좋은 자료가 많이 나옵니다.
properties (22)
authorminari
permlinkre-dyuryul-re-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t105716860z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 10:57:18
last_update2017-06-28 10:57:18
depth2
children1
last_payout2017-07-05 10:57:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length55
author_reputation18,256,774,154,134
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,461,984
net_rshares0
@dyuryul ·
감사합니다. 제가요즘 공부를 해야하나 싶어 고민 중에 있어서요!
자문구하겠습니다. 꾸벅꾸벅
properties (22)
authordyuryul
permlinkre-minari-re-dyuryul-re-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t105842161z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 10:58:42
last_update2017-06-28 10:58:42
depth3
children0
last_payout2017-07-05 10:58:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length50
author_reputation9,322,456,020,735
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,462,103
net_rshares0
@rudxor8 ·
음... 사진이 안보이는 것 같아요! 저만 안보인는 건가...
properties (22)
authorrudxor8
permlinkre-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t075652673z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 07:56:51
last_update2017-06-28 07:56:51
depth1
children1
last_payout2017-07-05 07:56:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length34
author_reputation5,836,272,699,954
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,446,512
net_rshares0
@minari ·
이미지 주소들이 스팀잇으로 나오는데 저도 잘 모르겠네요.
properties (22)
authorminari
permlinkre-rudxor8-re-minari-cryptocompare-tips-for-correcting-chart-data-from-cryptocompare-by-python-20170628t112108505z
categorykr
json_metadata{"tags":["kr"],"app":"steemit/0.1"}
created2017-06-28 11:20:51
last_update2017-06-28 11:20:51
depth2
children0
last_payout2017-07-05 11:20:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length31
author_reputation18,256,774,154,134
root_title"cryptocompare 차트 데이터 보정 팁 (Tips for correcting chart data from cryptocompare by python)"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id6,464,102
net_rshares0