Skip to main content

Python Pandas extensions for pandas dataframes

Project description

# pandas_ext
Python Pandas extensions for pandas dataframes

# Usage
import pandas_ext as px

## CSV

By default, pandas will natively read to s3 but won't write to s3.

## Excel

By default, pandas will natively read to s3 but won't write to s3.

To write to xls:
pip install pandas_ext[xls]

To write xlsx:
pip install pandas_ext[xlsx]

## Gdrive
By default, pandas does not read/write to Gdrive.

### For G Suite administrators
At the organization level, one must do the necessary installation and
deployment of the [gdrive lambda service]( to get this to work.

You will have to create a service account that shares your G Apps domain with the following APIs enabled:

- Google Drive

- Google Sheets

From there you must download the p12 credentials file and reference it in your settings.yml when deploying the gdrive service.

### For Gdrive clients
Once that is complete, you must share the folder you are interested in reading/writing to the service account email you've received from your administrator.

Locally, for client access you must set the `GDRIVE_URL` and `GDRIVE_KEY` in your projects environment variable in order to talk to
the gdrive lambda service.


## Parquet
By default, pandas ~does not read/write to Parquet~. This has been added in pandas version 24 and my methods will eventually update to use them but still allow writing to s3.


## Spectrum
to_spectrum is unique to pandas_ext.


## Salesforce
salesforce methods are unique to pandas_ext.


## SQL service


## XML
Pandas doesn't natively support writing to XML format.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pandas-ext, version 0.5.1
Filename, size File type Python version Upload date Hashes
Filename, size pandas_ext-0.5.1.tar.gz (11.7 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page