AI

Pandas – How to Concatenate Dataframe Columns

Quick code sample on how to concatenate the data frames columns. We will work with example of Boston dataset found with sklearn.datasets. One should note that data frames could be concatenated by rows and columns. In this post, you will learn about how to concatenate data frames by columns.

Here is the code for working with Boston datasets. First and foremost, the Boston dataset will be loaded.

from sklearn.datasets import load_boston
bd = load_boston()

Once loaded, let’s create different different data frames comprising of data and target variable.

df_x = pd.DataFrame(data=bd.data, columns=bd.feature_names)
df_y = pd.DataFrame(data=bd.target, columns=["MEDV"])

This above creates two data frames comprising of data (features) and the values of target variable. Here are the snapshots.

Fig 1. Data frame representing dataset (with features)
Fig 2. Data frame representing dataset (target variable)

Use the following command to concatenate the data frames.

df = pd.concat([df_x, df_y], axis=1)

Here is the resulting data frame from concatenation of two data frames by columns.

Fig 2. Data frame created by concatenating data frame by columns

Ajitesh Kumar

I have been recently working in the area of Data analytics including Data Science and Machine Learning / Deep Learning. I am also passionate about different technologies including programming languages such as Java/JEE, Javascript, Python, R, Julia, etc, and technologies such as Blockchain, mobile computing, cloud-native technologies, application security, cloud computing platforms, big data, etc. I would love to connect with you on Linkedin. Check out my latest book titled as First Principles Thinking: Building winning products using first principles thinking.

Recent Posts

Agentic Reasoning Design Patterns in AI: Examples

In recent years, artificial intelligence (AI) has evolved to include more sophisticated and capable agents,…

3 weeks ago

LLMs for Adaptive Learning & Personalized Education

Adaptive learning helps in tailoring learning experiences to fit the unique needs of each student.…

4 weeks ago

Sparse Mixture of Experts (MoE) Models: Examples

With the increasing demand for more powerful machine learning (ML) systems that can handle diverse…

1 month ago

Anxiety Disorder Detection & Machine Learning Techniques

Anxiety is a common mental health condition that affects millions of people around the world.…

1 month ago

Confounder Features & Machine Learning Models: Examples

In machine learning, confounder features or variables can significantly affect the accuracy and validity of…

1 month ago

Credit Card Fraud Detection & Machine Learning

Last updated: 26 Sept, 2024 Credit card fraud detection is a major concern for credit…

1 month ago