Compare text

Find the difference between two text files

Real-time editor
Hide unchanged lines
Disable line wrap
Layout
Diff precision
Syntax highlighting

read_jira_issues.py

Created Diff never expires
9 removals
27 lines
14 additions
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
Saved diffs