pandas date_range

最新推荐文章于 2022-06-14 14:55:21 发布

Jalen备忘录

最新推荐文章于 2022-06-14 14:55:21 发布

阅读量199

点赞数

分类专栏： Python

原文链接：https://stackoverflow.com/questions/53844922/pandas-date-range-on-a-weekly-basis-starting-with-a-particular-day-of-the-week

版权

Python 专栏收录该内容

80 篇文章 3 订阅

订阅专栏

def get_date_range():
    from_date_str, to_date_str = '2019-08-01', '2019-09-09'
    df_date_range = pd.date_range(from_date_str, to_date_str)
    df = pd.DataFrame(df_date_range, columns=['Date'])
    df['Date'] = df.apply(lambda x: x['Date'].strftime("%Y-%m-%d"), axis=1)

    from_date_str, to_date_str = '2019-08-01', '2019-09-09'
    df_date_range = pd.date_range(from_date_str, to_date_str, freq='MS')
    df = pd.DataFrame(df_date_range, columns=['Date'])
    df['Date'] = df.apply(lambda x: x['Date'].strftime("%Y-%m"), axis=1)

    from_date_str, to_date_str = '2019-08-01', '2019-09-09'
    df = pd.DataFrame()
    df['monday'] = pd.date_range(from_date_str, to_date_str, freq='W-MON')
    df['sunday'] = pd.date_range(from_date_str, to_date_str, freq='W-SUN')
    df['monday'] = df.apply(lambda x: x['monday'].strftime("%Y-%m-%d"), axis=1)
    df['sunday'] = df.apply(lambda x: x['sunday'].strftime("%Y-%m-%d"), axis=1)


if __name__ == '__main__':
    get_date_range()

参考：

https://stackoverflow.com/questions/53844922/pandas-date-range-on-a-weekly-basis-starting-with-a-particular-day-of-the-week

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.date_range.html