How to count the string occurrences in python

Question

I have this file

10, 44.66.44.55 , AD, AC , 112
10, 44.66.54.55 , AD, AC , 112
10, 44.66.44.55 , AD, AC , 112
50, 44.66.64.55 , AD, AC , 112
10, 44.66.54.55 , AD, AC , 112
10, 44.66.44.55 , AD, AC , 112

I want to add the column1 with same ip address. i want the output like

30, 44.66.44.55 , AD, AC , 112
20, 44.66.54.55 , AD, AC , 112
50, 44.66.64.55 , AD, AC , 112

I want to do in python

I tried

import re
import collections

a = collections.Counter()
with open("temp.txt", "r") as f:
   for line in f.readlines():
         list = line.split()
     a[list[1]] += int(list[0])
         print list[1]

@nneonneo , i tried the above and it gave the error , invalid literal — user1755071
– user1755071, Commented Jan 30, 2013 at 3:37

Abhijit · Accepted Answer · 2013-01-30 03:47:41Z

1

You may use the itertools.groupby solution, which is ideal in this case

>>> with open("test.csv") as fin:
    grouped_lines = groupby(sorted((e.split(',') for e in fin), key = itemgetter(1)), key = itemgetter(1))


>>> for k, v in grouped_lines:
    lines = list(v)
    lines[0][0] = sum(int(e[0]) for e in lines)
    print lines[0]


[30, ' 44.66.44.55 ', ' AD', ' AC ', ' 112\n']
[20, ' 44.66.54.55 ', ' AD', ' AC ', ' 112\n']
[50, ' 44.66.64.55 ', ' AD', ' AC ', ' 112\n']

answered Jan 30, 2013 at 3:47

Abhijit

64k20 gold badges143 silver badges209 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mirage · Accepted Answer · 2013-01-30 03:47:53Z

1

You need to split on , not on white spaces

try this

list = line.split(',')

answered Jan 30, 2013 at 3:47

Mirage

31.7k64 gold badges173 silver badges266 bronze badges

Comments

mbowden · Accepted Answer · 2013-01-30 05:22:44Z

0

There is a collections.Counter module. It returns a dictionary of of {'word': numberTimes} http://docs.python.org/2/library/collections.html

answered Jan 30, 2013 at 5:22

mbowden

7147 silver badges12 bronze badges

Comments

pradyunsg · Accepted Answer · 2013-01-30 07:25:53Z

0

Although @Abhijit's answer is shorter,
Try this, it also works.

After processing the file data, I store the data in a dictionary. This data is then manipulated when needed.
Your data is the values in the dict.

all_ips = {}

f = open('Test2.txt')
lines = f.readlines()
f.close()

for line in lines:
    ip = line.split(',')[1]

    props = line.split(',')
    props[0] = int(props[0])

    if ip not in all_ips:
        all_ips[ip] = props
    else:
        all_ips[ip][0] += props[0]

for ip in all_ips:
    print all_ips[ip]

answered Jan 30, 2013 at 7:25

pradyunsg

19.9k11 gold badges48 silver badges99 bronze badges

Collectives™ on Stack Overflow

How to count the string occurrences in python

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related