Bijay Kumar 
Recently, I was working on a data analytics project where I needed to convert a Pandas DataFrame into a nested dictionary format for a JSON API endpoint. The challenge was that I needed a specific structure with multiple levels of nesting. Fortunately, Pandas offers several flexible methods to transform DataFrames into nested dictionaries that can … Read more >>
Recently, while I was working on a data analysis project for a US retail company where I needed to clean thousands of customer records. The dataset had numerous missing values, duplicates, and outlier transactions that were skewing our analysis results. The issue was figuring out how to efficiently remove these problematic rows. Pandas, Python’s efficient … Read more >>
Recently, while working on a data analysis project, I needed to group data without performing any aggregation. The issue is, many Python developers only use groupby with aggregation functions like sum(), mean(), or count(). But sometimes you just want to group the data without summarizing it. In this article, I’ll cover several simple ways to … Read more >>
When declaring variables in TypeScript, you have three variables: let, const, and var. Understanding these variables is crucial for writing clean, maintainable, and error-free TypeScript code. In this tutorial, we’ll focus on the difference between let vs const in TypeScript, and when to use each one. Understand the let Variable in TypeScript The let the … Read more >>
TypeScript is a powerful language that builds on JavaScript by adding static type definitions. This feature helps developers catch errors early and ensures that their code is more predictable and maintainable. Among the many types available in TypeScript, understanding the difference between Record and Object is essential for every TypeScript developer. This tutorial will learn … Read more >>
While building a minor feature in our internal HR tool, I had to show the date for the next day based on user actions. Since we’re using TypeScript for the frontend, I looked into a few clean and reliable ways to calculate tomorrow’s date. In this tutorial, I’ll explain how to get tomorrow’s date in … Read more >>
When working with TypeScript, developers often need to reuse the methods or variables in many places or need clear labels. In TypeScript, String literal unions are simple and best for one-time use cases, and Enums give more structure and are useful when the options are reused in many places or need clear labels. Use string … Read more >>
Recently, while working on a TypeScript feature for an internal tool, I needed to compare two dates, but only the date part, not the time. At first, I thought it would be straightforward, but I realised there are multiple ways to do it, and the results can vary depending on the method used. I tried … Read more >>
While I was working on a data analysis project, I needed to calculate the mean of a pandas DataFrame column. When I ran my code, I encountered this frustrating error message: “Function is not implemented for this dtype: [how->mean, dtype->object]”. After several hours of debugging, I found the solution. In this article, I’ll explain why … Read more >>
Working with CSV files is a common task in data analysis and manipulation. While Pandas DataFrames are great for most operations, sometimes you need to convert your CSV data into a Python dictionary for specific use cases. In my decade-plus experience as a Python developer, I’ve found that knowing how to transform CSV data into … Read more >>
Download a FREE PDF (112 Pages) Containing 51 Useful Python Programs.
Download a FREE PDF on how to become a Python developer.