CSV データの合成(Python, random-csv-generator を使用)
ランダムデータの入った CSV ファイルを合成する. リレーショナルデータベースの試験,評価等に使うことを想定している.
【サイト内の関連ページ】
前準備
Git のインストール
Git のページ: https://git-scm.com/
Python の準備(Windows,Ubuntu 上)
- Windows での Python 3.10,関連パッケージ,Python 開発環境のインストール(winget を使用しないインストール): 別ページ »で説明
- Ubuntu では,システム Pythonを使うことができる.Python3 開発用ファイル,pip, setuptools のインストール: 別ページ »で説明
【サイト内の関連ページ】
- Python のまとめ: 別ページ »にまとめ
- Google Colaboratory の使い方など: 別ページ »で説明
【関連する外部ページ】 Python の公式ページ: https://www.python.org/
データ合成手順(Ubuntu 上)
Ubuntu の場合の手順を示す.Python を用いている.
random-csv-generator のインストール
インストール操作
sudo pip3 uninstall -y random_csv_generator
cd /tmp
git clone -q git+https://github.com/LucaCappelletti94/random_csv_generator
ソースコードの書き替え
次のようなデータを生成するように書き換える
region,province,surname,name,sex,birth_municipality,birth_province,birth_region,birth_cap,birth_province_code,birthdate,address,house_number,cap,municipality,province_code,codice_fiscale,total_debit,payed_debit
Lombardia,Pavia,Montanari,Roberto Angelo Giuseppe,M,Marzabotto,Bologna,Emilia Romagna,40043,BO,1942-03-31,Via Roma,69,27050,Ponte Nizza,PV,MNTRRT42C31B689X,13752,8137
Lazio,Latina,Menna,Daniela,F,Fara San Martino,Chieti,Abruzzo,66015,CH,1945-11-15,Via La Nece Snc-condominio De Felice,2,4019,Terracina,LT,MNNDNL45S55D495H,487,486
csvkit のインストール(Ubuntu 上)
Ubuntu を使用する場合は,次のように操作する.
sudo apt -y update
sudo apt -y install at csvkit
データ合成用の Python プログラム
次の Python プログラムを hoge.py のような名前で保存
# usage hoge.py 6540 'T1M' '/var/tmp'
import sys
import pandas as pd
from random_csv_generator import random_csv
num_of_records = int(sys.argv[1])
basename = sys.argv[2]
datadir = sys.argv[3]
df = random_csv(num_of_records)
df.to_csv(datadir + '/' + basename + '.csv', index=False, encoding='utf8', chunksize=1000)
DATADIR='/var/tmp'
time python3 hoge.py 6540 'T1M' ${DATADIR}
次のファイルを作るとする
- 約 250M のファイル,60個
次のように操作する
batch
#!/bin/bash
cd /mnt/kaneko
DATADIR='/mnt/kaneko'
python3 hoge.py 1634000 'T250M_1' ${DATADIR}
python3 hoge.py 1634000 'T250M_2' ${DATADIR}
python3 hoge.py 1634000 'T250M_3' ${DATADIR}
python3 hoge.py 1634000 'T250M_4' ${DATADIR}
python3 hoge.py 1634000 'T250M_5' ${DATADIR}
python3 hoge.py 1634000 'T250M_6' ${DATADIR}
python3 hoge.py 1634000 'T250M_7' ${DATADIR}
python3 hoge.py 1634000 'T250M_8' ${DATADIR}
python3 hoge.py 1634000 'T250M_9' ${DATADIR}
python3 hoge.py 1634000 'T250M_10' ${DATADIR}
python3 hoge.py 1634000 'T250M_11' ${DATADIR}
python3 hoge.py 1634000 'T250M_12' ${DATADIR}
python3 hoge.py 1634000 'T250M_13' ${DATADIR}
python3 hoge.py 1634000 'T250M_14' ${DATADIR}
python3 hoge.py 1634000 'T250M_15' ${DATADIR}
python3 hoge.py 1634000 'T250M_16' ${DATADIR}
python3 hoge.py 1634000 'T250M_17' ${DATADIR}
python3 hoge.py 1634000 'T250M_18' ${DATADIR}
python3 hoge.py 1634000 'T250M_19' ${DATADIR}
python3 hoge.py 1634000 'T250M_20' ${DATADIR}
python3 hoge.py 1634000 'T250M_21' ${DATADIR}
python3 hoge.py 1634000 'T250M_22' ${DATADIR}
python3 hoge.py 1634000 'T250M_23' ${DATADIR}
python3 hoge.py 1634000 'T250M_24' ${DATADIR}
python3 hoge.py 1634000 'T250M_25' ${DATADIR}
python3 hoge.py 1634000 'T250M_26' ${DATADIR}
python3 hoge.py 1634000 'T250M_27' ${DATADIR}
python3 hoge.py 1634000 'T250M_28' ${DATADIR}
python3 hoge.py 1634000 'T250M_29' ${DATADIR}
python3 hoge.py 1634000 'T250M_30' ${DATADIR}
python3 hoge.py 1634000 'T250M_31' ${DATADIR}
python3 hoge.py 1634000 'T250M_32' ${DATADIR}
python3 hoge.py 1634000 'T250M_33' ${DATADIR}
python3 hoge.py 1634000 'T250M_34' ${DATADIR}
python3 hoge.py 1634000 'T250M_35' ${DATADIR}
python3 hoge.py 1634000 'T250M_36' ${DATADIR}
python3 hoge.py 1634000 'T250M_37' ${DATADIR}
python3 hoge.py 1634000 'T250M_38' ${DATADIR}
python3 hoge.py 1634000 'T250M_39' ${DATADIR}
python3 hoge.py 1634000 'T250M_40' ${DATADIR}
python3 hoge.py 1634000 'T250M_41' ${DATADIR}
python3 hoge.py 1634000 'T250M_42' ${DATADIR}
python3 hoge.py 1634000 'T250M_43' ${DATADIR}
python3 hoge.py 1634000 'T250M_44' ${DATADIR}
python3 hoge.py 1634000 'T250M_45' ${DATADIR}
python3 hoge.py 1634000 'T250M_46' ${DATADIR}
python3 hoge.py 1634000 'T250M_47' ${DATADIR}
python3 hoge.py 1634000 'T250M_48' ${DATADIR}
python3 hoge.py 1634000 'T250M_49' ${DATADIR}
python3 hoge.py 1634000 'T250M_50' ${DATADIR}
python3 hoge.py 1634000 'T250M_51' ${DATADIR}
python3 hoge.py 1634000 'T250M_52' ${DATADIR}
python3 hoge.py 1634000 'T250M_53' ${DATADIR}
python3 hoge.py 1634000 'T250M_54' ${DATADIR}
python3 hoge.py 1634000 'T250M_55' ${DATADIR}
python3 hoge.py 1634000 'T250M_56' ${DATADIR}
python3 hoge.py 1634000 'T250M_57' ${DATADIR}
python3 hoge.py 1634000 'T250M_58' ${DATADIR}
python3 hoge.py 1634000 'T250M_59' ${DATADIR}
python3 hoge.py 1634000 'T250M_60' ${DATADIR}
python3 hoge.py 1634000 'T250M_61' ${DATADIR}
python3 hoge.py 1634000 'T250M_62' ${DATADIR}
python3 hoge.py 1634000 'T250M_63' ${DATADIR}
python3 hoge.py 1634000 'T250M_64' ${DATADIR}
python3 hoge.py 1634000 'T250M_65' ${DATADIR}
python3 hoge.py 1634000 'T250M_66' ${DATADIR}
python3 hoge.py 1634000 'T250M_67' ${DATADIR}
python3 hoge.py 1634000 'T250M_68' ${DATADIR}
python3 hoge.py 1634000 'T250M_69' ${DATADIR}
python3 hoge.py 1634000 'T250M_70' ${DATADIR}
python3 hoge.py 1634000 'T250M_71' ${DATADIR}
python3 hoge.py 1634000 'T250M_72' ${DATADIR}
python3 hoge.py 1634000 'T250M_73' ${DATADIR}
python3 hoge.py 1634000 'T250M_74' ${DATADIR}
python3 hoge.py 1634000 'T250M_75' ${DATADIR}
python3 hoge.py 1634000 'T250M_76' ${DATADIR}
python3 hoge.py 1634000 'T250M_77' ${DATADIR}
python3 hoge.py 1634000 'T250M_78' ${DATADIR}
python3 hoge.py 1634000 'T250M_79' ${DATADIR}
python3 hoge.py 1634000 'T250M_80' ${DATADIR}
python3 hoge.py 1634000 'T250M_81' ${DATADIR}
python3 hoge.py 1634000 'T250M_82' ${DATADIR}
python3 hoge.py 1634000 'T250M_83' ${DATADIR}
python3 hoge.py 1634000 'T250M_84' ${DATADIR}
python3 hoge.py 1634000 'T250M_85' ${DATADIR}
python3 hoge.py 1634000 'T250M_86' ${DATADIR}
python3 hoge.py 1634000 'T250M_87' ${DATADIR}
python3 hoge.py 1634000 'T250M_88' ${DATADIR}
python3 hoge.py 1634000 'T250M_89' ${DATADIR}
python3 hoge.py 1634000 'T250M_90' ${DATADIR}
python3 hoge.py 1634000 'T250M_91' ${DATADIR}
python3 hoge.py 1634000 'T250M_92' ${DATADIR}
python3 hoge.py 1634000 'T250M_93' ${DATADIR}
python3 hoge.py 1634000 'T250M_94' ${DATADIR}
python3 hoge.py 1634000 'T250M_95' ${DATADIR}
python3 hoge.py 1634000 'T250M_96' ${DATADIR}
python3 hoge.py 1634000 'T250M_97' ${DATADIR}
python3 hoge.py 1634000 'T250M_98' ${DATADIR}
python3 hoge.py 1634000 'T250M_99' ${DATADIR}
python3 hoge.py 1634000 'T250M_100' ${DATADIR}
python3 hoge.py 1634000 'T250M_101' ${DATADIR}
python3 hoge.py 1634000 'T250M_102' ${DATADIR}
python3 hoge.py 1634000 'T250M_103' ${DATADIR}
python3 hoge.py 1634000 'T250M_104' ${DATADIR}
python3 hoge.py 1634000 'T250M_105' ${DATADIR}
python3 hoge.py 1634000 'T250M_106' ${DATADIR}
python3 hoge.py 1634000 'T250M_107' ${DATADIR}
python3 hoge.py 1634000 'T250M_108' ${DATADIR}
python3 hoge.py 1634000 'T250M_109' ${DATADIR}
python3 hoge.py 1634000 'T250M_110' ${DATADIR}
python3 hoge.py 1634000 'T250M_111' ${DATADIR}
python3 hoge.py 1634000 'T250M_112' ${DATADIR}
python3 hoge.py 1634000 'T250M_113' ${DATADIR}
python3 hoge.py 1634000 'T250M_114' ${DATADIR}
python3 hoge.py 1634000 'T250M_115' ${DATADIR}
python3 hoge.py 1634000 'T250M_116' ${DATADIR}
python3 hoge.py 1634000 'T250M_117' ${DATADIR}
python3 hoge.py 1634000 'T250M_118' ${DATADIR}
python3 hoge.py 1634000 'T250M_119' ${DATADIR}
python3 hoge.py 1634000 'T250M_120' ${DATADIR}
python3 hoge.py 1634000 'T250M_121' ${DATADIR}
python3 hoge.py 1634000 'T250M_122' ${DATADIR}
python3 hoge.py 1634000 'T250M_123' ${DATADIR}
python3 hoge.py 1634000 'T250M_124' ${DATADIR}
python3 hoge.py 1634000 'T250M_125' ${DATADIR}
python3 hoge.py 1634000 'T250M_126' ${DATADIR}
python3 hoge.py 1634000 'T250M_127' ${DATADIR}
python3 hoge.py 1634000 'T250M_128' ${DATADIR}
python3 hoge.py 1634000 'T250M_129' ${DATADIR}
python3 hoge.py 1634000 'T250M_130' ${DATADIR}
python3 hoge.py 1634000 'T250M_131' ${DATADIR}
python3 hoge.py 1634000 'T250M_132' ${DATADIR}
python3 hoge.py 1634000 'T250M_133' ${DATADIR}
python3 hoge.py 1634000 'T250M_134' ${DATADIR}
python3 hoge.py 1634000 'T250M_135' ${DATADIR}
python3 hoge.py 1634000 'T250M_136' ${DATADIR}
python3 hoge.py 1634000 'T250M_137' ${DATADIR}
python3 hoge.py 1634000 'T250M_138' ${DATADIR}
python3 hoge.py 1634000 'T250M_139' ${DATADIR}
python3 hoge.py 1634000 'T250M_140' ${DATADIR}
python3 hoge.py 1634000 'T250M_141' ${DATADIR}
python3 hoge.py 1634000 'T250M_142' ${DATADIR}
python3 hoge.py 1634000 'T250M_143' ${DATADIR}
python3 hoge.py 1634000 'T250M_144' ${DATADIR}
python3 hoge.py 1634000 'T250M_145' ${DATADIR}
python3 hoge.py 1634000 'T250M_146' ${DATADIR}
python3 hoge.py 1634000 'T250M_147' ${DATADIR}
python3 hoge.py 1634000 'T250M_148' ${DATADIR}
python3 hoge.py 1634000 'T250M_149' ${DATADIR}
python3 hoge.py 1634000 'T250M_150' ${DATADIR}
python3 hoge.py 1634000 'T250M_151' ${DATADIR}
python3 hoge.py 1634000 'T250M_152' ${DATADIR}
python3 hoge.py 1634000 'T250M_153' ${DATADIR}
python3 hoge.py 1634000 'T250M_154' ${DATADIR}
python3 hoge.py 1634000 'T250M_155' ${DATADIR}
python3 hoge.py 1634000 'T250M_156' ${DATADIR}
python3 hoge.py 1634000 'T250M_157' ${DATADIR}
python3 hoge.py 1634000 'T250M_158' ${DATADIR}
python3 hoge.py 1634000 'T250M_159' ${DATADIR}
python3 hoge.py 1634000 'T250M_160' ${DATADIR}
python3 hoge.py 1634000 'T250M_161' ${DATADIR}
python3 hoge.py 1634000 'T250M_162' ${DATADIR}
python3 hoge.py 1634000 'T250M_163' ${DATADIR}
python3 hoge.py 1634000 'T250M_164' ${DATADIR}
python3 hoge.py 1634000 'T250M_165' ${DATADIR}
python3 hoge.py 1634000 'T250M_166' ${DATADIR}
python3 hoge.py 1634000 'T250M_167' ${DATADIR}
python3 hoge.py 1634000 'T250M_168' ${DATADIR}
python3 hoge.py 1634000 'T250M_169' ${DATADIR}
python3 hoge.py 1634000 'T250M_170' ${DATADIR}
python3 hoge.py 1634000 'T250M_171' ${DATADIR}
python3 hoge.py 1634000 'T250M_172' ${DATADIR}
python3 hoge.py 1634000 'T250M_173' ${DATADIR}
python3 hoge.py 1634000 'T250M_174' ${DATADIR}
python3 hoge.py 1634000 'T250M_175' ${DATADIR}
python3 hoge.py 1634000 'T250M_176' ${DATADIR}
python3 hoge.py 1634000 'T250M_177' ${DATADIR}
python3 hoge.py 1634000 'T250M_178' ${DATADIR}
python3 hoge.py 1634000 'T250M_179' ${DATADIR}
python3 hoge.py 1634000 'T250M_180' ${DATADIR}
python3 hoge.py 1634000 'T250M_181' ${DATADIR}
python3 hoge.py 1634000 'T250M_182' ${DATADIR}
python3 hoge.py 1634000 'T250M_183' ${DATADIR}
python3 hoge.py 1634000 'T250M_184' ${DATADIR}
python3 hoge.py 1634000 'T250M_185' ${DATADIR}
python3 hoge.py 1634000 'T250M_186' ${DATADIR}
python3 hoge.py 1634000 'T250M_187' ${DATADIR}
python3 hoge.py 1634000 'T250M_188' ${DATADIR}
python3 hoge.py 1634000 'T250M_189' ${DATADIR}
python3 hoge.py 1634000 'T250M_190' ${DATADIR}
python3 hoge.py 1634000 'T250M_191' ${DATADIR}
python3 hoge.py 1634000 'T250M_192' ${DATADIR}
python3 hoge.py 1634000 'T250M_193' ${DATADIR}
python3 hoge.py 1634000 'T250M_194' ${DATADIR}
python3 hoge.py 1634000 'T250M_195' ${DATADIR}
python3 hoge.py 1634000 'T250M_196' ${DATADIR}
python3 hoge.py 1634000 'T250M_197' ${DATADIR}
python3 hoge.py 1634000 'T250M_198' ${DATADIR}
python3 hoge.py 1634000 'T250M_199' ${DATADIR}
python3 hoge.py 1634000 'T250M_200' ${DATADIR}
exit
CTRL + D (同時押し)
# T500M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T500M_1.csv
tail -n +2 T250M_2.csv >> T500M_1.csv
# T1000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T1000M_1.csv
tail -n +2 T250M_2.csv >> T1000M_1.csv
tail -n +2 T250M_3.csv >> T1000M_1.csv
tail -n +2 T250M_4.csv >> T1000M_1.csv
# T2000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T2000M_1.csv
tail -n +2 T250M_2.csv >> T2000M_1.csv
tail -n +2 T250M_3.csv >> T2000M_1.csv
tail -n +2 T250M_4.csv >> T2000M_1.csv
tail -n +2 T250M_5.csv >> T2000M_1.csv
tail -n +2 T250M_6.csv >> T2000M_1.csv
tail -n +2 T250M_7.csv >> T2000M_1.csv
tail -n +2 T250M_8.csv >> T2000M_1.csv
# T4000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T4000M_1.csv
tail -n +2 T250M_2.csv >> T4000M_1.csv
tail -n +2 T250M_3.csv >> T4000M_1.csv
tail -n +2 T250M_4.csv >> T4000M_1.csv
tail -n +2 T250M_5.csv >> T4000M_1.csv
tail -n +2 T250M_6.csv >> T4000M_1.csv
tail -n +2 T250M_7.csv >> T4000M_1.csv
tail -n +2 T250M_8.csv >> T4000M_1.csv
tail -n +2 T250M_9.csv >> T4000M_1.csv
tail -n +2 T250M_10.csv >> T4000M_1.csv
tail -n +2 T250M_11.csv >> T4000M_1.csv
tail -n +2 T250M_12.csv >> T4000M_1.csv
tail -n +2 T250M_13.csv >> T4000M_1.csv
tail -n +2 T250M_14.csv >> T4000M_1.csv
tail -n +2 T250M_15.csv >> T4000M_1.csv
tail -n +2 T250M_16.csv >> T4000M_1.csv
# T8000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T8000M_1.csv
tail -n +2 T250M_2.csv >> T8000M_1.csv
tail -n +2 T250M_3.csv >> T8000M_1.csv
tail -n +2 T250M_4.csv >> T8000M_1.csv
tail -n +2 T250M_5.csv >> T8000M_1.csv
tail -n +2 T250M_6.csv >> T8000M_1.csv
tail -n +2 T250M_7.csv >> T8000M_1.csv
tail -n +2 T250M_8.csv >> T8000M_1.csv
tail -n +2 T250M_9.csv >> T8000M_1.csv
tail -n +2 T250M_10.csv >> T8000M_1.csv
tail -n +2 T250M_11.csv >> T8000M_1.csv
tail -n +2 T250M_12.csv >> T8000M_1.csv
tail -n +2 T250M_13.csv >> T8000M_1.csv
tail -n +2 T250M_14.csv >> T8000M_1.csv
tail -n +2 T250M_15.csv >> T8000M_1.csv
tail -n +2 T250M_16.csv >> T8000M_1.csv
tail -n +2 T250M_17.csv >> T8000M_1.csv
tail -n +2 T250M_18.csv >> T8000M_1.csv
tail -n +2 T250M_19.csv >> T8000M_1.csv
tail -n +2 T250M_20.csv >> T8000M_1.csv
tail -n +2 T250M_21.csv >> T8000M_1.csv
tail -n +2 T250M_22.csv >> T8000M_1.csv
tail -n +2 T250M_23.csv >> T8000M_1.csv
tail -n +2 T250M_24.csv >> T8000M_1.csv
tail -n +2 T250M_25.csv >> T8000M_1.csv
tail -n +2 T250M_26.csv >> T8000M_1.csv
tail -n +2 T250M_27.csv >> T8000M_1.csv
tail -n +2 T250M_28.csv >> T8000M_1.csv
tail -n +2 T250M_29.csv >> T8000M_1.csv
tail -n +2 T250M_30.csv >> T8000M_1.csv
tail -n +2 T250M_31.csv >> T8000M_1.csv
tail -n +2 T250M_32.csv >> T8000M_1.csv
# T12000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T12000M_1.csv
tail -n +2 T250M_2.csv >> T12000M_1.csv
tail -n +2 T250M_3.csv >> T12000M_1.csv
tail -n +2 T250M_4.csv >> T12000M_1.csv
tail -n +2 T250M_5.csv >> T12000M_1.csv
tail -n +2 T250M_6.csv >> T12000M_1.csv
tail -n +2 T250M_7.csv >> T12000M_1.csv
tail -n +2 T250M_8.csv >> T12000M_1.csv
tail -n +2 T250M_9.csv >> T12000M_1.csv
tail -n +2 T250M_10.csv >> T12000M_1.csv
tail -n +2 T250M_11.csv >> T12000M_1.csv
tail -n +2 T250M_12.csv >> T12000M_1.csv
tail -n +2 T250M_13.csv >> T12000M_1.csv
tail -n +2 T250M_14.csv >> T12000M_1.csv
tail -n +2 T250M_15.csv >> T12000M_1.csv
tail -n +2 T250M_16.csv >> T12000M_1.csv
tail -n +2 T250M_17.csv >> T12000M_1.csv
tail -n +2 T250M_18.csv >> T12000M_1.csv
tail -n +2 T250M_19.csv >> T12000M_1.csv
tail -n +2 T250M_20.csv >> T12000M_1.csv
tail -n +2 T250M_21.csv >> T12000M_1.csv
tail -n +2 T250M_22.csv >> T12000M_1.csv
tail -n +2 T250M_23.csv >> T12000M_1.csv
tail -n +2 T250M_24.csv >> T12000M_1.csv
tail -n +2 T250M_25.csv >> T12000M_1.csv
tail -n +2 T250M_26.csv >> T12000M_1.csv
tail -n +2 T250M_27.csv >> T12000M_1.csv
tail -n +2 T250M_28.csv >> T12000M_1.csv
tail -n +2 T250M_29.csv >> T12000M_1.csv
tail -n +2 T250M_30.csv >> T12000M_1.csv
tail -n +2 T250M_31.csv >> T12000M_1.csv
tail -n +2 T250M_32.csv >> T12000M_1.csv
tail -n +2 T250M_33.csv >> T12000M_1.csv
tail -n +2 T250M_34.csv >> T12000M_1.csv
tail -n +2 T250M_35.csv >> T12000M_1.csv
tail -n +2 T250M_36.csv >> T12000M_1.csv
tail -n +2 T250M_37.csv >> T12000M_1.csv
tail -n +2 T250M_38.csv >> T12000M_1.csv
tail -n +2 T250M_39.csv >> T12000M_1.csv
tail -n +2 T250M_40.csv >> T12000M_1.csv
tail -n +2 T250M_41.csv >> T12000M_1.csv
tail -n +2 T250M_42.csv >> T12000M_1.csv
tail -n +2 T250M_43.csv >> T12000M_1.csv
tail -n +2 T250M_44.csv >> T12000M_1.csv
tail -n +2 T250M_45.csv >> T12000M_1.csv
tail -n +2 T250M_46.csv >> T12000M_1.csv
tail -n +2 T250M_47.csv >> T12000M_1.csv
tail -n +2 T250M_48.csv >> T12000M_1.csv
# T16000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T16000M_1.csv
tail -n +2 T250M_2.csv >> T16000M_1.csv
tail -n +2 T250M_3.csv >> T16000M_1.csv
tail -n +2 T250M_4.csv >> T16000M_1.csv
tail -n +2 T250M_5.csv >> T16000M_1.csv
tail -n +2 T250M_6.csv >> T16000M_1.csv
tail -n +2 T250M_7.csv >> T16000M_1.csv
tail -n +2 T250M_8.csv >> T16000M_1.csv
tail -n +2 T250M_9.csv >> T16000M_1.csv
tail -n +2 T250M_10.csv >> T16000M_1.csv
tail -n +2 T250M_11.csv >> T16000M_1.csv
tail -n +2 T250M_12.csv >> T16000M_1.csv
tail -n +2 T250M_13.csv >> T16000M_1.csv
tail -n +2 T250M_14.csv >> T16000M_1.csv
tail -n +2 T250M_15.csv >> T16000M_1.csv
tail -n +2 T250M_16.csv >> T16000M_1.csv
tail -n +2 T250M_17.csv >> T16000M_1.csv
tail -n +2 T250M_18.csv >> T16000M_1.csv
tail -n +2 T250M_19.csv >> T16000M_1.csv
tail -n +2 T250M_20.csv >> T16000M_1.csv
tail -n +2 T250M_21.csv >> T16000M_1.csv
tail -n +2 T250M_22.csv >> T16000M_1.csv
tail -n +2 T250M_23.csv >> T16000M_1.csv
tail -n +2 T250M_24.csv >> T16000M_1.csv
tail -n +2 T250M_25.csv >> T16000M_1.csv
tail -n +2 T250M_26.csv >> T16000M_1.csv
tail -n +2 T250M_27.csv >> T16000M_1.csv
tail -n +2 T250M_28.csv >> T16000M_1.csv
tail -n +2 T250M_29.csv >> T16000M_1.csv
tail -n +2 T250M_30.csv >> T16000M_1.csv
tail -n +2 T250M_31.csv >> T16000M_1.csv
tail -n +2 T250M_32.csv >> T16000M_1.csv
tail -n +2 T250M_33.csv >> T16000M_1.csv
tail -n +2 T250M_34.csv >> T16000M_1.csv
tail -n +2 T250M_35.csv >> T16000M_1.csv
tail -n +2 T250M_36.csv >> T16000M_1.csv
tail -n +2 T250M_37.csv >> T16000M_1.csv
tail -n +2 T250M_38.csv >> T16000M_1.csv
tail -n +2 T250M_39.csv >> T16000M_1.csv
tail -n +2 T250M_40.csv >> T16000M_1.csv
tail -n +2 T250M_41.csv >> T16000M_1.csv
tail -n +2 T250M_42.csv >> T16000M_1.csv
tail -n +2 T250M_43.csv >> T16000M_1.csv
tail -n +2 T250M_44.csv >> T16000M_1.csv
tail -n +2 T250M_45.csv >> T16000M_1.csv
tail -n +2 T250M_46.csv >> T16000M_1.csv
tail -n +2 T250M_47.csv >> T16000M_1.csv
tail -n +2 T250M_48.csv >> T16000M_1.csv
tail -n +2 T250M_49.csv >> T16000M_1.csv
tail -n +2 T250M_50.csv >> T16000M_1.csv
tail -n +2 T250M_51.csv >> T16000M_1.csv
tail -n +2 T250M_52.csv >> T16000M_1.csv
tail -n +2 T250M_53.csv >> T16000M_1.csv
tail -n +2 T250M_54.csv >> T16000M_1.csv
tail -n +2 T250M_55.csv >> T16000M_1.csv
tail -n +2 T250M_56.csv >> T16000M_1.csv
tail -n +2 T250M_57.csv >> T16000M_1.csv
tail -n +2 T250M_58.csv >> T16000M_1.csv
tail -n +2 T250M_59.csv >> T16000M_1.csv
tail -n +2 T250M_60.csv >> T16000M_1.csv
tail -n +2 T250M_61.csv >> T16000M_1.csv
tail -n +2 T250M_62.csv >> T16000M_1.csv
tail -n +2 T250M_63.csv >> T16000M_1.csv
tail -n +2 T250M_64.csv >> T16000M_1.csv
# T20000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T20000M_1.csv
tail -n +2 T250M_2.csv >> T20000M_1.csv
tail -n +2 T250M_3.csv >> T20000M_1.csv
tail -n +2 T250M_4.csv >> T20000M_1.csv
tail -n +2 T250M_5.csv >> T20000M_1.csv
tail -n +2 T250M_6.csv >> T20000M_1.csv
tail -n +2 T250M_7.csv >> T20000M_1.csv
tail -n +2 T250M_8.csv >> T20000M_1.csv
tail -n +2 T250M_9.csv >> T20000M_1.csv
tail -n +2 T250M_10.csv >> T20000M_1.csv
tail -n +2 T250M_11.csv >> T20000M_1.csv
tail -n +2 T250M_12.csv >> T20000M_1.csv
tail -n +2 T250M_13.csv >> T20000M_1.csv
tail -n +2 T250M_14.csv >> T20000M_1.csv
tail -n +2 T250M_15.csv >> T20000M_1.csv
tail -n +2 T250M_16.csv >> T20000M_1.csv
tail -n +2 T250M_17.csv >> T20000M_1.csv
tail -n +2 T250M_18.csv >> T20000M_1.csv
tail -n +2 T250M_19.csv >> T20000M_1.csv
tail -n +2 T250M_20.csv >> T20000M_1.csv
tail -n +2 T250M_21.csv >> T20000M_1.csv
tail -n +2 T250M_22.csv >> T20000M_1.csv
tail -n +2 T250M_23.csv >> T20000M_1.csv
tail -n +2 T250M_24.csv >> T20000M_1.csv
tail -n +2 T250M_25.csv >> T20000M_1.csv
tail -n +2 T250M_26.csv >> T20000M_1.csv
tail -n +2 T250M_27.csv >> T20000M_1.csv
tail -n +2 T250M_28.csv >> T20000M_1.csv
tail -n +2 T250M_29.csv >> T20000M_1.csv
tail -n +2 T250M_30.csv >> T20000M_1.csv
tail -n +2 T250M_31.csv >> T20000M_1.csv
tail -n +2 T250M_32.csv >> T20000M_1.csv
tail -n +2 T250M_33.csv >> T20000M_1.csv
tail -n +2 T250M_34.csv >> T20000M_1.csv
tail -n +2 T250M_35.csv >> T20000M_1.csv
tail -n +2 T250M_36.csv >> T20000M_1.csv
tail -n +2 T250M_37.csv >> T20000M_1.csv
tail -n +2 T250M_38.csv >> T20000M_1.csv
tail -n +2 T250M_39.csv >> T20000M_1.csv
tail -n +2 T250M_40.csv >> T20000M_1.csv
tail -n +2 T250M_41.csv >> T20000M_1.csv
tail -n +2 T250M_42.csv >> T20000M_1.csv
tail -n +2 T250M_43.csv >> T20000M_1.csv
tail -n +2 T250M_44.csv >> T20000M_1.csv
tail -n +2 T250M_45.csv >> T20000M_1.csv
tail -n +2 T250M_46.csv >> T20000M_1.csv
tail -n +2 T250M_47.csv >> T20000M_1.csv
tail -n +2 T250M_48.csv >> T20000M_1.csv
tail -n +2 T250M_49.csv >> T20000M_1.csv
tail -n +2 T250M_50.csv >> T20000M_1.csv
tail -n +2 T250M_51.csv >> T20000M_1.csv
tail -n +2 T250M_52.csv >> T20000M_1.csv
tail -n +2 T250M_53.csv >> T20000M_1.csv
tail -n +2 T250M_54.csv >> T20000M_1.csv
tail -n +2 T250M_55.csv >> T20000M_1.csv
tail -n +2 T250M_56.csv >> T20000M_1.csv
tail -n +2 T250M_57.csv >> T20000M_1.csv
tail -n +2 T250M_58.csv >> T20000M_1.csv
tail -n +2 T250M_59.csv >> T20000M_1.csv
tail -n +2 T250M_60.csv >> T20000M_1.csv
tail -n +2 T250M_61.csv >> T20000M_1.csv
tail -n +2 T250M_62.csv >> T20000M_1.csv
tail -n +2 T250M_63.csv >> T20000M_1.csv
tail -n +2 T250M_64.csv >> T20000M_1.csv
tail -n +2 T250M_65.csv >> T20000M_1.csv
tail -n +2 T250M_66.csv >> T20000M_1.csv
tail -n +2 T250M_67.csv >> T20000M_1.csv
tail -n +2 T250M_68.csv >> T20000M_1.csv
tail -n +2 T250M_69.csv >> T20000M_1.csv
tail -n +2 T250M_70.csv >> T20000M_1.csv
tail -n +2 T250M_71.csv >> T20000M_1.csv
tail -n +2 T250M_72.csv >> T20000M_1.csv
tail -n +2 T250M_73.csv >> T20000M_1.csv
tail -n +2 T250M_74.csv >> T20000M_1.csv
tail -n +2 T250M_75.csv >> T20000M_1.csv
tail -n +2 T250M_76.csv >> T20000M_1.csv
tail -n +2 T250M_77.csv >> T20000M_1.csv
tail -n +2 T250M_78.csv >> T20000M_1.csv
tail -n +2 T250M_79.csv >> T20000M_1.csv
tail -n +2 T250M_80.csv >> T20000M_1.csv
# T24000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T24000M_1.csv
tail -n +2 T250M_2.csv >> T24000M_1.csv
tail -n +2 T250M_3.csv >> T24000M_1.csv
tail -n +2 T250M_4.csv >> T24000M_1.csv
tail -n +2 T250M_5.csv >> T24000M_1.csv
tail -n +2 T250M_6.csv >> T24000M_1.csv
tail -n +2 T250M_7.csv >> T24000M_1.csv
tail -n +2 T250M_8.csv >> T24000M_1.csv
tail -n +2 T250M_9.csv >> T24000M_1.csv
tail -n +2 T250M_10.csv >> T24000M_1.csv
tail -n +2 T250M_11.csv >> T24000M_1.csv
tail -n +2 T250M_12.csv >> T24000M_1.csv
tail -n +2 T250M_13.csv >> T24000M_1.csv
tail -n +2 T250M_14.csv >> T24000M_1.csv
tail -n +2 T250M_15.csv >> T24000M_1.csv
tail -n +2 T250M_16.csv >> T24000M_1.csv
tail -n +2 T250M_17.csv >> T24000M_1.csv
tail -n +2 T250M_18.csv >> T24000M_1.csv
tail -n +2 T250M_19.csv >> T24000M_1.csv
tail -n +2 T250M_20.csv >> T24000M_1.csv
tail -n +2 T250M_21.csv >> T24000M_1.csv
tail -n +2 T250M_22.csv >> T24000M_1.csv
tail -n +2 T250M_23.csv >> T24000M_1.csv
tail -n +2 T250M_24.csv >> T24000M_1.csv
tail -n +2 T250M_25.csv >> T24000M_1.csv
tail -n +2 T250M_26.csv >> T24000M_1.csv
tail -n +2 T250M_27.csv >> T24000M_1.csv
tail -n +2 T250M_28.csv >> T24000M_1.csv
tail -n +2 T250M_29.csv >> T24000M_1.csv
tail -n +2 T250M_30.csv >> T24000M_1.csv
tail -n +2 T250M_31.csv >> T24000M_1.csv
tail -n +2 T250M_32.csv >> T24000M_1.csv
tail -n +2 T250M_33.csv >> T24000M_1.csv
tail -n +2 T250M_34.csv >> T24000M_1.csv
tail -n +2 T250M_35.csv >> T24000M_1.csv
tail -n +2 T250M_36.csv >> T24000M_1.csv
tail -n +2 T250M_37.csv >> T24000M_1.csv
tail -n +2 T250M_38.csv >> T24000M_1.csv
tail -n +2 T250M_39.csv >> T24000M_1.csv
tail -n +2 T250M_40.csv >> T24000M_1.csv
tail -n +2 T250M_41.csv >> T24000M_1.csv
tail -n +2 T250M_42.csv >> T24000M_1.csv
tail -n +2 T250M_43.csv >> T24000M_1.csv
tail -n +2 T250M_44.csv >> T24000M_1.csv
tail -n +2 T250M_45.csv >> T24000M_1.csv
tail -n +2 T250M_46.csv >> T24000M_1.csv
tail -n +2 T250M_47.csv >> T24000M_1.csv
tail -n +2 T250M_48.csv >> T24000M_1.csv
tail -n +2 T250M_49.csv >> T24000M_1.csv
tail -n +2 T250M_50.csv >> T24000M_1.csv
tail -n +2 T250M_51.csv >> T24000M_1.csv
tail -n +2 T250M_52.csv >> T24000M_1.csv
tail -n +2 T250M_53.csv >> T24000M_1.csv
tail -n +2 T250M_54.csv >> T24000M_1.csv
tail -n +2 T250M_55.csv >> T24000M_1.csv
tail -n +2 T250M_56.csv >> T24000M_1.csv
tail -n +2 T250M_57.csv >> T24000M_1.csv
tail -n +2 T250M_58.csv >> T24000M_1.csv
tail -n +2 T250M_59.csv >> T24000M_1.csv
tail -n +2 T250M_60.csv >> T24000M_1.csv
tail -n +2 T250M_61.csv >> T24000M_1.csv
tail -n +2 T250M_62.csv >> T24000M_1.csv
tail -n +2 T250M_63.csv >> T24000M_1.csv
tail -n +2 T250M_64.csv >> T24000M_1.csv
tail -n +2 T250M_65.csv >> T24000M_1.csv
tail -n +2 T250M_66.csv >> T24000M_1.csv
tail -n +2 T250M_67.csv >> T24000M_1.csv
tail -n +2 T250M_68.csv >> T24000M_1.csv
tail -n +2 T250M_69.csv >> T24000M_1.csv
tail -n +2 T250M_70.csv >> T24000M_1.csv
tail -n +2 T250M_71.csv >> T24000M_1.csv
tail -n +2 T250M_72.csv >> T24000M_1.csv
tail -n +2 T250M_73.csv >> T24000M_1.csv
tail -n +2 T250M_74.csv >> T24000M_1.csv
tail -n +2 T250M_75.csv >> T24000M_1.csv
tail -n +2 T250M_76.csv >> T24000M_1.csv
tail -n +2 T250M_77.csv >> T24000M_1.csv
tail -n +2 T250M_78.csv >> T24000M_1.csv
tail -n +2 T250M_79.csv >> T24000M_1.csv
tail -n +2 T250M_80.csv >> T24000M_1.csv
tail -n +2 T250M_81.csv >> T24000M_1.csv
tail -n +2 T250M_82.csv >> T24000M_1.csv
tail -n +2 T250M_83.csv >> T24000M_1.csv
tail -n +2 T250M_84.csv >> T24000M_1.csv
tail -n +2 T250M_85.csv >> T24000M_1.csv
tail -n +2 T250M_86.csv >> T24000M_1.csv
tail -n +2 T250M_87.csv >> T24000M_1.csv
tail -n +2 T250M_88.csv >> T24000M_1.csv
tail -n +2 T250M_89.csv >> T24000M_1.csv
tail -n +2 T250M_90.csv >> T24000M_1.csv
tail -n +2 T250M_91.csv >> T24000M_1.csv
tail -n +2 T250M_92.csv >> T24000M_1.csv
tail -n +2 T250M_93.csv >> T24000M_1.csv
tail -n +2 T250M_94.csv >> T24000M_1.csv
tail -n +2 T250M_95.csv >> T24000M_1.csv
tail -n +2 T250M_96.csv >> T24000M_1.csv
# T28000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T28000M_1.csv
tail -n +2 T250M_2.csv >> T28000M_1.csv
tail -n +2 T250M_3.csv >> T28000M_1.csv
tail -n +2 T250M_4.csv >> T28000M_1.csv
tail -n +2 T250M_5.csv >> T28000M_1.csv
tail -n +2 T250M_6.csv >> T28000M_1.csv
tail -n +2 T250M_7.csv >> T28000M_1.csv
tail -n +2 T250M_8.csv >> T28000M_1.csv
tail -n +2 T250M_9.csv >> T28000M_1.csv
tail -n +2 T250M_10.csv >> T28000M_1.csv
tail -n +2 T250M_11.csv >> T28000M_1.csv
tail -n +2 T250M_12.csv >> T28000M_1.csv
tail -n +2 T250M_13.csv >> T28000M_1.csv
tail -n +2 T250M_14.csv >> T28000M_1.csv
tail -n +2 T250M_15.csv >> T28000M_1.csv
tail -n +2 T250M_16.csv >> T28000M_1.csv
tail -n +2 T250M_17.csv >> T28000M_1.csv
tail -n +2 T250M_18.csv >> T28000M_1.csv
tail -n +2 T250M_19.csv >> T28000M_1.csv
tail -n +2 T250M_20.csv >> T28000M_1.csv
tail -n +2 T250M_21.csv >> T28000M_1.csv
tail -n +2 T250M_22.csv >> T28000M_1.csv
tail -n +2 T250M_23.csv >> T28000M_1.csv
tail -n +2 T250M_24.csv >> T28000M_1.csv
tail -n +2 T250M_25.csv >> T28000M_1.csv
tail -n +2 T250M_26.csv >> T28000M_1.csv
tail -n +2 T250M_27.csv >> T28000M_1.csv
tail -n +2 T250M_28.csv >> T28000M_1.csv
tail -n +2 T250M_29.csv >> T28000M_1.csv
tail -n +2 T250M_30.csv >> T28000M_1.csv
tail -n +2 T250M_31.csv >> T28000M_1.csv
tail -n +2 T250M_32.csv >> T28000M_1.csv
tail -n +2 T250M_33.csv >> T28000M_1.csv
tail -n +2 T250M_34.csv >> T28000M_1.csv
tail -n +2 T250M_35.csv >> T28000M_1.csv
tail -n +2 T250M_36.csv >> T28000M_1.csv
tail -n +2 T250M_37.csv >> T28000M_1.csv
tail -n +2 T250M_38.csv >> T28000M_1.csv
tail -n +2 T250M_39.csv >> T28000M_1.csv
tail -n +2 T250M_40.csv >> T28000M_1.csv
tail -n +2 T250M_41.csv >> T28000M_1.csv
tail -n +2 T250M_42.csv >> T28000M_1.csv
tail -n +2 T250M_43.csv >> T28000M_1.csv
tail -n +2 T250M_44.csv >> T28000M_1.csv
tail -n +2 T250M_45.csv >> T28000M_1.csv
tail -n +2 T250M_46.csv >> T28000M_1.csv
tail -n +2 T250M_47.csv >> T28000M_1.csv
tail -n +2 T250M_48.csv >> T28000M_1.csv
tail -n +2 T250M_49.csv >> T28000M_1.csv
tail -n +2 T250M_50.csv >> T28000M_1.csv
tail -n +2 T250M_51.csv >> T28000M_1.csv
tail -n +2 T250M_52.csv >> T28000M_1.csv
tail -n +2 T250M_53.csv >> T28000M_1.csv
tail -n +2 T250M_54.csv >> T28000M_1.csv
tail -n +2 T250M_55.csv >> T28000M_1.csv
tail -n +2 T250M_56.csv >> T28000M_1.csv
tail -n +2 T250M_57.csv >> T28000M_1.csv
tail -n +2 T250M_58.csv >> T28000M_1.csv
tail -n +2 T250M_59.csv >> T28000M_1.csv
tail -n +2 T250M_60.csv >> T28000M_1.csv
tail -n +2 T250M_61.csv >> T28000M_1.csv
tail -n +2 T250M_62.csv >> T28000M_1.csv
tail -n +2 T250M_63.csv >> T28000M_1.csv
tail -n +2 T250M_64.csv >> T28000M_1.csv
tail -n +2 T250M_65.csv >> T28000M_1.csv
tail -n +2 T250M_66.csv >> T28000M_1.csv
tail -n +2 T250M_67.csv >> T28000M_1.csv
tail -n +2 T250M_68.csv >> T28000M_1.csv
tail -n +2 T250M_69.csv >> T28000M_1.csv
tail -n +2 T250M_70.csv >> T28000M_1.csv
tail -n +2 T250M_71.csv >> T28000M_1.csv
tail -n +2 T250M_72.csv >> T28000M_1.csv
tail -n +2 T250M_73.csv >> T28000M_1.csv
tail -n +2 T250M_74.csv >> T28000M_1.csv
tail -n +2 T250M_75.csv >> T28000M_1.csv
tail -n +2 T250M_76.csv >> T28000M_1.csv
tail -n +2 T250M_77.csv >> T28000M_1.csv
tail -n +2 T250M_78.csv >> T28000M_1.csv
tail -n +2 T250M_79.csv >> T28000M_1.csv
tail -n +2 T250M_80.csv >> T28000M_1.csv
tail -n +2 T250M_81.csv >> T28000M_1.csv
tail -n +2 T250M_82.csv >> T28000M_1.csv
tail -n +2 T250M_83.csv >> T28000M_1.csv
tail -n +2 T250M_84.csv >> T28000M_1.csv
tail -n +2 T250M_85.csv >> T28000M_1.csv
tail -n +2 T250M_86.csv >> T28000M_1.csv
tail -n +2 T250M_87.csv >> T28000M_1.csv
tail -n +2 T250M_88.csv >> T28000M_1.csv
tail -n +2 T250M_89.csv >> T28000M_1.csv
tail -n +2 T250M_90.csv >> T28000M_1.csv
tail -n +2 T250M_91.csv >> T28000M_1.csv
tail -n +2 T250M_92.csv >> T28000M_1.csv
tail -n +2 T250M_93.csv >> T28000M_1.csv
tail -n +2 T250M_94.csv >> T28000M_1.csv
tail -n +2 T250M_95.csv >> T28000M_1.csv
tail -n +2 T250M_96.csv >> T28000M_1.csv
tail -n +2 T250M_97.csv >> T28000M_1.csv
tail -n +2 T250M_98.csv >> T28000M_1.csv
tail -n +2 T250M_99.csv >> T28000M_1.csv
tail -n +2 T250M_100.csv >> T28000M_1.csv
tail -n +2 T250M_101.csv >> T28000M_1.csv
tail -n +2 T250M_102.csv >> T28000M_1.csv
tail -n +2 T250M_103.csv >> T28000M_1.csv
tail -n +2 T250M_104.csv >> T28000M_1.csv
tail -n +2 T250M_105.csv >> T28000M_1.csv
tail -n +2 T250M_106.csv >> T28000M_1.csv
tail -n +2 T250M_107.csv >> T28000M_1.csv
tail -n +2 T250M_108.csv >> T28000M_1.csv
tail -n +2 T250M_109.csv >> T28000M_1.csv
tail -n +2 T250M_110.csv >> T28000M_1.csv
tail -n +2 T250M_111.csv >> T28000M_1.csv
tail -n +2 T250M_112.csv >> T28000M_1.csv
# T32000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T32000M_1.csv
tail -n +2 T250M_2.csv >> T32000M_1.csv
tail -n +2 T250M_3.csv >> T32000M_1.csv
tail -n +2 T250M_4.csv >> T32000M_1.csv
tail -n +2 T250M_5.csv >> T32000M_1.csv
tail -n +2 T250M_6.csv >> T32000M_1.csv
tail -n +2 T250M_7.csv >> T32000M_1.csv
tail -n +2 T250M_8.csv >> T32000M_1.csv
tail -n +2 T250M_9.csv >> T32000M_1.csv
tail -n +2 T250M_10.csv >> T32000M_1.csv
tail -n +2 T250M_11.csv >> T32000M_1.csv
tail -n +2 T250M_12.csv >> T32000M_1.csv
tail -n +2 T250M_13.csv >> T32000M_1.csv
tail -n +2 T250M_14.csv >> T32000M_1.csv
tail -n +2 T250M_15.csv >> T32000M_1.csv
tail -n +2 T250M_16.csv >> T32000M_1.csv
tail -n +2 T250M_17.csv >> T32000M_1.csv
tail -n +2 T250M_18.csv >> T32000M_1.csv
tail -n +2 T250M_19.csv >> T32000M_1.csv
tail -n +2 T250M_20.csv >> T32000M_1.csv
tail -n +2 T250M_21.csv >> T32000M_1.csv
tail -n +2 T250M_22.csv >> T32000M_1.csv
tail -n +2 T250M_23.csv >> T32000M_1.csv
tail -n +2 T250M_24.csv >> T32000M_1.csv
tail -n +2 T250M_25.csv >> T32000M_1.csv
tail -n +2 T250M_26.csv >> T32000M_1.csv
tail -n +2 T250M_27.csv >> T32000M_1.csv
tail -n +2 T250M_28.csv >> T32000M_1.csv
tail -n +2 T250M_29.csv >> T32000M_1.csv
tail -n +2 T250M_30.csv >> T32000M_1.csv
tail -n +2 T250M_31.csv >> T32000M_1.csv
tail -n +2 T250M_32.csv >> T32000M_1.csv
tail -n +2 T250M_33.csv >> T32000M_1.csv
tail -n +2 T250M_34.csv >> T32000M_1.csv
tail -n +2 T250M_35.csv >> T32000M_1.csv
tail -n +2 T250M_36.csv >> T32000M_1.csv
tail -n +2 T250M_37.csv >> T32000M_1.csv
tail -n +2 T250M_38.csv >> T32000M_1.csv
tail -n +2 T250M_39.csv >> T32000M_1.csv
tail -n +2 T250M_40.csv >> T32000M_1.csv
tail -n +2 T250M_41.csv >> T32000M_1.csv
tail -n +2 T250M_42.csv >> T32000M_1.csv
tail -n +2 T250M_43.csv >> T32000M_1.csv
tail -n +2 T250M_44.csv >> T32000M_1.csv
tail -n +2 T250M_45.csv >> T32000M_1.csv
tail -n +2 T250M_46.csv >> T32000M_1.csv
tail -n +2 T250M_47.csv >> T32000M_1.csv
tail -n +2 T250M_48.csv >> T32000M_1.csv
tail -n +2 T250M_49.csv >> T32000M_1.csv
tail -n +2 T250M_50.csv >> T32000M_1.csv
tail -n +2 T250M_51.csv >> T32000M_1.csv
tail -n +2 T250M_52.csv >> T32000M_1.csv
tail -n +2 T250M_53.csv >> T32000M_1.csv
tail -n +2 T250M_54.csv >> T32000M_1.csv
tail -n +2 T250M_55.csv >> T32000M_1.csv
tail -n +2 T250M_56.csv >> T32000M_1.csv
tail -n +2 T250M_57.csv >> T32000M_1.csv
tail -n +2 T250M_58.csv >> T32000M_1.csv
tail -n +2 T250M_59.csv >> T32000M_1.csv
tail -n +2 T250M_60.csv >> T32000M_1.csv
tail -n +2 T250M_61.csv >> T32000M_1.csv
tail -n +2 T250M_62.csv >> T32000M_1.csv
tail -n +2 T250M_63.csv >> T32000M_1.csv
tail -n +2 T250M_64.csv >> T32000M_1.csv
tail -n +2 T250M_65.csv >> T32000M_1.csv
tail -n +2 T250M_66.csv >> T32000M_1.csv
tail -n +2 T250M_67.csv >> T32000M_1.csv
tail -n +2 T250M_68.csv >> T32000M_1.csv
tail -n +2 T250M_69.csv >> T32000M_1.csv
tail -n +2 T250M_70.csv >> T32000M_1.csv
tail -n +2 T250M_71.csv >> T32000M_1.csv
tail -n +2 T250M_72.csv >> T32000M_1.csv
tail -n +2 T250M_73.csv >> T32000M_1.csv
tail -n +2 T250M_74.csv >> T32000M_1.csv
tail -n +2 T250M_75.csv >> T32000M_1.csv
tail -n +2 T250M_76.csv >> T32000M_1.csv
tail -n +2 T250M_77.csv >> T32000M_1.csv
tail -n +2 T250M_78.csv >> T32000M_1.csv
tail -n +2 T250M_79.csv >> T32000M_1.csv
tail -n +2 T250M_80.csv >> T32000M_1.csv
tail -n +2 T250M_81.csv >> T32000M_1.csv
tail -n +2 T250M_82.csv >> T32000M_1.csv
tail -n +2 T250M_83.csv >> T32000M_1.csv
tail -n +2 T250M_84.csv >> T32000M_1.csv
tail -n +2 T250M_85.csv >> T32000M_1.csv
tail -n +2 T250M_86.csv >> T32000M_1.csv
tail -n +2 T250M_87.csv >> T32000M_1.csv
tail -n +2 T250M_88.csv >> T32000M_1.csv
tail -n +2 T250M_89.csv >> T32000M_1.csv
tail -n +2 T250M_90.csv >> T32000M_1.csv
tail -n +2 T250M_91.csv >> T32000M_1.csv
tail -n +2 T250M_92.csv >> T32000M_1.csv
tail -n +2 T250M_93.csv >> T32000M_1.csv
tail -n +2 T250M_94.csv >> T32000M_1.csv
tail -n +2 T250M_95.csv >> T32000M_1.csv
tail -n +2 T250M_96.csv >> T32000M_1.csv
tail -n +2 T250M_97.csv >> T32000M_1.csv
tail -n +2 T250M_98.csv >> T32000M_1.csv
tail -n +2 T250M_99.csv >> T32000M_1.csv
tail -n +2 T250M_100.csv >> T32000M_1.csv
tail -n +2 T250M_101.csv >> T32000M_1.csv
tail -n +2 T250M_102.csv >> T32000M_1.csv
tail -n +2 T250M_103.csv >> T32000M_1.csv
tail -n +2 T250M_104.csv >> T32000M_1.csv
tail -n +2 T250M_105.csv >> T32000M_1.csv
tail -n +2 T250M_106.csv >> T32000M_1.csv
tail -n +2 T250M_107.csv >> T32000M_1.csv
tail -n +2 T250M_108.csv >> T32000M_1.csv
tail -n +2 T250M_109.csv >> T32000M_1.csv
tail -n +2 T250M_110.csv >> T32000M_1.csv
tail -n +2 T250M_111.csv >> T32000M_1.csv
tail -n +2 T250M_112.csv >> T32000M_1.csv
tail -n +2 T250M_113.csv >> T32000M_1.csv
tail -n +2 T250M_114.csv >> T32000M_1.csv
tail -n +2 T250M_115.csv >> T32000M_1.csv
tail -n +2 T250M_116.csv >> T32000M_1.csv
tail -n +2 T250M_117.csv >> T32000M_1.csv
tail -n +2 T250M_118.csv >> T32000M_1.csv
tail -n +2 T250M_119.csv >> T32000M_1.csv
tail -n +2 T250M_120.csv >> T32000M_1.csv
tail -n +2 T250M_121.csv >> T32000M_1.csv
tail -n +2 T250M_122.csv >> T32000M_1.csv
tail -n +2 T250M_123.csv >> T32000M_1.csv
tail -n +2 T250M_124.csv >> T32000M_1.csv
tail -n +2 T250M_125.csv >> T32000M_1.csv
tail -n +2 T250M_126.csv >> T32000M_1.csv
tail -n +2 T250M_127.csv >> T32000M_1.csv
tail -n +2 T250M_128.csv >> T32000M_1.csv
# T36000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T36000M_1.csv
tail -n +2 T250M_2.csv >> T36000M_1.csv
tail -n +2 T250M_3.csv >> T36000M_1.csv
tail -n +2 T250M_4.csv >> T36000M_1.csv
tail -n +2 T250M_5.csv >> T36000M_1.csv
tail -n +2 T250M_6.csv >> T36000M_1.csv
tail -n +2 T250M_7.csv >> T36000M_1.csv
tail -n +2 T250M_8.csv >> T36000M_1.csv
tail -n +2 T250M_9.csv >> T36000M_1.csv
tail -n +2 T250M_10.csv >> T36000M_1.csv
tail -n +2 T250M_11.csv >> T36000M_1.csv
tail -n +2 T250M_12.csv >> T36000M_1.csv
tail -n +2 T250M_13.csv >> T36000M_1.csv
tail -n +2 T250M_14.csv >> T36000M_1.csv
tail -n +2 T250M_15.csv >> T36000M_1.csv
tail -n +2 T250M_16.csv >> T36000M_1.csv
tail -n +2 T250M_17.csv >> T36000M_1.csv
tail -n +2 T250M_18.csv >> T36000M_1.csv
tail -n +2 T250M_19.csv >> T36000M_1.csv
tail -n +2 T250M_20.csv >> T36000M_1.csv
tail -n +2 T250M_21.csv >> T36000M_1.csv
tail -n +2 T250M_22.csv >> T36000M_1.csv
tail -n +2 T250M_23.csv >> T36000M_1.csv
tail -n +2 T250M_24.csv >> T36000M_1.csv
tail -n +2 T250M_25.csv >> T36000M_1.csv
tail -n +2 T250M_26.csv >> T36000M_1.csv
tail -n +2 T250M_27.csv >> T36000M_1.csv
tail -n +2 T250M_28.csv >> T36000M_1.csv
tail -n +2 T250M_29.csv >> T36000M_1.csv
tail -n +2 T250M_30.csv >> T36000M_1.csv
tail -n +2 T250M_31.csv >> T36000M_1.csv
tail -n +2 T250M_32.csv >> T36000M_1.csv
tail -n +2 T250M_33.csv >> T36000M_1.csv
tail -n +2 T250M_34.csv >> T36000M_1.csv
tail -n +2 T250M_35.csv >> T36000M_1.csv
tail -n +2 T250M_36.csv >> T36000M_1.csv
tail -n +2 T250M_37.csv >> T36000M_1.csv
tail -n +2 T250M_38.csv >> T36000M_1.csv
tail -n +2 T250M_39.csv >> T36000M_1.csv
tail -n +2 T250M_40.csv >> T36000M_1.csv
tail -n +2 T250M_41.csv >> T36000M_1.csv
tail -n +2 T250M_42.csv >> T36000M_1.csv
tail -n +2 T250M_43.csv >> T36000M_1.csv
tail -n +2 T250M_44.csv >> T36000M_1.csv
tail -n +2 T250M_45.csv >> T36000M_1.csv
tail -n +2 T250M_46.csv >> T36000M_1.csv
tail -n +2 T250M_47.csv >> T36000M_1.csv
tail -n +2 T250M_48.csv >> T36000M_1.csv
tail -n +2 T250M_49.csv >> T36000M_1.csv
tail -n +2 T250M_50.csv >> T36000M_1.csv
tail -n +2 T250M_51.csv >> T36000M_1.csv
tail -n +2 T250M_52.csv >> T36000M_1.csv
tail -n +2 T250M_53.csv >> T36000M_1.csv
tail -n +2 T250M_54.csv >> T36000M_1.csv
tail -n +2 T250M_55.csv >> T36000M_1.csv
tail -n +2 T250M_56.csv >> T36000M_1.csv
tail -n +2 T250M_57.csv >> T36000M_1.csv
tail -n +2 T250M_58.csv >> T36000M_1.csv
tail -n +2 T250M_59.csv >> T36000M_1.csv
tail -n +2 T250M_60.csv >> T36000M_1.csv
tail -n +2 T250M_61.csv >> T36000M_1.csv
tail -n +2 T250M_62.csv >> T36000M_1.csv
tail -n +2 T250M_63.csv >> T36000M_1.csv
tail -n +2 T250M_64.csv >> T36000M_1.csv
tail -n +2 T250M_65.csv >> T36000M_1.csv
tail -n +2 T250M_66.csv >> T36000M_1.csv
tail -n +2 T250M_67.csv >> T36000M_1.csv
tail -n +2 T250M_68.csv >> T36000M_1.csv
tail -n +2 T250M_69.csv >> T36000M_1.csv
tail -n +2 T250M_70.csv >> T36000M_1.csv
tail -n +2 T250M_71.csv >> T36000M_1.csv
tail -n +2 T250M_72.csv >> T36000M_1.csv
tail -n +2 T250M_73.csv >> T36000M_1.csv
tail -n +2 T250M_74.csv >> T36000M_1.csv
tail -n +2 T250M_75.csv >> T36000M_1.csv
tail -n +2 T250M_76.csv >> T36000M_1.csv
tail -n +2 T250M_77.csv >> T36000M_1.csv
tail -n +2 T250M_78.csv >> T36000M_1.csv
tail -n +2 T250M_79.csv >> T36000M_1.csv
tail -n +2 T250M_80.csv >> T36000M_1.csv
tail -n +2 T250M_81.csv >> T36000M_1.csv
tail -n +2 T250M_82.csv >> T36000M_1.csv
tail -n +2 T250M_83.csv >> T36000M_1.csv
tail -n +2 T250M_84.csv >> T36000M_1.csv
tail -n +2 T250M_85.csv >> T36000M_1.csv
tail -n +2 T250M_86.csv >> T36000M_1.csv
tail -n +2 T250M_87.csv >> T36000M_1.csv
tail -n +2 T250M_88.csv >> T36000M_1.csv
tail -n +2 T250M_89.csv >> T36000M_1.csv
tail -n +2 T250M_90.csv >> T36000M_1.csv
tail -n +2 T250M_91.csv >> T36000M_1.csv
tail -n +2 T250M_92.csv >> T36000M_1.csv
tail -n +2 T250M_93.csv >> T36000M_1.csv
tail -n +2 T250M_94.csv >> T36000M_1.csv
tail -n +2 T250M_95.csv >> T36000M_1.csv
tail -n +2 T250M_96.csv >> T36000M_1.csv
tail -n +2 T250M_97.csv >> T36000M_1.csv
tail -n +2 T250M_98.csv >> T36000M_1.csv
tail -n +2 T250M_99.csv >> T36000M_1.csv
tail -n +2 T250M_100.csv >> T36000M_1.csv
tail -n +2 T250M_101.csv >> T36000M_1.csv
tail -n +2 T250M_102.csv >> T36000M_1.csv
tail -n +2 T250M_103.csv >> T36000M_1.csv
tail -n +2 T250M_104.csv >> T36000M_1.csv
tail -n +2 T250M_105.csv >> T36000M_1.csv
tail -n +2 T250M_106.csv >> T36000M_1.csv
tail -n +2 T250M_107.csv >> T36000M_1.csv
tail -n +2 T250M_108.csv >> T36000M_1.csv
tail -n +2 T250M_109.csv >> T36000M_1.csv
tail -n +2 T250M_110.csv >> T36000M_1.csv
tail -n +2 T250M_111.csv >> T36000M_1.csv
tail -n +2 T250M_112.csv >> T36000M_1.csv
tail -n +2 T250M_113.csv >> T36000M_1.csv
tail -n +2 T250M_114.csv >> T36000M_1.csv
tail -n +2 T250M_115.csv >> T36000M_1.csv
tail -n +2 T250M_116.csv >> T36000M_1.csv
tail -n +2 T250M_117.csv >> T36000M_1.csv
tail -n +2 T250M_118.csv >> T36000M_1.csv
tail -n +2 T250M_119.csv >> T36000M_1.csv
tail -n +2 T250M_120.csv >> T36000M_1.csv
tail -n +2 T250M_121.csv >> T36000M_1.csv
tail -n +2 T250M_122.csv >> T36000M_1.csv
tail -n +2 T250M_123.csv >> T36000M_1.csv
tail -n +2 T250M_124.csv >> T36000M_1.csv
tail -n +2 T250M_125.csv >> T36000M_1.csv
tail -n +2 T250M_126.csv >> T36000M_1.csv
tail -n +2 T250M_127.csv >> T36000M_1.csv
tail -n +2 T250M_128.csv >> T36000M_1.csv
tail -n +2 T250M_129.csv >> T36000M_1.csv
tail -n +2 T250M_130.csv >> T36000M_1.csv
tail -n +2 T250M_131.csv >> T36000M_1.csv
tail -n +2 T250M_132.csv >> T36000M_1.csv
tail -n +2 T250M_133.csv >> T36000M_1.csv
tail -n +2 T250M_134.csv >> T36000M_1.csv
tail -n +2 T250M_135.csv >> T36000M_1.csv
tail -n +2 T250M_136.csv >> T36000M_1.csv
tail -n +2 T250M_137.csv >> T36000M_1.csv
tail -n +2 T250M_138.csv >> T36000M_1.csv
tail -n +2 T250M_139.csv >> T36000M_1.csv
tail -n +2 T250M_140.csv >> T36000M_1.csv
tail -n +2 T250M_141.csv >> T36000M_1.csv
tail -n +2 T250M_142.csv >> T36000M_1.csv
tail -n +2 T250M_143.csv >> T36000M_1.csv
tail -n +2 T250M_144.csv >> T36000M_1.csv
# T40000M_1
# 「tail -n +2」により,先頭行を除去してから追加
cp T250M_1.csv T40000M_1.csv
tail -n +2 T250M_2.csv >> T40000M_1.csv
tail -n +2 T250M_3.csv >> T40000M_1.csv
tail -n +2 T250M_4.csv >> T40000M_1.csv
tail -n +2 T250M_5.csv >> T40000M_1.csv
tail -n +2 T250M_6.csv >> T40000M_1.csv
tail -n +2 T250M_7.csv >> T40000M_1.csv
tail -n +2 T250M_8.csv >> T40000M_1.csv
tail -n +2 T250M_9.csv >> T40000M_1.csv
tail -n +2 T250M_10.csv >> T40000M_1.csv
tail -n +2 T250M_11.csv >> T40000M_1.csv
tail -n +2 T250M_12.csv >> T40000M_1.csv
tail -n +2 T250M_13.csv >> T40000M_1.csv
tail -n +2 T250M_14.csv >> T40000M_1.csv
tail -n +2 T250M_15.csv >> T40000M_1.csv
tail -n +2 T250M_16.csv >> T40000M_1.csv
tail -n +2 T250M_17.csv >> T40000M_1.csv
tail -n +2 T250M_18.csv >> T40000M_1.csv
tail -n +2 T250M_19.csv >> T40000M_1.csv
tail -n +2 T250M_20.csv >> T40000M_1.csv
tail -n +2 T250M_21.csv >> T40000M_1.csv
tail -n +2 T250M_22.csv >> T40000M_1.csv
tail -n +2 T250M_23.csv >> T40000M_1.csv
tail -n +2 T250M_24.csv >> T40000M_1.csv
tail -n +2 T250M_25.csv >> T40000M_1.csv
tail -n +2 T250M_26.csv >> T40000M_1.csv
tail -n +2 T250M_27.csv >> T40000M_1.csv
tail -n +2 T250M_28.csv >> T40000M_1.csv
tail -n +2 T250M_29.csv >> T40000M_1.csv
tail -n +2 T250M_30.csv >> T40000M_1.csv
tail -n +2 T250M_31.csv >> T40000M_1.csv
tail -n +2 T250M_32.csv >> T40000M_1.csv
tail -n +2 T250M_33.csv >> T40000M_1.csv
tail -n +2 T250M_34.csv >> T40000M_1.csv
tail -n +2 T250M_35.csv >> T40000M_1.csv
tail -n +2 T250M_36.csv >> T40000M_1.csv
tail -n +2 T250M_37.csv >> T40000M_1.csv
tail -n +2 T250M_38.csv >> T40000M_1.csv
tail -n +2 T250M_39.csv >> T40000M_1.csv
tail -n +2 T250M_40.csv >> T40000M_1.csv
tail -n +2 T250M_41.csv >> T40000M_1.csv
tail -n +2 T250M_42.csv >> T40000M_1.csv
tail -n +2 T250M_43.csv >> T40000M_1.csv
tail -n +2 T250M_44.csv >> T40000M_1.csv
tail -n +2 T250M_45.csv >> T40000M_1.csv
tail -n +2 T250M_46.csv >> T40000M_1.csv
tail -n +2 T250M_47.csv >> T40000M_1.csv
tail -n +2 T250M_48.csv >> T40000M_1.csv
tail -n +2 T250M_49.csv >> T40000M_1.csv
tail -n +2 T250M_50.csv >> T40000M_1.csv
tail -n +2 T250M_51.csv >> T40000M_1.csv
tail -n +2 T250M_52.csv >> T40000M_1.csv
tail -n +2 T250M_53.csv >> T40000M_1.csv
tail -n +2 T250M_54.csv >> T40000M_1.csv
tail -n +2 T250M_55.csv >> T40000M_1.csv
tail -n +2 T250M_56.csv >> T40000M_1.csv
tail -n +2 T250M_57.csv >> T40000M_1.csv
tail -n +2 T250M_58.csv >> T40000M_1.csv
tail -n +2 T250M_59.csv >> T40000M_1.csv
tail -n +2 T250M_60.csv >> T40000M_1.csv
tail -n +2 T250M_61.csv >> T40000M_1.csv
tail -n +2 T250M_62.csv >> T40000M_1.csv
tail -n +2 T250M_63.csv >> T40000M_1.csv
tail -n +2 T250M_64.csv >> T40000M_1.csv
tail -n +2 T250M_65.csv >> T40000M_1.csv
tail -n +2 T250M_66.csv >> T40000M_1.csv
tail -n +2 T250M_67.csv >> T40000M_1.csv
tail -n +2 T250M_68.csv >> T40000M_1.csv
tail -n +2 T250M_69.csv >> T40000M_1.csv
tail -n +2 T250M_70.csv >> T40000M_1.csv
tail -n +2 T250M_71.csv >> T40000M_1.csv
tail -n +2 T250M_72.csv >> T40000M_1.csv
tail -n +2 T250M_73.csv >> T40000M_1.csv
tail -n +2 T250M_74.csv >> T40000M_1.csv
tail -n +2 T250M_75.csv >> T40000M_1.csv
tail -n +2 T250M_76.csv >> T40000M_1.csv
tail -n +2 T250M_77.csv >> T40000M_1.csv
tail -n +2 T250M_78.csv >> T40000M_1.csv
tail -n +2 T250M_79.csv >> T40000M_1.csv
tail -n +2 T250M_80.csv >> T40000M_1.csv
tail -n +2 T250M_81.csv >> T40000M_1.csv
tail -n +2 T250M_82.csv >> T40000M_1.csv
tail -n +2 T250M_83.csv >> T40000M_1.csv
tail -n +2 T250M_84.csv >> T40000M_1.csv
tail -n +2 T250M_85.csv >> T40000M_1.csv
tail -n +2 T250M_86.csv >> T40000M_1.csv
tail -n +2 T250M_87.csv >> T40000M_1.csv
tail -n +2 T250M_88.csv >> T40000M_1.csv
tail -n +2 T250M_89.csv >> T40000M_1.csv
tail -n +2 T250M_90.csv >> T40000M_1.csv
tail -n +2 T250M_91.csv >> T40000M_1.csv
tail -n +2 T250M_92.csv >> T40000M_1.csv
tail -n +2 T250M_93.csv >> T40000M_1.csv
tail -n +2 T250M_94.csv >> T40000M_1.csv
tail -n +2 T250M_95.csv >> T40000M_1.csv
tail -n +2 T250M_96.csv >> T40000M_1.csv
tail -n +2 T250M_97.csv >> T40000M_1.csv
tail -n +2 T250M_98.csv >> T40000M_1.csv
tail -n +2 T250M_99.csv >> T40000M_1.csv
tail -n +2 T250M_100.csv >> T40000M_1.csv
tail -n +2 T250M_101.csv >> T40000M_1.csv
tail -n +2 T250M_102.csv >> T40000M_1.csv
tail -n +2 T250M_103.csv >> T40000M_1.csv
tail -n +2 T250M_104.csv >> T40000M_1.csv
tail -n +2 T250M_105.csv >> T40000M_1.csv
tail -n +2 T250M_106.csv >> T40000M_1.csv
tail -n +2 T250M_107.csv >> T40000M_1.csv
tail -n +2 T250M_108.csv >> T40000M_1.csv
tail -n +2 T250M_109.csv >> T40000M_1.csv
tail -n +2 T250M_110.csv >> T40000M_1.csv
tail -n +2 T250M_111.csv >> T40000M_1.csv
tail -n +2 T250M_112.csv >> T40000M_1.csv
tail -n +2 T250M_113.csv >> T40000M_1.csv
tail -n +2 T250M_114.csv >> T40000M_1.csv
tail -n +2 T250M_115.csv >> T40000M_1.csv
tail -n +2 T250M_116.csv >> T40000M_1.csv
tail -n +2 T250M_117.csv >> T40000M_1.csv
tail -n +2 T250M_118.csv >> T40000M_1.csv
tail -n +2 T250M_119.csv >> T40000M_1.csv
tail -n +2 T250M_120.csv >> T40000M_1.csv
tail -n +2 T250M_121.csv >> T40000M_1.csv
tail -n +2 T250M_122.csv >> T40000M_1.csv
tail -n +2 T250M_123.csv >> T40000M_1.csv
tail -n +2 T250M_124.csv >> T40000M_1.csv
tail -n +2 T250M_125.csv >> T40000M_1.csv
tail -n +2 T250M_126.csv >> T40000M_1.csv
tail -n +2 T250M_127.csv >> T40000M_1.csv
tail -n +2 T250M_128.csv >> T40000M_1.csv
tail -n +2 T250M_129.csv >> T40000M_1.csv
tail -n +2 T250M_130.csv >> T40000M_1.csv
tail -n +2 T250M_131.csv >> T40000M_1.csv
tail -n +2 T250M_132.csv >> T40000M_1.csv
tail -n +2 T250M_133.csv >> T40000M_1.csv
tail -n +2 T250M_134.csv >> T40000M_1.csv
tail -n +2 T250M_135.csv >> T40000M_1.csv
tail -n +2 T250M_136.csv >> T40000M_1.csv
tail -n +2 T250M_137.csv >> T40000M_1.csv
tail -n +2 T250M_138.csv >> T40000M_1.csv
tail -n +2 T250M_139.csv >> T40000M_1.csv
tail -n +2 T250M_140.csv >> T40000M_1.csv
tail -n +2 T250M_141.csv >> T40000M_1.csv
tail -n +2 T250M_142.csv >> T40000M_1.csv
tail -n +2 T250M_143.csv >> T40000M_1.csv
tail -n +2 T250M_144.csv >> T40000M_1.csv
tail -n +2 T250M_145.csv >> T40000M_1.csv
tail -n +2 T250M_146.csv >> T40000M_1.csv
tail -n +2 T250M_147.csv >> T40000M_1.csv
tail -n +2 T250M_148.csv >> T40000M_1.csv
tail -n +2 T250M_149.csv >> T40000M_1.csv
tail -n +2 T250M_150.csv >> T40000M_1.csv
tail -n +2 T250M_151.csv >> T40000M_1.csv
tail -n +2 T250M_152.csv >> T40000M_1.csv
tail -n +2 T250M_153.csv >> T40000M_1.csv
tail -n +2 T250M_154.csv >> T40000M_1.csv
tail -n +2 T250M_155.csv >> T40000M_1.csv
tail -n +2 T250M_156.csv >> T40000M_1.csv
tail -n +2 T250M_157.csv >> T40000M_1.csv
tail -n +2 T250M_158.csv >> T40000M_1.csv
tail -n +2 T250M_159.csv >> T40000M_1.csv
tail -n +2 T250M_160.csv >> T40000M_1.csv
wc T250M_1.csv
wc T500M_1.csv
wc T1000M_1.csv
wc T2000M_1.csv
wc T4000M_1.csv
wc T8000M_1.csv
wc T12000M_1.csv
wc T16000M_1.csv
wc T20000M_1.csv
wc T24000M_1.csv
wc T28000M_1.csv
wc T32000M_1.csv
wc T36000M_1.csv
wc T40000M_1.csv
csvsql --tables T250M_1 T250M_1.csv | sed 's/"//g' > T250M_1.sql
cat T250M_1.sql | sed 's/T250/T500/g' > T500M_1.sql
cat T250M_1.sql | sed 's/T250/T1000/g' > T1000M_1.sql
cat T250M_1.sql | sed 's/T250/T2000/g' > T2000M_1.sql
cat T250M_1.sql | sed 's/T250/T4000/g' > T4000M_1.sql
cat T250M_1.sql | sed 's/T250/T8000/g' > T8000M_1.sql
cat T250M_1.sql | sed 's/T250/T12000/g' > T12000M_1.sql
cat T250M_1.sql | sed 's/T250/T16000/g' > T16000M_1.sql
cat T250M_1.sql | sed 's/T250/T20000/g' > T20000M_1.sql
cat T250M_1.sql | sed 's/T250/T24000/g' > T24000M_1.sql
cat T250M_1.sql | sed 's/T250/T28000/g' > T28000M_1.sql
cat T250M_1.sql | sed 's/T250/T32000/g' > T32000M_1.sql
cat T250M_1.sql | sed 's/T250/T36000/g' > T36000M_1.sql
cat T250M_1.sql | sed 's/T250/T40000/g' > T40000M_1.sql
データの調整
通貨記号,「,」付きの数字の調整.
cd /var/tmp
for i in *.csv; do
echo $i
sed -i 's/¥ //g' $i
sed -i 's/¥//g' $i
sed -i 's/€ //g' $i
sed -i 's/€//g' $i
sed -i 's/"//g' $i
done
テーブル定義
csvsql --table 'T1M' T1M.csv > T1M.sql