read_jira_issues.py
27 Zeilen
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