how to compare two fields in python

[upendra kumar Devisetty]

The data was sorted and so duplicates will not appear anywhere in the dataframe. The values does not have significance and can be ignored safely.

Thanks
Upendra

On Tuesday, April 30, 2013 11:19:56 AM UTC-7, Tim Chase wrote:
> 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