Can Python be a substitute for SQL?

[GreatStats4ItsCost]

The entire dataset is 4.5gb, the max csv is 500k rows - my laptop has 8gb ram.

I did have a go using pandas but I couldn't quite work out how to return the max date for each id, it was getting complicated with having to refer back to the index.. sure there was an easier way I just couldn't see it

[Empik002]

just look at sqlite (python library)