<img src="https://user-images.githubusercontent.com/64777509/179344226-e9440447-a69d-46c1-a535-d18c1680e73d.jpg" align="center" width="228">
# py_topping, a topping on great libraries
## This library focus on "simplify" (& laziness :P) <br><br>
PyPi Project Page : https://pypi.org/project/py-topping
<br><br>To Install the Stable Version<br>
```python
pip install py-topping
```
<br>To Install the Newest Version<br>
```python
pip install git+https://github.com/chanon-kr/Shared_Function.git
```
<br>
This library will *NOT auto install dependencies for you but you could see the list of dependencies in sample links<br><br>
You could see samples of how to use this library inside the samples folder in github<br>
https://github.com/chanon-kr/Shared_Function
<br>
***
### 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
Raw data
{
"_id": null,
"home_page": "https://github.com/chanon-kr/Shared_Function",
"name": "py-topping",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": null,
"keywords": "utility, ETL",
"author": "Chanon Krittapholchai",
"author_email": "chanon.krittapholchai@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/d4/06/c5abce7dd78f425bae5df9fd747eb846e628c272c5244165107fe963b1bb/py_topping-0.4.11.tar.gz",
"platform": null,
"description": "<img src=\"https://user-images.githubusercontent.com/64777509/179344226-e9440447-a69d-46c1-a535-d18c1680e73d.jpg\" align=\"center\" width=\"228\">\r\n\r\n# py_topping, a topping on great libraries\r\n## This library focus on \"simplify\" (& laziness :P) <br><br>\r\n\r\nPyPi Project Page : https://pypi.org/project/py-topping\r\n<br><br>To Install the Stable Version<br>\r\n```python\r\npip install py-topping\r\n```\r\n<br>To Install the Newest Version<br>\r\n```python\r\npip install git+https://github.com/chanon-kr/Shared_Function.git\r\n```\r\n<br>\r\nThis library will *NOT auto install dependencies for you but you could see the list of dependencies in sample links<br><br>\r\nYou could see samples of how to use this library inside the samples folder in github<br>\r\nhttps://github.com/chanon-kr/Shared_Function\r\n<br>\r\n\r\n***\r\n### database\r\n - To Work with SQL Server, MySQL, PostGreSQL, SQLite and Google BigQuery\r\n - To read view, table or store procedure as pandas dataframe \r\n - To insert pandas dataframe into SQL with different methods\r\n - from 0.3.18, will roll back if job fail, except Google BigQuery\r\n - Can't read Store Procedure in PostGreSQL will solve this in later version\r\n - Will working with Oracle Database in later version\r\n - Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/database.ipynb\r\n\r\n***\r\n### sharepoint\r\n - To download file from SP365 or SP on prim\r\n - To read csv/excel from SP365 as pandas dataframe\r\n - To download List as csv or pandas dataframe from SP365\r\n - To upload file to SP365 or SP on prim\r\n - Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/sharepoint.ipynb\r\n\r\n***\r\n### gcp\r\n - To download and upload file from GCP's bucket Storage\r\n - Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_GCS.ipynb\r\n\r\n***\r\n### socket\r\n - To receive and send data though socket (TCP/IP)\r\n - Dependecies and Sample of use => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_TCP.ipynb\r\n***\r\n### data_preparation\r\n - Encode categorical column\r\n - Create lagging parameter\r\n - Simple Deep Learning Model for Regression\r\n - Dependecies and Sample of use \r\n - Data Prep => https://github.com/chanon-kr/Shared_Function/blob/main/samples/data_preparation.ipynb\r\n - Simple Deep Learning => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_ml.ipynb\r\n\r\n***\r\n### general_use\r\n - To send email with python \r\n - To logging in csv file\r\n - To check port status\r\n - To send LINE message, sticker or picture with line notify\r\n - To Create diff hour of (Desired UTC) - (Environment UTC)\r\n - To Check health of your machine\r\n - Dependecies and Sample of use\r\n - LINE => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_LINE.ipynb\r\n - EMAIL => https://github.com/chanon-kr/Shared_Function/blob/main/samples/email_sender.ipynb\r\n - Other => https://github.com/chanon-kr/Shared_Function/blob/main/samples/other_function.ipynb\r\n\r\n***\r\n### opc\r\n - to read value from OPC UA\r\n - to write value to OPC UA\r\n - Dependecies and Sample of use \r\n - OPC UA => https://github.com/chanon-kr/Shared_Function/blob/main/samples/lazy_OPCUA.ipynb\r\n***\r\n### run_pipeline\r\n - To run your python or notebook scripts \r\n - To create FastAPI\r\n - Dependecies and Sample of use \r\n - run pipeline=> https://github.com/chanon-kr/Shared_Function/blob/main/samples/run_pipeline.ipynb\r\n - create FastAPI => https://github.com/chanon-kr/Shared_Function/blob/main/samples/api.ipynb\r\n\r\n\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "simplify functions from other libraries functions in 1-2 lines",
"version": "0.4.11",
"project_urls": {
"Download": "https://github.com/chanon-kr/Shared_Function/archive/v0.4.11.tar.gz",
"Homepage": "https://github.com/chanon-kr/Shared_Function"
},
"split_keywords": [
"utility",
" etl"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "d406c5abce7dd78f425bae5df9fd747eb846e628c272c5244165107fe963b1bb",
"md5": "df41ffe0cc35e22c75897d982db49bfc",
"sha256": "4e8b7b313bb9e6bf6c83da691afee1f070511515e49f9445911d6868007a8e27"
},
"downloads": -1,
"filename": "py_topping-0.4.11.tar.gz",
"has_sig": false,
"md5_digest": "df41ffe0cc35e22c75897d982db49bfc",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 139521,
"upload_time": "2024-06-30T09:39:56",
"upload_time_iso_8601": "2024-06-30T09:39:56.009724Z",
"url": "https://files.pythonhosted.org/packages/d4/06/c5abce7dd78f425bae5df9fd747eb846e628c272c5244165107fe963b1bb/py_topping-0.4.11.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-30 09:39:56",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "chanon-kr",
"github_project": "Shared_Function",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "py-topping"
}
JSON
