Altcademy - a Forbes magazine logo Best Coding Bootcamp 2023

How to make a dataframe in Pandas

Understanding DataFrames in Pandas

When you're learning programming, especially data science with Python, one of the most powerful tools at your disposal is the Pandas library. Pandas is like a Swiss Army knife for data manipulation and analysis. At the heart of Pandas is the DataFrame, which you can think of as a supercharged Excel spreadsheet living inside your computer's memory.

What is a DataFrame?

Imagine a table with rows and columns, where each column can be of a different type—numbers, strings, dates, and so on. This table is what we call a DataFrame in Pandas. It's a two-dimensional, size-mutable, and potentially heterogeneous tabular data structure with labeled axes (rows and columns). In simpler terms, it's a way to store and manipulate structured data neatly and efficiently.

Creating a DataFrame from Scratch

To get started, you'll need to have Python and Pandas installed. If you've got that set up, let's dive into creating our very first DataFrame.

Using a Dictionary

One of the simplest ways to create a DataFrame is from a dictionary of lists. Each key-value pair in the dictionary will correspond to a column in the DataFrame.

import pandas as pd

# A dictionary where keys are column names and values are lists of column data
data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35],
    'City': ['New York', 'Los Angeles', 'Chicago']

# Create a DataFrame from the dictionary
df = pd.DataFrame(data)

# Display the DataFrame

When you run this code, you'll see a neatly formatted table printed out, with Name, Age, and City as column headers, and rows indexed with numbers starting from 0.

From Lists of Lists

You can also create a DataFrame from a list of lists (or tuples), where each inner list represents a row.

# A list of lists where each inner list contains row data
data = [
    ['Alice', 25, 'New York'],
    ['Bob', 30, 'Los Angeles'],
    ['Charlie', 35, 'Chicago']

# Specify the column names separately
column_names = ['Name', 'Age', 'City']

# Create the DataFrame
df = pd.DataFrame(data, columns=column_names)

# Display the DataFrame

This will produce the same output as before, but this time we started with rows of data and specified column names separately.

Adding More Complexity

DataFrames can handle more than just basic data types. Let's add some complexity with dates and missing values.

Dealing with Dates

Dates can be particularly tricky, but Pandas simplifies working with them. Let's add a Birthday column.

# Adding a 'Birthday' column with date data
data['Birthday'] = pd.to_datetime(['1995-02-10', '1990-05-30', '1985-08-15'])

# Update our DataFrame
df = pd.DataFrame(data)

# Display the DataFrame

The pd.to_datetime() function ensures that Pandas understands these strings as dates, which allows for powerful date manipulations later on.

Handling Missing Values

In real-world data, it's common to have missing values. Pandas represents these as NaN (Not a Number). Let's see how this works.

# Adding a column with a missing value
data['Email'] = ['', None, '']

# Update our DataFrame
df = pd.DataFrame(data)

# Display the DataFrame

The None value in the Email list is converted to NaN in the DataFrame, which Pandas understands as a missing value.

Accessing and Modifying Data

Once you have a DataFrame, you might want to access specific parts of it or modify it.

Accessing Columns and Rows

You can access a column by using its name and a row by using its index.

# Access a column

# Access a row by index

The iloc method allows you to access rows by their integer location.

Adding and Removing Data

Adding a new column or removing an existing one is straightforward.

# Add a new column
df['Employed'] = [True, True, False]

# Remove the 'City' column
df.drop('City', axis=1, inplace=True)

# Display the updated DataFrame

The drop method removes the specified column (or row), and inplace=True means that the DataFrame is updated in place without needing to assign it to a new variable.

Intuition and Analogies

If you're still wrapping your head around what DataFrames are and how they work, here's an analogy: think of a DataFrame as a robot's memory bank where it stores its knowledge in different compartments (columns) and each piece of knowledge is a memory (row). When the robot wants to recall something, it goes to a specific compartment and retrieves a piece of memory by its label.

Working with Real Data

In practice, you'll often create DataFrames by importing data from files like CSVs or databases. Here's a quick example of how to read a CSV file into a DataFrame.

# Read data from a CSV file into a DataFrame
df = pd.read_csv('path_to_your_file.csv')

# Display the first 5 rows of the DataFrame

The read_csv function is incredibly versatile and can handle different file formats and data types with ease.


As you embark on your data science journey, mastering the art of creating and manipulating DataFrames will be invaluable. Think of DataFrames as the canvas for your data artistry, where Pandas is the brush that lets you paint with numbers and strings. By breaking down complex datasets into manageable structures, you can uncover insights and tell stories that would otherwise remain hidden in the raw data.

Remember, the key to learning programming is practice. So go ahead, play with DataFrames, make mistakes, and learn from them. With each line of code, you're not just building DataFrames; you're building your future as a data scientist.