Featured Post

How to Check Column Nulls and Replace: Pandas

Here is a post that shows how to count Nulls and replace them with the value you want in the Pandas Dataframe. We have explained the process in two steps - Counting and Replacing the Null values. Count null values (column-wise) in Pandas ## count null values column-wise null_counts = df.isnull(). sum() print(null_counts) ``` Output: ``` Column1    1 Column2    1 Column3    5 dtype: int64 ``` In the above code, we first create a sample Pandas DataFrame `df` with some null values. Then, we use the `isnull()` function to create a DataFrame of the same shape as `df`, where each element is a boolean value indicating whether that element is null or not. Finally, we use the `sum()` function to count the number of null values in each column of the resulting DataFrame. The output shows the count of null values column-wise. to count null values column-wise: ``` df.isnull().sum() ``` ##Code snippet to count null values row-wise: ``` df.isnull().sum(axis=1) ``` In the above code, `df` is the Panda

How to Retain data in Kafka and Get Additional Time for Analysis

The default topic retention period in Kafka is seven days. However, you can change the current retention period and keep data for a few more days. Hence it provides you additional time for analysis to get business insights.

How to Retain data in Kafka and Get Additional Time for Analysis

Kafka retention period

  • The retention period, you can set on two parameters of bytes and time. Due to cheap storage costs, companies wish to extend the data retention period. 
  • The retention period setup you need in the broker. It is not a deviation that Kafka is designed only for Seven days, and why we need to change it. Since space is cheaper, we can extend the retention period.

Setup for the retention period

Below is the setup in the broker configuration file for the retention period.


  • The most significant size threshold in bytes for deleting a log.


  • The length in milliseconds of a log will be maintained before being deleted.


  • Length before deletion in minutes. log.retention.ms is used as well if both are set.


  • Length before deletion in hours. log.retention.ms and log.retention.minutes would be used before this value if both are set.

Steps to disable retention period

You can disable the retention period by setting both log.retention.bytes and log.retention.ms to –1. So that we can effectively turn off the data deletion.

Steps to store data outside the broker

If we want our data to stick around for a while, what is the option other than brokers?
  • Move the data outside of Kafka and not retain it internally to the Kafka brokers themselves. 
  • Before data is removed by retention from Kafka, we could store the data in a database, in a Hadoop Distributed File System (HDFS™), or upload our event messages into something like cloud storage.


Popular posts from this blog

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers

6 Python file Methods Real Usage