# Stack the DataFrames on top of each other
#survey_sub and survey_sub_last10 are both dataframes
vertical_stack = pd.concat([survey_sub, survey_sub_last10], axis=0)

# Place the DataFrames side by side
horizontal_stack = pd.concat([survey_sub, survey_sub_last10], axis=1)

Popularity 10/10 Helpfulness 5/10 Language python

Source: datacarpentry.org

Tags: python py

Link to this answer
Share Copy Link

Contributed on May 06 2022

Yesid Cano Castro

0 Answers Avg Quality 2/10

concat 2 datframes python

Comment

In [12]:

pd.concat([df,df1], axis=0, ignore_index=True)
Out[12]:
   attr_1  attr_2  attr_3  id  quantity
0       0       1     NaN   1        20
1       1       1     NaN   2        23
2       1       1     NaN   3        19
3       0       0     NaN   4        19
4       1     NaN       0   5         8
5       0     NaN       1   6        13
6       1     NaN       1   7        20
7       1     NaN       1   8        25

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: concat co

Link to this answer
Share Copy Link

Contributed on Aug 12 2022

Gentle Gibbon

0 Answers Avg Quality 2/10

pandas concatenate two columns

Comment

# Basic syntax:
# If both columns are already string typed:
your_df["combined_col"] = your_df["column_1"] + your_df["column_2"]
# If one (or both) of the columns are not string typed:
your_df["combined_col"] = your_df["column_1"].astype(str) + your_df["column_2"]

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: combine

Link to this answer
Share Copy Link

Contributed on Jun 06 2023

Charles-Alexandre Roy

0 Answers Avg Quality 2/10

concat dataframes

Comment

result = pd.concat([df1, df2])

Popularity 10/10 Helpfulness 5/10 Language python

Source: pandas.pydata.org

Tags: concat co

Link to this answer
Share Copy Link

Contributed on Nov 18 2021

D Goglia

0 Answers Avg Quality 2/10

concat columns pandas dataframe

Comment

In [1]: df1 = pd.DataFrame(
   ...:     {
   ...:         "A": ["A0", "A1", "A2", "A3"],
   ...:         "B": ["B0", "B1", "B2", "B3"],
   ...:         "C": ["C0", "C1", "C2", "C3"],
   ...:         "D": ["D0", "D1", "D2", "D3"],
   ...:     },
   ...:     index=[0, 1, 2, 3],
   ...: )
   
In [8]: df4 = pd.DataFrame(
   ...:     {
   ...:         "B": ["B2", "B3", "B6", "B7"],
   ...:         "D": ["D2", "D3", "D6", "D7"],
   ...:         "F": ["F2", "F3", "F6", "F7"],
   ...:     },
   ...:     index=[2, 3, 6, 7],
   ...: )
   ...: 

In [9]: result = pd.concat([df1, df4], axis=1)
# This will merge columns of both the dataframes

Popularity 10/10 Helpfulness 4/10 Language python

Source: pandas.pydata.org

Tags: concat co

Link to this answer
Share Copy Link

Contributed on Jun 02 2021

Friendly Falcon

0 Answers Avg Quality 2/10

How to Concatenate Dataframe in python

Comment

# Stack the DataFrames on top of each other
vertical_stack = pd.concat([survey_sub, survey_sub_last10], axis=0)

# Place the DataFrames side by side
horizontal_stack = pd.concat([survey_sub, survey_sub_last10], axis=1)

Popularity 10/10 Helpfulness 4/10 Language python

Source: datacarpentry.org

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Jun 28 2022

DON-PECH

0 Answers Avg Quality 2/10

how to concat on the basis of particular columns in pandas

Comment

In [6]: result = pd.concat(frames, keys=['x', 'y', 'z'])

Popularity 10/10 Helpfulness 3/10 Language python

Source: pandas.pydata.org

Tags: basis basi

Link to this answer
Share Copy Link

Contributed on Dec 01 2020

Lovely Lemur

0 Answers Avg Quality 2/10

Adding new column to existing DataFrame in Pandas using concat method

Comment

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'team': ['India', 'South Africa', 'New Zealand', 'England'],
                   'points': [10, 8, 3, 5],
                   'runrate': [0.5, 1.4, 2, -0.6],
                   'wins': [5, 4, 2, 2]})

# print the DataFrame
print(df)

# create a new DataFrame
df2 = pd.DataFrame([[1, 2], [2, 1], [3, 4], [0, 3]],
                   columns=['matches_left', 'lost'])

# concat and Print the new DataFrame
print(pd.concat([df, df2], axis=1))

Popularity 9/10 Helpfulness 3/10 Language python

Source: itsmycode.com

Tags: concat co

Link to this answer
Share Copy Link

Contributed on Jan 24 2022

Gorgeous Gazelle

0 Answers Avg Quality 2/10

dataframe concatenate

Comment

# Pandas for Python

df['col1 & col2'] = df['col1']+df['col2']

#Output
#col1	col2	col1 & col2
#A1		A2		A1A2
#B1		B2		B1B2

Popularity 10/10 Helpfulness 2/10 Language python

Source: Grepper

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Apr 17 2020

MelCode

0 Answers Avg Quality 2/10

concatenate dataframes using one column

Contents

More Related Answers