u014210048的专栏

日期操作

pandas中尽量不用使用循环

定义一个空的DataFrame

pandas 正则表达式

python传参

尽量不要用以下方式更新一个DataFrame：df.loc[idx] = Lst如果要更新df, 我宁愿将新的列用list先存起来，然后用pd.concat()一次性更新，尽量不要用df.loc[idx]这种方式，否则会非常慢。

这个会不断刨根问底for root, dirs, files in os.walk(in_dir): #这个会刨根问底 for file in files: file_path = root + '/' + file print(file_path)这个不会刨根问底：for i in os.listdir(in_dir): file_path = in_dir + '/' + i print(file_path)...

# https://blog.csdn.net/weixin_36360005/article/details/112208014 pandas处理合并单元格

df = pd.DataFrame({'A' : ['foo', 'bar', 'foo', 'bar','foo', 'bar', 'foo', 'foo'], 'B' : ['one', 'one', 'two', 'three', 'two', 'two', 'one', 'three'], 'C' : np.random.randn(8), 'D' : np.random....

np.save('Stat.npy',data_frame_all) np.save('columns.npy', data_frame_all.columns) ndarray = np.load('Stat.npy', allow_pickle=True) columns = np.load('columns.npy',allow_pickle=True) # print(type(columns)) # print(ndarray.ndim) ...

from openpyxl.writer.excel import ExcelWriterwriter = pd.ExcelWriter(outfile) # 生成一个句柄对象sample_stat_no_correct.to_excel(writer,sheet_name='未修正样品数',index=False,freeze_panes=(1,2))sample_stat_correct.to_excel(writer,sheet_name='修正后样品数',index=False,f...

另有一个专门讲解这个的：Python正则表达式匹配反斜杠“\”_Nxin的小抄本-CSDN博客_正则匹配斜杠

原代码：def change_to_date_format_backup(data_frame, head): for idx in data_frame.index: value = data_frame.loc[idx, head] if pd.isnull(value): # NaT 也会是datetime.datetime pass elif value == '-': # 这种待修改 .

Dict = {}Dict2 = {}Dict['China'] = {}Dict2['China'] = {}Dict['China']['area'] = 960Dict2['China']['population'] = 14Dict.update(Dict2) #Dict的‘area’key会被 'population'覆盖掉for i in Dict['China']: print(i)#Dict的‘area’key会被 'population'覆盖掉.

aa = pd.DataFrame(np.arange(28).reshape(4,7),columns=['A','B','C','D','E','E','G'])aa.loc[4] = [0,0,0,0,0,0,0]aa.iloc[2,6] = 20.53print(aa)上面的aa的columns中，‘E’是重复的，会有错但假如不修改成浮点数，也不会报错：aa = pd.DataFrame(np.arange(28).reshape(4,7),columns=['A','..

Python 之 numpy 和 tensorflow 中的各种乘法（点乘和矩阵乘） - 刘[小]倩 - 博客园

from datetime import datetimefrom dateutil.relativedelta import relativedelta#=========================================================================#从字符串转为datetime对象，format与bb必须严格匹配bb = '2021-11-18 23:15:16'cc = datetime.strptime(bb,'%Y-%m-%d %H:.

Python字典嵌套字典 - blueattack - 博客园Python字典嵌套字典 - blueattack - 博客园

#!/usr/bin/pythonimport os.pathdir = "/mnt/lustre/user/wubin/01.Program/Scripts/01.script/GeneLab/runTumor"file = "/mnt/lustre/user/wubin/01.Program/Scripts/01.script/GeneLab/runTumor/run_tumor.pl"if os.path.exists(dir): print("yes,dir exists")if .

原代码在：https://scikit-learn.org/stable/auto_examples/cluster/plot_feature_agglomeration_vs_univariate_selection.html#sphx-glr-auto-examples-cluster-plot-feature-agglomeration-vs-univariate-selection-py

aa = 'China'bb = f"I'm from {aa}"cc = "I'm from %s"%(aa)dd = "I'm from {0}".format(aa)aaOut[25]: 'China'bbOut[26]: "I'm from China"ccOut[27]: "I'm from China"ddOut[28]: "I'm from China"

#!/home/wubin/miniconda3/bin/python# -*- coding: utf-8 -*-# https://blog.csdn.net/weixin_39274753/article/details/82221859 优先使用xml.etree.ElementTree模块# https://blog.csdn.net/weixin_36279318/article/details/79176475 这个讲得也不错# https://blog.csdn.net/yiluo.

# -*- coding: utf-8 -*-class human(): ''' 简单测试 ''' def __init__(self,name, salary): self.name = name self.salary = salary def get_name(self): print(self.name) def get_salary(self): print(self.sala.

转自：https://blog.csdn.net/yj1556492839/article/details/79881701

#合并单元格：from openpyxl import Workbookfrom openpyxl.styles import Alignmentbook = Workbook()sheet = book.activefanwei = "'A{}:B{}'".format('1','2')sheet.merge_cells('A1:B2') #这样可以sheet.merge_cells(fanwei) #这样不行sheet.merge_cells('A{}:B{}'.format(1,2.

# -*- coding: utf-8 -*-# https://blog.csdn.net/u010891397/article/details/83822311import numpy as npimport pandas as pdfrom pandas import DataFramedf3=DataFrame(np.arange(16).reshape((4,4)),index=['a','b','c','d'],columns=['one','two','three','fou...

Python中三种表示NA的方式# -*- coding: utf-8 -*-import numpy as npimport pandas as pd# data_frame = np.load('a.npy',allow_pickle=True)# print(data_frame.columns)df = pd.DataFrame({'one' : [1,2,3,pd.NA]})df = pd.DataFrame({'one' : [1,2,3,np.nan]})df = pd

# -*- coding: utf-8 -*-import getopt,sys# https://blog.csdn.net/u010951938/article/details/50864993# 1. 处理所使用的函数叫getopt() ，因为是直接使用import 导入的getopt 模块，所以要加上限定getopt 才可以。# 2. 使用sys.argv[1:] 过滤掉第一个参数（它是执行脚本的名字，不应算作参数的一部分）。# 3. 使用短格式分析串"ho:" 。当一个选项只是表示.

# -*- coding: utf-8 -*-# https://blog.csdn.net/weixin_45523154/article/details/101715076# https://www.cnblogs.com/findeasy/archive/2013/01/02/4053123.html# https://www.cnblogs.com/xied/p/12619571.htmlfrom docx import Documentfrom docx import section.

# -*- coding: utf-8 -*-# https://blog.csdn.net/weixin_45523154/article/details/101715076# https://www.cnblogs.com/findeasy/archive/2013/01/02/4053123.html# https://www.cnblogs.com/xied/p/12619571.htmlfrom docx import Documentfrom docx import section.

# -*- coding: UTF-8 -*-# 定义装饰器# decorator 作为装饰器的名字，只接受一个参数，就是函数func# 最后返回的是函数inner# 被“装饰”以后，func函数实际上就等于inner函数了# 如果要对func函数加什么参数，应该在def inner()里面加，而不是在def decorator(func)里面加# 装饰器在“装饰”的那一刻起，就已经执行，并返回一个inner函数，这个函数是否使用，装饰器都已经执行def decorator(func).