Python繪圖系統(tǒng)之繪制散點圖,極坐標(biāo)和子圖
參考
新增散點圖繪制
同一坐標(biāo)系中繪制多個圖像是很常見的需求,比如數(shù)據(jù)擬合的時候,用散點圖表示原始數(shù)據(jù),用曲線圖來表示擬合結(jié)果。而這兩組數(shù)據(jù)分別有其自身的繪圖類別。
為了降低代碼重復(fù),最好還是新建一個控件,專門用于約定繪圖類型。而且更加廣泛地講,除了散點圖條形圖這種,是二維還是三維,也可算在繪圖類型里面。所以,這個繪圖類型控件,至少包含兩個ComboBox,這對于已經(jīng)創(chuàng)建過AxisFrame和AxisList的我們來說,屬于小兒科水平
class DrawType(ttk.Frame): # ws為兩個combobox的寬 def __init__(self, master, types, slctType, slctDim="3", ws=None, **options): super().__init__(master, **options) self.pack() self.types = types # 繪圖類型 self.dims = ("x", "xy", "xyz", "tx", "txy", "txyz") # 繪圖維度 self.initVar(slctType, slctDim) self.initWidgets(ws) def initVar(self, slctType, slctDim): self.drawType = tk.StringVar() self.drawType.set(slctType) self.drawDim = tk.StringVar() if type(slctDim) != str: slctDim = self.dims[int(slctDim)] self.drawDim.set(slctDim) def initWidgets(self, ws): if ws==None: ws = [8, 3] vs = [self.drawType, self.drawDim] slcts = [self.types, self.dims] for i in range(2): slct = ttk.Combobox(self, width=ws[i], textvariable=vs[i]) slct['value'] = slcts[i] slct.pack(side=tk.LEFT) def getType(self): return self.drawType.get() def getDim(self): return self.drawDim.get()
然后更改DrawSystem,主要是把setCtrlButtons(self, frm)函數(shù)的前兩句改為
def setCtrlButtons(self, frm): self.drawTypeDim = DrawType(frm, self.TYPES, "點線圖") self.drawTypeDim.pack(side=tk.LEFT) # ...
另一方面,兩個ComboBox太大了,為了美觀,把新增和刪除兩個按鈕上的文字改為加號和減號。修改過后的UI如下
首先,在AxisList的初始化代碼中添加初始化繪圖類型的參數(shù)
def __init__(self, master, title, mode, widths, types, slctType, # 繪圖類型Combobox的參數(shù) **options): super().__init__(master, **options) self.pack() self.afs = {} self.data = {} self.initWidgets(title, widths) self.initFeature(types, slctType) self.initAxis(mode, widths)
由于更改是輸入?yún)?shù)的個數(shù),所以在DrawSystem中調(diào)用時,需要把types和slctType這兩個參數(shù)補(bǔ)上。
然后在initFeature中添加drawTypeDim,
def initFeature(self, types, slctType): frm = ttk.Frame(self._c) frm.pack(pady=2, side=tk.TOP, fill=tk.X) ttk.Button(frm, text="加載",width=5, command=self.btnLoadData).pack(side=tk.LEFT) self.drawTypeDim = DrawType(frm, types, slctType) self.vis = {L : True for L in 'txyz'} for flag in 'txyz': btn = ttk.Button(frm, text=flag, wid th=3) btn.pack(side=tk.LEFT) btn.bind("<Button-1>", self.btnAxisCollapse)
最后,更改繪圖邏輯。簡單起見,這里只挑選最經(jīng)典的三種圖像,即點線圖、散點圖和條形圖。首先,創(chuàng)建一個全局變量字典,用于存放這些圖像的名稱及其對應(yīng)的繪圖函數(shù)
self.drawDct = { "點線圖" : self.drawPlot, "散點圖" : self.drawScatter, "條形圖" : self.drawBar }
然后,考慮到每次繪圖都需要讀取AxisList中的繪圖類型,進(jìn)而需要分次調(diào)用繪圖函數(shù),所以創(chuàng)建窗口這一步也交給btnDrawImg函數(shù),從而繪圖函數(shù)就只剩下了完完全全的繪圖功能。相關(guān)代碼如下
def btnDrawImg(self): self.fig.clf() keys = self.drawTypeDim.getDim() p = '3d' if 'z' in keys else None ax = self.fig.add_subplot(projection=p) for al in self.als: data = self.readDatas(al) draw = self.drawDct[al.getDrawType()] draw(ax, data, keys) self.fig.subplots_adjust(left=0.1, right=0.95, top=0.95, bottom=0.08) self.canvas.draw() def drawBar(self, ax, data, keys): ax.bar(data['x'], data['y']) def drawPlot(self, ax, data, keys): ax.plot(*[data[key] for key in keys]) def drawScatter(self, ax, data, keys): ax.scatter(*[data[key] for key in keys])
最后運行結(jié)果如下,分別繪制的散點圖和曲線圖。
綁定與回調(diào)
DrawType類可以設(shè)置繪圖維度,而繪圖維度其實就是坐標(biāo)軸的個數(shù)。所以,一個比較合理的交互邏輯是,改選DrawType的維度后,坐標(biāo)軸個數(shù)也該隨之變化。為了實現(xiàn)這個功能,需要為ComboBox綁定一個事件,改動起來非常簡單,只需在initWidgets最后加上一行就可以。
def initWidgets(self, ws): if ws==None: ws = [8, 3] slct = ttk.Combobox(self, width=ws[0], textvariable=self.drawType) slct['value'] = self.types slct.pack(side=tk.LEFT) slct = ttk.Combobox(self, width=ws[1], textvariable=self.drawDim) slct['value'] = self.dims slct.pack(side=tk.LEFT) slct.bind('<<ComboboxSelected>>', self.dimChanged)
接下來比較重要的則是self.dimChanged的定義。我們希望當(dāng)Combobox改變時,是另一個控件的內(nèi)容發(fā)生變化,所以self.dimChanged最好是其他控件傳入的一個函數(shù)。故而需要更改DrawType的初始化函數(shù),即添加一個func參數(shù),然后把這個參數(shù)賦給self.dimChanged方法。
def __init__(self, master, types, slctType, slctDim="xyz", ws=None, func=None, **options): super().__init__(master, **options) #。。。 self.dimChanged = func # 。。。
最后,修改AxisList中初始化DrawType的語句
self.drawTypeDim = DrawType(frm, types, slctType, func=self.dimChanged)
并創(chuàng)建self.dimChanged函數(shù),代碼如下,邏輯是根據(jù)當(dāng)前選擇的維度來更新txyz這幾個AxisFrame。
def dimChanged(self, evt): txyz = self.getDrawDim() for flag in 'txyz': self.vis[flag] = flag in txyz self.updateVisible() def updateVisible(self): for flag in 'txyz': self.afs[flag].pack_forget() for flag in 'txyz': if self.vis[flag]: self.afs[flag].pack(side=tk.TOP, fill=tk.X)
最后,在坐標(biāo)軸創(chuàng)建時也應(yīng)該遵循繪圖維度和坐標(biāo)個數(shù)之間的關(guān)系,這樣打開軟件或者新創(chuàng)建一組坐標(biāo)的時候,就可以自動與繪圖維度相匹配了。
def initAxis(self, mode, widths): for flag in 'txyz': self.afs[flag] = AxisFrame(self._c, flag, mode, widths) self.afs[flag].pack(side=tk.TOP, fill=tk.X) self.vis = {L : L in self.getDrawDim() for L in 'txyz'} self.updateVisible()
既然可以通過DrawType的回調(diào)函數(shù)來設(shè)置坐標(biāo)軸,那么單個的x,y,z,t按鈕舊沒必要存在了??梢詫xisList中的相關(guān)代碼全都刪掉。
極坐標(biāo)功能
用坐標(biāo)個數(shù)來判斷是否繪制三維圖的確很直觀,但從matplotlib的繪圖邏輯來說卻非如此,對于matplotlib來說,只有直角坐標(biāo)是真實的,其他坐標(biāo)都是數(shù)據(jù)在直角坐標(biāo)上的投影罷了,這也是projection這個參數(shù)的來源。
所以,DrawType還有進(jìn)一步升級的空間。即除了圖表類型、參數(shù)個數(shù)之外,還可以加一個投影類型,即用于規(guī)范Projection參數(shù)。
投影和維度從設(shè)計方式來說是完全一致的,只需添加
self.projs = ("None", "3d", "polar")
在initVar中添加
self.drawDim = tk.StringVar() self.drawDim.set(dim)
在initWidgets中添加
slct = ttk.Combobox(self, width=ws[1], textvariable=self.drawProj) slct['value'] = self.projs slct.pack(side=tk.LEFT, padx=2)
并創(chuàng)建getProj函數(shù)
def getProj(self): return self.drawProj.get()
這個時候界面又變得臃腫了,所以再調(diào)整調(diào)整,最后效果為
下面更新繪圖邏輯,盡管只是多了一個設(shè)定坐標(biāo)映射的功能,但從可擴(kuò)展性的角度觸發(fā),還是新建一個專門設(shè)置坐標(biāo)軸的函數(shù)比較好。故而在DrawSystem中添加setDrawAxis函數(shù)
def setDrawAxis(self): p = self.drawTypeDim.getProj() if p == "None": ax = self.fig.add_subplot() else: ax = self.fig.add_subplot(projection=p) return ax
然后發(fā)現(xiàn)了一個小bug,就是無論在繪圖時是否使用z軸坐標(biāo),但會一并讀取z軸數(shù)據(jù),這里稍作改善,將readDatas中的循環(huán)改為
for flag in self.drawTypeDim.getDim():
這樣就可以繪制極坐標(biāo)圖了
子圖繪制功能
之前在添加DrawType控件的時候,不僅添加了全局控件,而且每個AxisList也都添加了,這可不是亂添加的,而是為了后續(xù)的功能,即子圖繪制。如果一個窗口中有多組坐標(biāo)軸,那么每個坐標(biāo)軸都應(yīng)該有相應(yīng)的圖像。
這個顯然屬于繪圖類型的范疇,所以第一步還是更新DrawType類,添加一個sub參數(shù),用以約束子圖的位置
def __init__(self, master, types, slctType, sub='111', slctDim="xyz", slctProj='3d', ws=None, func=None, **options):
盡管組件類型不同,但創(chuàng)建流程一致,先改initVar,然后在initWidgets中添加Entry。
def initVar(self, sub, slctType, dim, proj): self.drawSub = tk.StringVar() self.drawSub.set(sub) # .... # 后面是類型、維度、投影 def initWidgets(self, ws, sub): if ws==None: ws = [5, 5, 5, 3] eny = ttk.Entry(self, width=ws[0], textvariable=self.drawSub) eny.pack(side=tk.LEFT, padx=2) # ... # 注意后面創(chuàng)建combobox時ws后移
然后再給出一個get函數(shù)
def getSub(self): return self.drawSub.get()
而且對應(yīng)AxisList中也要添加get函數(shù),并且補(bǔ)上之前未添加的getProj函數(shù)
def getSub(self): return self.drawTypeDim.getSub() def getProj(self): return self.drawTypeDim.getProj()
在 initVar
中,幾乎出現(xiàn)了4行一摸一樣的代碼,為了讓其更加簡潔,可以稍作修改
def initVar(self, sub, slctType, dim, proj): kv = {"sub":sub, "type":slctType, "dim":dim, "proj": proj} self.drawVars = {key:tk.StringVar() for key in kv} for key in drawVars: drawVars[key].set(kv[key])
然后把之前的注入self.drawSub, self.drawType, self.drawDim, self.drawProj等變量,均改寫為self.drawVars字典調(diào)用的形式。類似getSub之類的函數(shù)非常容易修改,只要替換一下即可。而initWidgets,則和initVar一樣,可以寫得更加精簡,具體改動較多,這里舊不貼代碼了。
這里小小地聲明一下,這種極致縮短代碼行數(shù)的寫法,在團(tuán)隊協(xié)作的時候并不提倡。
到目前為止,在DrawType中,最核心的四個參數(shù)就是子圖類別、繪圖類型、數(shù)據(jù)維度以及投影。換言之,只要有了這四個參數(shù),那么理論上就可以得到一個DrawType的對象。
在DrawSystem中,除了每個AxisList有其自身的DrawType之外,還有一個全局的DrawType,但現(xiàn)在這兩者之間并沒有任何聯(lián)系。一個比較好的設(shè)計邏輯是,新建AxisList的時候,以全局的DrawType為模板。
所以,可將這四個參數(shù)寫成一個字典,用于參數(shù)的傳遞。所以首先在DrawType類中添加函數(shù)
def getDct(self): return {key:self.drawVars[key].get() for key in self.drawVars}
然后修改其初始化參數(shù)
def __init__(self, master, types, varDct = {"sub":"111", "type":'點線圖', "dim":"xyz", "proj": "3d"}, ws=None, func=None, **options):
相應(yīng)地更改 initVar
def initVar(self, varDct): self.drawVars = {key:tk.StringVar() for key in varDct} for key in self.drawVars: self.drawVars[key].set(varDct[key])
這個改動導(dǎo)致接口發(fā)生變化,更要命的是AxisList的初始化參數(shù)也要傳給DrawType,所以牽一發(fā)而動全身,包括AxilList以及DrawSystem,所有涉及到的代碼都要修改。
由于每個子圖都有其自身的坐標(biāo)軸,為了讓繪圖井然有序,需要來一個全局的坐標(biāo)軸字典,并在坐標(biāo)軸設(shè)置函數(shù)中調(diào)用
def setDrawAxis(self, al): sub = int(al.getSub()) if sub in self.axDct: return self.axDct[sub] p = al.getProj() if p == "None": self.axDct[sub] = self.fig.add_subplot(sub) else: self.axDct[sub] = self.fig.add_subplot(sub, projection=p) return self.axDct[sub]
繪圖函數(shù)為
def btnDrawImg(self): self.fig.clf() keys = self.drawTypeDim.getDim() self.axDct = {} for al in self.als: ax = self.setDrawAxis(al) data = self.readDatas(al) draw = self.drawDct[al.getDrawType()] draw(ax, data, keys) self.fig.subplots_adjust(left=0.1, right=0.95, top=0.95, bottom=0.08) self.canvas.draw()
最后效果如下
源代碼
import tkinter as tk import tkinter.ttk as ttk from tkinter.filedialog import askopenfilename import matplotlib as mpl mpl.use('TkAgg') import matplotlib.pyplot as plt from matplotlib.backends.backend_tkagg import ( FigureCanvasTkAgg, NavigationToolbar2Tk) from matplotlib.figure import Figure import numpy as np class AxisFrame(ttk.Frame): # widths 是每個控件的寬度 def __init__(self, master, label, mode, widths, **options): super().__init__(master, **options) self.pack() self.label = label self.initVar(mode) self.initWidgets(widths) def initVar(self, mode): self.MODES = ("序列化", "源代碼", "外部導(dǎo)入", "無數(shù)據(jù)") self.mode = tk.StringVar() self.setMode(mode) def initWidgets(self, widths): tk.Label(self, text=self.label, width=widths[0]).pack(side=tk.LEFT) self.slct = ttk.Combobox(self, width=widths[1], textvariable=self.mode) self.slct['value'] = self.MODES self.slct.pack(side=tk.LEFT) self.entry = tk.Entry(self, width=widths[2]) self.entry.pack(padx=5, side=tk.LEFT, fill=tk.X) def setText(self, text): self.entry.delete(0, "end") self.entry.insert(0, text) def get(self): return self.entry.get() def setMode(self, mode): if type(mode) != str: mode = self.MODES[mode] self.mode.set(mode) def setData(self, data=None, **txyz): if self.mode.get() == "序列化": return self.getArray() elif self.mode.get() == "外部導(dǎo)入": return self.loadData(data) else: return self.readPython(**txyz) def readPython(self, t=None, x=None, y=None, z=None): self.data = eval(self.get()) return self.data def loadData(self, data): if type(data) != type(None): self.data = data return self.data def getArray(self): val = self.get() self.data = eval(f"np.linspace({val})") return self.data class AxisList(ttk.Frame): def __init__(self, master, title, mode, widths, types, typeDct, # 繪圖類型Combobox的參數(shù) **options): super().__init__(master, **options) self.pack() self.afs = {} self.data = {} self.initWidgets(title, widths) self.initFeature(types, typeDct) self.initAxis(mode, widths) def initWidgets(self, title, widths): self.btn = ttk.Button(self, text=title, width=sum(widths)+5, command=self.Click) self.btn.pack(side=tk.TOP, fill=tk.X, expand=tk.YES) self._c = ttk.Frame(self) self.collapsed = True self.Click() def initFeature(self, types, typeDct): frm = ttk.Frame(self._c) frm.pack(pady=2, side=tk.TOP, fill=tk.X) ttk.Button(frm, text="加載",width=5, command=self.btnLoadData).pack(side=tk.LEFT) self.drawTypeDim = DrawType(frm, types, typeDct, func=self.dimChanged) self.drawTypeDim.pack(side=tk.LEFT, padx=2) self.vis = {L : True for L in 'txyz'} def dimChanged(self, evt): txyz = self.getDrawDim() for flag in 'txyz': self.vis[flag] = flag in txyz self.updateVisible() def updateVisible(self): for flag in 'txyz': self.afs[flag].pack_forget() for flag in 'txyz': if self.vis[flag]: self.afs[flag].pack(side=tk.TOP, fill=tk.X) def getSub(self): return self.drawTypeDim.getSub() def getProj(self): return self.drawTypeDim.getProj() def getDrawType(self): return self.drawTypeDim.getType() def getDrawDim(self): return self.drawTypeDim.getDim() def initAxis(self, mode, widths): for flag in 'txyz': self.afs[flag] = AxisFrame(self._c, flag, mode, widths) self.afs[flag].pack(side=tk.TOP, fill=tk.X) self.vis = {L : L in self.getDrawDim() for L in 'txyz'} self.updateVisible() def btnLoadData(self): name = askopenfilename() data = np.genfromtxt(name) for i, flag in enumerate('xyz'): if i >= data.shape[1]: return self.setOneMode(flag, "外部導(dǎo)入") self.data[flag] = self.setData(flag, data[:,i]) def Click(self): if self.collapsed: self._c.pack(side=tk.TOP, fill=tk.BOTH, expand=tk.YES) else: self._c.pack_forget() self.collapsed = not self.collapsed def setData(self, flag, data=None, **options): return self.afs[flag].setData(data, **options) def setOneMode(self, flag, mode): self.afs[flag].setMode(mode) # 繪圖類型和維度 # varDct 的格式是 {"sub":sub, "type":slctType, "dim":dim, "proj": proj} class DrawType(ttk.Frame): # ws為兩個combobox的寬 def __init__(self, master, types, varDct = {"sub":"111", "type":'點線圖', "dim":"xyz", "proj": "3d"}, ws=None, func=None, **options): super().__init__(master, **options) self.pack() self.dimChanged = func self.initVar(varDct) self.initWidgets(ws, types) def initVar(self, varDct): self.drawVars = {key:tk.StringVar() for key in varDct} for key in self.drawVars: self.drawVars[key].set(varDct[key]) def initWidgets(self, ws, types): if ws==None: ws = [5, 5, 5, 3] slctDct = {'type':types, 'proj': ("None", "3d", "polar"), 'dim' : ("x", "xy", "xyz", "tx", "txy", "txyz")} # 繪圖維度 keys = ['sub', 'type', 'proj', 'dim'] wDct = {} # 控件字典 # 此為設(shè)置子圖的Entry控件 wDct['sub'] = ttk.Entry(self, width=ws[0], textvariable=self.drawVars['sub']) for i, key in enumerate(keys[1:], 1): wDct[key] = ttk.Combobox(self, width=ws[i], textvariable=self.drawVars[key]) wDct[key]['value'] = slctDct[key] for key in keys: wDct[key].pack(side=tk.LEFT, padx=2) wDct['dim'].bind('<<ComboboxSelected>>', self.dimChanged) def getSub(self): return self.drawVars['sub'].get() def getType(self): return self.drawVars['type'].get() def getDim(self): return self.drawVars['dim'].get() def getProj(self): return self.drawVars['proj'].get() def getDct(self): return {key:self.drawVars[key].get() for key in self.drawVars} # 子圖類型 class DrawTypeSub(DrawType): pass class DarwSystem(): def __init__(self): self.root = tk.Tk() self.root.title("數(shù)據(jù)展示工具") self.data = {} self.als = [] self.initConst() self.setFrmCtrl() frmFig = ttk.Frame(self.root) frmFig.pack(side=tk.LEFT,fill=tk.BOTH,expand=tk.YES) self.setFrmFig(frmFig) self.root.mainloop() def initConst(self): self.TYPES = ("點線圖", "散點圖", "條形圖") self.drawDct = { "點線圖" : self.drawPlot, "散點圖" : self.drawScatter, "條形圖" : self.drawBar } def setFrmCtrl(self): frmCtrl = ttk.Frame(self.root,width=320) frmCtrl.pack(side=tk.RIGHT, fill=tk.Y) frm = ttk.Frame(frmCtrl, width=320) frm.pack(side=tk.TOP, fill=tk.X) self.setCtrlButtons(frm) self.frmAxis = ttk.Frame(frmCtrl) self.frmAxis.pack(side=tk.TOP, fill=tk.X) self.addLast(None) # ! 工具欄 def setCtrlButtons(self, frm): self.drawTypeDim = DrawType(frm, self.TYPES) self.drawTypeDim.pack(side=tk.LEFT) ttk.Button(frm, text="??",width=3, command=self.btnDrawImg).pack(side=tk.LEFT) ttk.Button(frm, text="??",width=3, command=self.btnLoadData).pack(side=tk.LEFT) btn = ttk.Button(frm, text="+", width=3) btn.pack(side=tk.LEFT) btn.bind("<Button-1>", self.addLast) btn = ttk.Button(frm, text="-", width=3) btn.pack(side=tk.LEFT) btn.bind("<Button-1>", self.deleteLast) def addLast(self, evt): title = f"坐標(biāo){len(self.als)}" al = AxisList(self.frmAxis, title, 1, [5,10,30], self.TYPES, self.drawTypeDim.getDct()) al.pack(side=tk.TOP, fill=tk.X) self.als.append(al) def deleteLast(self, evt): self.als[-1].pack_forget() del self.als[-1] def btnLoadData(self): name = askopenfilename() data = np.genfromtxt(name) for i, flag in enumerate('xyz'): if i >= data.shape[1]: return self.AL.setOneMode(flag, "外部導(dǎo)入") self.data[flag] = self.AL.setData(flag, data[:,i]) def readDatas(self, al): dct = {} data = {} for flag in self.drawTypeDim.getDim(): data[flag] = al.setData(flag, **dct) dct[flag] = data[flag] return data def setDrawAxis(self, al): sub = int(al.getSub()) print(sub) if sub in self.axDct: return self.axDct[sub] p = al.getProj() if p == "None": ax = self.fig.add_subplot(sub) else: ax = self.fig.add_subplot(sub, projection=p) return ax def btnDrawImg(self): self.fig.clf() keys = self.drawTypeDim.getDim() self.axDct = {} for al in self.als: ax = self.setDrawAxis(al) data = self.readDatas(al) draw = self.drawDct[al.getDrawType()] draw(ax, data, keys) self.fig.subplots_adjust(left=0.1, right=0.95, top=0.95, bottom=0.08) self.canvas.draw() def drawBar(self, ax, data, keys): ax.bar(data['x'], data['y']) def drawPlot(self, ax, data, keys): ax.plot(*[data[key] for key in keys]) def drawScatter(self, ax, data, keys): ax.scatter(*[data[key] for key in keys]) def setFrmFig(self, frmFig): self.fig = Figure() self.canvas = FigureCanvasTkAgg(self.fig,frmFig) self.canvas.get_tk_widget().pack( side=tk.TOP,fill=tk.BOTH,expand=tk.YES) self.toolbar = NavigationToolbar2Tk(self.canvas,frmFig, pack_toolbar=False) self.toolbar.update() self.toolbar.pack(side=tk.RIGHT) if __name__ == "__main__": test = DarwSystem()
以上就是Python繪圖系統(tǒng)之繪制散點圖,極坐標(biāo)和子圖的詳細(xì)內(nèi)容,更多關(guān)于Python繪圖的資料請關(guān)注腳本之家其它相關(guān)文章!
相關(guān)文章
Python數(shù)據(jù)可視化之繪制柱狀圖和條形圖
今天帶大家學(xué)習(xí)怎么利用Python繪制柱狀圖,條形圖,文中有非常詳細(xì)的代碼示例,對正在學(xué)習(xí)python的小伙伴們很有幫助,需要的朋友可以參考下2021-05-05python之當(dāng)你發(fā)現(xiàn)QTimer不能用時的解決方法
今天小編就為大家分享一篇python之當(dāng)你發(fā)現(xiàn)QTimer不能用時的解決方法,具有很好的參考價值,希望對大家有所幫助。一起跟隨小編過來看看吧2019-06-06python數(shù)據(jù)庫批量插入數(shù)據(jù)的實現(xiàn)(executemany的使用)
這篇文章主要介紹了python數(shù)據(jù)庫批量插入數(shù)據(jù)的實現(xiàn)(executemany的使用),文中通過示例代碼介紹的非常詳細(xì),對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2021-04-04Python使用pymssql連接SQL?SEVER數(shù)據(jù)庫全流程
SQL Server是微軟推出的重量級的數(shù)據(jù)庫,目前有多個版本,如2000、2008、2012等,下面這篇文章主要給大家介紹了關(guān)于Python使用pymssql連接SQL?SEVER數(shù)據(jù)庫的相關(guān)資料,需要的朋友可以參考下2023-12-12Python 高級教程之線程進(jìn)程和協(xié)程的代碼解析
這篇文章主要介紹了Python 高級教程之線程進(jìn)程和協(xié)程的代碼解析,包括使用線程模塊的簡單示例,本文給大家介紹的非常詳細(xì),對大家的學(xué)習(xí)或工作具有一定的參考借鑒價值,需要的朋友可以參考下2022-05-05