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 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

How to Use the First Row as the Header in Pandas

To use the first row as a header in Pandas

Round Pandas date to nearest year, month or week

In this post you can find how to: * solve error:

Rounding Pandas Timestamps to the Nearest Minute, 15M, 30M

Below you can find multiple ways to round to the

Guide: How To Move a Column to the Front in Pandas DataFrame?

In this guide, you can learn how to move columns

Guide: How to Exclude Rows while Sorting a DataFrame in Pandas

In this short how to guide you can learn how

How to Merge with Missing Values in Pandas

In this article, you can learn how to merge DataFrames