python: datatype convert

已于 2024-12-09 22:12:32 修改
阅读量135 收藏
点赞数 2
分类专栏： Python 文章标签： python postgresql mysql sqlserver sqlite sqlite3 oracle
于 2024-12-09 22:01:43 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/geovindu/article/details/144358925
版权 
# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述： 数据类型换
# https://learn.microsoft.com/en-us/sql/machine-learning/python/python-libraries-and-data-types?view=sql-server-ver16
# sql server https://docs.devart.com/python/sqlserver/data-types.htm
# sql server https://zontroy.com/mssql-to-python-type-mapping
# mysql https://zontroy.com/mysql-to-python-type-mapping
# mysql https://docs.devart.com/python/mysql/data-types.htm
# postgresql https://zontroy.com/postgresql-to-python-type-mapping
# postgresql https://docs.devart.com/python/postgresql/data-types.htm
# oracle  https://zontroy.com/oracle-to-python-type-mapping
# oracle https://docs.devart.com/python/oracle/data-types.htm
# sqlite https://docs.devart.com/python/sqlite/data-types.htm
# datatype convert
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : 2024/12/9 21:39
# User      : geovindu
# Product   : PyCharm
# Project   : pyGenerator
# File      : datatypeConvert.py
# explain   : 学习
 
class DataTyepconvert(object):
    """
    數據類型轉換
    """
    def __init__(self):
        """
 
        """
        self._strdatabase = "sql server、mysql、postgresql、oracle、sqlite"
        pass
 
    @staticmethod
    def SqlServerconvertt(datattype:str)->str:
        """
        sql server 數據類型轉換 python datatype
        :param dtattype:
        :return:
        """
        pythodatatype=""
        dtattype=datattype.lower()
        try:
            match dtattype:
                case "int":
                    pythodatatype="int"
                    pass
                case "char":
                    pythodatatype ="str"
                    pass
                case "nchar":
                    pythodatatype = "str"
                    pass
                case "nvarchar":
                    pythodatatype = "str"
                    pass
                case "bigint":
                    pythodatatype="float64"
                    pass
                case "binary":
                    pythodatatype ="bytes"
                    pass
                case "bit":
                    pythodatatype = "bool"
                    pass
                case "date":
                    pythodatatype = "datetime"
                    pass
                case "datetime":
                    pythodatatype = "datetime"
                case "datetime2":
                    pythodatatype = "datetime"
                case "time":
                    pythodatatype = "time"
                case "real":
                    pythodatatype="float64"
                    pass
                case "smalldatetime":
                    pythodatatype ="datetime"
                    pass
                case "smallint":
                    pythodatatype = "int32"
                    pass
                case "tinyint":
                    pythodatatype = "int32"
                    pass
                case "uniqueidentifier":
                    pythodatatype="str"
                    pass
                case "float":
                    pythodatatype ="float"
                    pass
                case "varbinary":
                    pythodatatype = "bytes"
                    pass
                case "decimal":
                    pythodatatype = "float"
                    pass
                case "image":
                    pythodatatype="bytes"
                    pass
                case "money":
                    pythodatatype ="float"
                    pass
                case "smallmoney":
                    pythodatatype ="float"
                    pass
                case "numeric":
                    pythodatatype ="float"
                    pass
                case "text":
                    pythodatatype = "str"
                    pass
                case "ntext":
                    pythodatatype = "str"
                    pass
                case _:
                    pythodatatype='str'
                    pass
        except ValueError as erro:
            pythodatatype = 'str'
 
        return pythodatatype
 
    @staticmethod
    def mySQLconvert(datattype:str)->str:
        """
        mySQL 數據類型轉換 python datatype
        :param dtattype:
        :return:
        """
        pythodatatype=""
        dtattype=datattype.lower()
        try:
            match dtattype:
                case "char":
                    pythodatatype="str"
                    pass
                case "varchar":
                    pythodatatype ="str"
                    pass
                case "enum":
                    pythodatatype = "str"
                    pass
                case "set":
                    pythodatatype="str"
                    pass
                case "tinytext":
                    pythodatatype ="str"
                    pass
                case "mediumtext":
                    pythodatatype = "str"
                    pass
                case "text":
                    pythodatatype="str"
                    pass
                case "longtext":
                    pythodatatype ="str"
                    pass
                case "json":
                    pythodatatype = "str"
                    pass
                case "bit":
                    pythodatatype="int"
                    pass
                case "tinyint":
                    pythodatatype ="int"
                    pass
                case "tinyint unsigned":
                    pythodatatype = "int"
                    pass
                case "smallint":
                    pythodatatype = "int"
                    pass
                case "smallint unsigned":
                    pythodatatype = "int"
                    pass
                case "mediumint":
                    pythodatatype = "int"
                    pass
                case "mediumint unsigned":
                    pythodatatype = "int"
                    pass
                case "int":
                    pythodatatype = "int"
                    pass
                case "int unsigned":
                    pythodatatype = "int"
                    pass
                case "bigint":
                    pythodatatype = "int"
                    pass
                case "bigint unsigned":
                    pythodatatype = "int"
                    pass
                case "year":
                    pythodatatype = "int"
                    pass
                case "decimal":
                    pythodatatype = "float"
                    pass
                case "float":
                    pythodatatype = "float"
                    pass
                case "double":
                    pythodatatype = "float"
                    pass
                case "date":
                    pythodatatype = "date"
                    pass
                case "time":
                    pythodatatype = "time"
                    pass
                case "datetime":
                    pythodatatype = "datetime"
                    pass
                case "timestamp":
                    pythodatatype = "datetime"
                    pass
                case "binary":
                    pythodatatype = "binary"
                    pass
                case "varbinary":
                    pythodatatype = "binary"
                    pass
                case "tinyblob":
                    pythodatatype = "bytes"
                    pass
                case "blob":
                    pythodatatype = "bytes"
                    pass
                case "mediumblob":
                    pythodatatype = "bytes"
                    pass
                case "longblob":
                    pythodatatype = "bytes"
                    pass
 
                case _:
                    pythodatatype='str'
                    pass
        except ValueError as erro:
            pythodatatype = 'str'
 
        return pythodatatype
 
    @staticmethod
    def postgreSQLconvert(datattype:str)->str:
        """
        postgreSQL 數據類型轉換 python datatype
        :param dtattype:
        :return:
        """
        pythodatatype=""
        dtattype=datattype.lower()
        try:
            match dtattype:
                case "character":
                    pythodatatype="str"
                    pass
                case "character varying":
                    pythodatatype ="str"
                    pass
                case "text":
                    pythodatatype = "str"
                    pass
                case "smallint":
                    pythodatatype = "int"
                    pass
                case "integer":
                    pythodatatype = "int"
                    pass
                case "bigint":
                    pythodatatype = "int"
                    pass
                case "serial":
                    pythodatatype = "int"
                    pass
                case "bigserial":
                    pythodatatype = "int"
                    pass
                case "real":
                    pythodatatype = "float"
                    pass
                case "double precision":
                    pythodatatype = "float"
                    pass
                case "numeric":
                    pythodatatype = "numeric"
                    pass
                case "date":
                    pythodatatype = "date"
                    pass
                case "time":
                    pythodatatype = "time"
                    pass
                case "time with time zone":
                    pythodatatype = "time"
                    pass
                case "timestamp":
                    pythodatatype = "datetime"
                    pass
                case "timestamp with time zone":
                    pythodatatype = "datetime"
                    pass
                case "bytea":
                    pythodatatype = "binary"
                    pass
                case "point":
                    pythodatatype = "point"
                    pass
                case "lseg":
                    pythodatatype = "lseg"
                    pass
                case "line":
                    pythodatatype = "line"
                    pass
                case "path":
                    pythodatatype = "path"
                    pass
                case "polygon":
                    pythodatatype = "polygon"
                    pass
                case "box":
                    pythodatatype = "box"
                    pass
                case "circle":
                    pythodatatype = "circle"
                    pass
                case _:
                    pythodatatype='str'
                    pass
        except ValueError as erro:
            pythodatatype = 'str'
 
        return pythodatatype
 
 
    @staticmethod
    def SQLiteconvert(datattype:str)->str:
        """
        SQLite 數據類型轉換 python datatype
        :param dtattype:
        :return:
        """
        pythodatatype=""
        dtattype=datattype.lower()
        try:
            match dtattype:
                case "int8":
                    pythodatatype="int"
                    pass
                case "tinyint":
                    pythodatatype ="int"
                    pass
                case "int2":
                    pythodatatype = "int"
                    pass
                case "smallint":
                    pythodatatype = "int"
                    pass
                case "int":
                    pythodatatype = "int"
                    pass
                case "integer":
                    pythodatatype = "int"
                    pass
                case "mediumint":
                    pythodatatype = "int"
                    pass
                case "int64":
                    pythodatatype = "int"
                    pass
                case "bigint":
                    pythodatatype = "int"
                    pass
                case "unsigned bigint":
                    pythodatatype = "int"
                    pass
                case "real":
                    pythodatatype = "float"
                    pass
                case "float":
                    pythodatatype = "float"
                    pass
                case "double":
                    pythodatatype = "float"
                    pass
                case "char":
                    pythodatatype = "str"
                    pass
                case "varchar":
                    pythodatatype = "str"
                    pass
                case "text":
                    pythodatatype = "str"
                    pass
                case "date":
                    pythodatatype = "date"
                    pass
                case "time":
                    pythodatatype = "time"
                    pass
                case "datetime":
                    pythodatatype = "datetime"
                    pass
                case "timestamp":
                    pythodatatype = "datetime"
                    pass
                case "blob":
                    pythodatatype = "binary"
                    pass
                case "binary":
                    pythodatatype = "binary"
                    pass
                case "unknown":
                    pythodatatype = "str"
                    pass
 
                case _:
                    pythodatatype='str'
                    pass
        except ValueError as erro:
            pythodatatype = 'str'
 
        return pythodatatype
 
    @staticmethod
    def oracleconvert(datattype:str)->str:
        """
        oracle 數據類型轉換 python datatype
        :param dtattype:
        :return:
        """
        pythodatatype=""
        dtattype=datattype.lower()
        try:
            match dtattype:
                case "char":
                    pythodatatype="str"
                    pass
                case "varchar2":
                    pythodatatype ="str"
                    pass
                case "nchar":
                    pythodatatype = "str"
                    pass
                case "nvarchar2":
                    pythodatatype = "str"
                    pass
                case "clob":
                    pythodatatype = "str"
                    pass
                case "nclob":
                    pythodatatype = "str"
                    pass
                case "cfile":
                    pythodatatype = "str"
                    pass
                case "long":
                    pythodatatype = "str"
                    pass
                case "rowid":
                    pythodatatype = "str"
                    pass
                case "urowid":
                    pythodatatype = "str"
                    pass
                case "float":
                    pythodatatype = "float"
                    pass
                case "binary_float":
                    pythodatatype = "float"
                    pass
                case "binary_double":
                    pythodatatype = "float"
                    pass
                case "number":
                    pythodatatype = "float"
                    pass
                case "integer":
                    pythodatatype = "int"
                    pass
                case "decimal":
                    pythodatatype = "float"
                    pass
                case "date":
                    pythodatatype = "date"
                    pass
                case "timestamp":
                    pythodatatype = "datetime"
                    pass
                case "timestamp with time zone":
                    pythodatatype = "datetime"
                    pass
                case "timestamp with local time zone":
                    pythodatatype = "datetime"
                    pass
                case "blob":
                    pythodatatype = "binary"
                    pass
                case "bfile":
                    pythodatatype = "binary"
                    pass
                case "raw":
                    pythodatatype = "binary"
                    pass
                case "long raw":
                    pythodatatype = "binary"
                    pass
                case _:
                    pythodatatype='str'
                    pass
        except ValueError as erro:
            pythodatatype = 'str'
 
        return pythodatatype

