表計算で簡単なグラフを描こうと思ったら遅くて使い物にならないので…。
テキストファイルを少し加工して以前にいただいたPerlのスクリプトで
描く為の加工をしました。exコマンド(ラインエディタ?)を利用。
ポイント:置換のコマンドはファイルにしておく
$ head to_ping_mynet_2007-10.csv
'2007-10-01 0:00:06',46.8,57.4,75.0
'2007-10-01 0:01:06',48.0,48.7,51.5
'2007-10-01 0:02:05',46.6,47.3,49.9
'2007-10-01 0:03:06',46.5,47.6,50.4
'2007-10-01 0:04:05',51.1,53.1,54.0
'2007-10-01 0:05:06',46.9,47.9,49.4
'2007-10-01 0:06:06',398.0,771.5,1251.8
'2007-10-01 0:07:06',46.5,47.7,50.8
'2007-10-01 0:08:05',47.4,61.0,98.3
'2007-10-01 0:09:05',46.5,47.4,49.8
$ more del_csv_ex_cmd
1,$s/'//g
w
q
$ ex to_ping_mynet_2007-10.csv < del_csv_ex_cmd
$ head to_ping_mynet_2007-10.csv
2007-10-01 0:00:06,46.8,57.4,75.0
2007-10-01 0:01:06,48.0,48.7,51.5
2007-10-01 0:02:05,46.6,47.3,49.9
2007-10-01 0:03:06,46.5,47.6,50.4
2007-10-01 0:04:05,51.1,53.1,54.0
2007-10-01 0:05:06,46.9,47.9,49.4
2007-10-01 0:06:06,398.0,771.5,1251.8
2007-10-01 0:07:06,46.5,47.7,50.8
2007-10-01 0:08:05,47.4,61.0,98.3
2007-10-01 0:09:05,46.5,47.4,49.8
◆某所へのping(1分間隔のグラフ)
