Ukudityaniswa phakathi kwe-Excel kunye nePython yinguqu ebalulekileyo yezakhono zokuhlalutya ezikhoyo kwi-Excel. Eyona nto intsha idibanisa amandla ePython kunye nokuguquguquka kwe-Excel.
Ngolu hlanganiso, ungabhala ikhowudi yePython kwiiseli ze-Excel, wenze iziboniso eziphambili usebenzisa amathala eencwadi afana ne-matplotlib kunye ne-seaborn, kwaye usebenzise ubuchule bokufunda koomatshini usebenzisa iilayibrari ezifana ne-scikit-learn kunye ne-statsmodels.
I-Python kwi-Excel ngokuqinisekileyo iya kuvula inani lamathuba amatsha kwi-spreadsheet. Oku kuya kutshintsha indlela abahlalutyi bePython kunye ne-Excel basebenza ngayo. Nantso indlela.
I-Excel mhlawumbi sesona sixhobo sidumileyo sokuhlalutya idatha ngenxa yokusebenziseka kwayo kunye nokuguquguquka.
Abasebenzisi be-Excel akufuneki bazi indlela yokucwangcisa ukucoca idatha okanye ukwenza iimbono kunye neemacros. Ngeefomyula ezimbalwa kunye nokucofa okumbalwa, sinokulawula idatha kwaye senze iitafile zepivot kunye neetshathi kwi-Excel.
I-Excel yodwa yayinkulu ekwenzeni uhlalutyo olusisiseko lwedatha, kodwa ukulinganiselwa kwayo akuzange kuvumele abahlalutyi bedatha ukuba benze ukuguqulwa kwedatha enzima kunye nokudala ukubonwa okuphambili (singasathethi ke ukusebenzisa iindlela zokufunda umatshini). Ngokwahlukileyo, iilwimi zokucwangcisa ezifana nePython zinokubamba izibalo ezinzima.
Ngoku abahlalutyi be-Excel kuya kufuneka bafunde iPython ukuze babone ubungqina bekamva labo.
Kodwa ngaba baya kuziqhelanisa?
Ewe, ulwimi lwenkqubo olusondeleyo kubasebenzisi abaninzi be-Excel lube yiVisual Basic for Applications (VBA), kodwa nabo babhala ikhowudi ye-VBA abazi. defiBagqiba ekubeni "ngabacwangcisi". Yiyo loo nto uninzi lwabasebenzisi be-Excel bejonga inkqubo yokufunda njengento entsonkothileyo okanye engeyomfuneko (kutheni ufunde ukwenza inkqubo xa ufumana itafile yepivot ngokucofa kanye?)
Ngethemba ukuba abahlalutyi be-Excel baziqhelanise. Iindaba ezimnandi kubo kukuba iPython lulwimi olufundeka lula. Abasebenzisi be-Excel abayi kudinga nokufaka iPython kwiikhompyuter zabo kwaye bakhuphele umhleli wekhowudi ukuze baqale ukubhala ikhowudi yePython. Ngapha koko, kukho umsebenzi omtsha wePY kwi-Excel ovumela abasebenzisi ukuba babhale ikhowudi yePython kwiseli ye-Excel.
Iyamangalisa, akunjalo? Ngoku sinokubhala ikhowudi yePython kwiseli ukufumana i-dataframe kunye neembono ngaphakathi kwiphepha lethu lokusebenza.
Oku ngokuqinisekileyo yindaleko kubuchule bohlalutyo be-Excel.
Oku kuya kunceda abahlalutyi bePython kunye ne-Excel
Ngoku ungasebenzisa amathala eencwadi anamandla ePython afana neepandas, i-seaborn, kunye ne-scikit-funda kwi-Excel workbook. La mathala eencwadi aya kusinceda ukuba senze uhlalutyo oluphambili, senze imbonakalo emangalisayo, kwaye sisebenzise ukufundwa koomatshini, uhlalutyo lokuxela kwangaphambili, kunye nobuchule bokuxela kwangaphambili kwi-Excel.
Abahlalutyi be-Excel abangakwaziyo ukubhala ikhowudi ye-Python kuya kufuneka benze iitafile ze-pivot ze-Excel, iifomyula, kunye neetshathi, kodwa abo balungelelanisayo baya kuthatha izakhono zabo zokuhlalutya kwinqanaba elilandelayo.
Nantsi eminye imizekelo yokuba uhlalutyo lwedatha kunye nePython luya kujongeka njani kwi-Excel.
NgePython kwi-Excel, siya kukwazi ukusebenzisa amabinzana aqhelekileyo (regex) ukufumana imitya ethile okanye iipatheni zokubhaliweyo kwiiseli. Kulo mzekelo ulandelayo, i-regex isetyenziselwa ukukhupha imihla kwisicatshulwa.
Imibono ephucukileyo efana neemephu zobushushu, iimephu zevayolin, kunye neeploti ze-swarm ngoku ziyenzeka kwi-Excel nge-Seaborn. Nali iyelenqe eliqhelekileyo lesibini esinokulenza noSeaborn, kodwa ngoku liboniswe kwiphepha lomsebenzi le-Excel.
Okokugqibela kodwa okungakuncinananga, ngoku ungasebenzisa iimodeli zokufunda zoomatshini ezifana ne-DecisionTreeClassifier kwiphepha lomsebenzi we-Excel kwaye ulungele imodeli usebenzisa i-pandas dataframes.
I-Python kwi-Excel iya kuvala umsantsa phakathi kwePython kunye ne-Excel abahlalutyi
Iintsuku apho abahlalutyi bePython kunye ne-Excel babenengxaki yokusebenzisana kunye ziya kuba ziphelile xa iPython kwi-Excel ifumaneka kubo bonke abasebenzisi.
Abahlalutyi be-Excel kuya kufuneka baziqhelanise nolu tshintsho lutsha ukuze bangabi nePython kuphela njengesakhono esitsha kwi-resume yabo, kodwa kubungqina bekamva labo lomsebenzi. Ukufunda i-VBA akusayi kufaneleka kubahlalutyi be-Excel njengokufunda iilayibrari zePython ezifana nePandas kunye neNumpy.
Ubalo lwePython luya kuqhuba kwiLifu likaMicrosoft, ke nabahlalutyi abasebenzisa iikhompyuter ezinobuncwane baya kuba namava okusebenza ngokukhawuleza kwezibalo ezinzima.
Kwelinye icala, abahlalutyi bePython baya kukwazi ukusebenzisana ngokulula nabahlalutyi be-Excel, bevala umsantsa phakathi kwabo.
I-Python kwi-Excel ngokuqinisekileyo iya kutshintsha indlela abahlalutyi bePython kunye ne-Excel bajongana nohlalutyo lwedatha kwixesha elizayo. Emva kwesibhengezo sikaMicrosoft, inani labahlalutyi be-Excel abaza kuqala ukufunda iPython liya kukhula.
IPython kwi-Excel okwangoku iyafumaneka kubasebenzisi abasebenzisa iBeta Channel kwiWindows. Ukufikelela kuyo kufuneka ujoyine inkqubo yeMicrosoft 365 Insider. Ukuze ufumane inkcazelo engakumbi funda apha.
Ercole Palmeri
Icandelo lomkhosi wasemanzini ligunya lokwenyani loqoqosho lwehlabathi, elithe lajonga kwimarike ye-150 yeebhiliyoni...
NgoMvulo ophelileyo, i-Financial Times ibhengeze isivumelwano kunye ne-OpenAI. I-FT ikhupha iilayisensi kubuntatheli bayo obukumgangatho wehlabathi…
Izigidi zabantu zihlawula iinkonzo zokusasaza, zihlawula umrhumo wenyanga. Luluvo oluqhelekileyo ukuba…
I-Coveware nguVeeam iya kuqhubeka nokubonelela ngeenkonzo zokuphendula ngeziganeko zokuxhwilwa kwe-cyber. I-Coveware iya kubonelela nge-forensics kunye nezakhono zokulungisa…
