semvec/pypi-packages huggingface dataset:
tableswift 0.1.4
Data wrangling framework with LLM using code generation
Requires Python: >=3.8

TableSwift is a python package that can do different types of data wrangling, using LLMs with code generation.

This package currently supports three functions. 
To start using the package, first configurre with your API key. 
```
ts.configure(api_key="your API key here.")
```
Or alternatively define yoru API key in the system environment using variable name TABLESWIFT_API_KEY.



To generate labels, use:
```
labeled_data = ts.generate_labels(instruction="label the input samples", 
                                      task="data_transformation",
                                      column_name="name",
                                      demonstrations=[{"Input": "sample1", "Output": "label1"},
                                                     {"Input": "sample2", "Output": "label2"}],
                                      samples_to_label=[{"Input": "sample1", "Output": ""},
                                                        {"Input": "sample2", "Output": ""},
                                                        {"Input": "sample3", "Output": ""}])
```

To generate code, use:
```
code, router_code = ts.generate_code(instruction="Transform input into output",
                     task="data_transformation",
                     samples=[{"Input": "sample1", "Output": "label1"},
                              {"Input": "sample2", "Output": "label2"}],
                     lang="python")
```

There are also hyperparameters that can be overriden, to do so, use:
```
code, router_code = ts.generate_code(instruction="Transform input into output",
                     task="data_transformation",
                     samples=[{"Input": "sample1", "Output": "label1"},
                              {"Input": "sample2", "Output": "label2"}],
                     lang="python",
                     num_trials=1,
                     num_retry=3,
                     num_iterations=1)
```

A list of hyperparameters with their defaul value is:
```
DEFAULT_PARAMS = {
    "use_data_router": True,
    "num_trials": 2,
    "num_retry": 3,
    "seed": 42,
    "num_iterations": 2,
    "max_num_solutions": 3,
    "limit_fallback": 20, # number of invalid data samples before fallback, should be a percentage in the future
    "llm": "gpt-4o-mini" 
}
```

Current package supports two languages: python and duckdb SQL. To generate python code use `lang=python`, and to generate duckdb SQL query, use `lang=sql`.
Current pakcage supports the following tasks, remember to match the task parameter with the following string.
```
"data_transformation"
"entity_matching"
"error_detection_spelling"
"value_imputation"
```
byteutils 0.1.0
A collection of reusable utility functions and modules.
Requires Python: >=3.10
Keywords: bblab, bitbytelab, python, utility, utils


<p><div align="center">
  <img src="assets/bitbytelab.png" alt="BitByteLab Logo" height="100">
 

**A Collection of reusable utilities.**

