滚动的蛋

摘要： > 处理函数(返回多条结果数组) drop FUNCTION cal_charge_sample(records dwd_pv_behavior_di[]); CREATE FUNCTION cal_charge_sample(records dwd_pv_behavior_di[]) RETURN 阅读全文

摘要： import numpy as np import matplotlib.pyplot as plt y = np.array([0, 38.39, 71.41, 99.66, 123.67, 143.88, 160.61, 174.03, 184.16, 190.8, 193.52]) x = n 阅读全文

摘要： 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 阅读全文