Altcademy - a Forbes magazine logo Best Coding Bootcamp 2023

How to create an empty dataframe in Python

Understanding DataFrames

Before we delve into creating an empty DataFrame, it's important to understand what a DataFrame is. Picture a table or a spreadsheet, with rows and columns. You have a name for each column and each row is an entry. This is what a DataFrame is. It's like a two-dimensional array, or a table of data, with rows and columns.

In Python, we use a library called pandas to work with DataFrames. Pandas is one of the most popular tools in Python for data manipulation. It provides the DataFrame, which enables you to load, process, and analyze data in Python.

Installing Pandas

First things first, to work with pandas, we need to install it. If you don't have pandas installed on your computer, you can do it by typing the following command in your terminal:

pip install pandas

Creating an Empty DataFrame

Now, let's move on to the main topic: creating an empty DataFrame. Here's how you do it:

# Import pandas library
import pandas as pd

# Create an empty DataFrame
df = pd.DataFrame()

In the above code, pd.DataFrame() is used to create an empty DataFrame and df is the variable where we store it.

Why Create an Empty DataFrame?

You might be wondering, why would we want to create an empty DataFrame? It's like having a basket but no fruits to put in it.

Well, sometimes, in our program, we might not have the data at the beginning. We might be getting the data as the program is running. In such cases, we can start with an empty DataFrame and as we get the data, we can keep adding it to the DataFrame. This is similar to having an empty basket and filling it with fruits as we find them.

Adding Data to the DataFrame

Now that we have our empty DataFrame, let's see how we can add data to it. We can add data to it in the form of rows or columns.

Adding a Column

To add a column, we will use the syntax df['column_name'] = data. Here is an example:

# Add a new column named 'Name'
df['Name'] = ['John', 'Sara', 'Bob', 'Mia']

The above code will add a new column named 'Name' to our DataFrame with the entries 'John', 'Sara', 'Bob', 'Mia'.

Adding a Row

Adding a row is a bit tricky. We have to use the append function for this. However, the append function doesn't modify the original DataFrame. Instead, it returns a new DataFrame with the added rows. Here is how we do it:

# Define a new row
new_row = {'Name':'Alex'}

# Add the new row
df = df.append(new_row, ignore_index=True)

In the above code, we first define a new row as a dictionary. Then, we use df.append(new_row, ignore_index=True) to add the new row to the DataFrame.

Displaying the DataFrame

Now that we have added some data to our DataFrame, we might want to see it. We can do this using print(df) or simply df.

# Display the DataFrame


Understanding DataFrames and being able to manipulate them is a crucial skill in data analysis and machine learning. Creating an empty DataFrame might seem like a simple task, but it's like a canvas. It might be empty at first, but it holds the potential for a masterpiece. The data you add to it, whether it's rows or columns, are like the strokes of a brush, each adding detail and depth to your picture. So, take your empty DataFrame, and paint your masterpiece! Happy coding!