pandas 数据区域读取和数字填充

一.数据区域读取和数据填充

有时候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