質問編集履歴

コード変更

2022/11/09 07:28

投稿

mizumizumizu

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -5,7 +5,7 @@
 [LOGGING],RD81DL96_1,2,3,4
 DATETIME[YYYY/MM/DD hh:mm:ss.s],INDEX,BIT[1;0],BIT[1;0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],TRIGGER[*;-]
-TIME,INDEX,E/E,E/E_TEST,瞬時負荷_0.1% 搬出CV1,瞬時負荷_0.1% 搬出CV2,瞬時負荷_0.1% 搬出CV3,瞬時負荷_0.1% Q1Uﾀﾞﾝﾊﾟ,瞬時負荷_0.1% Q1Lﾀﾞﾝﾊﾟ,瞬時負荷_0.1% Q2Uﾀﾞﾝﾊﾟ,瞬時負荷_0.1% Q2Lﾀﾞﾝﾊﾟ,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% 仮想主軸,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U1,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U2,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U3,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U4,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U5,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U6,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U7,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U8,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U9,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U10,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U11,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U12,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U13,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U14,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L1,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L2,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L3,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L4,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L5,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L6,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L7,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L8,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L9,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L10,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L11,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L12,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L13,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L14,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% #1昇降,瞬時負荷_0.1% #2昇降,瞬時負荷_0.1% #3昇降,瞬時負荷_0.1% #4昇降,瞬時負荷_0.1% #5昇降,瞬時負荷_0.1% #6昇降,瞬時負荷_0.1% #7昇降,瞬時負荷_0.1% #8昇降,瞬時負荷_0.1% #9昇降,瞬時負荷_0.1% #10昇降,瞬時負荷_0.1% #11昇降,瞬時負荷_0.1% #12昇降,瞬時負荷_0.1% #13昇降,瞬時負荷_0.1% #14昇降,瞬時負荷_0.1% #15昇降,瞬時負荷_0.1% #16昇降,瞬時負荷_0.1% #19R昇降,瞬時負荷_0.1% #20R昇降,瞬時負荷_0.1% #21R昇降,瞬時負荷_0.1% #22R昇降,瞬時負荷_0.1% NR1R昇降,瞬時負荷_0.1% NR2R昇降,瞬時負荷_0.1% NR3R昇降,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #19L昇降,瞬時負荷_0.1% #20L昇降,瞬時負荷_0.1% #21L昇降,瞬時負荷_0.1% #22L昇降,瞬時負荷_0.1% NR1L昇降,瞬時負荷_0.1% NR2L昇降,瞬時負荷_0.1% NR3L昇降,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #17昇降,瞬時負荷_0.1% #18昇降,瞬時負荷_0.1% #23昇降,瞬時負荷_0.1% #24昇降,瞬時負荷_0.1% #25昇降,瞬時負荷_0.1% #26昇降,瞬時負荷_0.1% #27昇降,瞬時負荷_0.1% #28昇降,瞬時負荷_0.1% #29昇降,瞬時負荷_0.1% #30昇降,瞬時負荷_0.1% #31昇降,瞬時負荷_0.1% #32昇降,瞬時負荷_0.1% #33昇降,瞬時負荷_0.1% #34昇降,瞬時負荷_0.1% #35昇降,瞬時負荷_0.1% #36昇降,瞬時負荷_0.1% #37昇降,瞬時負荷_0.1% #38昇降,瞬時負荷_0.1% #39昇降,瞬時負荷_0.1% #40昇降,瞬時負荷_0.1% #41昇降,瞬時負荷_0.1% #42昇降,瞬時負荷_0.1% #43昇降,瞬時負荷_0.1% #44昇降,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% #1回転,瞬時負荷_0.1% #2回転,瞬時負荷_0.1% #3回転,瞬時負荷_0.1% #4回転,瞬時負荷_0.1% #5回転,瞬時負荷_0.1% #6回転,瞬時負荷_0.1% #7回転,瞬時負荷_0.1% #8回転,瞬時負荷_0.1% #9回転,瞬時負荷_0.1% #10回転,瞬時負荷_0.1% #11回転,瞬時負荷_0.1% #12回転,瞬時負荷_0.1% #13回転,瞬時負荷_0.1% #14回転,瞬時負荷_0.1% #15回転,瞬時負荷_0.1% #16回転,瞬時負荷_0.1% #19R回転,瞬時負荷_0.1% #20R回転,瞬時負荷_0.1% #21R回転,瞬時負荷_0.1% #22R回転,瞬時負荷_0.1% NR1R回転,瞬時負荷_0.1% NR2R回転,瞬時負荷_0.1% NR3R回転,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #19L回転,瞬時負荷_0.1% #20L回転,瞬時負荷_0.1% #21L回転,瞬時負荷_0.1% #22L回転,瞬時負荷_0.1% NR1L回転,瞬時負荷_0.1% NR2L回転,瞬時負荷_0.1% NR3L回転,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #17回転,瞬時負荷_0.1% #18回転,瞬時負荷_0.1% #23回転,瞬時負荷_0.1% #24回転,瞬時負荷_0.1% #25回転,瞬時負荷_0.1% #26回転,瞬時負荷_0.1% #27回転,瞬時負荷_0.1% #28回転,瞬時負荷_0.1% #29回転,瞬時負荷_0.1% #30回転,瞬時負荷_0.1% #31回転,瞬時負荷_0.1% #32回転,瞬時負荷_0.1% #33回転,瞬時負荷_0.1% #34回転,瞬時負荷_0.1% #35回転,瞬時負荷_0.1% #36回転,瞬時負荷_0.1% #37回転,瞬時負荷_0.1% #38回転,瞬時負荷_0.1% #39回転,瞬時負荷_0.1% #40回転,瞬時負荷_0.1% #41回転,瞬時負荷_0.1% #42回転,瞬時負荷_0.1% #43回転,瞬時負荷_0.1% #44回転,瞬時負荷_0.1% #23湾曲R,瞬時負荷_0.1% #24湾曲R,瞬時負荷_0.1% #25湾曲R,瞬時負荷_0.1% #26湾曲R,瞬時負荷_0.1% #27湾曲R,瞬時負荷_0.1% #28湾曲R,瞬時負荷_0.1% #29湾曲R,瞬時負荷_0.1% #30湾曲R,瞬時負荷_0.1% #31湾曲R,瞬時負荷_0.1% #32湾曲R,瞬時負荷_0.1% #33湾曲R,瞬時負荷_0.1% #34湾曲R,瞬時負荷_0.1% #23湾曲L,瞬時負荷_0.1% #24湾曲L,瞬時負荷_0.1% #25湾曲L,瞬時負荷_0.1% #26湾曲L,瞬時負荷_0.1% #27湾曲L,瞬時負荷_0.1% #28湾曲L,瞬時負荷_0.1% #29湾曲L,瞬時負荷_0.1% #30湾曲L,瞬時負荷_0.1% #31湾曲L,瞬時負荷_0.1% #32湾曲L,瞬時負荷_0.1% #33湾曲L,瞬時負荷_0.1% #34湾曲L,Trigger
+TIME
 2022/10/20 10:46:13.8,1987,1,0,0,0,0,29,13,22,12,0,0,0,0,0,0,0,0,0,7,4,2,1,4,4,2,77,5,1,12,4,42,4,0,0,3,5,11,6,6,1,8,89,3,5,7,11,34,8,0,0,253,305,340,378,380,384,427,309,298,301,291,295,283,292,293,298,407,574,418,294,203,122,161,0,0,0,0,0,0,0,0,0,236,453,3,332,246,613,772,854,817,922,945,853,957,685,344,253,18,239,468,468,490,467,46,644,0,0,0,0,0,0,0,0,103,29,113,50,88,157,108,103,63,69,96,88,68,72,104,104,92,50,85,80,55,96,48,0,0,0,0,0,0,0,0,0,63,97,196,78,112,55,74,123,128,90,96,78,222,185,76,54,90,39,51,36,57,52,49,39,192,116,18,24,62,8,25,73,76,131,89,122,116,118,28,9,12,77,58,50,4,124,79,129,
 2022/10/20 10:46:13.9,1988,1,0,0,0,0,7,13,22,12,0,0,0,0,0,0,0,0,0,6,5,1,1,3,3,1,408,4,3,12,4,43,3,0,0,3,5,11,8,6,2,7,46,1,4,5,11,34,7,0,0,255,307,341,376,378,384,443,310,310,294,299,294,279,283,289,285,414,553,558,300,235,101,134,0,0,0,0,0,0,0,0,0,272,467,21,332,319,536,755,845,788,804,868,900,908,760,333,257,6,240,426,429,500,467,47,666,0,0,0,0,0,0,0,0,106,38,114,52,91,152,113,111,64,56,108,82,30,87,94,74,57,61,97,75,61,85,58,0,0,0,0,0,0,0,0,0,72,62,212,90,81,47,69,100,88,97,89,75,188,155,51,20,98,52,56,33,44,53,52,55,198,119,96,26,59,16,26,19,123,143,110,114,109,149,90,9,10,70,56,0,165,111,109,133,
 2022/10/20 10:46:14.0,1989,1,0,0,0,0,3,12,22,13,0,0,0,0,0,0,0,0,0,6,5,1,2,2,4,1,5,4,1,11,4,43,3,0,0,2,4,12,7,7,2,7,0,2,4,5,11,33,6,0,0,253,305,338,372,376,384,440,339,313,305,299,291,281,300,287,281,363,465,615,337,306,137,133,0,0,0,0,0,0,0,0,0,289,398,44,344,310,398,745,835,768,853,916,879,900,802,348,256,8,208,409,448,496,465,42,585,0,0,0,0,0,0,0,0,89,50,127,35,118,177,138,101,73,71,108,85,62,47,80,127,55,56,95,153,61,198,43,0,0,0,0,0,0,0,0,0,34,82,160,99,40,55,60,80,60,118,104,82,119,128,42,102,78,47,67,32,31,45,45,49,189,124,101,23,60,17,23,12,157,124,104,123,119,140,132,1,9,71,57,9,209,131,91,128,

