jobs = open("C:\\app\\ITWILL\\product\\18.0.0\\diag\\rdbms\\xe\\xe\\trace\\alert_xe.log", encoding='cp949', errors='ignore')
data = jobs.read()
data2= data.split()
k = [] # ora- 리스트
for i in data2:
if 'ora-' in i.lower():
k.append(i)
import pandas as pd
df = pd.DataFrame( k, columns=['col1'] ) #테이블 형식으로 만듬
from pandasql import sqldf
pysqldf = lambda q : sqldf( q, globals() )
q = """select col1, count(*) as 합계
from df
group by col1
order by 2 desc"""
pysqldf(q)#오류 갯수 출력
_________________________________________________________________
파이썬 방법
from collections import Counter
jobs = open("C:\\app\\ITWILL\\product\\18.0.0\\diag\\rdbms\\xe\\xe\\trace\\alert_xe.log", encoding='cp949', errors='ignore')
data = jobs.read()
data2 = data.split()
new_list=[]
for i in data2 :
if 'ora-' in i.lower() : #i.lower()에서 ora-가 포함된 것만 출력
new_list.append(i.lower())
counter=Counter(new_list)
print(counter)