xuefliang

 新建一条入库规则 1、端口8085 TCP协议 2、作用域选择 本地IP地址 选择任何IP地址  远程IP地址 选择任何IP地址

 hpv2=(    hpv    .assign(sf=hpv.zjhm.str.startswith('62'))    .query("jz_sj >= '2022-01-01' and jz_sj <= '2022-12-31'")    .drop_duplicates(['zjhm'])    .loc[:,'sjhm']    .dropna(axis=0)    .drop_duplicates()    .astype(str)    .str.slice(0,11) ) # hpv.to_csv('/mnt/d/hpv.csv') # hpv=pd.read_csv('/mnt/d/hpv.csv') (  hpv2  .groupby('sf')  .size() ) #API import requests import json import numpy as np url = 'https://api.uutool.cn/phone/location_batch' # data = {'phone': '18093189854,18919826420'} hpv2=hpv2.to_numpy() results=[] arrays = np.array_split(hpv2, len(hpv2) / 400) for a in arrays:     data={}       data['phone'] = ','.join(a)     response = requests.post(url, data=data)     results.append(json.loads(response.text)['data']['rows'])         DF=pd.DataFrame(columns=['phone', 'isp', 'province', '...

import os import oracledb import sys import pandas as pd import numpy as np import janitor from sqlalchemy import create_engine,text oracledb.init_oracle_client () # engine = create_engine( # f'oracle+oracledb://lxf:lxfXXK2023@192.168.30.48:1521/?service_name=JZDB1') engine = create_engine ( f'oracle+oracledb://lxf:lxfXXK2023@' , connect_args = { "host" : '192.168.30.48' , "port" : 1521 , "service_name" : 'JZDB1' }) sqltxt= ''' select * from IPVSDB.config_ymxx ''' ymxx= ( pd.read_sql ( text ( sqltxt ) , con =engine.connect () ) .clean_names () )

 import time import pandas as pd import numpy as np import requests from bs4 import BeautifulSoup headers = {     "User-Agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36" } year=['2011','2012','2013','2014','2015','2016','2017','2018','2019','2020','2021','2022'] mon=['01','02','03','04','05','06','07','08','09','10','11','12'] tian=pd.DataFrame(columns=['日期', '最高气温', '最低气温', '天气', '风向']) for y in year:     for m in mon:         response=requests.get(f"http://lishi.tianqi.com/pingliang/{y}{m}.html",headers=headers)         time.sleep(0.5)         content = response.text         soup = BeautifulSoup(content,'lxml')         divs = soup.find_all...

 import os import oracledb import sys import pandas as pd from sqlalchemy import create_engine from sqlalchemy import text #需要配置 Oracle Instant Client oracledb.init_oracle_client() params = oracledb.ConnectParams(host="111111111", port=1521, service_name="111111") conn = oracledb.connect(user="11111111111", password="1111111111111",params=params)

  sudo apt-get install '^libxcb.*-dev' libx11-xcb-dev libglu1-mesa-dev libxrender-dev libxi-dev libxkbcommon-dev libxkbcommon-x11-dev

一、conda install cx_Oracle 二、安装 Oracle Instant Client 1、下载了instantclient-basic-linux.x64-11.2.0.4.0.zip   mkdir -p /opt/oracle  cd /opt/oracle/  mv instantclient-basic-linux.x64-11.2.0.4.0.zip  /opt/oracle/  unzip instantclient-basic-linux.x64-11.2.0.4.0.zip 2、将Instant Client永久添加到运行时链接路径  sudo sh -c "echo /opt/oracle/instantclient_11_2  > /etc/ld.so.conf.d/oracle-instantclient.conf"  sudo  ldconfig