pramjana

Working with archived files in Python

This gist is to capture related code snippets for managing archived files.

Zip file handling

First, a look at how to work with zip files.

In case there's a list of zip files in a folder, and we need to extract them (taking care to rename same file names):

pramjana

Shell and Code Environment Configuration

The following sections list the commands required to setup the fish shell and various programming language environments, for standardized environments on new systems.

Code Environments

Python

# Poetry with pip

pramjana

Data Import/Export

CSV Import

The link to the official documentation on COPY The COPY command can be used to import data from files. To import data from a csv file, use:

 -- The table into which to import the data into
COPY table_name