TCST

#=================================
# Monthly Riding Record By Card ID
#=================================
for i in 01 02 03 04 05 06 07 08 09 10 11 12
do
   paste -d',' ../DATA/$i-8.csv ../DATA/$i-9.csv > tmp$$.o
   sed '/代幣/d'  tmp$$.o > $i.csv
done
#================================================================
# Accumulate Yearly and Split Card ID and By Leading Hex number
#================================================================
for i in 0 1 2  4 5 6 7 8 9 A B C D E F
do
   for j in 01 02 03 04 05 06 07 08 09 10 11 12
   do
      grep "^$i" $j.csv
   done > G$i
done
#==================================
# Count Riding Frequency by Card ID
#==================================
for i in 0 1 2 3 4 5 6 7 8 9 A B C D E F
do
   sort G$i | uniq -c | sort -rn > cardcount-$i.csv
done
#========================================
# split cardcount by riding count
#========================================
#=============Single Digit===============
for c in 1 2 3 4 5 6 7 8 9 
do
   for i in 0 1 2 3 4 5 6 7 8 9 A B C D E F
   do
      grep "^$c," cardcount-$i.csv
   done > splitcardcount-$c.csv
done 
#=============Double Digit===============
for c1 in 1 2 3 4 5 6 7 8 9 
do
   for c2 in 0 1 2 3 4 5 6 7 8 9 
   do
      for i in 0 1 2 3 4 5 6 7 8 9 A B C D E F
      do
	 grep "^$c1$c2," cardcount-$i.csv
      done > splitcardcount-$c1$c2.csv
   done 
done 
#=============Triple Digit===============
for i in 0 1 2 3 4 5 6 7 8 9 A B C D E F
do
   grep "^[1-9][0-9][0-9]," cardcount-$i.csv
done > splitcardcount-999.csv
#=============1000 time and above ===============
for i in 0 1 2 3 4 5 6 7 8 9 A B C D E F
do
   grep "^[1-9][0-9][0-9][0-9]," cardcount-$i.csv
done > splitcardcount-9999.csv
#============= Top Riders ===============
sort -nr *9999.csv | head -20 > TopRider.csv