In [ ]:
# %%bash
# cp $MYDB/ND_Dados_DBs/INOSS/T_*xlsx
# mkdir -p CSV
# mkdir -p Reports
# python xlsx2csv.py
In [2]:
%matplotlib inline
import seaborn as sns
import matplotlib.pyplot as plt
from datetime import datetime
import pandas as pd
import matplotlib
df = pd.read_excel("CSV/T_LOG1.csv", sep=",")
In [3]:
df
Out[3]:
In [4]:
df.describe()
Out[4]:
In [5]:
ax = sns.countplot(df['FN_SEVERITY'])
In [6]:
#Apps
ax = sns.countplot(df['FT_APP'])
In [7]:
#day
ax = sns.countplot(df['FD_DAY'])
In [8]:
#week day
ax = sns.countplot(df['FD_WEEKDAY'])
In [9]:
def plotAPP(df1):
df1['Y'] = df1.loc[:,'FT_APP'].astype('category')
vs = df1.Y.cat.categories
l = len(vs)
for ev in vs:
dat = df1[df1['Y']==ev]
ax = sns.countplot(dat.loc[:,'FN_SEVERITY'])
ax.set_title('SEVERITY IN ' + ev)
plt.show()
def plotWeek(df1):
df1['Y'] = df1.loc[:,'FD_WEEKDAY'].astype('category')
vs = df1.Y.cat.categories
fig, axes =plt.subplots(7,1,figsize=(10,30))
print(vs)
weekday =0
for ev in vs:
dat = df1[df1['Y']==ev]
sns.countplot(dat.loc[:,'FN_SEVERITY'],ax=axes[weekday],)
axes[weekday].set_title('SEVERITY IN WEEK DAY ' + str(ev))
weekday+=1
plt.show()
def plotMonth(df1):
df1['Y'] = df1.loc[:,'FD_MONTH'].astype('category')
vs = df1.Y.cat.categories
l = len(vs)
for ev in vs:
dat = df1[df1['Y']==ev]
ax = sns.countplot(dat.loc[:,'FN_SEVERITY'])
ax.set_title('SEVERITY IN Month ' + str(ev))
plt.show()
def plotDay(df1):
df1['Y'] = df1.loc[:,'FN_SEVERITY'].astype('category')
vs = df1.Y.cat.categories
l = len(vs)
for ev in vs:
dat = df1[df1['Y']==ev]
ax = sns.countplot(dat.loc[:,'FD_DAYN'])
ax.set_title('SEVERITY '+ str(ev)+ 'since logs started')
plt.show()
In [10]:
plotAPP(df)
In [11]:
plotWeek(df)
In [12]:
plotMonth(df)
In [13]:
plotDay(df)
In [14]:
#analise Proprieties
df1 = pd.read_csv("CSV/T_LOG1_PROPERTIES.csv", sep=",")
In [15]:
df1
Out[15]:
In [16]:
df1['Y'] = df1.loc[:,'FT_KEY'].astype('category')
df1.Y.describe()
df1.Y.value_counts()
Out[16]:
In [17]:
df1['Y'] = df1.loc[:,'FT_VAL'].astype('category')
df1.Y.describe()
df1.Y.value_counts()
Out[17]:
In [18]:
df.rename(columns={'FN_ID': 'FN_LOG_ID'}, inplace=True)
dfmerged = pd.merge(df, df1, on=['FN_LOG_ID'],how="right")
In [19]:
dfmerged
Out[19]:
In [39]:
n_df=pd.Index(df.FN_LOG_ID)
for i in df1:
#iprint(i)
df[df.FN_LOG_ID==i[0,"FN_ID"]][i.FT_KEY]=df1.FN_ID[0,"FT_VAL"]
In [25]:
df1
Out[25]:
In [ ]: