Every day, the RBI releases settlement data for various payment transactions. However, processing this data poses a significant challenge due to its colossal nature. The data is presented in a single file, with each month’s information spread across different sheets, and the sheet structure constantly changes over time. Manual consolidation of this data would require hours of painstaking effort. In this article, I aim to provide a code solution that will streamline this task, saving you valuable time. So, let’s dive right in without any further delay.
The Raw Data
The snapshot of the raw data contained in the Excel file posted by RBI every day looks something like this.
