请尝试以下 *** 作:
# Transform data in first dataframedf1 = pd.Dataframe(data)# Save the data in another datframedf2 = pd.Dataframe(data)# Rename column names of second dataframe df2.rename(index=str, columns={'Reader_ID1': 'Reader_ID1_x', 'SITE_ID1': 'SITE_ID1_x', 'EVENT_TS1': 'EVENT_TS1_x'}, inplace=True)# Merge the dataframes into another dataframe based on PERSonID and Badge_IDdf3 = pd.merge(df1, df2, how='outer', on=['PERSONID', 'Badge_ID'])# Use df.loc() to fetch the data you wantdf3.loc[(df3.Reader_ID1 < df3.Reader_ID1_x) & (df3.SITE_ID1 != df3.SITE_ID1_x) & (pd.to_datetime(df3['EVENT_TS1']) - pd.to_datetime(df3['EVENT_TS1_x'])<=datetime.timedelta(hours=event_time_diff))]
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)