Devam Ediyor

520160 Figure simple composite score from 2 ranks then re-sort csv

Hi,

I have everyday 2 csv files that I need to figure a simple composite score locally on my OSX machine (Script could be python, perl, ruby applescript) that outputs new re-sorted 3rd csv by new composite score.)

Every stock symbol has known score in the 1st csv:

(Following are already scored 1-12)

"No.","Ticker","Company","Sector","Industry","Country","Market Cap","P/E","Price","Change","Volume"

1,"BPT","BP Prudhoe Bay Royalty Trust","Basic Materials","Oil & Gas Refining & Marketing","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,75598

2,"PBT","Permian Basin Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,190976

3,"SBR","Sabine Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,9630

4,"MSB","Mesabi Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,67290

5,"NRT","North European Oil Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,14990

6,"SJT","San Juan Basin Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,81551

7,"MARPS","Marine Petroleum Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,3514

8,"PCO","Pendrell Corporation","Technology","Wireless Communications","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,283468

9,"TNH","Terra Nitrogen Company, L.P.","Basic Materials","Agricultural Chemicals","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,61131

10,"GNI","Great Northern Iron Ore Properties","Basic Materials","Steel & Iron","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,2850

11,"ISIG","Insignia Systems Inc.","Services","Marketing Services","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,46293

12,"ZIXI","Zix Corp.","Technology","Application Software","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,307800

2nd csv has the stock symbols ranked possibly like this on a random day:

"No.","Ticker","Company","Sector","Industry","Country","Market Cap","P/E","Price","Change","Volume"

1,"ZIXI","Zix Corp.","Technology","Application Software","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,307800

2,"SBR","Sabine Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,9630

3,"PBT","Permian Basin Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,190976

4,"MSB","Mesabi Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,67290

5,"BPT","BP Prudhoe Bay Royalty Trust","Basic Materials","Oil & Gas Refining & Marketing","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,75598

6,"MARPS","Marine Petroleum Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,3514

7,"SJT","San Juan Basin Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,81551

8,"PCO","Pendrell Corporation","Technology","Wireless Communications","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,283468

9,"NRT","North European Oil Royalty Trust","Financial","Diversified Investments","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,14990

10,"GNI","Great Northern Iron Ore Properties","Basic Materials","Steel & Iron","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,2850

11,"ISIG","Insignia Systems Inc.","Services","Marketing Services","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,46293

12,"TNH","Terra Nitrogen Company, L.P.","Basic Materials","Agricultural Chemicals","USA",[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]%,61131

What I need is:

1)Stock Symbols each get a new composite score:

So BPT for example would get a score of 6 (1+5)

ISIG would get a score of 22 (11+11) and so on.

TNH would get a score of 21 (9+12)

2) All rows with "Financial" or "Utilities" are stripped out.

3) Composite scores are re-sorted ASCENDING

4) Outputted into a 3rd csv with Composite Ranks in the 1st column.

I need to know how to run it via terminal or simple interface.

Beceriler: Her şey Kabul, Perl, PHP, Python

Daha fazlasını görün: wireless company, gas company, simple stock ticker, ruby price, php technology market, perl technology, northern trust company, northern trust, great northern corporation, get wireless, country financial, symbol technology, php symbol, iron python, sjt, simple csv, score, sbr, python perl, ore, oil industry, oil company, msb, materials software systems, market re

İşveren Hakkında:
( 27 değerlendirme ) Las Vegas, United States

Proje NO: #2266096

Seçilen:

bhupal123

====== As discussed, please see PMB. Thanks. ======

0 gün içinde 50$ USD
(587 Değerlendirme)
6.6