semvec/pypi-packages huggingface dataset:
pandas-to-snowflake 2.0.1
Bulk loading pandas dataframe to snowflake table

pandas_to_snowflake
=============

This is a python Package meant to making it easier for uploading dataframe to snowflake tables.

Installation
------------

To install the latest Pypi version, you’ll need to execute:

``` r
    pip install pandas_to_snowflake
    or
    python3 -m pip install pandas_to_snowflake
```

If instead you want to install the latest github master version:

``` r
    git clone https://github.com/nit567esh/pandas_to_snowflake.git
    cd <pkg_directory>
    python3 setup.py install
```

Drivers
-------
This library uses **snowflake.connector** for connecting to Snowflake.

Usage
-----

You’ll have available 3 functions fro different kind of operations:
`1. sf_create` - You can create a table from scratch from python and upload the contents of the data frame.
`2. sf_append` - You can insert/append the contents of the pandas data frame into existing snowflake table.
`3. sf_upsert` - You can insert and update the existing snowflake table using contents of the pandas data frame.

``` r
# Step 1: Import package 
import pandas_to_snowflake as ps

# Step 2: Configure snowflake authentication
snowflake_auth=(user, password, account, warehouse, database, port)

# Step 3: Use sf_create, sf_append or sf_upsert
sf_create(snowflake_auth, sql_ddl)
    Example - ps.sf_create(snowflake_auth = snowflake_auth, 
             sql_ddl = "create table test (custkey number default null, orderdate date default null)")

sf_append(dataframe, snowflake_auth, schema, table)
    Example - ps.sf_append(dataframe=iris, snowflake_auth = snowflake_auth, schema = 'analytics', table = 'iris'")

sf_upsert(dataframe, snowflake_auth, schema, table, upsertkey=('cols',....))
    Example - ps.sf_upsert(dataframe=order, snowflake_auth = snowflake_auth, schema = 'analytics', table='order', upsertkey=('date','product',))

```
wizardry 0.1.2
Wizardry is an open-source CLI for building powerful algorithmic trading strategies faster and easier
Requires Python: >=3.9,<4.0

# Wizardry, the Algorithmic Wizard 💫

Wizardry is an open-source **CLI** for **building powerful algorithmic trading strategies faster** and **easier** (for Lean/QuantConnect)

<div align="center">
<img src="https://raw.githubusercontent.com/ssantoshp/Wizardry/main/documentation/wiz.png"/>

![](https://static.pepy.tech/personalized-badge/wizardry?period=total&units=international_system&left_color=black&right_color=brightgreen&left_text=Users)
![](https://img.shields.io/badge/license-MIT-blue)
![](https://img.shields.io/badge/swag%20level-A++-brightgreen)
![](https://img.shields.io/badge/language-python🐍-blue)
![](https://camo.githubusercontent.com/97d4586afa582b2dcec2fa8ed7c84d02977a21c2dd1578ade6d48ed82296eb10/68747470733a2f2f6261646765732e66726170736f66742e636f6d2f6f732f76312f6f70656e2d736f757263652e7376673f763d313033)

</div>

Homepage: https://github.com/ssantoshp/Wizardry