HRU Deduping

hru_deduping.py

In [65]: import pandas as pd
   
In [66]: a = pd.DataFrame({'hru': [9, 10, 10], 'sub': [100, 100, 100], 'down': [-1, 200, -1]})

In [67]: a
Out[67]:
   hru  sub  down
0    9  100    -1
1   10  100   200
2   10  100    -1

In [73]: a.sort_values(['hru', 'down'], ascending=True)
Out[73]:
   hru  sub  down
0    9  100    -1
2   10  100    -1
1   10  100   200

In [74]: a.sort_values(['hru', 'down'], ascending=False)
Out[74]:
   hru  sub  down
1   10  100   200
2   10  100    -1
0    9  100    -1

In [75]: a.sort_values(['hru', 'down'], ascending=True).drop_duplicates('hru', keep='first')
Out[75]:
   hru  sub  down
0    9  100    -1
2   10  100    -1

In [76]: a.sort_values(['hru', 'down'], ascending=True).drop_duplicates('hru', keep='last')
Out[76]:
   hru  sub  down
0    9  100    -1
1   10  100   200