2024년의 매월 마지막 날만 고르기
df1 = pd.DataFrame(pd.date_range('2024-01-01', '2024-12-31', freq='M'), columns=['DATE'])
df1
DATE
0 2024-01-31
1 2024-02-29
2 2024-03-31
3 2024-04-30
4 2024-05-31
5 2024-06-30
6 2024-07-31
7 2024-08-31
8 2024-09-30
9 2024-10-31
10 2024-11-30
11 2024-12-31
2024년의 매주 토요일 고르기
df2 = pd.DataFrame(pd.date_range('2024-01-01', '2024-12-31', freq='W-SAT'), columns=['DATE'])
df2
DATE
0 2024-01-06
1 2024-01-13
2 2024-01-20
3 2024-01-27
4 2024-02-03
5 2024-02-10
6 2024-02-17
7 2024-02-24
8 2024-03-02
9 2024-03-09
10 2024-03-16
11 2024-03-23
12 2024-03-30
13 2024-04-06
14 2024-04-13
15 2024-04-20
16 2024-04-27
17 2024-05-04
18 2024-05-11
19 2024-05-18
20 2024-05-25
21 2024-06-01
22 2024-06-08
23 2024-06-15
24 2024-06-22
25 2024-06-29
26 2024-07-06
27 2024-07-13
28 2024-07-20
29 2024-07-27
30 2024-08-03
31 2024-08-10
32 2024-08-17
33 2024-08-24
34 2024-08-31
35 2024-09-07
36 2024-09-14
37 2024-09-21
38 2024-09-28
39 2024-10-05
40 2024-10-12
41 2024-10-19
42 2024-10-26
43 2024-11-02
44 2024-11-09
45 2024-11-16
46 2024-11-23
47 2024-11-30
48 2024-12-07
49 2024-12-14
50 2024-12-21
51 2024-12-28
2024년의 매월 마지막 영업일 (주말이면 앞으로 이동함)
df4 = pd.DataFrame(pd.date_range('2024-01-01', '2024-12-31', freq='BM'), columns=['DATE'])
df4
DATE
0 2024-01-31
1 2024-02-29
2 2024-03-29
3 2024-04-30
4 2024-05-31
5 2024-06-28
6 2024-07-31
7 2024-08-30
8 2024-09-30
9 2024-10-31
10 2024-11-29
11 2024-12-31
20204년의 매월 마지막날과 매월 마지막 영업일 비교
df5 = pd.concat([df1, df4], axis=1)
df5.columns = ['df1_name', 'df4_name']
df5['same'] = df5.df1_name == df5.df4_name
df5
df1_name df4_name same
0 2024-01-31 2024-01-31 True
1 2024-02-29 2024-02-29 True
2 2024-03-31 2024-03-29 False
3 2024-04-30 2024-04-30 True
4 2024-05-31 2024-05-31 True
5 2024-06-30 2024-06-28 False
6 2024-07-31 2024-07-31 True
7 2024-08-31 2024-08-30 False
8 2024-09-30 2024-09-30 True
9 2024-10-31 2024-10-31 True
10 2024-11-30 2024-11-29 False
11 2024-12-31 2024-12-31 True
