PYTHON

pandas join two columns

df['FullName'] = df[['First_Name', 'Last_Name']].agg('-'.join, axis=1)

merge two dataframes based on column

df_outer = pd.merge(df1, df2, on='id', how='outer') #here id is common column

df_outer

pd merge on multiple columns

new_df = pd.merge(A_df, B_df,  how='left', left_on=['A_c1','c2'], right_on = ['B_c1','c2'])

plotting two columns of a dataframe in python

df.plot(x='col_name_1', y='col_name_2', style='o')

merge three dataframes pandas based on column

# Merging 3 or more dataframes base on a common column
import pandas as pd
from functools import reduce

#Create a list of df to combine
list_of_df = [df_1,df_2,df_3]

#merge them together
df_combined = reduce(lambda left,right: pd.merge(left,right,on='common column'), list_of_df)

combine dataframes with two matching columns

merged_df = DF2.merge(DF1, how = 'inner', on = ['date', 'hours'])

merge two dataframes based on column

df_merge_col = pd.merge(df_row, df3, on='id')

df_merge_col

pandas merge two columns from different dataframes

#suppose you have two dataframes df1 and df2, and 
#you need to merge them along the column id
df_merge_col = pd.merge(df1, df2, on='id')

how to merge two pandas dataframes on a column

import pandas as pd
T1 = pd.merge(T1, T2, on=T1.index, how='outer')

merge two columns pandas

df["period"] = df["Year"] + df["quarter"]

how to join two dataframe in pandas based on two column

merged_df = left_df.merge(right_df, how='inner', left_on=["A", "B"], right_on=["A2","B2"])

merge two columns name in one header pandas

df['A'] = df[a_cols].apply(' '.join, axis=1)

how to merge two column pandas

DataFrame["new_column"] = DataFrame["column1"] + DataFrame["column2"] 

put two columns together in one column in pandas dataframe

# First dataframe with three columns
dlist=["vx","vy","vz"]
df=pd.DataFrame(columns=dlist)
df["vx"]=df1["v2x"]
df["vy"]=df1["v2y"]
df["vz"]=df1["v2z"]
# second dataframe with three columns
dlist=["vx","vy","vz"]
df0=pd.DataFrame(columns=dlist)
df0["vx"]=df2["v1x"]
df0["vy"]=df2["v1y"]
df0["vz"]=df2["v1z"]
# Here with concat we can create new dataframe with garther both in one
# YOU CAN PUT SOME VALUES IN EACH AND CHECK IT
# WHAT INSIDE THE CONCAT MUST BE A LIST OF DATAFRAME
v = pd.concat([df,df0])