In [1]:
import pandas as pd
In [2]:
df1 = pd.DataFrame({'A': ['A1', 'A2', 'A3'],
'B': ['B1', 'B2', 'B3'],
'C': ['C1', 'C2', 'C3']},
index=['ONE', 'TWO', 'THREE'])
print(df1)
In [3]:
df2 = pd.DataFrame({'C': ['C2', 'C3', 'C4'],
'D': ['D2', 'D3', 'D4']},
index=['TWO', 'THREE', 'FOUR'])
print(df2)
In [4]:
s1 = pd.Series(['X1', 'X2', 'X3'], index=['ONE', 'TWO', 'THREE'], name='X')
print(s1)
In [5]:
s2 = pd.Series(['Y2', 'Y3', 'Y4'], index=['TWO', 'THREE', 'FOUR'], name='Y')
print(s2)
In [6]:
df_concat = pd.concat([df1, df2])
print(df_concat)
In [7]:
df_concat_multi = pd.concat([df1, df2, df1])
print(df_concat_multi)
In [8]:
df_v = pd.concat([df1, df2], axis=0)
print(df_v)
In [9]:
df_h = pd.concat([df1, df2], axis=1)
print(df_h)
In [10]:
df_v_out = pd.concat([df1, df2], join='outer')
print(df_v_out)
In [11]:
df_v_in = pd.concat([df1, df2], join='inner')
print(df_v_in)
In [12]:
df_h_out = pd.concat([df1, df2], axis=1, join='outer')
print(df_h_out)
In [13]:
df_h_in = pd.concat([df1, df2], axis=1, join='inner')
print(df_h_in)
In [14]:
df_concat = pd.concat([df1, df2])
print(df_concat)
In [15]:
print(type(df_concat))
In [16]:
s_v = pd.concat([s1, s2])
print(s_v)
In [17]:
print(type(s_v))
In [18]:
s_h = pd.concat([s1, s2], axis=1)
print(s_h)
In [19]:
print(type(s_h))
In [20]:
s_h_in = pd.concat([s1, s2], axis=1, join='inner')
print(s_h_in)
In [21]:
df_s_h = pd.concat([df1, s2], axis=1)
print(df_s_h)
In [22]:
df_s_h_in = pd.concat([df1, s2], axis=1, join='inner')
print(df_s_h_in)
In [23]:
df_s_v = pd.concat([df1, s2])
print(df_s_v)
In [24]:
df1.loc['FOUR'] = ['A4', 'B4', 'C4']
print(df1)
In [25]:
s = pd.Series(['A5', 'B5', 'C5'], index=df1.columns, name='FIVE')
print(s)
In [26]:
df_append = df1.append(s)
print(df_append)