Question:
Python: Form a group based on nearest days of previous and next weeks?

Solution:

To build masks for>> >np.select try using the weekly period (>to_datetime+>to_period):


s = pd.to_datetime(df['DATE']).dt.to_period('W')


m1 = ~s.isin(s.add(1))

m2 = ~s.isin(s.sub(1))


df['MISSING'] = np.select([m1, m2], ['TAIL', 'HEAD'], 'NONE')


The best thing is that you can choose the way to>> >anchor your weekly periods.


Output:

                          DATE  WEEK MISSING

0    Tuesday, November 7, 2023    45    TAIL

1  Wednesday, November 8, 2023    45    TAIL

2   Thursday, November 9, 2023    45    TAIL

3    Friday, November 10, 2023    45    TAIL

4    Monday, November 13, 2023    46    NONE

5    Friday, November 17, 2023    46    NONE

6    Sunday, November 19, 2023    46    NONE

7    Monday, November 20, 2023    47    HEAD

8  Thursday, November 23, 2023    47    HEAD

9    Friday, November 24, 2023    47    HEAD


Intermediates:

                          DATE  WEEK MISSING                      s     m1     m2

0    Tuesday, November 7, 2023    45    TAIL  2023-11-06/2023-11-12   True  False

1  Wednesday, November 8, 2023    45    TAIL  2023-11-06/2023-11-12   True  False

2   Thursday, November 9, 2023    45    TAIL  2023-11-06/2023-11-12   True  False

3    Friday, November 10, 2023    45    TAIL  2023-11-06/2023-11-12   True  False

4    Monday, November 13, 2023    46    NONE  2023-11-13/2023-11-19  False  False

5    Friday, November 17, 2023    46    NONE  2023-11-13/2023-11-19  False  False

6    Sunday, November 19, 2023    46    NONE  2023-11-13/2023-11-19  False  False

7    Monday, November 20, 2023    47    HEAD  2023-11-20/2023-11-26  False   True

8  Thursday, November 23, 2023    47    HEAD  2023-11-20/2023-11-26  False   True

9    Friday, November 24, 2023    47    HEAD  2023-11-20/2023-11-26  False   True


Suggested blogs:

>How can you read a Blob in Deno in TypeScript?

>How to do Yup validation in form with TypeScript?

>How can I merge two arrays of objects that can be undefined in TypeScript?

>Javascript Error Solved: Property 'id' does not exist on type 'T'

>How to make sticky div remain stuck in JavaScript?

>How to manipulate manipulating Array object in JavaScript?

>How to do light and dark mode in a website using HTML and JavaScript?

>How to fix mouseover event glitch in JavaScript?


Nisha Patel

Nisha Patel

Submit
0 Answers