pandas、numpy篇——拼接

numpy

np.concatenate((nd1,nd2),axis=0)

np.vstack((nd1,nd2))沿着axis0
np.hstack()沿着axis1
np.split(nd1,[1,3]，axis=0)，返回nd[:1],nd[1:3],nd[3:]
np.split(nd,3),分成三份
np.r_[]axis=0 同pd.concat
np.c_[]axis=1 同pd.merge

pandas

pd.concat([df1,df2], axis=0, join='outer', join_axes=None, ignore_index=False,keys=None, levels=None, names=None, verify_integrity=False)
aixs=0跨行拼接
join='inner'交集
join_index=[df1.index]左连接
ignore_index=True 无视index，只考虑columns，合并后重新定义index

df.append(df) 默认axis=0

pd.merge(left, right, how='inner', on=None, left_on=None, right_on=None,left_index=False, right_index=False, sort=True,         suffixes=('_x', '_y'), copy=True, indicator=False, validate=None)
how='left' 'inner'左连接 交集
on=['column1','column2']列数据相等

left.join(right, on=key_or_keys)
pd.merge(left, right, left_on=key_or_keys, right_index=True,
      how='left', sort=False)