Python——pandas中的concat()函数和append()函数

一、concat()函数

• 拼接多个Series

# 1、按列(axis=0)拼接多个Series，拼接后仍为Series格式
import pandas as pd
# s1 = pd.Series(['a', 'b', 'c'])
# print('s1: \n', s1)
# s2 = pd.Series(['A', 'B', 'C'])
# print('s2: \n', s2)
# # 默认按列(axis=0)拼接多个Series
# data1 = pd.concat([s1, s2])
# print('data1: \n', data1)
# print('data1_type: \n', type(data1))
# 结果为：
s1: 
 0    a
1    b
2    c
dtype: object
s2: 
 0    A
1    B
2    C
dtype: object
data1: 
 0    a
1    b
2    c
0    A
1    B
2    C
dtype: object
data1_type: 
 <class 'pandas.core.series.Series'>

# 2、按行拼接多个Series(即按索引拼接)，拼接后格式为DataFrame格式
# (1)索引相同时
s1 = pd.Series(['a', 'b', 'c'])
print('s1: \n', s1)
s2 = pd.Series(['A', 'B', 'C'])
print('s2: \n', s2)
data2 = pd.concat([s1, s2], axis=1)
print('data2: \n', data2)
print('data2_type: \n', type(data2))
# 结果为：
s1: 
 0    a
1    b
2    c
dtype: object
s2: 
 0    A
1    B
2    C
dtype: object
data2: 
    0  1
0  a  A
1  b  B
2  c  C
data2_type: 
 <class 'pandas.core.frame.DataFrame'>

# (2)索引不同时
# s1 = pd.Series(['a', 'b', 'c'])
# s1.index = ['1', '2', '3']
# print('s1: \n', s1)
# s2 = pd.Series(['A', 'B', 'C'])
# s2.index = ['11', '22', '33']
# print(