py_topping, a topping on great libraries

This library focus on "simplify" (& laziness :P)

PyPi Project Page : https://pypi.org/project/py-topping

To Install the Stable Version

pip install py-topping

To Install the Newest Version

pip install git+https://github.com/chanon-kr/Shared_Function.git

This library will *NOT auto install dependencies for you but you could see the list of dependencies in sample links

You could see samples of how to use this library inside the samples folder in github
https://github.com/chanon-kr/Shared_Function

---

database

• To Work with SQL Server, MySQL, PostGreSQL, SQLite and Google BigQuery
• To read view, table or store procedure as pandas dataframe
• To insert pandas dataframe into SQL with different methods
  • from 0.3.18, will roll back if job fail, except Google BigQuery
• Can't read Store Procedure in PostGreSQL will solve this in later version
• Will working with Oracle Database in later version
• Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/database.ipynb

---

sharepoint

• To download file from SP365 or SP on prim
• To read csv/excel from SP365 as pandas dataframe
• To download List as csv or pandas dataframe from SP365
• To upload file to SP365 or SP on prim
• Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/sharepoint.ipynb

---

gcp

• To download and upload file from GCP's bucket Storage
• Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_GCS.ipynb

---

socket

• To receive and send data though socket (TCP/IP)
• Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_TCP.ipynb

---

data_preparation

• Encode categorical column
• Create lagging parameter
• Simple Deep Learning Model for Regression
• Dependecies and Sample of use
  • Data Prep => https://github.com/chanon-kr/Shared_Function/blob/main/samples/data_preparation.ipynb
  • Simple Deep Learning => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_ml.ipynb

---

general_use

• To send email with python
• To logging in csv file
• To check port status
• To send LINE message, sticker or picture with line notify
• To Create diff hour of (Desired UTC) - (Environment UTC)
• To Check health of your machine
• Dependecies and Sample of use
  • LINE => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_LINE.ipynb
  • EMAIL => https://github.com/chanon-kr/Shared_Function/blob/main/samples/email_sender.ipynb
  • Other => https://github.com/chanon-kr/Shared_Function/blob/main/samples/other_function.ipynb

---

opc

• to read value from OPC UA
• to write value to OPC UA
• Dependecies and Sample of use
  • OPC UA => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_OPCUA.ipynb

---

run_pipeline

• To run your python or notebook scripts
• To create FastAPI
• Dependecies and Sample of use
  • run pipeline=> https://github.com/chanon-kr/Shared_Function/blob/main/samples/run_pipeline.ipynb
  • create FastAPI => https://github.com/chanon-kr/Shared_Function/blob/main/samples/api.ipynb