import pandas as pd

raw_csv_data = pd.read_csv("Absenteeism-data.csv")

type(raw_csv_data)

pandas.core.frame.DataFrame

raw_csv_data

df = raw_csv_data.copy()

df

pd.options.display.max_columns = None
pd.options.display.max_rows = None

display(df)

df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 700 entries, 0 to 699
Data columns (total 11 columns):
 #   Column                     Non-Null Count  Dtype  
---  ------                     --------------  -----  
 0   Reason for Absence         700 non-null    int64  
 1   Date                       700 non-null    object 
 2   Transportation Expense     700 non-null    int64  
 3   Distance to Work           700 non-null    int64  
 4   Age                        700 non-null    int64  
 5   Daily Work Load Average    700 non-null    float64
 6   Body Mass Index            700 non-null    int64  
 7   Education                  700 non-null    int64  
 8   Children                   700 non-null    int64  
 9   Pets                       700 non-null    int64  
 10  Absenteeism Time in Hours  700 non-null    int64  
dtypes: float64(1), int64(9), object(1)
memory usage: 60.3+ KB

df.drop(['ID'], axis = 1)

df = df.drop(['ID'], axis = 1)

df

raw_csv_data

df['Reason for Absence'].min()

0

df['Reason for Absence'].max()

28

df['Reason for Absence'].value_counts()

Reason for Absence
23    147
28    110
27     66
13     52
0      38
19     36
22     32
26     31
25     29
11     24
10     22
18     21
14     18
1      16
7      13
12      8
21      6
6       6
8       5
9       4
5       3
16      3
24      3
15      2
4       2
3       1
2       1
17      1
Name: count, dtype: int64

df['Reason for Absence'].unique()

array([26,  0, 23,  7, 22, 19,  1, 11, 14, 21, 10, 13, 28, 18, 25, 24,  6,
       27, 17,  8, 12,  5,  9, 15,  4,  3,  2, 16])

len(df['Reason for Absence'].value_counts())

28

df['Reason for Absence'].value_counts().sort_index()

Reason for Absence
0      38
1      16
2       1
3       1
4       2
5       3
6       6
7      13
8       5
9       4
10     22
11     24
12      8
13     52
14     18
15      2
16      3
17      1
18     21
19     36
21      6
22     32
23    147
24      3
25     29
26     31
27     66
28    110
Name: count, dtype: int64

reason_columns = pd.get_dummies(df['Reason for Absence'])

reason_columns

reason_columns['check'] = reason_columns.sum(axis=1)
reason_columns

reason_columns['check'].sum(axis=0)

700

reason_columns['check'].value_counts()

check
1    700
Name: count, dtype: int64

reason_columns = reason_columns.drop(['check'], axis = 1)
reason_columns

reason_columns = reason_columns.drop(0, axis = 1)

reason_columns

df.columns.values

array(['Reason for Absence', 'Date', 'Transportation Expense',
       'Distance to Work', 'Age', 'Daily Work Load Average',
       'Body Mass Index', 'Education', 'Children', 'Pets',
       'Absenteeism Time in Hours'], dtype=object)

reason_columns.columns.values

array([1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19,
       21, 22, 23, 24, 25, 26, 27, 28], dtype=object)

df = df.drop(['Reason for Absence'], axis = 1)

df

reason_columns.loc[:, 1:14].max(axis=1)

0      False
1      False
2      False
3       True
4      False
5      False
6      False
7      False
8      False
9      False
10      True
11      True
12      True
13      True
14     False
15      True
16     False
17     False
18      True
19     False
20      True
21      True
22      True
23     False
24     False
25     False
26     False
27     False
28     False
29     False
30     False
31     False
32     False
33     False
34     False
35     False
36     False
37      True
38     False
39     False
40     False
41     False
42     False
43     False
44     False
45     False
46     False
47     False
48     False
49      True
50     False
51     False
52     False
53     False
54     False
55     False
56     False
57     False
58     False
59     False
60     False
61     False
62     False
63     False
64     False
65     False
66     False
67     False
68     False
69     False
70     False
71     False
72     False
73     False
74     False
75      True
76     False
77     False
78     False
79     False
80     False
81     False
82      True
83     False
84     False
85      True
86     False
87      True
88     False
89      True
90     False
91     False
92      True
93     False
94     False
95     False
96      True
97     False
98     False
99     False
100    False
101    False
102    False
103    False
104    False
105    False
106    False
107    False
108    False
109    False
110    False
111    False
112    False
113    False
114    False
115    False
116    False
117    False
118    False
119    False
120    False
121    False
122    False
123    False
124    False
125    False
126    False
127    False
128    False
129    False
130    False
131    False
132    False
133    False
134    False
135    False
136    False
137    False
138     True
139     True
140    False
141    False
142    False
143    False
144     True
145     True
146    False
147    False
148    False
149    False
150    False
151    False
152    False
153    False
154    False
155    False
156    False
157    False
158    False
159    False
160     True
161     True
162     True
163     True
164     True
165     True
166    False
167     True
168     True
169     True
170    False
171    False
172     True
173     True
174    False
175     True
176     True
177     True
178     True
179     True
180     True
181    False
182     True
183    False
184    False
185    False
186    False
187     True
188    False
189    False
190    False
191     True
192    False
193    False
194     True
195    False
196    False
197    False
198    False
199     True
200    False
201     True
202     True
203    False
204     True
205    False
206    False
207    False
208    False
209     True
210    False
211     True
212     True
213    False
214    False
215    False
216    False
217     True
218     True
219    False
220    False
221    False
222     True
223    False
224     True
225     True
226    False
227     True
228     True
229     True
230    False
231     True
232    False
233     True
234    False
235    False
236    False
237     True
238     True
239    False
240    False
241    False
242    False
243     True
244     True
245    False
246    False
247    False
248    False
249    False
250    False
251    False
252    False
253    False
254    False
255    False
256     True
257     True
258    False
259    False
260    False
261     True
262    False
263     True
264    False
265    False
266    False
267    False
268     True
269     True
270     True
271    False
272    False
273    False
274     True
275    False
276    False
277    False
278     True
279     True
280    False
281    False
282    False
283    False
284    False
285    False
286    False
287     True
288     True
289    False
290    False
291    False
292    False
293    False
294    False
295     True
296     True
297    False
298    False
299     True
300    False
301    False
302    False
303    False
304    False
305    False
306    False
307    False
308    False
309    False
310     True
311    False
312    False
313    False
314     True
315     True
316    False
317     True
318    False
319     True
320    False
321    False
322     True
323     True
324    False
325    False
326    False
327     True
328    False
329    False
330     True
331     True
332     True
333    False
334     True
335    False
336    False
337    False
338    False
339     True
340    False
341    False
342    False
343    False
344    False
345     True
346    False
347    False
348    False
349    False
350    False
351    False
352     True
353     True
354    False
355    False
356    False
357    False
358    False
359    False
360    False
361     True
362    False
363    False
364     True
365    False
366    False
367    False
368    False
369    False
370    False
371     True
372    False
373    False
374    False
375    False
376    False
377     True
378    False
379    False
380    False
381    False
382    False
383    False
384     True
385    False
386    False
387     True
388    False
389    False
390    False
391    False
392    False
393    False
394    False
395    False
396    False
397    False
398    False
399    False
400    False
401    False
402    False
403     True
404     True
405    False
406    False
407    False
408    False
409    False
410    False
411    False
412    False
413    False
414    False
415    False
416    False
417    False
418    False
419    False
420     True
421    False
422    False
423    False
424     True
425     True
426    False
427     True
428    False
429    False
430    False
431    False
432     True
433     True
434    False
435    False
436     True
437    False
438    False
439     True
440    False
441    False
442    False
443    False
444    False
445    False
446    False
447     True
448    False
449    False
450    False
451    False
452    False
453    False
454    False
455     True
456    False
457    False
458     True
459     True
460    False
461    False
462     True
463     True
464    False
465    False
466    False
467    False
468    False
469    False
470    False
471     True
472    False
473    False
474    False
475    False
476    False
477    False
478    False
479    False
480    False
481    False
482    False
483    False
484    False
485    False
486    False
487    False
488    False
489    False
490    False
491    False
492    False
493    False
494    False
495    False
496    False
497    False
498    False
499    False
500    False
501    False
502    False
503    False
504    False
505    False
506    False
507     True
508     True
509    False
510     True
511    False
512    False
513    False
514    False
515    False
516    False
517    False
518    False
519    False
520    False
521     True
522    False
523     True
524     True
525     True
526     True
527    False
528     True
529     True
530    False
531     True
532    False
533    False
534     True
535    False
536     True
537    False
538     True
539    False
540    False
541    False
542     True
543     True
544    False
545    False
546     True
547    False
548    False
549    False
550     True
551    False
552    False
553    False
554    False
555     True
556    False
557    False
558     True
559    False
560    False
561     True
562    False
563    False
564    False
565     True
566    False
567    False
568    False
569    False
570     True
571     True
572    False
573    False
574     True
575    False
576     True
577    False
578    False
579    False
580    False
581    False
582     True
583    False
584    False
585     True
586    False
587     True
588    False
589    False
590    False
591    False
592    False
593    False
594    False
595    False
596     True
597    False
598    False
599    False
600     True
601    False
602    False
603     True
604    False
605    False
606     True
607    False
608    False
609    False
610    False
611     True
612    False
613    False
614    False
615    False
616    False
617    False
618    False
619    False
620    False
621    False
622     True
623    False
624    False
625    False
626    False
627    False
628    False
629    False
630     True
631    False
632    False
633    False
634     True
635     True
636    False
637     True
638    False
639    False
640    False
641    False
642    False
643    False
644    False
645    False
646    False
647    False
648     True
649    False
650    False
651     True
652    False
653    False
654     True
655     True
656    False
657    False
658     True
659    False
660     True
661    False
662    False
663    False
664     True
665    False
666    False
667    False
668    False
669    False
670    False
671    False
672     True
673    False
674    False
675    False
676    False
677     True
678    False
679     True
680    False
681     True
682    False
683    False
684    False
685    False
686     True
687    False
688    False
689    False
690    False
691    False
692     True
693     True
694    False
695     True
696     True
697     True
698    False
699    False
dtype: bool

