目录
一.基本概念
二.内容
9.列操作集锦
A.数据情况
sheet1:
sheet2:
sheet3:
B.两表纵向合并——串联
import pandas as pd
#使输出的列名能够对齐
pd.set_option('display.unicode.ambiguous_as_wide',True)
pd.set_option('display.unicode.east_asian_width',True)
people1=pd.read_excel('D:\python学习\表格/people.xlsx',sheet_name='sheet1')#读取数据1
people2=pd.read_excel('D:\python学习\表格/people.xlsx',sheet_name='sheet2')#读取数据2
people=pd.concat([people1,people2])#纵向合并,为结果1
#若为people=pd.concat([people1,people2]).reset_index(drop=True)则index重新排序,为结果2
print(people)
结果1:
结果2:
B.两表横向合并——并列
import pandas as pd
#使输出的列名能够对齐
pd.set_option('display.unicode.ambiguous_as_wide',True)
pd.set_option('display.unicode.east_asian_width',True)
people1=pd.read_excel('D:\python学习\表格/people.xlsx',sheet_name='sheet1')#读取数据1
people2=pd.read_excel('D:\python学习\表格/people.xls