Data Science, Python, Pandas.
still best tackled with the good old SQL and a relational database where even a simple SQLite could perform better and in a very reasonable time. We can solve this problem in several ways. Here’s one of them. My solution is based on storing data in a PostgreSQL database and performing a composite