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 Search for String in the Whole DataFrame in Pandas

To search for a string in all columns of a

How to Find All Rows With Newline Inside a Column or DataFrame in Pandas

Here is the way to search for newlines in a

How to Pretty Print Newlines in Pandas DataFrame

In this short post, you'll see how to

How to Replace Regex Groups in Pandas

In this short tutorial, we'll look at how

How to Drop Bad Lines with read_csv in Pandas

Here are two approaches to drop bad lines with read_

How to Use Multiple Char Separator in read_csv in Pandas

Here is the way to use multiple separators (regex separators)

Combine Multiple columns into a single one in Pandas

In this short guide, you'll see how to

Dump (unique) values to CSV / to_csv in Pandas

This post will show you how to use to_csv

SQL Equivalent count(distinct) in Pandas - nunique

In this post, we will see how to count distinct

How to Replace Text in a Pandas DataFrame Or Column

Replace text is one of the most popular operation in