semvec/pypi-packages huggingface dataset:
easy-excel-tool 1.0.5
简易、好用的excel操作工具，兼具增删改查，表合并，导出等功能
License: MIT
Requires Python: >=3.6.8
Keywords: easy,excel,tool

# easy excel tool

在实际工作中，沉淀的一些简易、好用的excel数据处理工具，减少重复代码与文件冗余，希望一样能为使用者带来益处。如果您也想贡献好的代码片段，请将代码以及描述，通过邮箱（ [xinkonghan@gmail.com](mailto:hanxinkong<xinkonghan@gmail.com>)
）发送给我。代码格式是遵循自我主观，如存在不足敬请指出！

## 安装

```shell
pip install easy-excel-tool
```

## 主要功能

- `excel`
    - `create_excel` 创建一个空白的excel文件（可指定sheet名）
    - `add_sheet` 对指定excel文件新增sheet页（可指定sheet名）
    - `get_sheet_name` 获取excel文件所有sheet名
    - `remove_sheet` 删除excel文件中指定sheet页
    - `write_excel` 对excel文件写入或追加数据（可指定填充列，保留头部）

## 简单使用

```python
from easy_excel_tool import Excel

excel = Excel('./test.xlsx')
# excel.create_excel(inplace=True)
# excel.add_sheet(sheet_name=[
#     'donation_information',
# ])
data = [
    {'a': 1, 'b': 5, 'c': '88'},
    {'a': 7, 'b': 9, 'c': 66},
]
excel.write_excel(
    data,
    mode='w+',
    sheet_name='Sheet1',
    fill_column={'fill_column': 'fill'},
    header=True,
    inplace=False,
)
```

## 链接

Github：https://github.com/hanxinkong/easy-excel-tool

在线文档：https://easy-excel-tool.xink.top/

## 注明
b-roller 1.6.2
Download resources from several sources across the web
License: MIT
Requires Python: >=3.8,<4.0

# B-Roller

Download B-roll footage from YouTube **for fair use purposes**.

## Usage

### Download from YouTube

```
broll yt [OPTIONS] URL [START] [END]

  Download content from YouTube

Arguments:
  URL      A video id or a YouTube short/long url  [required]
  [START]  The desired start of the video in seconds or the format 00:00:00
  [END]    The desired end of the video in seconds or the format 00:00:00
```

For example:

```shell
broll yt "https://www.youtube.com/watch?v=QFLiIU8g-R0" 00:10 00:17
```
cleanup 1.0.4
A simple command line utility that organises files in a directory into subdirectories.
License: MIT
Keywords: cleanup file-organiser file-organisation file-management hue docopt

# CleanUp

[![GitHub Actions][gh-actions-shield]][gh-actions-link]
[![PyPI][pypi-shield]][pypi-link]
[![License][license-shield]][license-link]

A simple command line utility that organises files in a directory into subdirectories based on the files' extensions.

## Usage

![Usage](https://i.imgur.com/iATfu3Y.png)

When run without any option, it organises the files in the specified directory into subdirectories based on the files' extensions.

### Options

* #### `-d`, `--dry-run`
  
  Just displays the changes that would be made, without actually doing anything.
  
  ```bash
  cleanup -d path/to/dir        # dry run the cleanup
  cleanup -dr path/to/dir       # dry run the reverting a cleanup
  ```

* #### `-s`, `--silent`
  
  Prevents displaying any information while performing operations. Errors, however, are displayed irrespective of whether this option is enabled or not.

  ```bash
  cleanup -s path/to/dir        # silently cleanup
  cleanup -sr path/to/dir       # silently revert a cleanup
  ```

* #### `-r`, `--revert`
  
  Reverts the cleanup of a directory. Note that for this to work, the specified directory should have been cleaned up before.

  ```bash
  cleanup -r path/to/dir        # revert the cleanup of a directory
  ```

* #### `-h`, `--help`
  
  Displays the help text.

  ```bash
  cleanup -h
  ```

## Development

### Setup

1. Clone the repo and `cd` into it.

2. Set up a Python 3 virtual environment using [pipenv](https://docs.pipenv.org):
   ```bash
   pipenv --three         # create Python 3 virtual environment
   pipenv install --dev   # install all dependencies
   pipenv shell           # activate virtual environment shell
   ```

3. The cleanup script can now be run from the root directory of the project:
   ```bash
   python3 -m cleanup.cleanup -h
   ```

### Test

Make sure you're in the root directory of the project. You can then run the test using:
```bash
python3 -m tests.test
```

## License

This project is licensed under the terms of the [MIT license][license-link].


[gh-actions-shield]: https://img.shields.io/github/actions/workflow/status/faheel/cleanup/ci.yml?style=for-the-badge&logo=github
[gh-actions-link]: https://github.com/faheel/cleanup/actions/workflows/ci.yml
[pypi-shield]: https://img.shields.io/pypi/v/cleanup.svg?style=for-the-badge
[pypi-link]: https://pypi.org/project/cleanup
[license-shield]: https://img.shields.io/github/license/faheel/cleanup.svg?style=for-the-badge
[license-link]: https://github.com/faheel/cleanup/blob/master/LICENSE