Skip to main content

simtoolsz

PyPI - License PyPI - Version Python - Version

English | 中文

一个简单、方便的工具集合,均是个人工作中的常用功能。对之前pytoolsz工具包的精简重构,保留最实用的功能模块。

部分功能可能还有问题,如果使用中发现问题还请反馈给我。

功能特性

🕐 时间处理 (simtoolsz.datetime)

  • 时间格式转换: 支持多种时间格式间的相互转换(中文、英文、ISO8601、秒、分钟、小时等)
  • 智能格式识别: 自动识别输入的时间格式类型
  • 枚举支持: 提供 DurationFormat 枚举类,标准化时间格式处理
  • 时间计算: 支持时间跨度的计算和转换

📧 邮件处理 (simtoolsz.mail)

  • 邮件发送: 支持HTML/纯文本邮件,附件、抄送、密送
  • 邮件接收: IMAP协议邮件读取,支持主题搜索
  • 编码支持: UTF-7编码解码,处理国际化邮件
  • 内嵌图片: 支持HTML邮件中的内嵌图片

💾 数据处理 (simtoolsz.db)

  • 压缩包数据读取: 直接从ZIP压缩包读取CSV、Excel、Parquet、JSON数据到DuckDB
  • 特殊格式支持: 支持TSV、Avro、Arrow等特殊格式文件的数据库转换
  • 批量处理: 支持多文件批量导入数据库
  • 灵活配置: 可自定义表名映射和导入参数

📖 数据读取 (simtoolsz.reader)

  • 多格式读取: 统一接口读取CSV、TSV、Excel、Parquet、JSON、IPC、Avro等格式
  • Polars集成: 基于Polars的高性能数据读取
  • 智能选择: 根据文件扩展名自动选择合适的读取器
  • Lazy加载支持: 支持大数据集的懒加载模式

🛠️ 工具函数 (simtoolsz.utils)

  • 日期获取: today() 函数,支持时区、格式化、标准datetime对象返回
  • 列表操作: take_from_list() 智能列表元素查找
  • 文件夹操作: checkFolders() 批量文件夹检查和创建
  • 文件查找: lastFile() 基于时间或大小的文件查找

国家代码转换 (simtoolsz.countrycode)

  • 国家名称到代码: 支持将国家名称转换为对应的ISO 3166-1 alpha-2代码
  • 代码到国家名称: 支持将ISO 3166-1 alpha-2代码转换为国家名称
  • G7/G20国家列表: 提供G7和G20国家的代码列表
  • 多类型国家代码转换:支持类型丰富,详细可见代码转换模块说明

安装

pip install simtoolsz

核心依赖

  • Python >= 3.11
  • pendulum >= 3.1.0
  • duckdb >= 1.4.0
  • polars >= 1.0.0

快速开始

时间格式转换

from simtoolsz.datetime import TimeConversion

# 中文时间到秒
tc = TimeConversion("1天2小时30分钟45秒", "chinese")
seconds = tc.convert("seconds")
print(f"1天2小时30分钟45秒 = {seconds}秒")

# 秒到中文时间
tc = TimeConversion(90061, "seconds")
chinese = tc.convert("chinese")
print(f"90061秒 = {chinese}")

发送邮件

from simtoolsz.mail import send_email

# 发送纯文本邮件
result = send_email(
    email_account="your@qq.com",
    password="your_password",
    subject="测试邮件",
    content="这是一封测试邮件",
    recipients="friend@example.com"
)

# 发送HTML邮件带附件
result = send_email(
    email_account="your@gmail.com",
    password="app_password",
    subject="项目报告",
    content="<h1>本月工作报告</h1><p>详见附件</p>",
    recipients=["boss@company.com", "同事<colleague@company.com>"],
    attachments=["report.pdf", "data.xlsx"],
    html_mode=True
)

数据读取

from simtoolsz.reader import getreader
import polars as pl

# 使用getreader读取CSV文件
reader = getreader("data.csv")
df = reader("data.csv")

# 读取TSV文件
df = load_tsv("data.tsv")

# Lazy加载大数据集
lazy_df = load_data("large_data.csv", lazy=True)

# 加载压缩数据集
df = load_data("large_data_archive.tar.gz/data.csv")

压缩包数据导入数据库

from simtoolsz.db import zip2db

# 从ZIP文件读取数据到DuckDB
con = zip2db(
    zip_file="data.zip",
    db_file="output.db",
    table={"users.csv": "用户表", "orders.xlsx": "订单表"}
)

# 查询数据
tables = con.execute("SHOW TABLES").fetchall()
print(f"导入的表: {tables}")

工具函数

from simtoolsz.utils import today, take_from_list

# 获取当前日期时间
current = today(addtime=True)
formatted = today(fmt="YYYY年MM月DD日 HH:mm:ss")

# 列表查找
result = take_from_list("hello", ["he", "world"])  # 返回 "he"
result = take_from_list([2, 3], [1, 2, 3, 4])    # 返回 2

国家代码转换

from simtoolsz.countrycode import CountryCode

# 初始化国家代码转换工具
cc = CountryCode()

# 转换国家名称到代码
code = cc.convert("中国")  # 返回 "CN"

# 转换代码到国家名称
name = cc.convert("US", target="name")  # 返回 "United States"

# 获取G7国家列表
g7 = cc.convert("G7", target="name")
print(g7)

Metadata

Release files for simtoolsz 0.2.16

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

Source distribution (sdist)

Source distribution for simtoolsz 0.2.16
File Size Uploaded
simtoolsz-0.2.16.tar.gz 161.5 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for simtoolsz 0.2.16
File Interpreter ABI Platform
simtoolsz-0.2.16-py3-none-any.whl Python 3 none any Details

Total release size: 240.2 kB

Release files / simtoolsz-0.2.16.tar.gz

Download URL simtoolsz-0.2.16.tar.gz
Size 161.5 kB
Tags Source
SHA-256 checksum
How to use checksums
27362883221ffabe1658d5ad786f0b04e201fba0c220775f6cdec0502c3429a8
BLAKE2b-256 checksum
How to use checksums
0cbf9f78f3ac071abf54a392cbfe47586cfe730c1ea6d7f0fa05ae48a2d86b94
Upload date
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.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Jun 30, 2026.

Transparency log

Release files / simtoolsz-0.2.16-py3-none-any.whl

Download URL simtoolsz-0.2.16-py3-none-any.whl
Size 78.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
e57dcde6655cd0b16037f9762c9b5aaa0a7e248b6f5eb8435d9e8ae28bb04390
BLAKE2b-256 checksum
How to use checksums
be7640ca9f682e5829a9977f3ac7a45879b0e00ed08ad9b82d005e2a5c3e2a64
Upload date
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.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Jun 30, 2026.

Transparency log

Release history Release notifications | RSS feed

This release

0.2.16 This release

2 release files

0.2.15

2 release files

0.2.13

2 release files

0.2.12

2 release files

0.2.11

2 release files

0.2.10

2 release files

0.2.9

2 release files

0.2.8

2 release files

0.2.6

2 release files

0.2.5

2 release files

0.2.2

2 release files

0.2.1

2 release files

0.2.0

2 release files

0.1.15

2 release files

0.1.13

2 release files

0.1.12

2 release files

0.1.11

2 release files

0.1.10

2 release files

0.1.7

2 release files

0.1.6

2 release files

0.1.5

2 release files

0.1.4

2 release files

0.1.3

2 release files

0.1.1

2 release files

0.1.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page