Skip to content

Instantly share code, notes, and snippets.

View DataSolveProblems's full-sized avatar
💭
Github Working In Progress

Jie Jenn DataSolveProblems

💭
Github Working In Progress
View GitHub Profile
import sys
from PyQt5.QtWidgets import (QApplication, QWidget, QLCDNumber, QSlider, QVBoxLayout)
from PyQt5.QtCore import Qt
class AppDemo(QWidget):
def __init__(self):
super().__init__()
self.resize(600, 500)
self.setWindowTitle('Update LCD with slider')
import sys
import csv
from PyQt5.QtWidgets import (QApplication, QWidget, QMainWindow, QPushButton, QAction, QHeaderView, QLineEdit, QLabel,
QTableWidget, QTableWidgetItem, QVBoxLayout, QHBoxLayout)
from PyQt5.QtGui import QPainter, QStandardItemModel, QIcon
from PyQt5.Qt import Qt
from PyQt5.QtChart import QChart, QChartView, QPieSeries
class DataEntryForm(QWidget):
def __init__(self):
import sys, random
from PyQt5.QtWidgets import (QApplication, QMainWindow)
from PyQt5.QtChart import QChart, QChartView, QValueAxis, QBarCategoryAxis, QBarSet, QBarSeries
from PyQt5.Qt import Qt
from PyQt5.QtGui import QPainter
class MainWindow(QMainWindow):
def __init__(self):
super().__init__()
self.resize(800, 600)
import sys
from PyQt5.QtWidgets import (QApplication, QMainWindow, QTextEdit, QDockWidget, QListWidget)
from PyQt5.QtCore import Qt
class MainWindow(QMainWindow):
def __init__(self):
super().__init__()
self.resize(800, 600)
dockWidget = QDockWidget('Dock', self)
import sys
from PyQt5.QtWidgets import (QApplication, QWidget, QFileDialog, QTextEdit, QPushButton, QLabel, QVBoxLayout)
from PyQt5.QtGui import QPixmap
from PyQt5.QtCore import QDir
class DialogApp(QWidget):
def __init__(self):
super().__init__()
self.resize(800, 600)
import sys
from PyQt5.QtWidgets import (QApplication, QMainWindow)
from PyQt5.QtChart import QChart, QChartView, QBarSet, QHorizontalPercentBarSeries, QBarCategoryAxis, QValueAxis
from PyQt5.Qt import Qt
from PyQt5.QtGui import QPainter
class MainWindow(QMainWindow):
def __init__(self):
super().__init__()
self.resize(600, 400)
import sys
from PyQt5.QtWidgets import (QApplication, QMainWindow)
from PyQt5.QtChart import QChart, QChartView, QHorizontalBarSeries, QBarSet, QBarCategoryAxis, QValueAxis
from PyQt5.Qt import Qt
from PyQt5.QtGui import QPainter
class MainWindow(QMainWindow):
def __init__(self):
super().__init__()
self.resize(800, 600)
Option Explicit
Dim wsRawData As Worksheet
Dim LastRow As Long
Dim collection_UniqueList As Collection
Public Const Output_Folder_Path As String = "<Output directory>"
Sub MainProgram()
Option Explicit
Private Sub ProgressBar_Run()
Dim wsData As Worksheet, RowMax As Long, ColumnMax As Long
Dim Counter As Long, RowNumber As Long, ColumnNumber As Long
Dim PercentText As String
Set wsData = ThisWorkbook.Worksheets("Data")
With wsData
import pandas
googleSheetId = '<Google Sheets Id>'
worksheetName = '<Sheet Name>'
URL = 'https://docs.google.com/spreadsheets/d/{0}/gviz/tq?tqx=out:csv&sheet={1}'.format(
googleSheetId,
worksheetName
)
df = pandas.read_csv(URL)