awk script for generating a matrix for PCA

LM_POS.txt

able
abundance
abundant
acclaimed
accomplish
accomplished
accomplishes
accomplishing
accomplishment
accomplishments
achieve
achieved
achievement
achievements
achieves
achieving
adequately
advancement
advancements
advances
advancing
advantage
advantaged
advantageous
advantageously
advantages
alliance
alliances
assure
assured
assures
assuring
attain
attained
attaining
attainment
attainments
attains
attractive
attractiveness
beautiful
beautifully
beneficial
beneficially
benefit
benefited
benefiting
benefitted
benefitting
better
bolstered
bolstering
bolsters
boom
booming
boost
boosted
breakthrough
breakthroughs
brilliant
charitable
collaborate
collaborated
collaborates
collaborating
collaboration
collaborations
collaborative
collaborator
collaborators
compliment
complimentary
complimented
complimenting
compliments
conclusive
conclusively
conducive
confident
constructive
constructively
courteous
creative
creatively
creativeness
creativity
delight
delighted
delightful
delightfully
delighting
delights
dependability
dependable
desirable
desired
despite
destined
diligent
diligently

new.sh

awk '{
    printf("%d ", $1);
    count=0;
    for(i = 1; i <= NF; i++) {
       while($i ~ getline < "LM_POS.txt") {count++;}
       }
   print count;
   }'

original.sh

awk '{
    printf("%d ", $1);
    count=0;
    for(i = 1; i <= NF; i++) {
       if($i ~ /^RT$/) {count++;}
       }
   print count;
   }'

tweet.txt

0   noteworthy $ge's close by ktr8der
1   $ge news: [$$] eu probes utc's proposed goodrich acquisition daytrading stocks
1   analysts' actions: $goog, $ge, $ffiv - thestreet via thestreet
1   apple inc, dollar general, micron tech, ge attract heavy trading demand wednesday $aapl $dg $mu $ge mkt
1   heavily traded shares trading for mar 28th: dg qqq mu f ge $mu $qqq $dg $ge stocks
1   here's today's most active equity options and strikes: $aapl, $ge and $bac\n
1   historical data suggests industrial goods weak through may, caterpillar strong $ba $cat $de $emr $ge $hon
1   new post added to financial futures update blog: $zb_f $zn_f $ge_f
1   rt thestreet: the latest upgrades/downgrades -- $goog $ge $ffiv
1   rt barronsonline: big opportunities in big-cap stocks: interview t. rowe price's mark finn via barronsonline $trvlx $ge $pfe $csco $msft
1   stock analysts reiterated thr ratings of these shares on mar 28th epam $kior $mapp $nice $vrtx $bby $crm $ge $hts $len
1   the latest upgrades/downgrades -- $goog $ge $ffiv
2   $ge is a very disaster.. but i dont want to short it..! ;) $spy
2   general electric short 16.98 $ge
3   jimcramer stephanie_link $si v $ge steel cage death match?
3   here's why ge is having a good week $ge $opy mkt stocks trading
4   $ge - general electric stock analysis - bullish stochastic crossover -
4   $ge industry milestone: ge's heavy duty gas turbines surpass 2...
4   $ge news: comment: ge capital can shrug off ratings warning daytrading stocks
4   $ge setting up very nicely here. looking for ge to eclipse highs of 20.85. a close under 19.7 would be short term bearish.
4   $ge target raised at oppenheimer from $21 to $24 reiterates outperform.
4   scoffic like $ge's fin side and possible divi boost in 2nd half
4   big end of the day buys in $ge on massive volume. observation (long)
4   diagenic, $ge combine genes and imaging for alzheimer's biomarkers biotech
4   rt fiercebiotech: diagenic, $ge combine genes and imaging for alzheimer's biomarkers biotech
4   see whose expected to report an surprise\t $mmm\t, $utx\t, $ge\t, $pfe\t, $kft\ttfb
4   visa taps nordstrom executive to lead cards unit $ge
4   bght $ge 19.80
0   $ge we everywhere worldwide
0   meezy_montana wattupp witt a collab my nigga $ge x wavelife