clickhouse-local is a really good tool for analyzing local data, as it supports a wide range of data formats and it's really fast. It can save you a lot of time, because there is no need to install a batch of packages to use it or setup a database server. Just download a binary/install one package and enjoy. It has developed rapidly in recent years and continues to improve.
https://clickhouse.com/docs/en/operations/utilities/clickhou...