Python

sortig a list

Please support our Python advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: May 2008

Posts: 11

Reputation: ccandillo is an unknown quantity at this point

Solved Threads: 0

ccandillo

Offline

Newbie Poster

sortig a list

Jun 17th, 2009

I cannot seem to figure this out. This part of a larger script that I am writing. I have a list that looks like this. The fields are servername, port and program. How do I sort it to get a tally of what servers are listening on what ports.

This is my list:
[['server1', '1045', 'winlogon.exe'],
['server1', '8001', 'ctxsgsvc.exe'],
['server1', '3704', 'winlogon.exe'],
['server1', '1043', 'snmp.exe'],
['server2', '1041', 'snmp.exe'],
['server2', '1040', 'bpjava-msvc.exe'],
['server3', '2226', 'winlogon.exe'],
['server4', '1045', 'winlogon.exe'],
['server4', '1049', 'svchost.exe'],
['server5', '1048', 'clussvc.exe'],
['server5', '4660', 'winlogon.exe'],
['server5', '4911', 'winlogon.exe'],
['server6', '2226', 'winlogon.exe'],
['server6', '1045', 'winlogon.exe'],
['server6', '4998', 'unsecapp.exe'],
['server7', '4001', 'winlogon.exe']]

This is what I want:

1045 is open on server1, server4
8001 is open on server1
2226 is open on server3, server6
etc...

So far this is what I have but it doen't quite work:

Help with Code Tags

(Toggle Plain Text)

allports = list(set(total.keys()))
lines = total.values()

for port in allports:
    for line in lines:
        if line[1] == port:
            data[port] = line[0]

•

Join Date: Dec 2006

Posts: 1,056

Reputation: woooee is a jewel in the rough

Solved Threads: 298

woooee

Offline

Veteran Poster

Re: sortig a list

Jun 17th, 2009

Use a dictionary, with port number as the key, pointing to a list of servers running on that port.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
allports = list(set(total.keys()))
lines = total.values()
 
data_dict = {}
for port in allports:
    for line in lines:
        this_port = line[1]
        ## add key to dictionary if it doesn't exist, 
        ## pointing to an empty list
        if this_port not in data_dict:  
            data_dict[this_port] = []
 
        data_dict[this_port].append(line[0])
 
keys = data_dict.keys()
keys.sort()
print keys
allports = list(set(total.keys()))
lines = total.values()

data_dict = {}
for port in allports:
    for line in lines:
        this_port = line[1]
        ## add key to dictionary if it doesn't exist, 
        ## pointing to an empty list
        if this_port not in data_dict:  
            data_dict[this_port] = []

        data_dict[this_port].append(line[0])

keys = data_dict.keys()
keys.sort()
print keys