常规代码
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’)