read_jira_issues.py
생성일 비교 결과 만료 없음
9 삭제
| 행 | |
|---|---|
| 총 | |
| 삭제 | |
| 글자 | |
| 총 | |
| 삭제 | |
14 추가
| 행 | |
|---|---|
| 총 | |
| 추가 | |
| 글자 | |
| 총 | |
| 추가 | |
import pandas as pd
import pandas as pd
import os
import os
path = os.getcwd()+'\Ph3_Charts'+'\\'
print(path)
from os import listdir
from os import listdir
from os.path import isfile, join
from os.path import isfile, join
days_range = [f for f in listdir(path) if isfile(join(path, f))]
# Get CWD
CWD = os.getcwd()
# Join CWD with `Ph3_Charts` folder
PH3_CHART_PATH = os.path.join(CWD, 'Ph3_Charts')
print(PH3_CHART_PATH)
days_range = [f for f in listdir(PH3_CHART_PATH) if isfile(join(PH3_CHART_PATH, f))]
dataframes = []
dataframes = []
count = 0
count = 0
for i in days_range:
for i in days_range:
try:
try:
print(i,count)
print(i,count)
dataframes.append(pd.read_excel(path+i, sheet_name = "Issues Jira", index_col=0))
dataframes.append(pd.read_excel(PH3_CHART_PATH+i, sheet_name = "Issues Jira", index_col=0))
count += 1
count += 1
except:
except Exception as e: # catch *all* exceptions
pass
print(e) # print it out