mercredi 22 avril 2020

Repeating the pattern of Numbers thrice in a month

I want to distribute the numbers preset in the list in whole month

a) Given a Holiday list, I want to dynamically assign '1' on the holiday date and '0' for working day .

eg.

Holiday_List = ['2020-01-01','2020-01-05','2020-01-12','2020-01-19','2020-01-26']
Start_date = datetime.datetime(year=2020, month =1 , day=1)
end_date = datetime.datetime(year =2020,month =1,day=28 )

Below is the outpput I am looking for in dataframe,where 'Date' and 'Holiday' are columns.

Date        Holiday
01-01-2020  1
02-01-2020  0
03-01-2020  0
04-01-2020  0
05-01-2020  1
06-01-2020  0
07-01-2020  0
08-01-2020  0
09-01-2020  0
10-01-2020  0
11-01-2020  0
12-01-2020  1
13-01-2020  0
14-01-2020  0
15-01-2020  0
16-01-2020  0
17-01-2020  0
18-01-2020  0
19-01-2020  1
20-01-2020  0
21-01-2020  0
22-01-2020  0
23-01-2020  0
24-01-2020  0
25-01-2020  0
26-01-2020  1
27-01-2020  0
28-01-2020  0

B) Given a list of nos like [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18].. I want to break into 3 equal part and store it in 3 different list.

a=[1,2,3,4,5,6],b=[7,8,9,10,11,12], c=[13,14,15,16,17,18]..
sequence should be there like first 6 element in a, sec in 'b' and 3rd in 'c'

C) I want to distribute the above lists a,b,c in whole months such that gap between 1 element of a,b and c should be 8 days only..similarly for others nos. and there is one constraint I cannot assign any no. of holiday.

Below is the final output I am looking for and Here I have assigning dummy value 'NW' to have gap of 8 days between every list.

Date        Holiday Values
01-01-2020  1   Holiday
02-01-2020  0   1
03-01-2020  0   2
04-01-2020  0   3
05-01-2020  1   Holiday
06-01-2020  0   4
07-01-2020  0   5
08-01-2020  0   6
09-01-2020  0   NW
10-01-2020  0   NW
11-01-2020  0   7
12-01-2020  1   Holiday
13-01-2020  0   8
14-01-2020  0   9
15-01-2020  0   10
16-01-2020  0   11
17-01-2020  0   12
18-01-2020  0   NW
19-01-2020  1   Holiday
20-01-2020  0   13
21-01-2020  0   14
22-01-2020  0   15
23-01-2020  0   16
24-01-2020  0   17
25-01-2020  0   18
26-01-2020  1   Holiday
27-01-2020  0   NW
28-01-2020  0   NW

Aucun commentaire:

Enregistrer un commentaire