reason_type_1 = reason_columns.loc[:, 1:14].max(axis=1)
reason_type_2 = reason_columns.loc[:, 15:17].max(axis=1)
reason_type_3 = reason_columns.loc[:, 18:21].max(axis=1)
reason_type_4 = reason_columns.loc[:, 22:].max(axis=1)

reason_type_3

0      False
1      False
2      False
3      False
4      False
5      False
6      False
7      False
8       True
9      False
10     False
11     False
12     False
13     False
14     False
15     False
16     False
17      True
18     False
19     False
20     False
21     False
22     False
23     False
24      True
25     False
26     False
27     False
28      True
29     False
30      True
31      True
32     False
33      True
34     False
35     False
36     False
37     False
38     False
39     False
40     False
41     False
42     False
43      True
44     False
45     False
46     False
47     False
48     False
49     False
50     False
51     False
52     False
53     False
54     False
55     False
56      True
57     False
58     False
59     False
60     False
61     False
62     False
63     False
64     False
65     False
66     False
67     False
68     False
69     False
70     False
71     False
72     False
73     False
74      True
75     False
76     False
77     False
78     False
79     False
80     False
81     False
82     False
83      True
84     False
85     False
86     False
87     False
88     False
89     False
90     False
91      True
92     False
93     False
94     False
95     False
96     False
97     False
98     False
99      True
100    False
101    False
102    False
103    False
104     True
105    False
106    False
107    False
108    False
109    False
110    False
111     True
112    False
113    False
114     True
115    False
116     True
117    False
118    False
119    False
120    False
121    False
122    False
123    False
124    False
125    False
126    False
127    False
128    False
129     True
130     True
131    False
132    False
133    False
134    False
135    False
136    False
137    False
138    False
139    False
140    False
141    False
142    False
143    False
144    False
145    False
146    False
147    False
148    False
149    False
150    False
151     True
152    False
153    False
154     True
155    False
156     True
157     True
158    False
159    False
160    False
161    False
162    False
163    False
164    False
165    False
166    False
167    False
168    False
169    False
170    False
171    False
172    False
173    False
174    False
175    False
176    False
177    False
178    False
179    False
180    False
181    False
182    False
183    False
184    False
185    False
186    False
187    False
188    False
189    False
190    False
191    False
192    False
193    False
194    False
195    False
196    False
197     True
198     True
199    False
200     True
201    False
202    False
203    False
204    False
205    False
206    False
207     True
208     True
209    False
210    False
211    False
212    False
213    False
214    False
215    False
216    False
217    False
218    False
219    False
220     True
221    False
222    False
223    False
224    False
225    False
226    False
227    False
228    False
229    False
230    False
231    False
232    False
233    False
234    False
235    False
236     True
237    False
238    False
239    False
240    False
241     True
242    False
243    False
244    False
245    False
246    False
247    False
248    False
249     True
250     True
251    False
252     True
253     True
254    False
255     True
256    False
257    False
258    False
259    False
260    False
261    False
262    False
263    False
264    False
265    False
266    False
267     True
268    False
269    False
270    False
271    False
272     True
273    False
274    False
275    False
276    False
277    False
278    False
279    False
280    False
281    False
282    False
283    False
284    False
285    False
286    False
287    False
288    False
289    False
290    False
291    False
292    False
293    False
294    False
295    False
296    False
297    False
298    False
299    False
300    False
301     True
302    False
303    False
304    False
305    False
306    False
307    False
308    False
309    False
310    False
311    False
312    False
313    False
314    False
315    False
316    False
317    False
318    False
319    False
320    False
321    False
322    False
323    False
324    False
325    False
326     True
327    False
328    False
329    False
330    False
331    False
332    False
333    False
334    False
335    False
336    False
337    False
338    False
339    False
340    False
341    False
342    False
343    False
344    False
345    False
346    False
347    False
348    False
349    False
350    False
351    False
352    False
353    False
354    False
355    False
356    False
357     True
358    False
359     True
360    False
361    False
362    False
363    False
364    False
365    False
366    False
367    False
368    False
369    False
370    False
371    False
372    False
373    False
374    False
375    False
376    False
377    False
378    False
379    False
380    False
381    False
382    False
383    False
384    False
385    False
386    False
387    False
388    False
389    False
390     True
391     True
392    False
393    False
394    False
395    False
396    False
397    False
398    False
399    False
400    False
401     True
402    False
403    False
404    False
405    False
406    False
407    False
408    False
409    False
410     True
411    False
412    False
413    False
414    False
415    False
416    False
417    False
418    False
419    False
420    False
421    False
422    False
423    False
424    False
425    False
426    False
427    False
428    False
429    False
430    False
431    False
432    False
433    False
434     True
435    False
436    False
437    False
438    False
439    False
440    False
441    False
442    False
443    False
444    False
445    False
446    False
447    False
448    False
449    False
450    False
451    False
452    False
453    False
454    False
455    False
456     True
457    False
458    False
459    False
460    False
461    False
462    False
463    False
464    False
465    False
466    False
467    False
468    False
469    False
470    False
471    False
472    False
473    False
474    False
475    False
476    False
477    False
478    False
479    False
480    False
481    False
482    False
483    False
484    False
485    False
486    False
487    False
488    False
489    False
490    False
491    False
492    False
493    False
494    False
495    False
496    False
497    False
498    False
499    False
500    False
501    False
502    False
503    False
504    False
505    False
506    False
507    False
508    False
509    False
510    False
511    False
512    False
513    False
514    False
515    False
516    False
517    False
518    False
519    False
520    False
521    False
522    False
523    False
524    False
525    False
526    False
527    False
528    False
529    False
530    False
531    False
532     True
533    False
534    False
535    False
536    False
537    False
538    False
539    False
540    False
541    False
542    False
543    False
544    False
545    False
546    False
547    False
548    False
549    False
550    False
551    False
552    False
553    False
554    False
555    False
556    False
557    False
558    False
559    False
560    False
561    False
562     True
563    False
564     True
565    False
566    False
567    False
568    False
569     True
570    False
571    False
572    False
573    False
574    False
575    False
576    False
577     True
578    False
579     True
580    False
581    False
582    False
583    False
584    False
585    False
586    False
587    False
588    False
589    False
590    False
591    False
592    False
593    False
594     True
595    False
596    False
597    False
598    False
599    False
600    False
601    False
602    False
603    False
604    False
605    False
606    False
607    False
608    False
609    False
610    False
611    False
612    False
613    False
614    False
615    False
616    False
617    False
618    False
619    False
620    False
621    False
622    False
623    False
624    False
625    False
626    False
627    False
628    False
629     True
630    False
631    False
632    False
633    False
634    False
635    False
636    False
637    False
638    False
639    False
640    False
641    False
642    False
643    False
644    False
645    False
646    False
647    False
648    False
649    False
650    False
651    False
652     True
653    False
654    False
655    False
656     True
657     True
658    False
659    False
660    False
661    False
662    False
663    False
664    False
665    False
666    False
667     True
668    False
669    False
670    False
671     True
672    False
673    False
674    False
675     True
676    False
677    False
678    False
679    False
680    False
681    False
682     True
683    False
684    False
685    False
686    False
687    False
688    False
689    False
690    False
691    False
692    False
693    False
694    False
695    False
696    False
697    False
698    False
699    False
dtype: bool

