我在python中定义了一个函数,用于提取基于业务的操作时数。_我已经检索到的ID:def hours_operation(business_id):
day = day_open(business_id)
start = day_start(business_id)
end = day_end(business_id)
day1 = []
for i in day:
try:
value = "start"+str(i)
except:
value = 'None'
day1.append(value)
dict1 = {}
for i in range(len(day1)):
dict1[day1[i]]=start[i]
start_df = pd.DataFrame(dict1, index=[0])
day2 = []
for i in day:
day2.append("end"+str(i))
dict2 = {}
for i in range(len(day2)):
dict2[day2[i]]=end[i]
end_df = pd.DataFrame(dict2, index=[0])
for i in day:
start_df['end'+str(i)]=end_df['end'+str(i)]
return start_df
问题是,我的输出如下所示:Out[36]:
start0 start1 start2 start3 start4 ... end2 end3 end4 end5 end6
0 1100 1100 1100 1100 1100 ... 2200 2200 2200 2200 2100
然而,我喜欢这种形式,在一个企业每周只工作4天而不是7天的情况下。我希望它作为N/A返回开始和结束。
如果一个业务只工作4天,那么我想要的输出就是这样的:start0 start1 start2 start3 start4 start5 start6 end1 end2 end3 end4 end5 end6
0 1100 1100 1100 1100 1100 N/A N/A 2200 2200 2200 N/a N/A