sjt2015的博客

import pandas as pddf=pd.read_excel(“工作簿1.xlsx”,sheet_name=0,header=None)i=5while i<=21:col_name=df.loc[1,i]j=0for j in [i,i+1,i+2]:df.loc[1,j]=col_name+"_"+df.loc[2,j]i=i+3if i==14:i=i+1df.rename(columns=df.loc[1],inplace=True)df.drop(label

import osimport xlrdimport pandas as pddef file_path(file_dir):file_list = []for root, dirs, files in os.walk(file_dir):for file in files:if os.path.splitext(file)[1] == ‘.xlsx’ or os.path.splitext(file)[1] == ‘.xls’:file_list.append(os.path.join(r

import docximport jiebafrom collections import Counterimport pandas as pdimport xlwtdocument=docx.Document(r"C:\Users\fj\Desktop\讲话稿.docx")content=" ".join([para.text for para in document.paragraphs])seg_list=jieba.cut(content,cut_all=False)seg_lis

python将pandas数据写入sqlserver数据库示例import pandas as pdimport pyodbcimport sqlalchemyengin=sqlalchemy.create_engine(“mssql+pyodbc://sa:123@testdb”)data=pd.read_excel(r"E:\anzhuo\qcm_batch_search.xlsx")data.to_sql(“单位名称”,engin,index=False,if_exists=‘append

求助，oracle安装过程中，报错ora-03113错误。卸载后，清理注册表项后，再重新安装，仍旧报错ora-03113。