Duplicate data is the bane of data management. Duplicate data items in the form of duplicate rows can cause confusion in data analysis that could result in severe consequences in business estimations ...

Data cleaning is a critical step in any data analysis project. It ensures the data is accurate, consistent, and ready for further analysis. I will walk you through an advanced MySQL data cleaning ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

Django clickhouse backend is a django database backend for clickhouse database. This project allows using django ORM to interact with clickhouse, the goal of the project is to operate clickhouse like ...