This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import file2 | |
import file3 | |
import file4 | |
file2.print_in_file2() | |
file3.print_in_file3() | |
file4.print_in_file4() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def print_in_file2(): | |
print "print_in_file2" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import file5 | |
def print_in_file3(): | |
file5.print_in_file5() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import file5 | |
def print_in_file4(): | |
print_in_file5() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def print_in_file5(): | |
print "print_in_file5" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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') |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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] |