PYCOF (PYthon COmmon Functions)

1. Installation

You can get pycof from PyPI with:

pip install pycof

The library is supported on Windows, Linux and MacOs.

2. Usage

2.1. Documentation

You can find the full documentation at https://www.florianfelice.com/pycof or by clicking on the name of each function in the next section. It will redirect you the the function's specific documentation.

2.1. Available functions

The current version of the library provides:

remote_execute_sql: aggragated function for SQL queries to SELECT, INSERT, DELETE or COPY.
read: Load any data file, regarless of the format.
send_email: simple function to send email to contacts in a concise way.
verbose_display: extended function to print strings, lists, data frames and progression bar if used as a wrapper in for loops.
add_zero: simple function to convert int to str by adding a 0 is less than 10.
group: will convert an int to a str with thousand seperator.
replace_zero: will transform 0 values to - for display purposes.
week_sunday: will return week number of last sunday date of a given date.
display_name: displays the current user name. Will display either first, last or full name.
write: writes a str to a specific file (usually .txt) in one line of code.
file_age: computes the age (in days, hours, ...) of a given local file.
str2bool: converts string to boolean.
And many others!

2.2. Config file for credentials

The function remote_execute_sql and send_email will by default look for the credentials located at /etc/.pycof/config.json. On Windows, save the config file as C:/Windows/.pycof/config.json.

The file follows the below structure:

{
	"DB_USER": "",
	"DB_PASSWORD": "",
	"DB_HOST": "",
	"DB_PORT": "3306",
	"DB_DATABASE": "",
	"__COMMENT_1__": "Email specific, send_email"
	"EMAIL_USER": "",
	"EMAIL_PASSWORD": "",
	"EMAIL_SMTP": "smtp.gmail.com",
	"EMAIL_PORT": "587"
	"__COMMENT_2__": "IAM specific, if useIAM=True in remote_execute_sql",
	"CLUSTER_NAME": "",
	"AWS_ACCESS_KEY_ID": "",
	"AWS_SECRET_ACCESS_KEY": "",
	"REGION": "eu-west-1"
}

On Unix based system, run:

sudo nano /etc/.pycof/config.json

and paste the above json after filling the empty strings (pre-filled values are standard default values).

Reminder: To save the file, with nano press CTRL + O, confirm with y then CTRL + X to exit.

On Windows, use the path C:/Windows/.pycof/config.json.

Release files for PYCOF 1.8.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for PYCOF 1.8.0
File	Size	Uploaded
pycof-1.8.0.tar.gz	28.0 kB	Jul 7, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for PYCOF 1.8.0
File	Interpreter	ABI	Platform	Reset
pycof-1.8.0-py3-none-any.whl 30.7 kB Jul 7, 2026	Python 3	none	any	Details

Total release size: 58.7 kB

Release files / pycof-1.8.0.tar.gz

Download URL	pycof-1.8.0.tar.gz
Size	28.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`3e9106a246c4a533a100c460ee405a94252a6e061409f1df41badc98d53ec157`
BLAKE2b-256 checksum How to use checksums	`e3eb0d2fec1e597df1cb5fc9cd95d042ae97c673da10e945b1d4a9dbdd1e8945`
Upload date	Jul 7, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/6.1.0 CPython/3.13.12`

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/florianfelice/PYCOF
Publishing commit: github.com/florianfelice/PYCOF/tree/75533c5ac06ca336b6f3fd6a257a20b92107db9a

Workflow

Publishing configuration: github.com/florianfelice/PYCOF/blob/75533c5ac06ca336b6f3fd6a257a20b92107db9a/.github/workflows/release.yml
Publishing logs: github.com/florianfelice/PYCOF/actions/runs/28881166011/attempts/1

Artifact

Subject: pycof-1.8.0.tar.gz
SHA-256 checksum: 3e9106a246c4a533a100c460ee405a94252a6e061409f1df41badc98d53ec157 Verifying attestations

Release files / pycof-1.8.0-py3-none-any.whl

Download URL	pycof-1.8.0-py3-none-any.whl
Size	30.7 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`fcf8273efd9165c45e9d5bf0775b852f1921cf741e61a0afa9d41d46836ec5f2`
BLAKE2b-256 checksum How to use checksums	`5b432395d211eceddccf82e0493ed626cd33ccae7de2f718d9e855ff3289be39`
Upload date	Jul 7, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/6.1.0 CPython/3.13.12`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/florianfelice/PYCOF
Publishing commit: github.com/florianfelice/PYCOF/tree/75533c5ac06ca336b6f3fd6a257a20b92107db9a

Workflow

Publishing configuration: github.com/florianfelice/PYCOF/blob/75533c5ac06ca336b6f3fd6a257a20b92107db9a/.github/workflows/release.yml
Publishing logs: github.com/florianfelice/PYCOF/actions/runs/28881166011/attempts/1

Artifact

Subject: pycof-1.8.0-py3-none-any.whl
SHA-256 checksum: fcf8273efd9165c45e9d5bf0775b852f1921cf741e61a0afa9d41d46836ec5f2 Verifying attestations