首页
关于
Search
1
git lg彩色显示日志
28 阅读
2
在 Ubuntu 22.04 LTS 中安装 Docker
19 阅读
3
CentOs/Ubuntu搭建上网x-ui
18 阅读
4
git使用多个源和多个分支
15 阅读
5
清理Windows臃肿程序
15 阅读
默认分类
网站搭建
Windows
Linux
Docker
OpenWrt
Hackintosh
Git
Python
Web开发
JavaScript
FFmpeg
Demo
工具
刷机
油猴脚本
Excel
Chrome Extension
登录
Search
标签搜索
Pandas
读取
时区
Chrome
centos8
求和
Nginx
Typecho
404
csv
国际站
询盘导出
油猴脚本
bbr
Ubuntu
远程桌面
日志
log
数据清洗
打印机
野生程序猿
累计撰写
153
篇文章
累计收到
0
条评论
首页
栏目
默认分类
网站搭建
Windows
Linux
Docker
OpenWrt
Hackintosh
Git
Python
Web开发
JavaScript
FFmpeg
Demo
工具
刷机
油猴脚本
Excel
Chrome Extension
页面
关于
搜索到
153
篇与
的结果
2022-10-19
Python统计时间段频次demo
import datetime import pandas as pd # from pprint import pprint from pytz import timezone,all_timezones fmt = "%Y-%m-%d %H:%M:%S %Z%z" # Current time in UTC now_utc = datetime.datetime.now(timezone('UTC')) print(now_utc.strftime(fmt)) # Convert to US/Pacific time zone now_pacific = now_utc.astimezone(timezone('US/Pacific')) print(now_pacific.strftime(fmt)) now_pabeijing = now_utc.astimezone(timezone('Asia/Shanghai')) print(now_pabeijing.strftime(fmt)) # for zone in all_timezones: # if 'Asia' in zone: # print(zone) def get_loacl(x): if type(x['时间']) == str: time_str = x['日期']+' '+x['时间'] dt = datetime.datetime.strptime(time_str,'%Y/%m/%d %H:%M PDT') dt = timezone('US/Pacific').localize(dt) dt_beijing = dt.astimezone(timezone('Asia/Shanghai')) print(time_str,dt,dt_beijing) return dt_beijing else: return x['时间'] def calc_hours(df): # 生成24小时时间段 times = [] for i in range(24): times.append({'时间段': '{0}时'.format(i), 'section': (i, i + 1), '计数': 0}) # 处理带PDT的时间 df['hours'] = df.apply(lambda x: datetime.datetime.strptime(x['日期']+x['时间'],'%Y/%m/%d%H:%M PDT') if type(x['时间']) == str else x['时间'],axis=1) df['locals'] = df.apply(lambda x: get_loacl(x),axis=1) print(df) # 循环统计 for i,r in df.iterrows(): for tx in times: if tx['section'][0] <= r['locals'].hour < tx['section'][1]: tx['计数'] = tx['计数'] + 1 break # 转为dataframe dt = pd.DataFrame(times).drop(['section'],axis=1) return dt df = pd.read_excel('./亚马逊订单2022-10-19.xlsx',usecols=['日期','时间'],sheet_name='订单详情') d = calc_hours(df) print(d)import datetime import random # 生成随机测试时间数量 from pprint import pprint SAMPLE_COUNT = 10 SECTION = 'section' SUM = 'sum' def my_time(): times = [] for i in range(24): times.append({SECTION: (i, i + 1), SUM: 0}) cnt = 0 while True: h = random.randint(0, 23) m = random.randint(0, 59) t = datetime.time(hour=h, minute=m) for tx in times: if tx[SECTION][0] <= t.hour < tx[SECTION][1]: tx[SUM] = tx[SUM] + 1 pprint(f'{t.strftime("%H:%M")} @ {tx[SECTION]}') break cnt = cnt + 1 if cnt > SAMPLE_COUNT: break return times if __name__ == '__main__': timex = my_time() pprint(timex)
2022年10月19日
2 阅读
0 评论
0 点赞
2022-10-19
datetime的时区转换
1.将时区信息添加到datetime日期时间对象from datetime import datetime from pytz import timezone date_str = "2009-05-05 22:28:15" datetime_obj = datetime.strptime(date_str, "%Y-%m-%d %H:%M:%S") datetime_obj_utc = datetime_obj.replace(tzinfo=timezone('UTC')) print(datetime_obj_utc.strftime("%Y-%m-%d %H:%M:%S %Z%z"))运行结果:2009-05-05 22:28:15 UTC+00002.将非UTC时区信息添加到datetime日期时间对象from datetime import datetime from pytz import timezone date_str = "2014-05-28 22:28:15" datetime_obj_naive = datetime.strptime(date_str, "%Y-%m-%d %H:%M:%S") # 错误的方式❌! datetime_obj_pacific = datetime_obj_naive.replace(tzinfo=timezone('US/Pacific')) print(datetime_obj_pacific.strftime("%Y-%m-%d %H:%M:%S %Z%z")) # 正确的方式✅! datetime_obj_pacific = timezone('US/Pacific').localize(datetime_obj_naive) print(datetime_obj_pacific.strftime("%Y-%m-%d %H:%M:%S %Z%z"))运行结果:2014-05-28 22:28:15 PST-08002014-05-28 22:28:15 PDT-07003.时区转换from datetime import datetime from pytz import timezone fmt = "%Y-%m-%d %H:%M:%S %Z%z" # Current time in UTC now_utc = datetime.now(timezone('UTC')) print(now_utc.strftime(fmt)) # Convert to US/Pacific time zone now_pacific = now_utc.astimezone(timezone('US/Pacific')) print(now_pacific.strftime(fmt)) # Convert to Europe/Berlin time zone now_berlin = now_pacific.astimezone(timezone('Europe/Berlin')) print(now_berlin.strftime(fmt))运行结果:2009-05-06 03:09:49 UTC+00002009-05-05 20:09:49 PDT-07002009-05-06 05:09:49 CEST+02004.查看所有时区from pytz import all_timezones print len(all_timezones) for zone in all_timezones: if 'US' in zone: print(zone)运行结果:US/AlaskaUS/AleutianUS/ArizonaUS/CentralUS/East-IndianaUS/EasternUS/HawaiiUS/Indiana-StarkeUS/MichiganUS/MountainUS/PacificUS/Pacific-NewUS/Samoa
2022年10月19日
2 阅读
0 评论
0 点赞
2022-10-15
Ubuntu安装Samba服务及配置共享文件夹
1.安装sambasudo apt-get install samba samba-common2.创建共享文件夹,权限777mkdir /home/username/share sudo chmod 777 /home/username/share3.添加用户和密码sudo smbpasswd -a username4.修改配置文件sudo vi /etc/samba/smb.conf[share] comment = share folder browseable = yes path = /home/nanshou/share create mask = 0700 directory mask = 0700 valid users = username force user = username force group = username public = yes available = yes writable = yes5.重启sambasudo service smbd restart
2022年10月15日
2 阅读
0 评论
0 点赞
2022-10-14
Linux搭建打印服务器
1.安装p910ndapt install p910nd2.插上USB, dmesg检查是否连接[ 1966.857496] usb 2-1: new full-speed USB device number 3 using ohci-platform [ 1967.045264] usb 2-1: New USB device found, idVendor=09c5, idProduct=0588 [ 1967.045287] usb 2-1: New USB device strings: Mfr=0, Product=0, SerialNumber=0 [ 1967.051636] usblp 2-1:1.0: usblp0: USB Bidirectional printer dev 3 if 0 alt 0 proto 2 vid 0x09C5 pid 0x05883.编辑文件 vi /etc/default/p910nd# Printer number, if not 0 P910ND_NUM="0" # Additional daemon arguments, see man 8 p910nd P910ND_OPTS="-f /dev/usb/lp0" # Debian specific (set to 1 to enable start by default) P910ND_START="1"4.生效配置sudo systemctl restart p910nd reboot5.参考链接
2022年10月14日
8 阅读
0 评论
0 点赞
2022-09-30
git lg彩色显示日志
git lggit config --global alias.lg "log --color --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit"
2022年09月30日
28 阅读
0 评论
0 点赞
1
...
24
25
26
...
31