커뮤니티

data manager 질문드려요

프로필 이미지
캣피쉬
2021-01-29 05:03:02
2393
글번호 216733
답변완료

첨부 이미지

날짜를 yyyy/mm/dd 로 바꾸니 인식은되는데, 잘 안들어가네요. 혹시몰라 소수점 2째자리로도 만들어봤는데 역시나 안되네요 ㅠㅠ 샘플 csv data 입니다. 감사합니다. 1900/01/00,9:00:18, 426.50 ,-2.00 ,-0.50 ,0.00 ,-0.17 ,1.00 1900/01/00,9:00:21, 427.00 ,-1.25 ,-0.50 ,0.00 ,-0.63 ,0.75 1900/01/00,9:00:24, 427.05 ,-1.00 ,-0.50 ,0.00 ,-0.60 ,1.70 1900/01/00,9:00:29, 427.15 ,-1.00 ,-0.25 ,0.00 ,-0.42 ,0.75 1900/01/00,9:00:30, 426.95 ,-1.00 ,-0.40 ,0.00 ,-0.43 ,0.07 1900/01/00,9:00:33, 427.40 ,-1.00 ,-0.25 ,0.00 ,-0.44 ,-0.06 1900/01/00,9:00:36, 427.35 ,-1.00 ,-0.14 ,0.00 ,-0.33 ,-0.39 1900/01/00,9:00:39, 427.60 ,-1.00 ,-0.19 ,0.00 ,-0.20 ,-0.30 1900/01/00,9:00:42, 427.45 ,-1.00 ,-0.11 ,0.00 ,-0.23 ,-0.41 1900/01/00,9:00:45, 427.55 ,-1.00 ,-0.05 ,-1.00 ,-0.25 ,-0.42 1900/01/00,9:00:48, 427.25 ,-0.86 ,0.05 ,-1.00 ,-0.19 ,-0.15 1900/01/00,9:00:51, 427.50 ,-0.88 ,0.08 ,-1.00 ,-0.21 ,0.11 1900/01/00,9:00:54, 427.45 ,-0.73 ,0.12 ,-1.00 ,-0.17 ,0.27 1900/01/00,9:00:57, 427.55 ,-0.64 ,0.18 ,-1.00 ,-0.13 ,0.25 1900/01/00,9:01:00, 427.50 ,-0.67 ,0.20 ,-1.00 ,-0.06 ,0.29 1900/01/00,9:01:03, 427.35 ,-0.69 ,0.22 ,-1.00 ,-0.08 ,0.14 1900/01/00,9:01:06, 427.35 ,-0.68 ,0.26 ,-1.00 ,-0.03 ,-0.03 1900/01/00,9:01:09, 427.05 ,-0.67 ,0.31 ,-1.00 ,0.00 ,-0.02 1900/01/00,9:01:13, 427.05 ,-0.66 ,0.34 ,-1.00 ,-0.02 ,-0.33 1900/01/00,9:01:15, 427.45 ,-0.68 ,0.35 ,-1.00 ,-0.05 ,-0.61 1900/01/00,9:01:30, 427.45 ,-0.62 ,0.43 ,-1.00 ,-0.02 ,-0.41 1900/01/00,9:01:42, 426.80 ,-0.64 ,0.39 ,-1.00 ,0.00 ,-0.40 1900/01/00,9:01:45, 426.65 ,-0.63 ,0.41 ,-1.33 ,-0.04 ,-0.28 1900/01/00,9:01:48, 426.70 ,-0.65 ,0.38 ,-1.33 ,-0.02 ,-0.29 1900/01/00,9:01:51, 426.70 ,-0.66 ,0.38 ,-1.33 ,-0.04 ,-0.24 1900/01/00,9:01:54, 426.85 ,-0.65 ,0.40 ,-1.33 ,-0.05 ,-0.23 1900/01/00,9:01:57, 426.55 ,-0.65 ,0.43 ,-1.33 ,-0.07 ,-0.19 1900/01/00,9:02:00, 426.65 ,-0.61 ,0.39 ,-1.33 ,-0.08 ,-0.17 1900/01/00,9:02:03, 426.40 ,-0.62 ,0.40 ,-1.33 ,-0.10 ,-0.26 1900/01/00,9:02:06, 426.75 ,-0.62 ,0.40 ,-1.33 ,-0.13 ,-0.33
예스트레이더 (iM증권)
답변 1
프로필 이미지

예스스탁 예스스탁 답변

2021-01-29 17:15:57

