If using all scalar values you must pass an index

The Problem: When you try to create a pandas dataframe using only scalar values without passing an index, you will get a ValueError: If using all scalar values, you must pass an index. In this article, I will provide an explanation of the problem and three easy and different solutions. First, let’s understand the root […]

šŸ… How to Combine Pandas Dataframe Columns Easily

In Python based data analysis projects, it is quite common to combine dataframe columns. Actually, it is super easy to to this. In this blog post, I am going to show you how to combine pandas dataframe columns easily. There are more than one ways to combine multiple pandas dataframe columns. Luckily, the easiest method […]

[SOLVED!] How to convertĀ frame.append() toĀ pandas.concat()?

FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

I was using frame.append method to add rows to a dataframe, yet it is deprecated and going to be removed from pandas. So, in this article, I will tell you how to convert DataFrame.append() to pandas.concat(). It’s easy. This is my original code with append method. With this code, I was appending a dataframe to b dataframe. […]

UNIX Timestamp to Readable Date With One Line of Code

UNIX Timestamp to Readable Date

Pandas library’s to_datetime method easily converts UNIX timestamp to readable date format in Python. Epoch, also known as Unix timestamps, is the number of seconds (not milliseconds!) that have elapsed since January 1, 1970 at 00:00:00 GMT.

Remove TIME from DATETIME value in Python

remove time from date in python

In this article, I am going to show you how to remove time from datetime value in Python. It is possible to remove time from datetime value in Python with just a few lines of code..But it can be tricky if you don’t follow the necessary steps. This is what we want to achieve: Here, […]