semvec/pypi-packages huggingface dataset:
clidb 0.2.3
CLI based SQL client for local data
License: MIT
Requires Python: >=3.8,<4.0

# clidb

![screenshot](./img/iris.png)

clidb is a command line sql client for individual data files, allowing these to be queried (even joined) and viewed. It natively supports CSV and parquet formats, with support for other file types available via the optional extras dependency.

## Data Formats
The following file types can be opened as views in clidb without extras:
- csv
- parquet(.gz)

With pandas installed, the following are also supported:
- json(l)
- xls(x)
- clipboard
- ...

## Usage

This package can be installed with:

```bash
pip install "clidb[extras]"
```

and executed via:

```bash
clidb
```

### Arguments

If a filename is supplied as an argument to clidb then it will open the data file as a view.

If a directory or S3 path is supplied then the directory view will open in that location.

For example:

```bash
clidb data/iris.csv
```

or

```bash
clidb s3://somebucket/data/
```

The contents of the clipboard can be converted into a view (e.g. after copying from Google Sheets), using the `--clipboard` argument:

```bash
clidb --clipboard
```

For some data sources, it can be helpful to render lines that separate rows. This can be enabled via the `row-lines` option:

```bash
clidb --row-lines
```

## Advanced Usage
New views can be created from an opened file. For example if `iris.csv` was opened as the view `iris`, then we could create a new view:
```sql
create view iris_variety as (select variety, avg("petal.length") from iris group by variety)
```

![create view](./img/iris_variety.png)

Views can be joined together, for example:
```sql
select * from iris natural join iris_variety
```

![join](./img/iris_join.png)
magcoordpy 0.2.4
A python package for working with magnetic coordinate transformations
License: MIT
Requires Python: >=3.8,<4.0

# MagCoordPy

![test-main](https://github.com/giorgiosavastano/magcoordpy/actions/workflows/python-test-main.yml/badge.svg)
![coverage-main](https://img.shields.io/codecov/c/github/giorgiosavastano/magcoordpy)
![license](https://img.shields.io/github/license/giorgiosavastano/magcoordpy)
![PyPI - Downloads](https://img.shields.io/pypi/dm/magcoordpy)

A python package for working with magnetic coordinate transformations.
The documentation is available at <https://magcoordpy.readthedocs.io/en/latest/>.

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

    pip install magcoordpy

Example usage
-------------

    from magcoordpy import coord_transforms
    long_geo = np.arange(-180, 190, 10)
    lati_geo = np.zeros(len(long_array))
    alti_geo = np.zeros(len(long_array))
    lat_cd, lon_cd, r_cd = coord_transforms.geodetic2cd(lati_geo, long_geo, alti_geo, year=2021.0)


It includes the following functions (not exhaustive list):

* geodetic2cd --> transformation from geodetic to centered dipole
* cd2geodetic --> transformation from centered dipole to geodetic


## Authors

- Giorgio Savastano (<giorgiosavastano@gmail.com>)

Please use github issues to make bug reports and request new functionality. Contributions are always welcome.

## References

Laundal, K.M., Richmond, A.D. Magnetic Coordinate Systems. Space Sci Rev 206, 27–59 (2017). <https://doi.org/10.1007/s11214-016-0275-y>