안녕하세요? 예스스탁입니다. 날짜 지정형식이 잘못되어서 오류가 나오고 있습니다. 날짜가 1900/01/00 으로 되어있는데, 2000/01/01로 모두 변환하시고 처리하시면 됩니다. 감사합니다. > 캣피쉬 님이 쓴 글입니다. > 제목 : data manager 질문드려요 > 날짜를 yyyy/mm/dd 로 바꾸니 인식은되는데, 잘 안들어가네요. 혹시몰라 소수점 2째자리로도 만들어봤는데 역시나 안되네요 ㅠㅠ 샘플 csv data 입니다. 감사합니다. 1900/01/00,9:00:18, 426.50 ,-2.00 ,-0.50 ,0.00 ,-0.17 ,1.00 1900/01/00,9:00:21, 427.00 ,-1.25 ,-0.50 ,0.00 ,-0.63 ,0.75 1900/01/00,9:00:24, 427.05 ,-1.00 ,-0.50 ,0.00 ,-0.60 ,1.70 1900/01/00,9:00:29, 427.15 ,-1.00 ,-0.25 ,0.00 ,-0.42 ,0.75 1900/01/00,9:00:30, 426.95 ,-1.00 ,-0.40 ,0.00 ,-0.43 ,0.07 1900/01/00,9:00:33, 427.40 ,-1.00 ,-0.25 ,0.00 ,-0.44 ,-0.06 1900/01/00,9:00:36, 427.35 ,-1.00 ,-0.14 ,0.00 ,-0.33 ,-0.39 1900/01/00,9:00:39, 427.60 ,-1.00 ,-0.19 ,0.00 ,-0.20 ,-0.30 1900/01/00,9:00:42, 427.45 ,-1.00 ,-0.11 ,0.00 ,-0.23 ,-0.41 1900/01/00,9:00:45, 427.55 ,-1.00 ,-0.05 ,-1.00 ,-0.25 ,-0.42 1900/01/00,9:00:48, 427.25 ,-0.86 ,0.05 ,-1.00 ,-0.19 ,-0.15 1900/01/00,9:00:51, 427.50 ,-0.88 ,0.08 ,-1.00 ,-0.21 ,0.11 1900/01/00,9:00:54, 427.45 ,-0.73 ,0.12 ,-1.00 ,-0.17 ,0.27 1900/01/00,9:00:57, 427.55 ,-0.64 ,0.18 ,-1.00 ,-0.13 ,0.25 1900/01/00,9:01:00, 427.50 ,-0.67 ,0.20 ,-1.00 ,-0.06 ,0.29 1900/01/00,9:01:03, 427.35 ,-0.69 ,0.22 ,-1.00 ,-0.08 ,0.14 1900/01/00,9:01:06, 427.35 ,-0.68 ,0.26 ,-1.00 ,-0.03 ,-0.03 1900/01/00,9:01:09, 427.05 ,-0.67 ,0.31 ,-1.00 ,0.00 ,-0.02 1900/01/00,9:01:13, 427.05 ,-0.66 ,0.34 ,-1.00 ,-0.02 ,-0.33 1900/01/00,9:01:15, 427.45 ,-0.68 ,0.35 ,-1.00 ,-0.05 ,-0.61 1900/01/00,9:01:30, 427.45 ,-0.62 ,0.43 ,-1.00 ,-0.02 ,-0.41 1900/01/00,9:01:42, 426.80 ,-0.64 ,0.39 ,-1.00 ,0.00 ,-0.40 1900/01/00,9:01:45, 426.65 ,-0.63 ,0.41 ,-1.33 ,-0.04 ,-0.28 1900/01/00,9:01:48, 426.70 ,-0.65 ,0.38 ,-1.33 ,-0.02 ,-0.29 1900/01/00,9:01:51, 426.70 ,-0.66 ,0.38 ,-1.33 ,-0.04 ,-0.24 1900/01/00,9:01:54, 426.85 ,-0.65 ,0.40 ,-1.33 ,-0.05 ,-0.23 1900/01/00,9:01:57, 426.55 ,-0.65 ,0.43 ,-1.33 ,-0.07 ,-0.19 1900/01/00,9:02:00, 426.65 ,-0.61 ,0.39 ,-1.33 ,-0.08 ,-0.17 1900/01/00,9:02:03, 426.40 ,-0.62 ,0.40 ,-1.33 ,-0.10 ,-0.26 1900/01/00,9:02:06, 426.75 ,-0.62 ,0.40 ,-1.33 ,-0.13 ,-0.33