Append Columns to pandas DataFrame in Loop in Python (Example)

 

This tutorial demonstrates how to add new columns to a pandas DataFrame within a for loop in Python programming.

The article will contain one example for the addition of new variables to a pandas DataFrame within a for loop. To be more specific, the post is structured as follows:

Let’s dive right into the example…

 

Example Data & Libraries

We first have to import the pandas library, if we want to use the corresponding functions:

import pandas as pd                        # Load pandas

In addition, have a look at the following example data:

data = pd.DataFrame({'x1':range(5, 10),    # Create pandas DataFrame
                     'x2':range(10, 15),
                     'x3':range(20, 25)})
print(data)                                # Print pandas DataFrame

 

table 1 DataFrame append columns pandas dataframe loop python

 

Have a look at the table that got returned after executing the previously shown Python programming code. It shows that our example pandas DataFrame is constructed of five data points and three columns.

 

Example: Append Columns to pandas DataFrame within for Loop

In this example, I’ll illustrate how to use a for loop to append new variables to a pandas DataFrame in Python.

Have a look at the Python syntax below. It shows a for loop that consists of two lines.

The first line specifies that we want to iterate over a range from 1 to 4.

The second line specifies what we want to do in this loop, i.e. in each iteration we want to add a new column containing the iterator i times the value three. The variable name of this new column should be called like the iterator.

Let’s do this:

for i in range(1, 4):                      # Append columns within for loop
    data[i] = i * 3
print(data)                                # Print updated DataFrame

 

table 2 DataFrame append columns pandas dataframe loop python

 

Table 2 shows the output of the previous code: We have extended our example data set by three new columns.

 

Video & Further Resources

I have recently published a video on my YouTube channel, which illustrates the Python programming code of this article. You can find the video below.

 

Please accept YouTube cookies to play this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.

YouTube Content Consent Button Thumbnail

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

Additionally, you could read the other posts on this homepage. A selection of articles is shown below.

 

This tutorial has shown how to append, combine, and concatenate new variables to a pandas DataFrame within a for loop in Python. If you have any additional questions, please let me know in the comments below. In addition, please subscribe to my email newsletter to receive updates on new posts.

 

Subscribe to the Statistics Globe Newsletter

Get regular updates on the latest tutorials, offers & news at Statistics Globe.
I hate spam & you may opt out anytime: Privacy Policy.


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
Top