摘要： 1、字符串转datetime from datetime import datetime, timedelta time_a = datetime.strptime('2022-09-03 20:31:10', "%Y-%m-%d %H:%M:%S") 2、datetime转字符串 str_time 阅读全文

摘要： 1、分组求和 import pandas as pd from datetime import datetime, timedelta data = pd.DataFrame({ "company": ["A", "A", "A", "A", "A", "A", "A", "A", "A", "A" 阅读全文

摘要： 1、按照索引取值 data=pd.DataFrame({ "company":["A","A","A","A","A","A","A","A","A","A","A","A"], "salary":[10,12,13,36,12,10,12,13,36,12,36,12], "age":[3,1,1 阅读全文

摘要： import psycopg2 conn = psycopg2.connect(database="sdp", user="kiki", password="123", host="", port="5432") cursor = conn.cursor() stats_sql = "select 阅读全文

摘要： 1、查询进程阻塞进程 select * from pg_stat_activity where wait_event_type = 'Lock'; 2、杀死进程 select pg_terminate_backend(pid)； 阅读全文

摘要： select * from table_a partition(p1) 阅读全文

摘要： 1、将所有的csv文件放到一个文件夹，位置任意。2、打开cmd，切换到存放csv的文件夹，也可以在csv文件夹中，按住shift加鼠标右键，选择在此处打开命令窗口。3、输入copy *.csv all.csv，all-group的名字，可以任意。然后按enter，等待完成就可以了。4、打开csv文件 阅读全文

摘要： Clickhouse 分组查询排序取第一条数据 -- Note: Unless you save your query, these tabs will NOT persist if you clear your cookies or change browsers. SELECT vin, veh 阅读全文

摘要： spring: cloud: gateway: globalcors: corsConfigurations: '[/**]': allowedHeaders: "*" allowedOriginPatterns: "*" allowCredentials: true allowedMethods: 阅读全文

摘要： 1、自定义typeHandler package com.apollo.cloud.common.core.mybatis.typehandler; import java.sql.CallableStatement; import java.sql.PreparedStatement; impor 阅读全文