分钟数据序号转分钟

import pandas as pd
index = pd.date_range('2021-01-01 09:31:00', periods=120, freq='1min')
series = pd.Series(range(1,121), index=index)
print(series)

 

    server = '127.0.0.1'
    database = 'Stock'
    username = 'sa'
    password = 'root'

    index_list = list(range(1, 121))



    cnxn = pyodbc.connect(
        'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)
    sw_init_date = datetime(2021, 1, 1, 9, 30, 0)
    xw_init_date = datetime(2021, 1, 1, 13, 0, 0)

    for i_sw in index_list:
        i_minute = sw_init_date + timedelta(minutes=i_sw)
        i_minute_value = ' ' + i_minute.strftime('%H:%M:%S')
        sql = 'INSERT INTO [dbo].[minute_dict] \
                    ([minute_index] \
                    ,[minute_value])\
                VALUES({0},\'{1}\')'.format(i_sw,i_minute_value)
        cnxn.execute(sql)

    for i_xw in index_list:
        i_minute = xw_init_date + timedelta(minutes=i_xw)
        i_minute_value = ' '+i_minute.strftime('%H:%M:%S')
        sql = 'INSERT INTO [dbo].[minute_dict] \
                            ([minute_index] \
                            ,[minute_value])\
                        VALUES({0},\'{1}\')'.format(i_xw, i_minute_value)

        cnxn.execute(sql)
    cnxn.commit()