On 2013-04-30 10:41, upendra kumar Devisetty wrote: > I have a very basic question in python. I want to go through each > line of the a csv file and compare to see if the first field of > line 1 is same as first field of next line and so on. If it finds a > match then i would like to put that field in an object1 else put > that field in a different object2. Finally i would like to count > how many of the fields in object1 vs object2. Can this be done in > python? Here is a small example. > > BRM_1 679 1929 > BRM_1 203 567 > BRM_2 367 1308 > BRM_3 435 509 > As you can see field1 of line1 is same as field2 of line2 and so > that field BRM_1 should be place in object1 and BRM_2 and BRM_3 > should be placed in object2. So the final numbers of object1 is 1 > and object2 is 2.
You underdefine the problem. What happens in the case of: BRM_1 ... BRM_1 ... BRM_2 ... BRM_1 ... <-- duplicates a (not-immediately) previous line BRM_3 ... Also, do the values that follow have any significance for this, or are they just noise to be ignored? -tkc -- http://mail.python.org/mailman/listinfo/python-list