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.参考链接

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"

Ubuntu修改系统时区 方法一1 修改时间tzselect 依次选择4->9->1->1 #Asia->China-> Beijing->yes2 复制文件到/etc目录下sudo cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime 3 查看修改结果date -R方法二1.列出可用的中国时区sudo timedatectl list-timezones | grep Asia/Shanghai2.设置中国时区sudo timedatectl set-timezone Asia/Shanghai3.验证时区设置timedatectl

Pandas修改列名 # 使用字典替换 df = df.rename(columns = {'title_year':'release_date', 'movie_facebook_likes':'facebook_likes'}) # 直接修改列名 df.columns = ['release_date','facebook_likes']

Pandas带格式导出为xlsx文件 # 创建文件 writer = pd.ExcelWriter('订单.xlsx',engine='xlsxwriter') # 创建百分数格式 percent_fmt = writer.book.add_format({'num_format': '0.00%'}) # 写入表格 df.to_excel(writer,sheet_name='订单详情',encoding='utf8',index=False) # 调整格式 sheet = writer.sheets['订单详情'] sheet.set_column('A:B',20) #设置AB列宽20 sheet.set_column('C:D',20, percent_fmt) #设置AB列宽20,百分数单元格格式 sheet.set_row(2,30) #设置第2行高30 # 写入公式 for index in range(0,len(df)): in_str = str(index+3) sheet.write_formula('O'+in_str,'=IFERROR(HYPERLINK(VLOOKUP(A{0},图片!$A$2:$D$1000,3,FALSE),"链接"),"")'.format(in_str)) # 保存文件 writer.save()