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!

Pandas TypeError 'list' object is not callable - rename Pandas columns

The Pandas error 'list' object is not callable

How to Wrap/Break Long Column Names in Pandas Dataframe

To wrap or break long column names in Pandas we

How to Create a Pivot Table and Get Percentages in Pandas

Pivoting a table and calculating row-wise or column-wise percentages is

How to Format Numbers with Commas for Thousands in Pandas

To display large numbers in a more readable format we

Fixing "ValueError: Cannot mix tz-aware with tz-naive values" in Pandas

When using pd.to_datetime() in Pandas, you might encounter

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