커뮤니티
data manager 질문드려요
2021-01-29 05:03:02
2393
글번호 216733
첨부 이미지
그림1
그림2
날짜를 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
- 1. 캡처_2021_01_29_04_51_31_195.png (0.02 MB)
- 2. 캡처_2021_01_29_04_51_48_662.png (0.02 MB)
답변 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
다음글
이전글