I-Python izosungula indlela abahlaziyi bedatha abasebenza ngayo ku-Excel

IMicrosoft imemezele ukuhlanganiswa kwePython ku-Excel.

Ake sibone ukuthi izoshintsha kanjani indlela abahlaziyi bePython ne-Excel abasebenza ngayo.

Ukuhlanganiswa phakathi kwe-Excel ne-Python kuwukuguquguquka okuphawulekayo kwamakhono okuhlaziya atholakala ku-Excel. Ukuqamba okusha kwangempela kuhlanganisa amandla ePython nokuguquguquka kwe-Excel.

Ukuqamba

Ngalokhu kuhlanganiswa, ungabhala ikhodi ye-Python kumaseli e-Excel, udale ukubonwa okuthuthukile usebenzisa imitapo yolwazi efana ne-matplotlib ne-seaborn, futhi usebenzise amasu okufunda ngomshini usebenzisa imitapo yolwazi efana ne-scikit-learn kanye ne-statsmodels.

I-Python ku-Excel izovula amathuba amaningi amasha kusipredishithi. Lokhu kuzoshintsha indlela abahlaziyi bePython ne-Excel abasebenza ngayo. Kanjalo.

Yiziphi izinguquko kubahlaziyi kanye nabasebenzisi be-Excel

I-Excel cishe iyithuluzi elidume kakhulu lokuhlaziya idatha ngenxa yokusebenziseka nokuvumelana nezimo.

Abasebenzisi be-Excel abadingi ukwazi ukuthi bahlela kanjani ukuhlanza idatha noma ukudala ukubukwa namamakhro. Ngamafomula ambalwa nokuchofoza okumbalwa, singakwazi ukuphatha idatha futhi sidale amathebula e-pivot namashadi ku-Excel.

I-Excel iyodwa yayiyinhle kakhulu ekwenzeni ukuhlaziya idatha eyisisekelo, kodwa ukulinganiselwa kwayo akuzange kuvumele abahlaziyi bedatha ukuba benze izinguquko eziyinkimbinkimbi zedatha futhi benze ukubonwa okuthuthukile (ingasaphathwa eyokusebenzisa amasu okufunda ngomshini). Ngokuphambene, izilimi zokuhlela ezifana nePython zingakwazi ukuphatha izibalo eziyinkimbinkimbi.

Manje abahlaziyi be-Excel kuzofanela bafunde iPython ukuze bafakazele imisebenzi yabo esikhathini esizayo.

Kodwa ingabe bazozivumelanisa nezimo?

Nokho, ulimi lohlelo olusondele kakhulu kubasebenzisi abaningi be-Excel kube yi-Visual Basic for Applications (VBA), kodwa nalabo ababhala ikhodi ye-VBA abazi. defiBagcina sebengaba “programmers”. Kungakho iningi labasebenzisi be-Excel libheka ukuhlela ukufunda njengento eyinkimbinkimbi noma engadingekile (kungani ufunda ukuhlela lapho ungathola ithebula le-pivot ngokuchofoza okukodwa?)

Ngethemba ukuthi abahlaziyi be-Excel bazivumelanisa nezimo. Izindaba ezinhle kubo ukuthi iPython iwulimi okulula ukulufunda. Abasebenzisi be-Excel ngeke baze badinge ukufaka iPython kumakhompyutha abo futhi balande umhleli wekhodi ukuze baqale ukubhala ikhodi yePython. Eqinisweni, kunomsebenzi omusha we-PY ku-Excel ovumela abasebenzisi ukuthi babhale ikhodi yePython kuseli le-Excel.

Kuyamangalisa, akunjalo? Manje sesingakwazi ukubhala ikhodi yePython kuseli ukuze sithole uhlaka lwedatha nokubukwa ngaphakathi kweshidi lethu lokusebenzela.

Lokhu ngokuqinisekile kuyinguquko emandleni okuhlaziya e-Excel.

Imitapo yolwazi yePython yokuhlaziywa kwedatha izotholakala ku-Excel.

Lokhu kuzozuzisa bobabili abahlaziyi bePython ne-Excel

Manje ungasebenzisa imitapo yolwazi yePython enamandla njengama-panda, i-seaborn, kanye ne-scikit-learn encwadini yokusebenzela ye-Excel. Lezi zincwadi zizosisiza senze ukuhlaziya okuthuthukile, sidale ukubukeka okumangalisayo, futhi sisebenzise ukufunda ngomshini, ukuhlaziya okubikezelayo, nezindlela zokubikezela ku-Excel.

Abahlaziyi be-Excel abangakwazi ukubhala ikhodi ye-Python kuzodingeka benze okuthile ngamathebula e-Excel pivot, amafomula, namashadi, kodwa labo abazivumelanisa nezimo bazoyisa amakhono abo okuhlaziya ezingeni elilandelayo.

Nazi ezinye izibonelo zokuthi ukuhlaziywa kwedatha ngePython kuzobukeka kanjani ku-Excel.

NgePython ku-Excel, sizokwazi ukusebenzisa izinkulumo ezivamile (regex) ukuze sithole izintambo ezithile noma amaphethini ombhalo kumaseli. Esibonelweni esilandelayo, i-regex isetshenziswa ukukhipha amadethi embhalweni.

Ukubuka okuthuthukile njengamamephu okushisa, amamephu e-violin, neziqephu ze-swarm manje kungenzeka ku-Excel nge-Seaborn. Nasi itulo elijwayelekile lababhangqwana esingalidala no-Seaborn, kodwa manje selikhonjiswe ekhasini lokusebenzela le-Excel.

Okokugcina, manje usungasebenzisa amamodeli okufunda omshini afana ne-DecisionTreeClassifier kushidi lokusebenzela le-Excel futhi ulingane imodeli usebenzisa amafreyimu edatha e-pandas.
I-Python ku-Excel izovala igebe phakathi kwabahlaziyi be-Python nabakwa-Excel

Izinsuku lapho abahlaziyi be-Python ne-Excel benenkinga yokusebenza ndawonye zizophela lapho i-Python ku-Excel itholakala kubo bonke abasebenzisi.

Abahlaziyi be-Excel bazodinga ukuzivumelanisa nalezi zinguquko ezintsha ukuze bangabi ne-Python kuphela njengekhono elisha ekuqaliseni kwabo futhi, kodwa nobufakazi besikhathi esizayo bemisebenzi yabo. Ukufunda i-VBA ngeke kuhambisane nabahlaziyi be-Excel njengokufunda imitapo yolwazi yePython efana nePandas neNumpy.

Izibalo zePython zizosebenza ku-Microsoft Cloud, ngakho-ke nabahlaziyi abasebenzisa amakhompyutha anomkhawulo wezinsiza bazobhekana nokucutshungulwa okusheshayo kwezibalo eziyinkimbinkimbi.

Ngakolunye uhlangothi, abahlaziyi bePython bazokwazi ukusebenzisana kalula nabahlaziyi be-Excel, bevala igebe phakathi kwabo.

I-Python ku-Excel izoshintsha nakanjani indlela abahlaziyi bePython ne-Excel ababhekana ngayo nokuhlaziywa kwedatha esikhathini esizayo. Ngemuva kwesimemezelo seMicrosoft, inani labahlaziyi be-Excel abazoqala ukufunda iPython lizokhula.

I-Python ku-Excel okwamanje iyatholakala kubasebenzisi abasebenzisa Isiteshi se-Beta ku-Windows. Ukuze uyifinyelele kufanele ujoyine uhlelo lwe-Microsoft 365 Insider. Ukuze uthole ulwazi olwengeziwe funda lapha.

Ercole Palmeri