This is Python pandas questions . I am only sending a small part of the CSV file . Just need a very simple script for requirement 4.3 using floordiv( ). Read explanation below

Date	Time Occurred
8/24/19	450
8/30/19	2320
8/25/19	545
11/20/19	350
8/30/19	2100

Requirement 4: (5 points) Create new columns into your data frame:

1. Created a month field from Date field. answered below:

df['Month'] = pd.to_datetime(df['Date']).dt.month 

2. Created a day field from Date field. answer below. answered below

df['Day'] = pd.to_datetime(df['Date']).dt.day

3. Please create an hour field from Time Occurred (can handle *mathematically (arithmetically) or as a string).

• For this I'm asking you (tutor) to use floordiv( ) function.
• The hours before and and after. Please ignore the left column. It was just a counting index

Transcribed Image Text:

OHN3+ 0 1 2 4 When you extract the hours you should get this: OHNM + 0 2 450 2320 545 350 2100 1 23 3 4 43534 21 OHN3+ 0 1 2 4 When you extract the hours you should get this: OHNM + 0 2 450 2320 545 350 2100 1 23 3 4 43534 21