I want to find out whether it is day or night from the "timestamp" column in my data frame. The time stamp columns have values as follows:
20:0 , 14:30, 6:15, 5:0, 4:0 etc.
I used a for loop but it randomly generated day and night.
for x in data['timestamp']:
if x> '12:00':
print('Day')
else:
print('Night')
I want a column beside my timestamp column which has values as "Day" whenever the timestamp is between 6:00am to 18:00 and "Night" when the timestamp is between 18:01 to 5:59 am.
解决方案timestamp = ['6:00', '18:00', '18:01', '5:59']
for time in timestamp:
hourMin = time.split(":")
hour = int(hourMin[0])
mint = int(hourMin[1])
if hour>= 6 and hour <= 18:
if(hour == 18):
if(mint > 0):
print("Night\n")
else:
print("Day\n")
else:
print("Day\n")
else:
print("Night\n")