Python~AssertionError: dataType ＜class ‘pyspark.sql.types.StringType‘＞ should be an instance of
feizuiku0116的博客
11-14 1415
错误提示 Traceback (most recent call last): File "/tmp/pycharm_project_639/pyspark-chapter01_3.8/1.py", line 17, in <module> schema = StructType()\ File "/root/anaconda3/envs/pyspark_env/lib/python3.8/site-packages/pyspark/sql/types.py", line 553
python list和series转换dataframe_Python：将dataframe列从Series转换为Datetime datatype
weixin_28868483的博客
02-19 2447
您可以使用带格式字符串的to_datetime()来提取日期：date = pd.to_datetime(df.Start_Time, format='%Y, %m, %d').dt.date也可以修改在位日期：^{pr2}$或者，您可以在读取csv时将其转换为日期：to_date = lambda x: pd.to_datetime(x, format='%Y, %m, %d').date()c...
python将object转换为float,如何在python中将datatype：object转换为float64？
weixin_42521424的博客
12-08 1631
I am going around in circles and tried so many different ways so I guess my core understanding is wrong. I would be grateful for help in understanding my encoding/decoding issues.I import the datafram...
Python Datatype Conversions
maxzcl的博客
12-15 722
Bytes & Float Bytes to Float ​​​​​​python - Convert Bytes to Floating Point Numbers? - Stack Overflow ==> struct Python struct pack, unpack - JournalDev official doc:struct — Interpret bytes as packed binary data — Python 3.7.12 documentation .
python将object转换为float_如何在python中将datatype:object转换为float64？
weixin_39623713的博客
12-08 3727
您可以通过调用^{}来转换大多数列：In [36]:df = df.convert_objects(convert_numeric=True)df.dtypesOut[36]:Date objectWD int64Manpower float642nd objectCTR object2ndU float...
python中tensorflow是什么_关于python：TensorFlow字符串：它们是什么以及如何使用它们...
weixin_36476970的博客
12-29 477
当我用tf.read_file读取文件时，我得到了类型为tf.string的东西。文档只说这是"可变长度字节数组。张量的每个元素都是字节数组。" (https://www.tensorflow.org/versions/r0.10/resources/dims_types.html)。我不知道该怎么解释。这种类型我什么也做不了。在通常的python中，您可以通过my_string[:4]之类的索引...
python datetime模块timedelta,Python：如何从datetime.timedelta对象获取时间？
weixin_29616999的博客
12-03 273
A mysql database table has a column whose datatype is time ( http://dev.mysql.com/doc/refman/5.0/en/time.html ). When the table data is accessed, Python returns the value of this column as a datetime....
错误记录关于二维数组的调用error: cannot convert ‘int**‘ to ‘int (*)[48]‘
热门推荐
Growzhang的博客
11-01 2万+
数组相信大家都不会陌生，编程中常见的一种数据类型。 现在说的问题是关于二维数组调用的一些情况。 int a[5][5] 像这样我们随便定义一个二维数组，在传递参数的时候像这样就OK了 void f(int a[][5]) { /*....*/ } 当然还有一些其他的方法可以处理函数调用的问题，当然这个问题并不是这篇博客所讨论的重点，在一次写程序中： #include <stdlib.h> #include <stdio.h> #include <string.h&g
python图像切割成多边形_Python：用于剪切带有多边形的光栅图像的函数的代码检查...
weixin_39960793的博客
12-11 459
我正在请求审核以下代码.我有一个空间参考图像和一个多边形.我编写了一个代码(见下文)来剪辑此图像以保存新图像(剪裁区域).此功能基于要素类的几何图形剪切栅格.基于几何体的剪切意味着您将使用要素类中所有要素的边界来剪切栅格,而不是这些要素的最小边界矩形输入：多边形图层和一个或多个栅格图层输出：新的栅格图层,剪切为多边形边界import osgeo.gdalimport shapefileimport...
【ILWIS x Python：无限可能】：用Python脚本拓展ILWIS边界
本文探讨了ILWIS与Python集成的实践与应用，涵盖了ILWIS的基本操作、数据处理和功能扩展等方面。文章首先介绍了ILWIS软件及其在地理信息系统中的应用，随后阐述了Python脚本在ILWIS自动化操作中的潜力与实践。在数据...
how to use python to convert a datatype from 1.0 to 1
07-13
To convert a data type from 1.0 to 1 in Python, you can use the `int()` function to convert the float to an integer. Here&#39;s an example: ```python value = 1.0 converted_value = int(value) print...
Cannot use median strategy with non-numeric data: could not convert string to float: ‘＜1
Ducunyu的博客
10-19 4115
创建一个imputer实例, 指定你要用属性中的中位数替代该属性的缺失值，再使用fit()方法将imputer实例适配到训练集，实现代码如下： from sklearn.impute import SimpleImputer imputer = SimpleImputer(strategy='median') imputer.fit(housing) 运行结果如下： ValueError: Cannot use median strategy with non-numeric data: could n
基于WebUI的深度学习模型部署与应用实践
Programming Talk
05-06 470
随着深度学习技术的快速发展，如何将训练好的模型快速部署并提供友好的用户交互界面成为许多AI项目落地的关键。WebUI(Web User Interface)作为一种轻量级、跨平台的解决方案，正被广泛应用于各类AI模型的部署场景。本文将详细介绍基于Python生态构建WebUI的技术方案，包含完整的代码实现，并探讨在实际项目中的应用实践。本文详细介绍了基于Gradio构建深度学习WebUI的完整流程，从基础实现到生产部署，涵盖了实际项目中的关键技术和优化方案。二、基于Gradio的模型部署实践。
Python办公自动化应用（三）
2301_78858267的博客
05-07 468
根据中、英文对照字典（参见Python办公自动化应用（一））将Excel表单元格里的中文替换为英文。
QuecPython错误码汇总
Quectel的博客
05-06 684
QuecPython中定义的各种错误代码常量
CentOS9与Windows通过Samba实现永久共享配置
最新发布
m0_74744788的博客
05-09 358
对于Samba服务的正常运行至关重要。首先设置SELinux布尔值(或者直接关了selinux)如果上述命令无法成功执行，可能需要手动添加Samba使用的端口。配置防火墙和SELinux策略（如果可以直接把防火墙关了）最后在windows资源管理器里输入linux ip。重启Samba服务并设置开机自启动。
麒麟系统如何卸载Anaconda
qq_42078147的博客
05-09 254
在麒麟操作系统（Kylin OS）上卸载 Anaconda 的步骤与在其他 Linux 系统上类似。
两次解析格式化字符串 + 使用SQLAlchemy的relationship执行任意命令 -- link-shortener b01lersCTF 2025
weixin_59166557的博客
05-05 843
我们可以用一个 「仓库管理员」 的比喻，来形象地理解 SQLAlchemy ORM：你有一个巨大的仓库（数据库），里面堆满了各种货物（数据）。仓库的货架结构复杂，每个货架对应一张表格（数据库表），比如「图书货架」「用户货架」等。传统方式中，如果你想存取货物，必须手动填写复杂的单据（写SQL语句），比如： 但有了 SQLAlchemy ORM，仓库里会出现一个聪明的 「机器人管理员」，它帮你把仓库的复杂结构翻译成你熟悉的 Python 对象和代码！用Python类定义货架结构： 你不再需要记住货架的复杂布局，
Python初学者笔记第十一期 -- （字符串编程练习题）
Pi_Qiu_的博客
05-07 624
输入一个字符串，判断其是否是回文字符串。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值