Recent Topics

Python Folder structure for Scheduling Tasks

In some project need to use python for Scheduling Tasks/cronjob, Here if you use rest api structure/framework like django or Flask, then project file size will increase unnecessary. So here we can use a folder structure which will run for cronjob/sqs/anylogin running task....

Read More

Python Pandas- Compare Two CSV files, based on that comparison update CSV file

Sometimes we need to compare 2 CSV and get a list of common rows or common columns, that is a very common requirement.

But sometimes we also need to compare CSV files and based one comparison need to update CSV file. In this example I am going to elaborate that, hope that will help others.

I faced this requirement in “Reconciliation” module in one of my project, where One CSV I got from Bank where I can see all transactions happened in one day .

I have another csv where I have all transactions recorded in my database. So now we need to compare transaction with common id (Like transaction id ) and find out all transactions which are not present in our DB.

Read More