xhga

通过跳板机ssh远程连接mysql:import pymysqlfrom sshtunnel import SSHTunnelForwarderimport requestsimport datetimewith SSHTunnelForwarder( ssh_address_or_host=('ssh-Ip', 22), ssh_password='ssh-密码', ssh_username='ssh-用户', remote_b

Python获取印度各银行对应的ifsc(前4位)：import requestsimport reheaders = { "User-Agent":"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3...

import numpy as npimport pandas as pdmy_list = list('abcdefghi')my_arr = np.arange(26)my_dict = dict(zip(my_arr, my_list))series = pd.Series(my_dict)print('--------------------------series dat...

import pymysql# 建立连接connect_stat = pymysql.Connect(host='localhost', port=3306, user='root', passwd='123456', db='stats', charset='utf8')cursor = connect_stat.cursor()# 查询sqlcursor.execute("sele...

引入 xlsxwriter 包import xlsxwriterworkbook = xlsxwriter.Workbook('currency_format.xlsx')cell_format_one = workbook.add_format({'bold': True, 'font_color': 'red'})cell_format_two = workbook.add_f...

1.连接数据库import pymysqlimport xlsxwriterconnect = pymysql.Connect(host='localhost', port=3306, user='root', passwd='123456', db='luck', charset='utf8')cursor = connect.cursor()cursor.execu...