Python 3.x Python

データソースが間違っていたので修正

2022/11/07 02:58

投稿

mizumizumizu

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -1,52 +1,31 @@
 ### 前提
-質問よろしくお願い致します。
 下記のことを行いたいのですが、コードでエラーが出てどのように修正すればよいか分からず教えて頂きたいです。
+各列にTIME(データ取得日時),測定値が格納されたCSVファイルを、1秒毎に平均化してCSVファイルに出力したい
+下記は使用するCSVデータで名称「test.csv」
-各列にTIME(データ取得日時),測定値A,B,C,D,E,F,Gが格納されたCSVファイルを、1秒毎に平均化してCSVファイルに出力したい
-TIME列には「西暦年/月/日　時/分/秒」のデータが格納されている
-本当は0.1秒刻みで取得しているデータであるが、ファイル内の数式表示欄には0.1秒の位が四捨五入された値が表示されている
-下記は使用するCSVデータで名称「test.csv」
-データ内のTIME列最上部の46:13.8は2022/10/20 10:46:13.8を示している（CSVファイルのセルには46:13.8と表示されているが、上部の数式表示欄には2022/10/20  10:46:14と表示されている。46:13.8の0.8秒が四捨五入されて表示されている）
-[LOGGING]	RD81DL96_1	2	3	4
-DATETIME[YYYY/MM/DD hh:mm:ss.s]	INDEX	BIT[1;0]	BIT[1;0]	SHORT[DEC.0]	SHORT[DEC.0]	SHORT[DEC.0]	SHORT[DEC.0]
-TIME　　  	A	B	C	D	E	F	G
-46:13.8	1987	1	0	0	0	0	29
-46:13.9	1988	1	0	0	0	0	7
-46:14.0	1989	1	0	0	0	0	3
-46:14.1	1990	1	0	0	0	0	4
-46:14.2	1991	1	0	0	0	0	1
-46:14.3	1992	1	0	0	0	0	3
-46:14.4	1993	1	0	0	0	0	26
-46:14.5	1994	1	0	0	0	0	29
-46:14.6	1995	1	0	0	0	0	2
-46:14.7	1996	1	0	0	0	0	2
-46:14.8	1997	1	0	0	0	0	3
-46:14.9	1998	1	0	0	0	0	6
-46:15.0	1999	1	0	0	0	0	9
-46:15.1	2000	1	0	0	0	0	9
-46:15.2	2001	1	0	0	0	0	6
+[LOGGING],RD81DL96_1,2,3,4
+DATETIME[YYYY/MM/DD hh:mm:ss.s],INDEX,BIT[1;0],BIT[1;0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],SHORT[DEC.0],TRIGGER[*;-]
+TIME,INDEX,E/E,E/E_TEST,瞬時負荷_0.1% 搬出CV1,瞬時負荷_0.1% 搬出CV2,瞬時負荷_0.1% 搬出CV3,瞬時負荷_0.1% Q1Uﾀﾞﾝﾊﾟ,瞬時負荷_0.1% Q1Lﾀﾞﾝﾊﾟ,瞬時負荷_0.1% Q2Uﾀﾞﾝﾊﾟ,瞬時負荷_0.1% Q2Lﾀﾞﾝﾊﾟ,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% 仮想主軸,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U1,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U2,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U3,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U4,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U5,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U6,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U7,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U8,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U9,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U10,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U11,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U12,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U13,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ U14,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L1,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L2,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L3,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L4,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L5,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L6,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L7,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L8,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L9,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L10,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L11,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L12,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L13,瞬時負荷_0.1% 分割ﾀﾞﾝﾊﾟ L14,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% #1昇降,瞬時負荷_0.1% #2昇降,瞬時負荷_0.1% #3昇降,瞬時負荷_0.1% #4昇降,瞬時負荷_0.1% #5昇降,瞬時負荷_0.1% #6昇降,瞬時負荷_0.1% #7昇降,瞬時負荷_0.1% #8昇降,瞬時負荷_0.1% #9昇降,瞬時負荷_0.1% #10昇降,瞬時負荷_0.1% #11昇降,瞬時負荷_0.1% #12昇降,瞬時負荷_0.1% #13昇降,瞬時負荷_0.1% #14昇降,瞬時負荷_0.1% #15昇降,瞬時負荷_0.1% #16昇降,瞬時負荷_0.1% #19R昇降,瞬時負荷_0.1% #20R昇降,瞬時負荷_0.1% #21R昇降,瞬時負荷_0.1% #22R昇降,瞬時負荷_0.1% NR1R昇降,瞬時負荷_0.1% NR2R昇降,瞬時負荷_0.1% NR3R昇降,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #19L昇降,瞬時負荷_0.1% #20L昇降,瞬時負荷_0.1% #21L昇降,瞬時負荷_0.1% #22L昇降,瞬時負荷_0.1% NR1L昇降,瞬時負荷_0.1% NR2L昇降,瞬時負荷_0.1% NR3L昇降,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #17昇降,瞬時負荷_0.1% #18昇降,瞬時負荷_0.1% #23昇降,瞬時負荷_0.1% #24昇降,瞬時負荷_0.1% #25昇降,瞬時負荷_0.1% #26昇降,瞬時負荷_0.1% #27昇降,瞬時負荷_0.1% #28昇降,瞬時負荷_0.1% #29昇降,瞬時負荷_0.1% #30昇降,瞬時負荷_0.1% #31昇降,瞬時負荷_0.1% #32昇降,瞬時負荷_0.1% #33昇降,瞬時負荷_0.1% #34昇降,瞬時負荷_0.1% #35昇降,瞬時負荷_0.1% #36昇降,瞬時負荷_0.1% #37昇降,瞬時負荷_0.1% #38昇降,瞬時負荷_0.1% #39昇降,瞬時負荷_0.1% #40昇降,瞬時負荷_0.1% #41昇降,瞬時負荷_0.1% #42昇降,瞬時負荷_0.1% #43昇降,瞬時負荷_0.1% #44昇降,瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% (空き),瞬時負荷_0.1% #1回転,瞬時負荷_0.1% #2回転,瞬時負荷_0.1% #3回転,瞬時負荷_0.1% #4回転,瞬時負荷_0.1% #5回転,瞬時負荷_0.1% #6回転,瞬時負荷_0.1% #7回転,瞬時負荷_0.1% #8回転,瞬時負荷_0.1% #9回転,瞬時負荷_0.1% #10回転,瞬時負荷_0.1% #11回転,瞬時負荷_0.1% #12回転,瞬時負荷_0.1% #13回転,瞬時負荷_0.1% #14回転,瞬時負荷_0.1% #15回転,瞬時負荷_0.1% #16回転,瞬時負荷_0.1% #19R回転,瞬時負荷_0.1% #20R回転,瞬時負荷_0.1% #21R回転,瞬時負荷_0.1% #22R回転,瞬時負荷_0.1% NR1R回転,瞬時負荷_0.1% NR2R回転,瞬時負荷_0.1% NR3R回転,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #19L回転,瞬時負荷_0.1% #20L回転,瞬時負荷_0.1% #21L回転,瞬時負荷_0.1% #22L回転,瞬時負荷_0.1% NR1L回転,瞬時負荷_0.1% NR2L回転,瞬時負荷_0.1% NR3L回転,瞬時負荷_0.1% (空き),瞬時負荷_0.1% #17回転,瞬時負荷_0.1% #18回転,瞬時負荷_0.1% #23回転,瞬時負荷_0.1% #24回転,瞬時負荷_0.1% #25回転,瞬時負荷_0.1% #26回転,瞬時負荷_0.1% #27回転,瞬時負荷_0.1% #28回転,瞬時負荷_0.1% #29回転,瞬時負荷_0.1% #30回転,瞬時負荷_0.1% #31回転,瞬時負荷_0.1% #32回転,瞬時負荷_0.1% #33回転,瞬時負荷_0.1% #34回転,瞬時負荷_0.1% #35回転,瞬時負荷_0.1% #36回転,瞬時負荷_0.1% #37回転,瞬時負荷_0.1% #38回転,瞬時負荷_0.1% #39回転,瞬時負荷_0.1% #40回転,瞬時負荷_0.1% #41回転,瞬時負荷_0.1% #42回転,瞬時負荷_0.1% #43回転,瞬時負荷_0.1% #44回転,瞬時負荷_0.1% #23湾曲R,瞬時負荷_0.1% #24湾曲R,瞬時負荷_0.1% #25湾曲R,瞬時負荷_0.1% #26湾曲R,瞬時負荷_0.1% #27湾曲R,瞬時負荷_0.1% #28湾曲R,瞬時負荷_0.1% #29湾曲R,瞬時負荷_0.1% #30湾曲R,瞬時負荷_0.1% #31湾曲R,瞬時負荷_0.1% #32湾曲R,瞬時負荷_0.1% #33湾曲R,瞬時負荷_0.1% #34湾曲R,瞬時負荷_0.1% #23湾曲L,瞬時負荷_0.1% #24湾曲L,瞬時負荷_0.1% #25湾曲L,瞬時負荷_0.1% #26湾曲L,瞬時負荷_0.1% #27湾曲L,瞬時負荷_0.1% #28湾曲L,瞬時負荷_0.1% #29湾曲L,瞬時負荷_0.1% #30湾曲L,瞬時負荷_0.1% #31湾曲L,瞬時負荷_0.1% #32湾曲L,瞬時負荷_0.1% #33湾曲L,瞬時負荷_0.1% #34湾曲L,Trigger
+2022/10/20 10:46:13.8,1987,1,0,0,0,0,29,13,22,12,0,0,0,0,0,0,0,0,0,7,4,2,1,4,4,2,77,5,1,12,4,42,4,0,0,3,5,11,6,6,1,8,89,3,5,7,11,34,8,0,0,253,305,340,378,380,384,427,309,298,301,291,295,283,292,293,298,407,574,418,294,203,122,161,0,0,0,0,0,0,0,0,0,236,453,3,332,246,613,772,854,817,922,945,853,957,685,344,253,18,239,468,468,490,467,46,644,0,0,0,0,0,0,0,0,103,29,113,50,88,157,108,103,63,69,96,88,68,72,104,104,92,50,85,80,55,96,48,0,0,0,0,0,0,0,0,0,63,97,196,78,112,55,74,123,128,90,96,78,222,185,76,54,90,39,51,36,57,52,49,39,192,116,18,24,62,8,25,73,76,131,89,122,116,118,28,9,12,77,58,50,4,124,79,129,
+2022/10/20 10:46:13.9,1988,1,0,0,0,0,7,13,22,12,0,0,0,0,0,0,0,0,0,6,5,1,1,3,3,1,408,4,3,12,4,43,3,0,0,3,5,11,8,6,2,7,46,1,4,5,11,34,7,0,0,255,307,341,376,378,384,443,310,310,294,299,294,279,283,289,285,414,553,558,300,235,101,134,0,0,0,0,0,0,0,0,0,272,467,21,332,319,536,755,845,788,804,868,900,908,760,333,257,6,240,426,429,500,467,47,666,0,0,0,0,0,0,0,0,106,38,114,52,91,152,113,111,64,56,108,82,30,87,94,74,57,61,97,75,61,85,58,0,0,0,0,0,0,0,0,0,72,62,212,90,81,47,69,100,88,97,89,75,188,155,51,20,98,52,56,33,44,53,52,55,198,119,96,26,59,16,26,19,123,143,110,114,109,149,90,9,10,70,56,0,165,111,109,133,
+2022/10/20 10:46:14.0,1989,1,0,0,0,0,3,12,22,13,0,0,0,0,0,0,0,0,0,6,5,1,2,2,4,1,5,4,1,11,4,43,3,0,0,2,4,12,7,7,2,7,0,2,4,5,11,33,6,0,0,253,305,338,372,376,384,440,339,313,305,299,291,281,300,287,281,363,465,615,337,306,137,133,0,0,0,0,0,0,0,0,0,289,398,44,344,310,398,745,835,768,853,916,879,900,802,348,256,8,208,409,448,496,465,42,585,0,0,0,0,0,0,0,0,89,50,127,35,118,177,138,101,73,71,108,85,62,47,80,127,55,56,95,153,61,198,43,0,0,0,0,0,0,0,0,0,34,82,160,99,40,55,60,80,60,118,104,82,119,128,42,102,78,47,67,32,31,45,45,49,189,124,101,23,60,17,23,12,157,124,104,123,119,140,132,1,9,71,57,9,209,131,91,128,
+2022/10/20 10:46:14.1,1990,1,0,0,0,0,4,12,22,12,0,0,0,0,0,0,0,0,0,6,6,1,1,3,4,1,7,4,1,13,4,43,3,0,0,1,5,11,7,7,1,7,3,1,4,5,11,35,7,0,0,253,304,335,367,374,384,437,372,313,306,307,298,283,304,281,279,319,370,616,426,363,246,93,0,0,0,0,0,0,0,0,0,281,438,31,341,322,262,615,824,737,840,918,925,908,816,369,253,94,127,399,408,536,486,48,452,0,0,0,0,0,0,0,0,98,51,110,58,104,162,114,89,74,80,94,82,36,77,87,119,1,66,77,90,56,130,66,0,0,0,0,0,0,0,0,0,49,94,220,111,63,40,134,101,73,78,129,68,115,131,49,88,99,45,59,34,40,50,59,43,192,128,88,98,53,17,22,69,89,129,122,115,119,133,123,42,11,63,60,71,230,99,114,136,
+2022/10/20 10:46:14.2,1991,1,0,0,0,0,1,13,22,11,0,0,0,0,0,0,0,0,0,7,5,2,1,3,3,1,7,596,2,10,3,42,2,0,0,3,6,13,7,8,2,8,4,130,4,6,11,32,8,0,0,252,304,334,366,372,383,432,375,333,312,302,289,290,311,286,280,301,358,519,434,298,346,152,0,0,0,0,0,0,0,0,0,277,431,44,368,314,243,481,817,711,877,965,913,905,827,424,282,90,120,375,399,518,524,55,426,0,0,0,0,0,0,0,0,98,34,105,50,80,163,104,110,76,78,76,82,59,65,76,106,39,55,81,121,55,84,51,0,0,0,0,0,0,0,0,0,80,74,212,82,83,60,90,33,92,88,135,59,85,113,42,100,92,58,65,36,47,46,56,40,209,125,101,116,51,20,23,26,58,93,129,127,118,138,124,113,12,59,58,79,120,84,103,137,
 ### 実現したいこと
 ・上記CSVデータを1秒刻みで平均化したい