df

df = pd.concat([df, reason_type_1, reason_type_2, reason_type_3, reason_type_4], axis = 1)
df

df.columns.values

array(['Date', 'Transportation Expense', 'Distance to Work', 'Age',
       'Daily Work Load Average', 'Body Mass Index', 'Education',
       'Children', 'Pets', 'Absenteeism Time in Hours', 0, 1, 2, 3],
      dtype=object)

df.rename(columns = {0:'Reason_1',1:'Reason_2',2:'Reason_3', 3: 'Reason_4'})

df = df.rename(columns = {0:'Reason_1',1:'Reason_2',2:'Reason_3', 3: 'Reason_4'})

df.head()

column_names_reordered = ['Reason_1', 'Reason_2', 'Reason_3', 'Reason_4', 
                          'Date', 'Transportation Expense', 'Distance to Work', 'Age',
       'Daily Work Load Average', 'Body Mass Index', 'Education',
       'Children', 'Pets', 'Absenteeism Time in Hours']

df.reindex(columns = column_names_reordered)

df = df.reindex(columns = column_names_reordered)

df_reason_mod = df.copy()

df_reason_mod

type(df_reason_mod['Date'][0])

str

df_reason_mod['Date']

0      07/07/2015
1      14/07/2015
2      15/07/2015
3      16/07/2015
4      23/07/2015
5      10/07/2015
6      17/07/2015
7      24/07/2015
8      06/07/2015
9      13/07/2015
10     20/07/2015
11     14/07/2015
12     15/07/2015
13     15/07/2015
14     15/07/2015
15     17/07/2015
16     17/07/2015
17     27/07/2015
18     30/07/2015
19     05/08/2015
20     12/08/2015
21     03/08/2015
22     10/08/2015
23     14/08/2015
24     17/08/2015
25     24/08/2015
26     04/08/2015
27     12/08/2015
28     19/08/2015
29     28/08/2015
30     17/08/2015
31     27/08/2015
32     27/08/2015
33     17/08/2015
34     17/08/2015
35     17/08/2015
36     04/08/2015
37     20/08/2015
38     21/08/2015
39     28/08/2015
40     01/09/2015
41     07/09/2015
42     01/09/2015
43     08/09/2015
44     09/09/2015
45     13/09/2015
46     14/09/2015
47     24/09/2015
48     04/09/2015
49     14/09/2015
50     21/09/2015
51     28/09/2015
52     08/09/2015
53     15/09/2015
54     22/09/2015
55     29/09/2015
56     16/09/2015
57     23/09/2015
58     30/09/2015
59     11/09/2015
60     18/09/2015
61     25/09/2015
62     06/10/2015
63     13/10/2015
64     14/10/2015
65     15/10/2015
66     16/10/2015
67     16/10/2015
68     06/10/2015
69     14/10/2015
70     21/10/2015
71     22/10/2015
72     21/10/2015
73     21/10/2015
74     22/10/2015
75     13/10/2015
76     20/10/2015
77     21/10/2015
78     23/10/2015
79     30/10/2015
80     05/11/2015
81     04/11/2015
82     05/11/2015
83     12/11/2015
84     19/11/2015
85     02/11/2015
86     09/11/2015
87     16/11/2015
88     18/11/2015
89     20/11/2015
90     18/11/2015
91     25/11/2015
92     20/11/2015
93     27/11/2015
94     02/11/2015
95     10/11/2015
96     11/11/2015
97     26/11/2015
98     01/12/2015
99     01/12/2015
100    02/12/2015
101    02/12/2015
102    03/12/2015
103    04/12/2015
104    08/12/2015
105    09/12/2015
106    10/12/2015
107    11/12/2015
108    15/12/2015
109    16/12/2015
110    11/12/2015
111    18/12/2015
112    18/12/2015
113    06/01/2016
114    04/01/2016
115    05/01/2016
116    05/01/2016
117    06/01/2016
118    07/01/2016
119    07/01/2016
120    08/01/2016
121    11/01/2016
122    12/01/2016
123    12/01/2016
124    13/01/2016
125    14/01/2016
126    15/01/2016
127    11/01/2016
128    12/01/2016
129    12/01/2016
130    12/01/2016
131    13/01/2016
132    21/01/2016
133    28/01/2016
134    25/01/2016
135    26/01/2016
136    28/01/2016
137    05/02/2016
138    03/02/2016
139    10/02/2016
140    11/02/2016
141    11/02/2016
142    12/02/2016
143    12/02/2016
144    08/02/2016
145    09/02/2016
146    15/02/2016
147    09/02/2016
148    16/02/2016
149    23/02/2016
150    25/02/2016
151    15/02/2016
152    16/02/2016
153    17/02/2016
154    25/02/2016
155    01/03/2016
156    01/03/2016
157    08/03/2016
158    15/03/2016
159    16/03/2016
160    02/03/2016
161    03/03/2016
162    04/03/2016
163    04/03/2016
164    07/03/2016
165    14/03/2016
166    21/03/2016
167    22/03/2016
168    24/03/2016
169    24/03/2016
170    25/03/2016
171    25/03/2016
172    28/03/2016
173    29/03/2016
174    30/03/2016
175    28/03/2016
176    28/03/2016
177    29/03/2016
178    30/03/2016
179    30/03/2016
180    17/03/2016
181    18/03/2016
182    25/03/2016
183    28/03/2016
184    06/04/2016
185    13/04/2016
186    12/04/2016
187    13/04/2016
188    14/04/2016
189    15/04/2016
190    15/04/2016
191    06/04/2016
192    07/04/2016
193    08/04/2016
194    08/04/2016
195    22/04/2016
196    29/04/2016
197    29/04/2016
198    26/04/2016
199    27/04/2016
200    27/04/2016
201    28/04/2016
202    08/04/2016
203    04/04/2016
204    04/05/2016
205    05/05/2016
206    02/05/2016
207    03/05/2016
208    03/05/2016
209    11/05/2016
210    09/05/2016
211    10/05/2016
212    04/05/2016
213    11/05/2016
214    18/05/2016
215    25/05/2016
216    25/05/2016
217    24/05/2016
218    11/05/2016
219    27/05/2016
220    06/06/2016
221    13/06/2016
222    14/06/2016
223    16/06/2016
224    17/06/2016
225    13/06/2016
226    20/06/2016
227    27/06/2016
228    29/06/2016
229    03/06/2016
230    07/06/2016
231    08/06/2016
232    09/06/2016
233    10/06/2016
234    20/06/2016
235    30/06/2016
236    05/07/2016
237    06/07/2016
238    08/07/2016
239    08/07/2016
240    12/07/2016
241    14/07/2016
242    15/07/2016
243    18/07/2016
244    19/07/2016
245    18/07/2016
246    19/07/2016
247    20/07/2016
248    21/07/2016
249    11/07/2016
250    14/07/2016
251    21/07/2016
252    04/08/2016
253    11/08/2016
254    07/08/2016
255    08/08/2016
256    10/08/2016
257    10/08/2016
258    11/08/2016
259    08/08/2016
260    09/08/2016
261    10/08/2016
262    10/08/2016
263    10/08/2016
264    14/08/2016
265    15/08/2016
266    17/08/2016
267    24/08/2016
268    08/08/2016
269    30/08/2016
270    05/09/2016
271    09/09/2016
272    07/09/2016
273    08/09/2016
274    12/09/2016
275    13/09/2016
276    13/09/2016
277    13/09/2016
278    14/09/2016
279    14/09/2016
280    15/09/2016
281    16/09/2016
282    16/09/2016
283    14/09/2016
284    15/09/2016
285    15/09/2016
286    16/09/2016
287    26/09/2016
288    26/09/2016
289    05/10/2016
290    05/10/2016
291    05/10/2016
292    06/10/2016
293    06/10/2016
294    06/10/2016
295    12/10/2016
296    12/10/2016
297    12/10/2016
298    14/10/2016
299    14/10/2016
300    14/10/2016
301    15/10/2016
302    16/10/2016
303    16/10/2016
304    19/10/2016
305    19/10/2016
306    20/10/2016
307    20/10/2016
308    22/10/2016
309    22/10/2016
310    26/10/2016
311    27/10/2016
312    27/10/2016
313    27/10/2016
314    28/10/2016
315    28/10/2016
316    29/10/2016
317    07/11/2016
318    07/11/2016
319    08/11/2016
320    11/11/2016
321    14/11/2016
322    14/11/2016
323    14/11/2016
324    14/11/2016
325    15/11/2016
326    16/11/2016
327    16/11/2016
328    17/11/2016
329    17/11/2016
330    18/11/2016
331    18/11/2016
332    21/11/2016
333    22/11/2016
334    23/11/2016
335    25/11/2016
336    25/11/2016
337    29/11/2016
338    24/11/2016
339    05/12/2016
340    05/12/2016
341    05/12/2016
342    05/12/2016
343    06/12/2016
344    09/12/2016
345    15/12/2016
346    15/12/2016
347    16/12/2016
348    20/12/2016
349    20/12/2016
350    22/12/2016
351    23/12/2016
352    20/12/2016
353    20/12/2016
354    21/12/2016
355    19/12/2016
356    19/12/2016
357    19/12/2016
358    04/01/2017
359    09/01/2017
360    09/01/2017
361    03/01/2017
362    03/01/2017
363    09/01/2017
364    11/01/2017
365    16/01/2017
366    16/01/2017
367    25/01/2017
368    27/01/2017
369    07/02/2017
370    01/02/2017
371    01/02/2017
372    03/02/2017
373    10/02/2017
374    17/02/2017
375    13/02/2017
376    15/02/2017
377    16/02/2017
378    16/02/2017
379    17/02/2017
380    13/02/2017
381    13/02/2017
382    21/02/2017
383    21/02/2017
384    22/02/2017
385    22/02/2017
386    24/02/2017
387    24/02/2017
388    22/02/2017
389    24/02/2017
390    07/03/2017
391    08/03/2017
392    10/03/2017
393    10/03/2017
394    13/03/2017
395    13/03/2017
396    14/03/2017
397    14/03/2017
398    20/03/2017
399    22/03/2017
400    22/03/2017
401    23/03/2017
402    24/03/2017
403    28/03/2017
404    29/03/2017
405    30/03/2017
406    30/03/2017
407    30/03/2017
408    31/03/2017
409    31/03/2017
410    27/03/2017
411    28/03/2017
412    05/04/2017
413    07/04/2017
414    07/04/2017
415    10/04/2017
416    10/04/2017
417    12/04/2017
418    12/04/2017
419    17/04/2017
420    19/04/2017
421    28/04/2017
422    28/04/2017
423    24/04/2017
424    26/04/2017
425    01/05/2017
426    03/05/2017
427    08/05/2017
428    10/05/2017
429    10/05/2017
430    11/05/2017
431    12/05/2017
432    15/05/2017
433    15/05/2017
434    17/05/2017
435    17/05/2017
436    19/05/2017
437    22/05/2017
438    22/05/2017
439    29/05/2017
440    31/05/2017
441    05/06/2017
442    05/06/2017
443    06/06/2017
444    08/06/2017
445    09/06/2017
446    09/06/2017
447    12/06/2017
448    12/06/2017
449    13/06/2017
450    19/06/2017
451    20/06/2017
452    26/06/2017
453    28/06/2017
454    28/06/2017
455    28/06/2017
456    28/06/2017
457    30/06/2017
458    27/06/2017
459    27/06/2017
460    06/07/2017
461    06/07/2017
462    07/07/2017
463    10/07/2017
464    14/07/2017
465    14/07/2017
466    17/07/2017
467    18/07/2017
468    24/07/2017
469    24/07/2017
470    25/07/2017
471    25/07/2017
472    25/07/2017
473    28/07/2017
474    28/07/2017
475    24/07/2017
476    24/07/2017
477    25/07/2017
478    27/07/2017
479    27/07/2017
480    03/08/2017
481    07/08/2017
482    08/08/2017
483    08/08/2017
484    08/08/2017
485    08/08/2017
486    10/08/2017
487    14/08/2017
488    15/08/2017
489    17/08/2017
490    22/08/2017
491    22/08/2017
492    22/08/2017
493    24/08/2017
494    28/08/2017
495    05/09/2017
496    05/09/2017
497    05/09/2017
498    05/09/2017
499    07/09/2017
500    08/09/2017
501    08/09/2017
502    11/09/2017
503    13/09/2017
504    18/09/2017
505    19/09/2017
506    26/09/2017
507    05/10/2017
508    05/10/2017
509    06/10/2017
510    11/10/2017
511    11/10/2017
512    17/10/2017
513    19/10/2017
514    20/10/2017
515    24/10/2017
516    24/10/2017
517    24/10/2017
518    24/10/2017
519    24/10/2017
520    25/10/2017
521    25/10/2017
522    25/10/2017
523    26/10/2017
524    26/10/2017
525    27/10/2017
526    27/10/2017
527    29/10/2017
528    29/10/2017
529    29/10/2017
530    29/10/2017
531    31/10/2017
532    07/11/2017
533    08/11/2017
534    08/11/2017
535    10/11/2017
536    14/11/2017
537    15/11/2017
538    17/11/2017
539    17/11/2017
540    21/11/2017
541    22/11/2017
542    23/11/2017
543    23/11/2017
544    27/11/2017
545    27/11/2017
546    28/11/2017
547    28/11/2017
548    28/11/2017
549    29/11/2017
550    30/11/2017
551    30/11/2017
552    24/11/2017
553    24/11/2017
554    27/11/2017
555    05/12/2017
556    06/12/2017
557    06/12/2017
558    08/12/2017
559    08/12/2017
560    13/12/2017
561    14/12/2017
562    15/12/2017
563    15/12/2017
564    18/12/2017
565    19/12/2017
566    19/12/2017
567    21/12/2017
568    18/12/2017
569    19/12/2017
570    01/01/2018
571    04/01/2018
572    04/01/2018
573    05/01/2018
574    08/01/2018
575    10/01/2018
576    11/01/2018
577    12/01/2018
578    15/01/2018
579    16/01/2018
580    17/01/2018
581    17/01/2018
582    17/01/2018
583    18/01/2018
584    26/01/2018
585    06/02/2018
586    06/02/2018
587    07/02/2018
588    07/02/2018
589    08/02/2018
590    08/02/2018
591    08/02/2018
592    09/02/2018
593    09/02/2018
594    12/02/2018
595    12/02/2018
596    13/02/2018
597    14/02/2018
598    15/02/2018
599    15/02/2018
600    15/02/2018
601    16/02/2018
602    16/02/2018
603    21/02/2018
604    21/02/2018
605    21/02/2018
606    22/02/2018
607    23/02/2018
608    26/02/2018
609    26/02/2018
610    26/02/2018
611    26/02/2018
612    27/02/2018
613    27/02/2018
614    27/02/2018
615    28/02/2018
616    22/02/2018
617    23/02/2018
618    05/03/2018
619    05/03/2018
620    06/03/2018
621    06/03/2018
622    06/03/2018
623    07/03/2018
624    08/03/2018
625    08/03/2018
626    08/03/2018
627    09/03/2018
628    12/03/2018
629    12/03/2018
630    13/03/2018
631    14/03/2018
632    15/03/2018
633    16/03/2018
634    19/03/2018
635    19/03/2018
636    19/03/2018
637    19/03/2018
638    20/03/2018
639    21/03/2018
640    21/03/2018
641    21/03/2018
642    22/03/2018
643    22/03/2018
644    23/03/2018
645    23/03/2018
646    27/03/2018
647    28/03/2018
648    28/03/2018
649    28/03/2018
650    29/03/2018
651    26/03/2018
652    26/03/2018
653    28/03/2018
654    02/04/2018
655    02/04/2018
656    03/04/2018
657    04/04/2018
658    05/04/2018
659    06/04/2018
660    09/04/2018
661    10/04/2018
662    10/04/2018
663    10/04/2018
664    11/04/2018
665    13/04/2018
666    13/04/2018
667    16/04/2018
668    17/04/2018
669    20/04/2018
670    24/04/2018
671    26/04/2018
672    26/04/2018
673    27/04/2018
674    07/05/2018
675    09/05/2018
676    09/05/2018
677    09/05/2018
678    09/05/2018
679    10/05/2018
680    10/05/2018
681    10/05/2018
682    11/05/2018
683    11/05/2018
684    11/05/2018
685    14/05/2018
686    15/05/2018
687    15/05/2018
688    15/05/2018
689    16/05/2018
690    16/05/2018
691    18/05/2018
692    21/05/2018
693    21/05/2018
694    23/05/2018
695    23/05/2018
696    23/05/2018
697    24/05/2018
698    24/05/2018
699    31/05/2018
Name: Date, dtype: object

