John D K

John D K

Working as a Data Scientist with experience in many different areas like: Data Quality, Data manipulation, Data Migration, Data Validation. Using Python, Pandas and Linux for Data Science!

How to Calculate Days Elapsed Since a Certain Date in Pandas

In this guide, I'll show you how to

How to Count Special Characters in a Column in Pandas

In this guide, I'll show you how to

How to Count the Occurrences of a Specific Value in Pandas DataFrame

In this short guide, I'll show you how

How To Split Column Data Based on Condition in Pandas

In this short guide, I'll show you how

Count Characters in a Column and Create a new Length Column in Pandas

In this short guide, I'll show you how

How to Combine Date and Time Columns with Pandas

In this short guide, I'll show you how

How to Compare Two Excel or CSV Files Using Pandas

When working with data, you may need to compare two

How to Read a Compressed CSV or JSON File in Pandas

To read compressed CSV and JSON files directly without manually

How to Save a Pandas DataFrame as a Compressed CSV/JSON File

To save a DataFrame as a compressed CSV/JSON file

How to Open and Convert an SQLite Database to a Pandas DataFrame

In this article, we’ll explore how to open an