利用pd.date_range()函数选出2019年的周六日（附freq参数枚举）

• freq参数枚举

Alias	Description
B	business day frequency
C	custom business day frequency
D	calendar day frequency
W	weekly frequency
M	month end frequency
SM	semi-month end frequency (15th and end of month)
BM	business month end frequency
CBM	custom business month end frequency
MS	month start frequency
SMS	semi-month start frequency (1st and 15th)
BMS	business month start frequency
CBMS	custom business month start frequency
Q	quarter end frequency
BQ	business quarter end frequency
QS	quarter start frequency
BQS	business quarter start frequency
A, Y	year end frequency
BA, BY	business year end frequency
AS, YS	year start frequency
BAS, BYS	business year start frequency
BH	business hour frequency
H	hourly frequency
T, min	minutely frequency
S	secondly frequency
L, ms	milliseconds
U, us	microseconds
N	nanoseconds

import pandas as pd


def weekend():
    """
    :return: 返回一个包含周六日的list
    """
    everyday_list = pd.date_range('2019-01-01', '2019-12-31', freq='D')  # 2019年每天的datatime格式
    date_list = pd.date_range('2019-01-01', '2019-12-31', freq='B')  # 2019年返回工作日datatime格式
    weekend_list = []
    for i in everyday_list:
        if i not in date_list:
            weekend_list.append(str(i))

    return weekend_list


if __name__ == '__main__':
    weekend_list = weekend()
    insert_suffix_list = []
    for i in range(0, len(weekend_list)):
        if i%2 == 0:
            # 如果是周六
            insert_suffix_i = "(UUID(),'%s','星期六')" % weekend_list[i]
            insert_suffix_list.append(insert_suffix_i)
        else:
            # 如果是周日
            insert_suffix_i = "(UUID(),'%s','星期日')" % weekend_list[i]
            insert_suffix_list.append(insert_suffix_i)

    insert_prefix = "INSERT INTO `holidays_weekend` (id,holidays_weekend_date,remark) VALUES "
    insert_suffix = ",".join(k for k in insert_suffix_list)
    insert_sql = insert_prefix + insert_suffix + ";"

    print insert_sql