1

I have a CSV file with the following:

    date    running_balance
0   18/09/2017  5803.66
1   18/09/2017  5812.39
2   18/09/2017  6062.39
3   14/09/2017  6099.25
4   13/09/2017  6113.88
5   13/09/2017  6118.88

I want to graph this only using the latest balance information for any particular day. How can I make this simply return:

    date    running_balance
0   18/09/2017  5803.66
3   14/09/2017  6099.25
4   13/09/2017  6113.88

Can I simply keep the rows grouped by date where the index is at a minimum?

Thanks.

0 Answers0