df_reason_mod['Date'] = pd.to_datetime(df_reason_mod['Date'], format = '%d/%m/%Y')

df_reason_mod['Date']

0     2015-07-07
1     2015-07-14
2     2015-07-15
3     2015-07-16
4     2015-07-23
5     2015-07-10
6     2015-07-17
7     2015-07-24
8     2015-07-06
9     2015-07-13
10    2015-07-20
11    2015-07-14
12    2015-07-15
13    2015-07-15
14    2015-07-15
15    2015-07-17
16    2015-07-17
17    2015-07-27
18    2015-07-30
19    2015-08-05
20    2015-08-12
21    2015-08-03
22    2015-08-10
23    2015-08-14
24    2015-08-17
25    2015-08-24
26    2015-08-04
27    2015-08-12
28    2015-08-19
29    2015-08-28
30    2015-08-17
31    2015-08-27
32    2015-08-27
33    2015-08-17
34    2015-08-17
35    2015-08-17
36    2015-08-04
37    2015-08-20
38    2015-08-21
39    2015-08-28
40    2015-09-01
41    2015-09-07
42    2015-09-01
43    2015-09-08
44    2015-09-09
45    2015-09-13
46    2015-09-14
47    2015-09-24
48    2015-09-04
49    2015-09-14
50    2015-09-21
51    2015-09-28
52    2015-09-08
53    2015-09-15
54    2015-09-22
55    2015-09-29
56    2015-09-16
57    2015-09-23
58    2015-09-30
59    2015-09-11
60    2015-09-18
61    2015-09-25
62    2015-10-06
63    2015-10-13
64    2015-10-14
65    2015-10-15
66    2015-10-16
67    2015-10-16
68    2015-10-06
69    2015-10-14
70    2015-10-21
71    2015-10-22
72    2015-10-21
73    2015-10-21
74    2015-10-22
75    2015-10-13
76    2015-10-20
77    2015-10-21
78    2015-10-23
79    2015-10-30
80    2015-11-05
81    2015-11-04
82    2015-11-05
83    2015-11-12
84    2015-11-19
85    2015-11-02
86    2015-11-09
87    2015-11-16
88    2015-11-18
89    2015-11-20
90    2015-11-18
91    2015-11-25
92    2015-11-20
93    2015-11-27
94    2015-11-02
95    2015-11-10
96    2015-11-11
97    2015-11-26
98    2015-12-01
99    2015-12-01
100   2015-12-02
101   2015-12-02
102   2015-12-03
103   2015-12-04
104   2015-12-08
105   2015-12-09
106   2015-12-10
107   2015-12-11
108   2015-12-15
109   2015-12-16
110   2015-12-11
111   2015-12-18
112   2015-12-18
113   2016-01-06
114   2016-01-04
115   2016-01-05
116   2016-01-05
117   2016-01-06
118   2016-01-07
119   2016-01-07
120   2016-01-08
121   2016-01-11
122   2016-01-12
123   2016-01-12
124   2016-01-13
125   2016-01-14
126   2016-01-15
127   2016-01-11
128   2016-01-12
129   2016-01-12
130   2016-01-12
131   2016-01-13
132   2016-01-21
133   2016-01-28
134   2016-01-25
135   2016-01-26
136   2016-01-28
137   2016-02-05
138   2016-02-03
139   2016-02-10
140   2016-02-11
141   2016-02-11
142   2016-02-12
143   2016-02-12
144   2016-02-08
145   2016-02-09
146   2016-02-15
147   2016-02-09
148   2016-02-16
149   2016-02-23
150   2016-02-25
151   2016-02-15
152   2016-02-16
153   2016-02-17
154   2016-02-25
155   2016-03-01
156   2016-03-01
157   2016-03-08
158   2016-03-15
159   2016-03-16
160   2016-03-02
161   2016-03-03
162   2016-03-04
163   2016-03-04
164   2016-03-07
165   2016-03-14
166   2016-03-21
167   2016-03-22
168   2016-03-24
169   2016-03-24
170   2016-03-25
171   2016-03-25
172   2016-03-28
173   2016-03-29
174   2016-03-30
175   2016-03-28
176   2016-03-28
177   2016-03-29
178   2016-03-30
179   2016-03-30
180   2016-03-17
181   2016-03-18
182   2016-03-25
183   2016-03-28
184   2016-04-06
185   2016-04-13
186   2016-04-12
187   2016-04-13
188   2016-04-14
189   2016-04-15
190   2016-04-15
191   2016-04-06
192   2016-04-07
193   2016-04-08
194   2016-04-08
195   2016-04-22
196   2016-04-29
197   2016-04-29
198   2016-04-26
199   2016-04-27
200   2016-04-27
201   2016-04-28
202   2016-04-08
203   2016-04-04
204   2016-05-04
205   2016-05-05
206   2016-05-02
207   2016-05-03
208   2016-05-03
209   2016-05-11
210   2016-05-09
211   2016-05-10
212   2016-05-04
213   2016-05-11
214   2016-05-18
215   2016-05-25
216   2016-05-25
217   2016-05-24
218   2016-05-11
219   2016-05-27
220   2016-06-06
221   2016-06-13
222   2016-06-14
223   2016-06-16
224   2016-06-17
225   2016-06-13
226   2016-06-20
227   2016-06-27
228   2016-06-29
229   2016-06-03
230   2016-06-07
231   2016-06-08
232   2016-06-09
233   2016-06-10
234   2016-06-20
235   2016-06-30
236   2016-07-05
237   2016-07-06
238   2016-07-08
239   2016-07-08
240   2016-07-12
241   2016-07-14
242   2016-07-15
243   2016-07-18
244   2016-07-19
245   2016-07-18
246   2016-07-19
247   2016-07-20
248   2016-07-21
249   2016-07-11
250   2016-07-14
251   2016-07-21
252   2016-08-04
253   2016-08-11
254   2016-08-07
255   2016-08-08
256   2016-08-10
257   2016-08-10
258   2016-08-11
259   2016-08-08
260   2016-08-09
261   2016-08-10
262   2016-08-10
263   2016-08-10
264   2016-08-14
265   2016-08-15
266   2016-08-17
267   2016-08-24
268   2016-08-08
269   2016-08-30
270   2016-09-05
271   2016-09-09
272   2016-09-07
273   2016-09-08
274   2016-09-12
275   2016-09-13
276   2016-09-13
277   2016-09-13
278   2016-09-14
279   2016-09-14
280   2016-09-15
281   2016-09-16
282   2016-09-16
283   2016-09-14
284   2016-09-15
285   2016-09-15
286   2016-09-16
287   2016-09-26
288   2016-09-26
289   2016-10-05
290   2016-10-05
291   2016-10-05
292   2016-10-06
293   2016-10-06
294   2016-10-06
295   2016-10-12
296   2016-10-12
297   2016-10-12
298   2016-10-14
299   2016-10-14
300   2016-10-14
301   2016-10-15
302   2016-10-16
303   2016-10-16
304   2016-10-19
305   2016-10-19
306   2016-10-20
307   2016-10-20
308   2016-10-22
309   2016-10-22
310   2016-10-26
311   2016-10-27
312   2016-10-27
313   2016-10-27
314   2016-10-28
315   2016-10-28
316   2016-10-29
317   2016-11-07
318   2016-11-07
319   2016-11-08
320   2016-11-11
321   2016-11-14
322   2016-11-14
323   2016-11-14
324   2016-11-14
325   2016-11-15
326   2016-11-16
327   2016-11-16
328   2016-11-17
329   2016-11-17
330   2016-11-18
331   2016-11-18
332   2016-11-21
333   2016-11-22
334   2016-11-23
335   2016-11-25
336   2016-11-25
337   2016-11-29
338   2016-11-24
339   2016-12-05
340   2016-12-05
341   2016-12-05
342   2016-12-05
343   2016-12-06
344   2016-12-09
345   2016-12-15
346   2016-12-15
347   2016-12-16
348   2016-12-20
349   2016-12-20
350   2016-12-22
351   2016-12-23
352   2016-12-20
353   2016-12-20
354   2016-12-21
355   2016-12-19
356   2016-12-19
357   2016-12-19
358   2017-01-04
359   2017-01-09
360   2017-01-09
361   2017-01-03
362   2017-01-03
363   2017-01-09
364   2017-01-11
365   2017-01-16
366   2017-01-16
367   2017-01-25
368   2017-01-27
369   2017-02-07
370   2017-02-01
371   2017-02-01
372   2017-02-03
373   2017-02-10
374   2017-02-17
375   2017-02-13
376   2017-02-15
377   2017-02-16
378   2017-02-16
379   2017-02-17
380   2017-02-13
381   2017-02-13
382   2017-02-21
383   2017-02-21
384   2017-02-22
385   2017-02-22
386   2017-02-24
387   2017-02-24
388   2017-02-22
389   2017-02-24
390   2017-03-07
391   2017-03-08
392   2017-03-10
393   2017-03-10
394   2017-03-13
395   2017-03-13
396   2017-03-14
397   2017-03-14
398   2017-03-20
399   2017-03-22
400   2017-03-22
401   2017-03-23
402   2017-03-24
403   2017-03-28
404   2017-03-29
405   2017-03-30
406   2017-03-30
407   2017-03-30
408   2017-03-31
409   2017-03-31
410   2017-03-27
411   2017-03-28
412   2017-04-05
413   2017-04-07
414   2017-04-07
415   2017-04-10
416   2017-04-10
417   2017-04-12
418   2017-04-12
419   2017-04-17
420   2017-04-19
421   2017-04-28
422   2017-04-28
423   2017-04-24
424   2017-04-26
425   2017-05-01
426   2017-05-03
427   2017-05-08
428   2017-05-10
429   2017-05-10
430   2017-05-11
431   2017-05-12
432   2017-05-15
433   2017-05-15
434   2017-05-17
435   2017-05-17
436   2017-05-19
437   2017-05-22
438   2017-05-22
439   2017-05-29
440   2017-05-31
441   2017-06-05
442   2017-06-05
443   2017-06-06
444   2017-06-08
445   2017-06-09
446   2017-06-09
447   2017-06-12
448   2017-06-12
449   2017-06-13
450   2017-06-19
451   2017-06-20
452   2017-06-26
453   2017-06-28
454   2017-06-28
455   2017-06-28
456   2017-06-28
457   2017-06-30
458   2017-06-27
459   2017-06-27
460   2017-07-06
461   2017-07-06
462   2017-07-07
463   2017-07-10
464   2017-07-14
465   2017-07-14
466   2017-07-17
467   2017-07-18
468   2017-07-24
469   2017-07-24
470   2017-07-25
471   2017-07-25
472   2017-07-25
473   2017-07-28
474   2017-07-28
475   2017-07-24
476   2017-07-24
477   2017-07-25
478   2017-07-27
479   2017-07-27
480   2017-08-03
481   2017-08-07
482   2017-08-08
483   2017-08-08
484   2017-08-08
485   2017-08-08
486   2017-08-10
487   2017-08-14
488   2017-08-15
489   2017-08-17
490   2017-08-22
491   2017-08-22
492   2017-08-22
493   2017-08-24
494   2017-08-28
495   2017-09-05
496   2017-09-05
497   2017-09-05
498   2017-09-05
499   2017-09-07
500   2017-09-08
501   2017-09-08
502   2017-09-11
503   2017-09-13
504   2017-09-18
505   2017-09-19
506   2017-09-26
507   2017-10-05
508   2017-10-05
509   2017-10-06
510   2017-10-11
511   2017-10-11
512   2017-10-17
513   2017-10-19
514   2017-10-20
515   2017-10-24
516   2017-10-24
517   2017-10-24
518   2017-10-24
519   2017-10-24
520   2017-10-25
521   2017-10-25
522   2017-10-25
523   2017-10-26
524   2017-10-26
525   2017-10-27
526   2017-10-27
527   2017-10-29
528   2017-10-29
529   2017-10-29
530   2017-10-29
531   2017-10-31
532   2017-11-07
533   2017-11-08
534   2017-11-08
535   2017-11-10
536   2017-11-14
537   2017-11-15
538   2017-11-17
539   2017-11-17
540   2017-11-21
541   2017-11-22
542   2017-11-23
543   2017-11-23
544   2017-11-27
545   2017-11-27
546   2017-11-28
547   2017-11-28
548   2017-11-28
549   2017-11-29
550   2017-11-30
551   2017-11-30
552   2017-11-24
553   2017-11-24
554   2017-11-27
555   2017-12-05
556   2017-12-06
557   2017-12-06
558   2017-12-08
559   2017-12-08
560   2017-12-13
561   2017-12-14
562   2017-12-15
563   2017-12-15
564   2017-12-18
565   2017-12-19
566   2017-12-19
567   2017-12-21
568   2017-12-18
569   2017-12-19
570   2018-01-01
571   2018-01-04
572   2018-01-04
573   2018-01-05
574   2018-01-08
575   2018-01-10
576   2018-01-11
577   2018-01-12
578   2018-01-15
579   2018-01-16
580   2018-01-17
581   2018-01-17
582   2018-01-17
583   2018-01-18
584   2018-01-26
585   2018-02-06
586   2018-02-06
587   2018-02-07
588   2018-02-07
589   2018-02-08
590   2018-02-08
591   2018-02-08
592   2018-02-09
593   2018-02-09
594   2018-02-12
595   2018-02-12
596   2018-02-13
597   2018-02-14
598   2018-02-15
599   2018-02-15
600   2018-02-15
601   2018-02-16
602   2018-02-16
603   2018-02-21
604   2018-02-21
605   2018-02-21
606   2018-02-22
607   2018-02-23
608   2018-02-26
609   2018-02-26
610   2018-02-26
611   2018-02-26
612   2018-02-27
613   2018-02-27
614   2018-02-27
615   2018-02-28
616   2018-02-22
617   2018-02-23
618   2018-03-05
619   2018-03-05
620   2018-03-06
621   2018-03-06
622   2018-03-06
623   2018-03-07
624   2018-03-08
625   2018-03-08
626   2018-03-08
627   2018-03-09
628   2018-03-12
629   2018-03-12
630   2018-03-13
631   2018-03-14
632   2018-03-15
633   2018-03-16
634   2018-03-19
635   2018-03-19
636   2018-03-19
637   2018-03-19
638   2018-03-20
639   2018-03-21
640   2018-03-21
641   2018-03-21
642   2018-03-22
643   2018-03-22
644   2018-03-23
645   2018-03-23
646   2018-03-27
647   2018-03-28
648   2018-03-28
649   2018-03-28
650   2018-03-29
651   2018-03-26
652   2018-03-26
653   2018-03-28
654   2018-04-02
655   2018-04-02
656   2018-04-03
657   2018-04-04
658   2018-04-05
659   2018-04-06
660   2018-04-09
661   2018-04-10
662   2018-04-10
663   2018-04-10
664   2018-04-11
665   2018-04-13
666   2018-04-13
667   2018-04-16
668   2018-04-17
669   2018-04-20
670   2018-04-24
671   2018-04-26
672   2018-04-26
673   2018-04-27
674   2018-05-07
675   2018-05-09
676   2018-05-09
677   2018-05-09
678   2018-05-09
679   2018-05-10
680   2018-05-10
681   2018-05-10
682   2018-05-11
683   2018-05-11
684   2018-05-11
685   2018-05-14
686   2018-05-15
687   2018-05-15
688   2018-05-15
689   2018-05-16
690   2018-05-16
691   2018-05-18
692   2018-05-21
693   2018-05-21
694   2018-05-23
695   2018-05-23
696   2018-05-23
697   2018-05-24
698   2018-05-24
699   2018-05-31
Name: Date, dtype: datetime64[ns]

