read_jira_issues.py

Created Diff never expires
9 suppressions
Lignes
Total
Supprimé
Mots
Total
Supprimé
Pour continuer à utiliser cette fonctionnalité, passez à
Diffchecker logo
Diffchecker Pro
27 lignes
14 ajouts
Lignes
Total
Ajouté
Mots
Total
Ajouté
Pour continuer à utiliser cette fonctionnalité, passez à
Diffchecker logo
Diffchecker Pro
31 lignes
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