-46:13台は46:13.8から46:13.9の2行のデータで平均化
+2022/10/20 10:46:13台は46:13.8から46:13.9の2行のデータで平均化
-46:14台は46:14.0から46:13.9の10行のデータで平均化
+2022/10/20 10:46:14台は46:14.0から46:14.2の3行のデータで平均化
 その1秒の中で持っているデータの行数が異なっていても、持っている個数に応じて平均化したい
-実際に使用するデータは上記のようなデータが無数に格納されるので、今回の46:13台、46:14台、46:15台だけが持っている個数で平均化できれば良いわけでは無い
+実際に使用するデータは上記のようなデータが無数に格納されるので、今回の46:13台、46:14台だけが持っている個数で平均化できれば良いわけでは無い
 ・平均化されたデータを再度CSVファイルに出力したい
-TIME(データ取得日時),A,B,C,D,E,F,Gの並び順はそのままに、平均化されたことで行数が減って格納されるイメージ
 ### 発生している問題・エラーメッセージ
 raise KeyError(key) from err
 KeyError: 'TIME'
 ### 該当のソースコード
@@ -61,22 +40,5 @@
 df_resample = df.resample('S').sum()
 df_resample.to_csv('output.comcsv')
-### 試したこと
-**「sep=',',index_col=0,parse_dates=True」**の部分と
-**「df['datetime'] = pd.to_datetime(df['TIME']) # 日時情報が入った列をdatetime型へ変換
-df.set_index('datetime',inplace=True) #indexにdatetime列を指定し、置き換え」**の部分がdatetimeに変化するためのコードで重複するためそれぞれ削除してみましたが
-**「 File "<string>", line 3, in raise_from
-dateutil.parser._parser.ParserError: hour must be in 0..23: 46:13.8」**と
-**「 raise TypeError(
-TypeError: Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex, but got an instance of 'Index'」**のエラーが出てしまいました。
-df.dtypeでTIMEの形式を見てもobjectの状態でした。
-### 補足情報（FW/ツールのバージョンなど）
-ここにより詳細な情報を記載してください。

Python 3.x Python

試したことを追加

2022/11/02 05:21

投稿

mizumizumizu

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -1,11 +1,13 @@
 ### 前提
 質問よろしくお願い致します。
+下記のことを行いたいのですが、コードでエラーが出てどのように修正すればよいか分からず教えて頂きたいです。
 各列にTIME(データ取得日時),測定値A,B,C,D,E,F,Gが格納されたCSVファイルを、1秒毎に平均化してCSVファイルに出力したい
 TIME列には「西暦年/月/日　時/分/秒」のデータが格納されている
 本当は0.1秒刻みで取得しているデータであるが、ファイル内の数式表示欄には0.1秒の位が四捨五入された値が表示されている
-下記は使用するCSVデータ
+下記は使用するCSVデータで名称「test.csv」
 データ内のTIME列最上部の46:13.8は2022/10/20 10:46:13.8を示している（CSVファイルのセルには46:13.8と表示されているが、上部の数式表示欄には2022/10/20  10:46:14と表示されている。46:13.8の0.8秒が四捨五入されて表示されている）
 [LOGGING]	RD81DL96_1	2	3	4
@@ -61,7 +63,18 @@
 df_resample.to_csv('output.comcsv')
 ### 試したこと
+**「sep=',',index_col=0,parse_dates=True」**の部分と
+**「df['datetime'] = pd.to_datetime(df['TIME']) # 日時情報が入った列をdatetime型へ変換
+df.set_index('datetime',inplace=True) #indexにdatetime列を指定し、置き換え」**の部分がdatetimeに変化するためのコードで重複するためそれぞれ削除してみましたが
+**「 File "<string>", line 3, in raise_from
+dateutil.parser._parser.ParserError: hour must be in 0..23: 46:13.8」**と
+**「 raise TypeError(
+TypeError: Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex, but got an instance of 'Index'」**のエラーが出てしまいました。
-ここに問題に対して試したことを記載してください。
+df.dtypeでTIMEの形式を見てもobjectの状態でした。
 ### 補足情報（FW/ツールのバージョンなど）

Python 3.x Python