pandas之（二）读取excel

常规代码

import pandas as pd
#读取指定excel表
people=pd.read_excel(“C:/USers/bocom/Desktop/python/pandas/People - 副本.xlsx”)
#打印表属性
print(people.shape)
#打印列
print(people.columns)
#打印前三条数据（带表头共四行）
print(people.head(3))
#打印分隔符
print("+++++++++++++")
#打印扣三条数据（带表头共四行）
print(people.tail(3))

指定index列

#先行指定Index列，避免生成多余index列
people = pd.read_excel(‘C:/USers/bocom/Desktop/python/pandas/People.xlsx’,index.col=‘ID’)

header存在脏数据

#header首行（0）有脏数据，指定读取第一行数据
people=pd.read_excel(“C:/USers/bocom/Desktop/python/pandas/People.xlsx”，header=1)

添加列名(填坑：英文版标点）

#读取表，header设置为空
people = pd.read_excel(‘C:/USers/bocom/Desktop/python/pandas/People.xlsx’,header=None)
#设置列名
people.columns=[‘ID’,‘Type’,‘Title’,‘FirstName’,‘MiddleName’,‘LastName’]
people.set_index(‘ID’,inplace=True)
print(people.columns)
#存入原表
people.to_excel(‘C:/USers/bocom/Desktop/python/pandas/People.xlsx’)