常用代码片段

获取excel数据

import pandas as pd
 # 其中总获取的数据为多维列表，通过for循环可以取出数据
def a(path,sheet_name):
    try:
        df = pd.read_excel(io=path,sheet_name=sheet_name)
    except FileNotFoundError as f:
        print(f)
    else:
        zong = df.values

将数据保存为excel格式,要保证数据长度相同才能保存

import pandas as pd
df2 = pd.DataFrame(zip(list_time, list_dianliu, list_h1, list_h2,list_h3,list_h4),
                           columns=['时间', 'A相电流', '环境温度1', '环境温度2', '环境温度3', '环境温度4'])
df2.to_excel(excel_writer=r'D:\1物联网\对比数据\1118\初步结果.xlsx'
                     )

将获取的时间戳数据解析，注意要将字符串形式的转为浮点型

t = '1573987216.74333'
t2 = time.localtime(float(t))
time_datas=time.strftime("%Y-%m-%d-%H:%M:%S", t2)
print(time_datas)

sqlite数据库查询语句

    try:
        # 创建连接对象，连接本地数据库
        conn = sqlite3.connect(r'C:\Users\Administrator\Desktop\sqlite_001.db')
        # 创建一个游标对象，调用 execute()执行SQL语句
        c = conn.cursor()
        # c.execute(
        #     ''' CREATE TABLE  if not exists day_datas
        # (ID INTEGER PRIMARY KEY AUTOINCREMENT,
        # TIME_NAME CHAR (20),
        # SIGE_NAME CHAR (10),
        # DATA_NAME CHAR(100))''')
    except sqlite3.Error as error:
        print(error)
    else:
        # sql1 = 'select TIME_NAME,DATA_NAME from day_datas'

        sql2 = 'SELECT * FROM "main"."day_datas" WHERE _rowid_ BETWEEN 63450 and 73110' ##注意这句

将16进制的数据，通过列表解析（首先将字符串——>byte——>list()）#即可解析数据

d1 ='010380001300130014000000e300e300e30000006c0000000017d800000000006400150000006d17d8000d0c6e61f90f46c7eb000000000000000000000000000000a600a4000000000000000000000000000000000000000000005a4909805a4909805a49098000000000000000000000000000000000000000000000000000000000'
d2=d1[6:]
def HexToByte(hexStr):
    return bytes.fromhex(hexStr)
hh = HexToByte(d2)
# print(hh)
ll = list(hh)
print(ll,len(ll))

16进制数据转为10进制可读数据

def x_int16(a):
    return int(a,16)