import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False
alarm_df = pd.read_excel('data/附件1 报警数据集 (Attachment 1 Alarm data set).xlsx')
fault_df = pd.read_excel('data/附件2 故障数据集 (Attachment 2 Fault data set).xlsx')
test_df = pd.read_excel('data/附件3 测试数据 (Attachment 3 Test data).xlsx')
alarm_df.head()
fault_df.head()
test_df.head()
alarm_df = alarm_df.drop(labels='累计占比 (Cumulative proportion)',axis=1)
fault_df = fault_df.drop(labels='累计占比 (Cumulative proportion)',axis=1)
alarm_df.head()
alarm_df['是否属于误报 (Whether a misstatement)'].unique()
a = {'是 (True)':1,'否 (False)':0,'否,其中有1次为真实火灾 (False, one of them was a real fire)':-1}
alarm_df['误报'] = alarm_df['是否属于误报 (Whether a misstatement)'].apply(lambda x:a[x])
alarm_df['真实次数'] = np.where(alarm_df['误报']==-1,1,(1-alarm_df['误报'])*alarm_df['火警次数 (Number of fire alarms)'])
alarm_df.head()
ans = 0
alarm_df['同一起']=0
for i in alarm_df['项目名称 (Object name)'].unique():
address = alarm_df[alarm_df['项目名称 (Object name)']==i]
for j in address['回路 (Loop)'].unique():
loop = address[address['回路 (Loop)']==j]
dic = {}
for k in loop['机号 (Machinery number)'].unique():
mn = loop[loop['机号 (Machinery number)']==k]
if len(mn['真实次数']):
if mn['真实次数'].max():
a=sorted(zip(mn['真实次数'],mn['真实次数'].index),key=lambda x:x[0])
alarm_df['同一起'][a[-1][1]]=1
ans+=mn['真实次数'].max()
ans
ans = 0
for i in alarm_df['项目名称 (Object name)'].unique():
address = alarm_df[alarm_df['项目名称 (Object name)']==i]
for j in address['回路 (Loop)'].unique():
loop = address[address['回路 (Loop)']==j] # 同一个回路
dic = {}
for k in loop['机号 (Machinery number)'].unique():
mn = loop[loop['机号 (Machinery number)']==k]
if len(mn['真实次数']):
ans+=mn['真实次数'].sum()
ans
set(alarm_df['部件名称 (Component name)']).difference(set(fault_df['部件名称 (Component n



