Sorting Counter by year in Python

Question

The code below counts the amounts of occurrences of individual years in a row of a CSV file.

import csv
from collections import Counter

out=open("meteors.csv", "r")
data=csv.reader(out)
data.next()
data=[row for row in data]
out.close()

year = [] 

for row in data:
    if row[2]=='':
        continue
    else:       
        year.append(row[2])

c = Counter(year)

print c

The results come out like this:

Counter ({'2012':15, '2004':10, '2008':4})

Can anyone give me a piece of code I can add in order to sort the results by year?

@abc: no, this is an attempt to sort the dictionary by *key*. — Martijn Pieters, Jan 03 '15 at 16:34

Hackaholic · Accepted Answer · 2015-01-03T16:53:51.013

-1

try this:

sorted(c.items(),key=lambda x:x[0])

edited Jan 03 '15 at 16:53

answered Jan 03 '15 at 16:34

Hackaholic

19,069
5
54
72

any reason??? for downvote??? – Hackaholic Jan 03 '15 at 16:36
1

1) It's wrong. 2) Did you visit any of 2 links under **This question already has an answer here:**? – vaultah Jan 03 '15 at 16:37
how can u say its wrong??? – Hackaholic Jan 03 '15 at 16:38
Didn't work I'm afraid. I inserted in just above 'print c' – Richie Jan 03 '15 at 16:39
u need to try `print sorted(c.items(),key=lambda x:x[1])` – Hackaholic Jan 03 '15 at 16:40
@abc correct me where i am wrong, i thing u talking about reverse=True argument??? – Hackaholic Jan 03 '15 at 16:42
@Richie is that worked for u?? – Hackaholic Jan 03 '15 at 16:48
@Hackaholic This has ordered the data in order of the value rather than the key, however I managed to get some different code from the link provided by abc which sorted it for me. Thanks – Richie Jan 03 '15 at 16:52
so yeah its wrong bcos u sort by second element not by first – vaultah Jan 03 '15 at 16:52
@ab ahh i dident noticed need to sort on 1st, let me edit – Hackaholic Jan 03 '15 at 16:53
@Richie yea in place of x[1] put x[0], check the edit, i thought u want on values, sorry fro my bad – Hackaholic Jan 03 '15 at 16:55
@Hackaholic Yep works now. Thanks! – Richie Jan 03 '15 at 16:57

Sorting Counter by year in Python

1 Answers1