Metadata-Version: 2.3
Name: core_pro
Version: 0.0.17
Summary: A utility package for data science
Project-URL: Homepage, https://github.com/kevinkhang2909/core_pro
Project-URL: Bug Tracker, https://github.com/kevinkhang2909/core_pro/issues
Author-email: Kevin Khang <kevinkhang2909@gmail.com>
License: Copyright (c) 2023 Kevin Khang
                
                Permission is hereby granted, free of charge, to any person obtaining a copy
                of this software and associated documentation files (the "Software"), to deal
                in the Software without restriction, including without limitation the rights
                to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
                copies of the Software, and to permit persons to whom the Software is
                furnished to do so, subject to the following conditions:
                
                The above copyright notice and this permission notice shall be included in all
                copies or substantial portions of the Software.
                
                THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
                IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
                FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
                AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
                LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
                OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
                SOFTWARE.
License-File: LICENSE
Keywords:  aws, google,api
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Requires-Python: >=3.9
Requires-Dist: boto3
Requires-Dist: colorama
Requires-Dist: func-timeout
Requires-Dist: google-api-python-client
Requires-Dist: google-auth-oauthlib
Requires-Dist: google-cloud-storage
Requires-Dist: openpyxl
Requires-Dist: pandas
Requires-Dist: polars
Requires-Dist: psutil
Requires-Dist: pyarrow
Requires-Dist: sqlalchemy
Requires-Dist: tqdm
Requires-Dist: trino
Description-Content-Type: text/markdown

# Introduction
Data tools to increase productivity in your workflow

# How to setup
Install with pip:
```
pip install core_pro
```

Copy your client_secret.json to use Google Sheet API. If you don't have the error will raise
[Link tutorial](https://developers.google.com/slides/api/quickstart/python)
```
Please copy your json to the folder with name: 'client_secret.json'
```

If you don't have any python environment, please create your environment with conda
```
conda create -n <your_name> python=3.11 -y && conda activate <your_name>
```

Setup Big Data Account in environment
- Setup in windows
[Link tutorial](https://docs.oracle.com/en/database/oracle/machine-learning/oml4r/1.5.1/oread/creating-and-modifying-environment-variables-on-windows.html#GUID-DD6F9982-60D5-48F6-8270-A27EC53807D0)
```
Set variable **PRESTO_USER** with **Account** on RAM
Set variable **PRESTO_PASSWORD** with **Account Password** on RAM
```

# How to use our power toys
- Query with JDBC - [Notebook](https://git.garena.com/xuankhang.do/how-to-use/-/blob/master/query_jdbc.ipynb)
- Working with Google Sheets - [Notebook](https://git.garena.com/xuankhang.do/how-to-use/-/blob/master/gsheet.ipynb)
- Working with Google Slide
- Working with Google Drive
- Working with Gmail
- Working with AWS Storage - [Notebook](https://git.garena.com/xuankhang.do/how-to-use/-/blob/master/aws.ipynb)
- Working with Google Cloud Storage