type(df_reason_mod['Date'])

pandas.core.series.Series

df_reason_mod.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 700 entries, 0 to 699
Data columns (total 14 columns):
 #   Column                     Non-Null Count  Dtype         
---  ------                     --------------  -----         
 0   Reason_1                   700 non-null    bool          
 1   Reason_2                   700 non-null    bool          
 2   Reason_3                   700 non-null    bool          
 3   Reason_4                   700 non-null    bool          
 4   Date                       700 non-null    datetime64[ns]
 5   Transportation Expense     700 non-null    int64         
 6   Distance to Work           700 non-null    int64         
 7   Age                        700 non-null    int64         
 8   Daily Work Load Average    700 non-null    float64       
 9   Body Mass Index            700 non-null    int64         
 10  Education                  700 non-null    int64         
 11  Children                   700 non-null    int64         
 12  Pets                       700 non-null    int64         
 13  Absenteeism Time in Hours  700 non-null    int64         
dtypes: bool(4), datetime64[ns](1), float64(1), int64(8)
memory usage: 57.6 KB

df_reason_mod['Date'][0]

Timestamp('2015-07-07 00:00:00')

df_reason_mod['Date'][0].month

7

list_months = []
list_months

[]

df_reason_mod.shape

(700, 14)

for i in range(df_reason_mod.shape[0]):
    list_months.append(df_reason_mod['Date'][i].month)

