daybreak0804

import sys

# for PyQt 
from PyQt4 import uic, QtGui
from PyQt4.QtGui import QMainWindow, QApplication
from PyQt4.QtGui import QTableWidgetItem, QTreeWidgetItem
from PyQt4.QtGui import QFileDialog, QFont, QFileSystemModel, QListWidgetItem 
from PyQt4.QtCore import QModelIndex, QDir, SIGNAL, QObject, pyqtSlot

form_class = uic.loadUiType("./qTreeWidget_test.ui")[0]

daybreak0804

import os
import docx
from docx.document import Document
from docx.oxml.table import CT_Tbl
from docx.oxml.text.paragraph import CT_P
from docx.table import _Cell, Table
from docx.text.paragraph import Paragraph

os.chdir('C:\\OJT_Kevin\\161027_docx_parsing')

daybreak0804

import wx
import os


app = wx.PySimpleApp()
wildcard = "Python source (*.py)|*.py|" \
        "Compiled Python (*.pyc)|*.pyc|" \
        "All files (*.*)|*.*"
dialog = wx.FileDialog(None, "Choose a file", os.getcwd(), "", wildcard, wx.MULTIPLE)
if dialog.ShowModal() == wx.ID_OK:

daybreak0804

def print_in_file5():
    print "print_in_file5"

daybreak0804

import file5

def print_in_file4():
    print_in_file5()

daybreak0804

import file5

def print_in_file3():
    file5.print_in_file5()

daybreak0804

def print_in_file2():
    print "print_in_file2"

daybreak0804

import file2
import file3
import file4


file2.print_in_file2()
file3.print_in_file3()
file4.print_in_file4()

daybreak0804

# part 1
import openpyxl
import pandas as pd
import numpy as np
workbook1 = openpyxl.load_workbook('ExcelPowerQueryConsumePredict.xlsx')
sheet = workbook1.get_sheet_by_name('AAA')
csv_AAA = pd.read_csv('AAA.csv', header=None)
row_length = csv_AAA.shape[0]
column_length = csv_AAA.shape[1]