read_jira_issues.py

Created Diff never expires
9 removals
Lines
Total
Removed
Words
Total
Removed
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
27 lines
14 additions
Lines
Total
Added
Words
Total
Added
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
31 lines
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