list_months

[7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 6,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 7,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 8,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 9,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 10,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 11,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 12,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 1,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 2,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 3,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 4,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5,
 5]

len(list_months)

700

df_reason_mod['Month Value'] = list_months

df_reason_mod.head(20)

df_reason_mod['Date'][699].weekday()

3

df_reason_mod['Date'].dt.day

0       7
1      14
2      15
3      16
4      23
5      10
6      17
7      24
8       6
9      13
10     20
11     14
12     15
13     15
14     15
15     17
16     17
17     27
18     30
19      5
20     12
21      3
22     10
23     14
24     17
25     24
26      4
27     12
28     19
29     28
30     17
31     27
32     27
33     17
34     17
35     17
36      4
37     20
38     21
39     28
40      1
41      7
42      1
43      8
44      9
45     13
46     14
47     24
48      4
49     14
50     21
51     28
52      8
53     15
54     22
55     29
56     16
57     23
58     30
59     11
60     18
61     25
62      6
63     13
64     14
65     15
66     16
67     16
68      6
69     14
70     21
71     22
72     21
73     21
74     22
75     13
76     20
77     21
78     23
79     30
80      5
81      4
82      5
83     12
84     19
85      2
86      9
87     16
88     18
89     20
90     18
91     25
92     20
93     27
94      2
95     10
96     11
97     26
98      1
99      1
100     2
101     2
102     3
103     4
104     8
105     9
106    10
107    11
108    15
109    16
110    11
111    18
112    18
113     6
114     4
115     5
116     5
117     6
118     7
119     7
120     8
121    11
122    12
123    12
124    13
125    14
126    15
127    11
128    12
129    12
130    12
131    13
132    21
133    28
134    25
135    26
136    28
137     5
138     3
139    10
140    11
141    11
142    12
143    12
144     8
145     9
146    15
147     9
148    16
149    23
150    25
151    15
152    16
153    17
154    25
155     1
156     1
157     8
158    15
159    16
160     2
161     3
162     4
163     4
164     7
165    14
166    21
167    22
168    24
169    24
170    25
171    25
172    28
173    29
174    30
175    28
176    28
177    29
178    30
179    30
180    17
181    18
182    25
183    28
184     6
185    13
186    12
187    13
188    14
189    15
190    15
191     6
192     7
193     8
194     8
195    22
196    29
197    29
198    26
199    27
200    27
201    28
202     8
203     4
204     4
205     5
206     2
207     3
208     3
209    11
210     9
211    10
212     4
213    11
214    18
215    25
216    25
217    24
218    11
219    27
220     6
221    13
222    14
223    16
224    17
225    13
226    20
227    27
228    29
229     3
230     7
231     8
232     9
233    10
234    20
235    30
236     5
237     6
238     8
239     8
240    12
241    14
242    15
243    18
244    19
245    18
246    19
247    20
248    21
249    11
250    14
251    21
252     4
253    11
254     7
255     8
256    10
257    10
258    11
259     8
260     9
261    10
262    10
263    10
264    14
265    15
266    17
267    24
268     8
269    30
270     5
271     9
272     7
273     8
274    12
275    13
276    13
277    13
278    14
279    14
280    15
281    16
282    16
283    14
284    15
285    15
286    16
287    26
288    26
289     5
290     5
291     5
292     6
293     6
294     6
295    12
296    12
297    12
298    14
299    14
300    14
301    15
302    16
303    16
304    19
305    19
306    20
307    20
308    22
309    22
310    26
311    27
312    27
313    27
314    28
315    28
316    29
317     7
318     7
319     8
320    11
321    14
322    14
323    14
324    14
325    15
326    16
327    16
328    17
329    17
330    18
331    18
332    21
333    22
334    23
335    25
336    25
337    29
338    24
339     5
340     5
341     5
342     5
343     6
344     9
345    15
346    15
347    16
348    20
349    20
350    22
351    23
352    20
353    20
354    21
355    19
356    19
357    19
358     4
359     9
360     9
361     3
362     3
363     9
364    11
365    16
366    16
367    25
368    27
369     7
370     1
371     1
372     3
373    10
374    17
375    13
376    15
377    16
378    16
379    17
380    13
381    13
382    21
383    21
384    22
385    22
386    24
387    24
388    22
389    24
390     7
391     8
392    10
393    10
394    13
395    13
396    14
397    14
398    20
399    22
400    22
401    23
402    24
403    28
404    29
405    30
406    30
407    30
408    31
409    31
410    27
411    28
412     5
413     7
414     7
415    10
416    10
417    12
418    12
419    17
420    19
421    28
422    28
423    24
424    26
425     1
426     3
427     8
428    10
429    10
430    11
431    12
432    15
433    15
434    17
435    17
436    19
437    22
438    22
439    29
440    31
441     5
442     5
443     6
444     8
445     9
446     9
447    12
448    12
449    13
450    19
451    20
452    26
453    28
454    28
455    28
456    28
457    30
458    27
459    27
460     6
461     6
462     7
463    10
464    14
465    14
466    17
467    18
468    24
469    24
470    25
471    25
472    25
473    28
474    28
475    24
476    24
477    25
478    27
479    27
480     3
481     7
482     8
483     8
484     8
485     8
486    10
487    14
488    15
489    17
490    22
491    22
492    22
493    24
494    28
495     5
496     5
497     5
498     5
499     7
500     8
501     8
502    11
503    13
504    18
505    19
506    26
507     5
508     5
509     6
510    11
511    11
512    17
513    19
514    20
515    24
516    24
517    24
518    24
519    24
520    25
521    25
522    25
523    26
524    26
525    27
526    27
527    29
528    29
529    29
530    29
531    31
532     7
533     8
534     8
535    10
536    14
537    15
538    17
539    17
540    21
541    22
542    23
543    23
544    27
545    27
546    28
547    28
548    28
549    29
550    30
551    30
552    24
553    24
554    27
555     5
556     6
557     6
558     8
559     8
560    13
561    14
562    15
563    15
564    18
565    19
566    19
567    21
568    18
569    19
570     1
571     4
572     4
573     5
574     8
575    10
576    11
577    12
578    15
579    16
580    17
581    17
582    17
583    18
584    26
585     6
586     6
587     7
588     7
589     8
590     8
591     8
592     9
593     9
594    12
595    12
596    13
597    14
598    15
599    15
600    15
601    16
602    16
603    21
604    21
605    21
606    22
607    23
608    26
609    26
610    26
611    26
612    27
613    27
614    27
615    28
616    22
617    23
618     5
619     5
620     6
621     6
622     6
623     7
624     8
625     8
626     8
627     9
628    12
629    12
630    13
631    14
632    15
633    16
634    19
635    19
636    19
637    19
638    20
639    21
640    21
641    21
642    22
643    22
644    23
645    23
646    27
647    28
648    28
649    28
650    29
651    26
652    26
653    28
654     2
655     2
656     3
657     4
658     5
659     6
660     9
661    10
662    10
663    10
664    11
665    13
666    13
667    16
668    17
669    20
670    24
671    26
672    26
673    27
674     7
675     9
676     9
677     9
678     9
679    10
680    10
681    10
682    11
683    11
684    11
685    14
686    15
687    15
688    15
689    16
690    16
691    18
692    21
693    21
694    23
695    23
696    23
697    24
698    24
699    31
Name: Date, dtype: int32

