ʻO ka hoʻohui ʻana ma waena o Excel a me Python kahi hoʻololi koʻikoʻi o nā mana analytical i loaʻa ma Excel. ʻO ka mea hou maoli ka hoʻohui ʻana i ka mana o Python me ka maʻalahi o Excel.
Me kēia hoʻohui ʻana, hiki iā ʻoe ke kākau i ka code Python ma nā cell Excel, hana i nā hiʻohiʻona kiʻekiʻe me ka hoʻohana ʻana i nā hale waihona puke e like me matplotlib a me ka moana, a hoʻohana pū i nā ʻenehana aʻo mīkini e hoʻohana ana i nā hale waihona puke e like me scikit-learn a me statsmodels.
E wehe maoli ʻo Python ma Excel i kekahi mau mea hou i loko o kahi pālahalaha. E hoʻololi kēia i ke ʻano o ka hana ʻana o Python a me Excel. Pēlā.
ʻO Excel paha ka mea hana kaulana loa no ka nānā ʻana i ka ʻikepili ma muli o kona hoʻohana a me ka maʻalahi.
ʻAʻole pono nā mea hoʻohana Excel e ʻike pehea e hoʻolālā ai e hoʻomaʻemaʻe i ka ʻikepili a i ʻole hana i nā manaʻo a me nā macros. Me nā ʻano kumu ʻelua a me nā kaomi liʻiliʻi, hiki iā mākou ke hoʻokele i ka ʻikepili a hana i nā papa pivot a me nā pakuhi ma Excel.
ʻO Excel wale nō ka mea maikaʻi no ka hoʻokō ʻana i ka loiloi ʻikepili kumu, akā ʻaʻole i ʻae ʻia e kāna mau palena i nā mea loiloi ʻikepili e hana i nā hoʻololi ʻikepili paʻakikī a hana i nā hiʻohiʻona kiʻekiʻe (e waiho wale i nā ʻenehana aʻo mīkini). Ma ka hoʻohālikelike ʻana, hiki i nā ʻōlelo papahana e like me Python ke mālama i nā helu paʻakikī.
I kēia manawa, pono e aʻo nā mea loiloi Excel i ka Python e hōʻoia i ka wā e hiki mai ana i kā lākou ʻoihana.
Akā, e hoʻololi paha lākou?
ʻAe, ʻo ka ʻōlelo papahana kokoke loa i ka hapa nui o nā mea hoʻohana Excel ʻo Visual Basic for Applications (VBA), akā ʻo ka poʻe kākau VBA code ʻaʻole maopopo. defiHoʻopau lākou i "mea papahana". ʻO ia ke kumu e noʻonoʻo ai ka hapa nui o nā mea hoʻohana Excel i ke aʻo ʻana i ka papahana ma ke ʻano he mea paʻakikī a pono ʻole paha (no ke aha e aʻo ai i ka papahana inā hiki iā ʻoe ke kiʻi i kahi papa pivot me hoʻokahi kaomi?)
Manaʻo e hoʻololi nā mea loiloi Excel. ʻO ka nūhou maikaʻi no lākou he ʻōlelo maʻalahi ka Python e aʻo ai. ʻAʻole pono nā mea hoʻohana Excel e hoʻokomo iā Python ma kā lākou kamepiula a hoʻoiho i kahi hoʻoponopono code e hoʻomaka e kākau i ka code Python. ʻO kaʻoiaʻiʻo, aia kahi hana PY hou ma Excel e hiki ai i nā mea hoʻohana ke kākau i ka code Python i kahi cell Excel.
Kupaianaha, 'a'ole anei? I kēia manawa hiki iā mākou ke kākau i ka code Python i loko o kahi kelepona e kiʻi i kahi dataframe a me nā ʻike i loko o kā mākou pepa hana.
ʻOiaʻiʻo kēia he hoʻololi i ka hiki ʻana o Excel.
E pōmaikaʻi kēia i nā mea loiloi Python a me Excel
I kēia manawa hiki iā ʻoe ke hoʻohana i nā hale waihona puke Python ikaika e like me pandas, seaborn, a me scikit-aʻo i loko o kahi puke hana Excel. E kōkua kēia mau hale waihona puke iā mākou e hana i nā ʻikepili holomua, e hana i nā hiʻohiʻona kupaianaha, a e hoʻopili i ka aʻo ʻana i ka mīkini, ka wānana wānana, a me nā ʻenehana wānana ma Excel.
Pono nā mea loiloi Excel ʻaʻole ʻike pehea e kākau ai i ka code Python me nā papa pivot Excel, formula, a me nā pakuhi, akā ʻo ka poʻe e hoʻololi e lawe i kā lākou mau mākau analytical i ka pae aʻe.
Eia kekahi mau hiʻohiʻona o ka nānā ʻana o ka ʻikepili me Python e like me Excel.
Me Python ma Excel, hiki iā mākou ke hoʻohana i nā ʻōlelo maʻamau (regex) e ʻimi ai i nā kaula kikoʻī a i ʻole nā ʻano kikokikona i loko o nā cell. Ma kēia laʻana, hoʻohana ʻia kahi regex e unuhi i nā lā mai ka kikokikona.
Hiki i kēia manawa nā hiʻohiʻona kiʻekiʻe e like me nā palapala wela, nā palapala violin, a me nā ʻāpana swarm ma Excel me Seaborn. Eia ka papa hana maʻamau a mākou e hana ai me Seaborn, akā hōʻike ʻia i kēia manawa ma kahi pepa hana Excel.
ʻO ka mea hope akā ʻaʻole ka mea liʻiliʻi loa, hiki iā ʻoe ke hoʻohana i nā hiʻohiʻona aʻo mīkini e like me DecisionTreeClassifier ma kahi pepa hana Excel a kūpono i ke kumu hoʻohālike me ka hoʻohana ʻana i nā ʻikepili pandas.
E hoʻopili ʻo Python ma Excel i ka ʻokoʻa ma waena o Python a me Excel
ʻO nā lā i pilikia ai ka hana pū ʻana o Python a me Excel i ka wā e loaʻa ai ʻo Python ma Excel i nā mea hoʻohana āpau.
Pono nā mea loiloi Excel e hoʻololi i kēia mau hoʻololi hou i ka loaʻa ʻole ʻana o Python ma ke ʻano he loea hou i kā lākou hoʻomaka, akā i ka hōʻoia ʻana i kā lākou ʻoihana. ʻAʻole pili ke aʻo ʻana i ka VBA i nā mea loiloi Excel e like me ke aʻo ʻana i nā hale waihona puke Python e like me Pandas a me Numpy.
E holo ana nā helu Python i ka Microsoft Cloud, no laila, ʻo nā mea loiloi e hoʻohana ana i nā kamepiula palena waiwai e ʻike i ka wikiwiki wikiwiki no nā helu paʻakikī.
Ma ka ʻaoʻao ʻē aʻe, hiki i nā mea loiloi Python ke hana maʻalahi me nā mea loiloi Excel, e hoʻopaʻa ana i ke āpau ma waena o lākou.
E hoʻololi maoli ʻo Python i Excel i ke ʻano o ka hoʻopili ʻana o nā mea loiloi ʻo Python a me Excel i ka ʻikepili ʻikepili i ka wā e hiki mai ana. Ma hope o ka hoʻolaha ʻana o Microsoft, e ulu ka nui o nā mea loiloi Excel e hoʻomaka e aʻo iā Python.
Loaʻa ka Python ma Excel i nā mea hoʻohana e holo ana i Beta Channel ma Windows. No ke komo ʻana iā ia, pono ʻoe e hui pū me ka polokalamu Microsoft 365 Insider. No ka 'ike hou aku e heluhelu maanei.
Ercole Palmeri
He mana hoʻokele waiwai maoli ka ʻāpana moana, kahi i hoʻokele i kahi mākeke 150 biliona ...
I ka Pōʻakahi i hala, ua hoʻolaha ka Financial Times i kahi kuʻikahi me OpenAI. Laikini ʻo FT i kāna nūpepa papa honua…
E uku ana nā miliona o ka poʻe no nā lawelawe streaming, e uku ana i nā uku kau inoa o kēlā me kēia mahina. He manaʻo maʻamau ʻoe…
E hoʻomau ʻo Coveware e Veeam i ka hoʻolako ʻana i nā lawelawe pane ʻana i ka hanana cyber extortion. E hāʻawi ʻo Coveware i nā forensics a me nā mana hoʻoponopono…
