任意のキーでグループ化し、データを集計します。
ここでは、2008年のデータを店舗・商品別の観点で集計します。
■入力ファイル
入力ファイルは、「2.3 データを抽出する」で抽出した結果を使用します。
《 result\2_抽出結果(2008年).csv 》
"SALESDATE","STORECODE","NMTENPO","LOCATION","CDTYPE","GTYPE","CDMAKER","NUMBER","SALEPRICE" "2008-01-01","1000","本店","駅前","CPH-02W","据え置き型CDプレイヤーTSB2-001","9","1","40800" "2008-01-01","1000","本店","駅前","TV-06PK","パーソナルテレビ06PK","2","1","34000" "2008-01-01","1000","本店","駅前","VM-02K","加湿器02K","4","1","127500" "2008-01-01","1000","本店","駅前","IRS-02B","遠赤外線ストーブ02B","10","2","16400" "2008-01-01","1000","本店","駅前","TV-01HK","ハイビジョンテレビ01HK","9","1","765100" "2008-01-01","1000","本店","駅前","FD-01W","電気カーペット01W","3","1","18100" "2008-01-01","1000","本店","駅前","FD-01W","電気カーペット01W","5","1","17000" "2008-01-01","1000","本店","駅前","AC-07GW","ガスエアコン","3","1","114800" "2008-01-01","1000","本店","駅前","CL-01K","デジタルカメラCNNT3000","5","1","61300" "2008-01-01","1000","本店","駅前","IRH-02W","遠赤外線ヒーター02W","5","2","14600" ・・・ |