df_reason_mod['Date'].dt.weekday

0      1
1      1
2      2
3      3
4      3
5      4
6      4
7      4
8      0
9      0
10     0
11     1
12     2
13     2
14     2
15     4
16     4
17     0
18     3
19     2
20     2
21     0
22     0
23     4
24     0
25     0
26     1
27     2
28     2
29     4
30     0
31     3
32     3
33     0
34     0
35     0
36     1
37     3
38     4
39     4
40     1
41     0
42     1
43     1
44     2
45     6
46     0
47     3
48     4
49     0
50     0
51     0
52     1
53     1
54     1
55     1
56     2
57     2
58     2
59     4
60     4
61     4
62     1
63     1
64     2
65     3
66     4
67     4
68     1
69     2
70     2
71     3
72     2
73     2
74     3
75     1
76     1
77     2
78     4
79     4
80     3
81     2
82     3
83     3
84     3
85     0
86     0
87     0
88     2
89     4
90     2
91     2
92     4
93     4
94     0
95     1
96     2
97     3
98     1
99     1
100    2
101    2
102    3
103    4
104    1
105    2
106    3
107    4
108    1
109    2
110    4
111    4
112    4
113    2
114    0
115    1
116    1
117    2
118    3
119    3
120    4
121    0
122    1
123    1
124    2
125    3
126    4
127    0
128    1
129    1
130    1
131    2
132    3
133    3
134    0
135    1
136    3
137    4
138    2
139    2
140    3
141    3
142    4
143    4
144    0
145    1
146    0
147    1
148    1
149    1
150    3
151    0
152    1
153    2
154    3
155    1
156    1
157    1
158    1
159    2
160    2
161    3
162    4
163    4
164    0
165    0
166    0
167    1
168    3
169    3
170    4
171    4
172    0
173    1
174    2
175    0
176    0
177    1
178    2
179    2
180    3
181    4
182    4
183    0
184    2
185    2
186    1
187    2
188    3
189    4
190    4
191    2
192    3
193    4
194    4
195    4
196    4
197    4
198    1
199    2
200    2
201    3
202    4
203    0
204    2
205    3
206    0
207    1
208    1
209    2
210    0
211    1
212    2
213    2
214    2
215    2
216    2
217    1
218    2
219    4
220    0
221    0
222    1
223    3
224    4
225    0
226    0
227    0
228    2
229    4
230    1
231    2
232    3
233    4
234    0
235    3
236    1
237    2
238    4
239    4
240    1
241    3
242    4
243    0
244    1
245    0
246    1
247    2
248    3
249    0
250    3
251    3
252    3
253    3
254    6
255    0
256    2
257    2
258    3
259    0
260    1
261    2
262    2
263    2
264    6
265    0
266    2
267    2
268    0
269    1
270    0
271    4
272    2
273    3
274    0
275    1
276    1
277    1
278    2
279    2
280    3
281    4
282    4
283    2
284    3
285    3
286    4
287    0
288    0
289    2
290    2
291    2
292    3
293    3
294    3
295    2
296    2
297    2
298    4
299    4
300    4
301    5
302    6
303    6
304    2
305    2
306    3
307    3
308    5
309    5
310    2
311    3
312    3
313    3
314    4
315    4
316    5
317    0
318    0
319    1
320    4
321    0
322    0
323    0
324    0
325    1
326    2
327    2
328    3
329    3
330    4
331    4
332    0
333    1
334    2
335    4
336    4
337    1
338    3
339    0
340    0
341    0
342    0
343    1
344    4
345    3
346    3
347    4
348    1
349    1
350    3
351    4
352    1
353    1
354    2
355    0
356    0
357    0
358    2
359    0
360    0
361    1
362    1
363    0
364    2
365    0
366    0
367    2
368    4
369    1
370    2
371    2
372    4
373    4
374    4
375    0
376    2
377    3
378    3
379    4
380    0
381    0
382    1
383    1
384    2
385    2
386    4
387    4
388    2
389    4
390    1
391    2
392    4
393    4
394    0
395    0
396    1
397    1
398    0
399    2
400    2
401    3
402    4
403    1
404    2
405    3
406    3
407    3
408    4
409    4
410    0
411    1
412    2
413    4
414    4
415    0
416    0
417    2
418    2
419    0
420    2
421    4
422    4
423    0
424    2
425    0
426    2
427    0
428    2
429    2
430    3
431    4
432    0
433    0
434    2
435    2
436    4
437    0
438    0
439    0
440    2
441    0
442    0
443    1
444    3
445    4
446    4
447    0
448    0
449    1
450    0
451    1
452    0
453    2
454    2
455    2
456    2
457    4
458    1
459    1
460    3
461    3
462    4
463    0
464    4
465    4
466    0
467    1
468    0
469    0
470    1
471    1
472    1
473    4
474    4
475    0
476    0
477    1
478    3
479    3
480    3
481    0
482    1
483    1
484    1
485    1
486    3
487    0
488    1
489    3
490    1
491    1
492    1
493    3
494    0
495    1
496    1
497    1
498    1
499    3
500    4
501    4
502    0
503    2
504    0
505    1
506    1
507    3
508    3
509    4
510    2
511    2
512    1
513    3
514    4
515    1
516    1
517    1
518    1
519    1
520    2
521    2
522    2
523    3
524    3
525    4
526    4
527    6
528    6
529    6
530    6
531    1
532    1
533    2
534    2
535    4
536    1
537    2
538    4
539    4
540    1
541    2
542    3
543    3
544    0
545    0
546    1
547    1
548    1
549    2
550    3
551    3
552    4
553    4
554    0
555    1
556    2
557    2
558    4
559    4
560    2
561    3
562    4
563    4
564    0
565    1
566    1
567    3
568    0
569    1
570    0
571    3
572    3
573    4
574    0
575    2
576    3
577    4
578    0
579    1
580    2
581    2
582    2
583    3
584    4
585    1
586    1
587    2
588    2
589    3
590    3
591    3
592    4
593    4
594    0
595    0
596    1
597    2
598    3
599    3
600    3
601    4
602    4
603    2
604    2
605    2
606    3
607    4
608    0
609    0
610    0
611    0
612    1
613    1
614    1
615    2
616    3
617    4
618    0
619    0
620    1
621    1
622    1
623    2
624    3
625    3
626    3
627    4
628    0
629    0
630    1
631    2
632    3
633    4
634    0
635    0
636    0
637    0
638    1
639    2
640    2
641    2
642    3
643    3
644    4
645    4
646    1
647    2
648    2
649    2
650    3
651    0
652    0
653    2
654    0
655    0
656    1
657    2
658    3
659    4
660    0
661    1
662    1
663    1
664    2
665    4
666    4
667    0
668    1
669    4
670    1
671    3
672    3
673    4
674    0
675    2
676    2
677    2
678    2
679    3
680    3
681    3
682    4
683    4
684    4
685    0
686    1
687    1
688    1
689    2
690    2
691    4
692    0
693    0
694    2
695    2
696    2
697    3
698    3
699    3
Name: Date, dtype: int32

