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 Split Strings and Extract the N-th Element in a Pandas DataFrame

Working with text data in Pandas, you may need to

How to Estimate the Memory Usage of a Pandas DataFrame

When working with large datasets, it's important to

How To Find the Closest Values in a Pandas Series to a Number

In this post we will see how to find the

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