一.数据区域读取和数据填充
有时候excel文件数据杂乱:
用pandas区域读取和填充:
import pandas as pd
from datetime import timedelta,date
data = pd.read_excel("C:/Users/Administrator/Desktop/Books.xlsx",encoding="utf-8",skiprows=3,usecols = "C:F",dtype={"ID":str,"InStore":str,"Date":str})
start = date(2018,1,1)
def add_month(d,md):
yd = md//12
m = d.month + md%12
if m!=12:
yd+=m//12
m = m%12
return date(d.year+yd,m,d.day)
#日期填充函数
for i in data.index:
data["ID"].at[i] = i +1
data["InStore"].at[i] = "YES" if i%2==0 else "NO"
data["Date"].at[i] = add_month(start,i)
data.to_excel("C:/Us