df_reason_mod['Day of the Week'] = df_reason_mod['Date'].dt.weekday

df_reason_mod.head()

df_reason_mod = df_reason_mod.drop(['Date'], axis = 1)
df_reason_mod.head()

df_reason_mod.reindex(columns =column_names_upd)

column_names_upd = ['Reason_1', 'Reason_2', 'Reason_3', 'Reason_4', 'Month Value', 'Day of the Week',
       'Transportation Expense', 'Distance to Work', 'Age',
       'Daily Work Load Average', 'Body Mass Index', 'Education', 'Children',
       'Pets', 'Absenteeism Time in Hours']

df_reason_mod =df_reason_mod.reindex(columns =column_names_upd)
df_reason_mod.head()

df_reason_date_mod = df_reason_mod.copy()

type(df_reason_date_mod['Transportation Expense'][0])

numpy.int64

type(df_reason_date_mod['Distance to Work'][0])

numpy.int64

type(df_reason_date_mod['Age'][0])

numpy.int64

type(df_reason_date_mod['Daily Work Load Average'][0])

numpy.float64

type(df_reason_date_mod['Body Mass Index'][0])

numpy.int64

display(df_reason_date_mod)

df_reason_date_mod['Education'].unique()

array([1, 3, 2, 4])

df_reason_date_mod['Education'].value_counts()

Education
1    583
3     73
2     40
4      4
Name: count, dtype: int64

df_reason_date_mod['Education'] = df_reason_date_mod['Education'].map({1:0, 2:1, 3:1, 4:1})

df_reason_date_mod['Education'].unique()

array([0, 1])

df_reason_date_mod['Education'].value_counts()

Education
0    583
1    117
Name: count, dtype: int64

df_cleaned = df_reason_date_mod.copy()

df_reason_mod.head(5)

df_cleaned.to_csv('df_reason_date_mod.csv')

Drop 'ID':¶

'Reason for Absence':¶

.get_dummies()¶

Group the Reasons for Absence:¶

Concatenate Column Values¶

Reorder Columns¶

Create a Checkpoint¶

'Date':¶

Extract the Month Value:¶

Extract the Day of the Week:¶

Exercise:¶

'Education', 'Children', 'Pets'¶

Final Checkpoint¶

	ID	Reason for Absence	Date	Transportation Expense	Distance to Work	Age	Daily Work Load Average	Body Mass Index	Education	Children	Pets	Absenteeism Time in Hours
0	11	26	07/07/2015	289	36	33	239.554	30	1	2	1	4
1	36	0	14/07/2015	118	13	50	239.554	31	1	1	0	0
2	3	23	15/07/2015	179	51	38	239.554	31	1	0	0	2
3	7	7	16/07/2015	279	5	39	239.554	24	1	2	0	4
4	11	23	23/07/2015	289	36	33	239.554	30	1	2	1	2
...	...	...	...	...	...	...	...	...	...	...	...	...
695	17	10	23/05/2018	179	22	40	237.656	22	2	2	0	8
696	28	6	23/05/2018	225	26	28	237.656	24	1	1	2	3
697	18	10	24/05/2018	330	16	28	237.656	25	2	0	0	8
698	25	23	24/05/2018	235	16	32	237.656	25	3	0	0	2
699	15	28	31/05/2018	291	31	40	237.656	25	1	1	1	2

	Date	Transportation Expense	Distance to Work	Age	Daily Work Load Average	Body Mass Index	Education	Children	Pets	Absenteeism Time in Hours	Reason_1	Reason_2	Reason_3	Reason_4
0	07/07/2015	289	36	33	239.554	30	1	2	1	4	False	False	False	True
1	14/07/2015	118	13	50	239.554	31	1	1	0	0	False	False	False	False
2	15/07/2015	179	51	38	239.554	31	1	0	0	2	False	False	False	True
3	16/07/2015	279	5	39	239.554	24	1	2	0	4	True	False	False	False
4	23/07/2015	289	36	33	239.554	30	1	2	1	2	False	False	False	True