[![Release](https://img.shields.io/github/v/tag/bitbytelab/bblab)](https://github.com/bitbytelab/bblab/tag)
[![Platforms](https://img.shields.io/badge/platform-windows%20%7C%20macOS%20%7C%20linux-blue)]()
[![License](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE)
[![Python](https://img.shields.io/badge/Python-3.9%2B-blue.svg)](https://www.python.org/)
[![PyPI](https://img.shields.io/badge/PyPI-upwork-cli-lightgrey.svg)](https://pypi.org/project/upwork-cli)

</div></p>

bblab.utils
=============================================

A collection of reusable utility functions and modules.

Usage
=====

---
## 🧪 Project Structure

<pre>
<!-- dir-tree-start -->
📁 bblab/
├── 📁 src/
│   └── 📁 bblab/
├── 📁 examples/
│   └── sample_usage.py
├── 📁 tests/
│   └── test.py
├── ⚙️ .env
├── 🚫 .gitignore
├── 📃 LICENSE
├── 📃 LICENSE.txt
├── ⚙️ pyproject.toml
├── 📝 README.md
└── ⚙️ ruff.toml
<!-- dir-tree-end -->
</pre>

---

## 📄 License

Licensed under the [MIT License](LICENSE).

---

## 🤝 Contributing

- Open an issue for ideas, bugs, or suggestions.
- Pull requests are welcome!

---

## 🔗 Links

- 📦 [PyPI](https://pypi.org/project/bblab)
- 🛠️ [Issues](https://github.com/bitbytelab/bblab/issues)
- ⭐ [Star on GitHub](https://github.com/bitbytelab/bblab)

---
bytescripts 0.1.0
A collection of reusable utility functions and modules.
Requires Python: >=3.10
Keywords: bblab, bitbytelab, python, utility, utils


<p><div align="center">
  <img src="assets/bitbytelab.png" alt="BitByteLab Logo" height="100">
 

**A Collection of reusable utilities.**

[![Release](https://img.shields.io/github/v/tag/bitbytelab/bblab)](https://github.com/bitbytelab/bblab/tag)
[![Platforms](https://img.shields.io/badge/platform-windows%20%7C%20macOS%20%7C%20linux-blue)]()
[![License](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE)
[![Python](https://img.shields.io/badge/Python-3.9%2B-blue.svg)](https://www.python.org/)
[![PyPI](https://img.shields.io/badge/PyPI-upwork-cli-lightgrey.svg)](https://pypi.org/project/upwork-cli)

</div></p>

bblab.utils
=============================================

A collection of reusable utility functions and modules.

Usage
=====

---
## 🧪 Project Structure

<pre>
<!-- dir-tree-start -->
📁 bblab/
├── 📁 src/
│   └── 📁 bblab/
├── 📁 examples/
│   └── sample_usage.py
├── 📁 tests/
│   └── test.py
├── ⚙️ .env
├── 🚫 .gitignore
├── 📃 LICENSE
├── 📃 LICENSE.txt
├── ⚙️ pyproject.toml
├── 📝 README.md
└── ⚙️ ruff.toml
<!-- dir-tree-end -->
</pre>

---

## 📄 License

Licensed under the [MIT License](LICENSE).

---

## 🤝 Contributing

- Open an issue for ideas, bugs, or suggestions.
- Pull requests are welcome!

---

## 🔗 Links

- 📦 [PyPI](https://pypi.org/project/bblab)
- 🛠️ [Issues](https://github.com/bitbytelab/bblab/issues)
- ⭐ [Star on GitHub](https://github.com/bitbytelab/bblab)

---
byteextras 0.1.0
A collection of reusable utility functions and modules.
Requires Python: >=3.10
Keywords: bblab, bitbytelab, python, utility, utils


<p><div align="center">
  <img src="assets/bitbytelab.png" alt="BitByteLab Logo" height="100">
 

**A Collection of reusable utilities.**

[![Release](https://img.shields.io/github/v/tag/bitbytelab/bblab)](https://github.com/bitbytelab/bblab/tag)
[![Platforms](https://img.shields.io/badge/platform-windows%20%7C%20macOS%20%7C%20linux-blue)]()
[![License](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE)
[![Python](https://img.shields.io/badge/Python-3.9%2B-blue.svg)](https://www.python.org/)
[![PyPI](https://img.shields.io/badge/PyPI-upwork-cli-lightgrey.svg)](https://pypi.org/project/upwork-cli)

</div></p>

bblab.utils
=============================================

A collection of reusable utility functions and modules.

Usage
=====

---
## 🧪 Project Structure

<pre>
<!-- dir-tree-start -->
📁 bblab/
├── 📁 src/
│   └── 📁 bblab/
├── 📁 examples/
│   └── sample_usage.py
├── 📁 tests/
│   └── test.py
├── ⚙️ .env
├── 🚫 .gitignore
├── 📃 LICENSE
├── 📃 LICENSE.txt
├── ⚙️ pyproject.toml
├── 📝 README.md
└── ⚙️ ruff.toml
<!-- dir-tree-end -->
</pre>

---

## 📄 License

Licensed under the [MIT License](LICENSE).

---

## 🤝 Contributing

- Open an issue for ideas, bugs, or suggestions.
- Pull requests are welcome!

---

## 🔗 Links

- 📦 [PyPI](https://pypi.org/project/bblab)
- 🛠️ [Issues](https://github.com/bitbytelab/bblab/issues)
- ⭐ [Star on GitHub](https://github.com/bitbytelab/bblab)

---
byteextra 0.1.0
A collection of reusable utility functions and modules.
Requires Python: >=3.10
Keywords: bblab, bitbytelab, python, utility, utils


<p><div align="center">
  <img src="assets/bitbytelab.png" alt="BitByteLab Logo" height="100">
 

**A Collection of reusable utilities.**

[![Release](https://img.shields.io/github/v/tag/bitbytelab/bblab)](https://github.com/bitbytelab/bblab/tag)
[![Platforms](https://img.shields.io/badge/platform-windows%20%7C%20macOS%20%7C%20linux-blue)]()
[![License](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE)
[![Python](https://img.shields.io/badge/Python-3.9%2B-blue.svg)](https://www.python.org/)
[![PyPI](https://img.shields.io/badge/PyPI-upwork-cli-lightgrey.svg)](https://pypi.org/project/upwork-cli)

</div></p>

bblab.utils
=============================================

A collection of reusable utility functions and modules.

Usage
=====

---
## 🧪 Project Structure

<pre>
<!-- dir-tree-start -->
📁 bblab/
├── 📁 src/
│   └── 📁 bblab/
├── 📁 examples/
│   └── sample_usage.py
├── 📁 tests/
│   └── test.py
├── ⚙️ .env
├── 🚫 .gitignore
├── 📃 LICENSE
├── 📃 LICENSE.txt
├── ⚙️ pyproject.toml
├── 📝 README.md
└── ⚙️ ruff.toml
<!-- dir-tree-end -->
</pre>

---

## 📄 License

Licensed under the [MIT License](LICENSE).

---

## 🤝 Contributing

- Open an issue for ideas, bugs, or suggestions.
- Pull requests are welcome!

---

## 🔗 Links

- 📦 [PyPI](https://pypi.org/project/bblab)
- 🛠️ [Issues](https://github.com/bitbytelab/bblab/issues)
- ⭐ [Star on GitHub](https://github.com/bitbytelab/bblab)

---
bitbytelab 0.1.0
A collection of reusable utility functions and modules.
Requires Python: >=3.10
Keywords: bblab, bitbytelab, python, utility, utils


<p><div align="center">
  <img src="assets/bitbytelab.png" alt="BitByteLab Logo" height="100">
 

**A Collection of reusable utilities.**

[![Release](https://img.shields.io/github/v/tag/bitbytelab/bblab)](https://github.com/bitbytelab/bblab/tag)
[![Platforms](https://img.shields.io/badge/platform-windows%20%7C%20macOS%20%7C%20linux-blue)]()
[![License](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE)
[![Python](https://img.shields.io/badge/Python-3.9%2B-blue.svg)](https://www.python.org/)
[![PyPI](https://img.shields.io/badge/PyPI-upwork-cli-lightgrey.svg)](https://pypi.org/project/upwork-cli)

</div></p>

bblab.utils
=============================================

A collection of reusable utility functions and modules.

Usage
=====

---
## 🧪 Project Structure

<pre>
<!-- dir-tree-start -->
📁 bblab/
├── 📁 src/
│   └── 📁 bblab/
├── 📁 examples/
│   └── sample_usage.py
├── 📁 tests/
│   └── test.py
├── ⚙️ .env
├── 🚫 .gitignore
├── 📃 LICENSE
├── 📃 LICENSE.txt
├── ⚙️ pyproject.toml
├── 📝 README.md
└── ⚙️ ruff.toml
<!-- dir-tree-end -->
</pre>

---

## 📄 License

Licensed under the [MIT License](LICENSE).

---

## 🤝 Contributing

- Open an issue for ideas, bugs, or suggestions.
- Pull requests are welcome!

---

## 🔗 Links

- 📦 [PyPI](https://pypi.org/project/bblab)
- 🛠️ [Issues](https://github.com/bitbytelab/bblab/issues)
- ⭐ [Star on GitHub](https://github.com/bitbytelab/bblab)

---
pix-framework 0.14.2
Process Improvement Explorer Framework contains process discovery and improvement modules of the Process Improvement Explorer project.
Requires Python: <3.12,>=3.9

# PIX Framework

![pix-framework](https://github.com/AutomatedProcessImprovement/pix-framework/actions/workflows/build.yaml/badge.svg)
![version](https://img.shields.io/github/v/tag/AutomatedProcessImprovement/pix-framework)

Framework for building process mining applications.

## Installation

The package requires **Python 3.9+**. You can install it from PyPI: 

```shell
pip install pix-framework
```

## Releases

You can browse compiled releases in the [Releases](https://github.com/AutomatedProcessImprovement/pix-framework/releases) section.

## Description

The `pix_framework.discovery` package besides root modules contains the following subpackages with additional information located in their README files:

- [batch_processing_discovery](src/pix_framework/discovery/batch_processing/)
- [prioritization_discovery](src/pix_framework/discovery/prioritization/)
- [case_attribute_discovery](src/pix_framework/discovery/case_attribute/)

The `pix_framework.enhancement` package besides root modules contains the following subpackages with additional information located in their README files:

- [start_time_estimator](src/pix_framework/enhancement/start_time_estimator/)

## Development

### Testing

To run tests, use the following command:

```shell
pytest -m "not benchmark"
```

### Benchmarking

To run benchmarks, use the following command:

```shell
pytest --benchmark-only
```
dask-hpcconfig 2025.6.0
Configuration for various dask clusters
Requires Python: >=3.10

# dask-hpcconfig

To install, use

```bash
python -m pip install git+https://github.com/umr-lops/dask-hpcconfig.git#egg=dask-hpcconfig
```

or clone the source:

```bash
git clone https://github.com/umr-lops/dask-hpcconfig.git
cd dask-hpcconfig
```

and then install from there:

```bash
python -m pip install .
```

or as "editable":

```bash
python -m pip install -e .
```

## Usage

```python
import dask_hpcconfig
```

To list the available cluster definitions:

```python
dask_hpcconfig.print_clusters()
```

or, as a mapping of name to type:

```python
clusters = dask_hpcconfig.available_clusters()
```

To create a cluster, use:

```python
cluster = dask_hpcconfig.cluster(name)
```

where `name` is the name of one of the available clusters.

To override any particular setting:
For example on 'datarmor-local' to use only 7 workers for increasing memory size of each worker:

```python
overrides = {"cluster.n_workers": 7}
cluster = dask_hpcconfig.cluster("datarmor-local", **overrides)
```

For example on 'datarmor' to use only 7 workers for increasing memory size of each worker, and use 49 workers (i.e. 7 mpi_1 nodes) :

```python
overrides = {"cluster.cores": 7}
cluster = dask_hpcconfig.cluster("datarmor", **overrides)
cluster.scale(49)
```

`cluster` can then be used to create a `Client`:

```python
from distributed import Client

client = Client(cluster)
```
zx-db-manager 0.1.2
A MySQL cloud library
Requires Python: >=3.12.2

# zx_mysql

`zx_mysql` 是一个用于连接和操作 MySQL 数据库的 Python 库。

## 安装

```bash
pip install zx_db_manager


from zx_db_manager import MySqlCloud



DEFAULT_HOST = '120.48.151.191'
DEFAULT_PORT = 3306
DEFAULT_USER = 'zxtech'
DEFAULT_PASSWORD = os.getenv('SUPER_PASSWORD')

# 修正：添加必要的初始化参数
test = MySqlCloud(DEFAULT_HOST, DEFAULT_PORT, DEFAULT_USER, DEFAULT_PASSWORD)
# 连接数据库

def test_query():
    # 建立数据库连接，假设数据库名为 'your_database_name'，请根据实际情况修改
    database_name = 'requirement'
    connection = test.connect_database(database_name)
    result = []
    if connection:
        # 修改查询语句，添加 LIMIT 100
        query = "SELECT custom_name, title, sub_system FROM requirement LIMIT 100"
        rows = test.execute_query(query)
        if rows:
            print("查询结果:")
            for row in rows:
                print(row)
            result = rows
        else:
            print("未查询到数据。")
    else:
        print("数据库连接失败，请检查配置信息。")
    return result


def create_test_database():
    """创建 test 数据库"""
    database_name = 'test'
    if test.create_database(database_name):
        print(f"成功创建数据库 {database_name}")
    else:
        print(f"创建数据库 {database_name} 失败")

def create_test_table():
    """在 test 数据库中创建表"""
    database_name = 'test'
    table_name = 'test_table'
    # 修改表结构，使其与查询字段同步
    table_schema = "custom_name VARCHAR(255), title VARCHAR(255), sub_system VARCHAR(255)"
    if test.create_table(database_name, table_name, table_schema):
        print(f"成功在 {database_name} 中创建表 {table_name}")
    else:
        print(f"在 {database_name} 中创建表 {table_name} 失败")

def insert_test_data():
    """向 test_table 表中插入来自 test_query 的数据"""
    database_name = 'test'
    table_name = 'test_table'
    insert_query = f"INSERT INTO {table_name} (custom_name, title, sub_system) VALUES (%s, %s, %s)"
    data_rows = test_query()
    connection = test.connect_database(database_name)
    if connection and data_rows:
        for data in data_rows:
            test.execute_insert(insert_query, data)
        print(f"成功向 {table_name} 插入 {len(data_rows)} 条数据")
    else:
        if not connection:
            print(f"连接数据库 {database_name} 失败，无法插入数据")
        else:
            print("没有可插入的数据。")

def test_execute_sql():
    # 连接到数据库
    database_name = 'test'
    if test.connect_database(database_name):
        try:
            # 使用 test 数据库
            use_db_sql = "USE test"
            result = test.execute_sql(use_db_sql)
            if result:
                print("成功使用 test 数据库")
            else:
                print("使用 test 数据库失败")

            # 删除 test_table 表中的所有数据
            delete_sql = "DELETE FROM test_table"
            result = test.execute_sql(delete_sql)
            if result:
                print("成功删除 test_table 表中的所有数据")
            else:
                print("删除 test_table 表数据失败")
        except Exception as e:
            print(f"执行 SQL 语句时出错: {e}")
        finally:
            # 关闭数据库连接
            test.close_connection()
    else:
        print(f"无法连接到数据库 {database_name}")

if __name__ == "__main__":
    test_query()
    #test_database_test()
    #test_execute_sql()