Ukusebenza ngeefayile ze-CSV ngumsebenzi oqhelekileyo xa ujongene nokuguqulwa kwedatha kunye nohlalutyo. Umba omnye osoloko ujongene nawo sisidingo sokongeza iikoma kwifayile ye-CSV ukuze kwahlule ngokufanelekileyo iindawo zedatha. Kweli nqaku, siza kuphanda kwiinkcukacha zendlela yokongeza iikoma kwifayile ye-CSV usebenzisa ithala leencwadi lePython elinamandla, iPandas. Siza kunika inkcazo ngenyathelo ngenyathelo lekhowudi, elandelwa kukuphononongwa nzulu kwamathala eencwadi anxulumeneyo kunye nemisebenzi ebandakanyekayo kwinkqubo. Ke masingene ngaphakathi kwaye senze idatha yakho ilungelelaniswe kwaye ifikeleleke!
Isisombululo kwingxaki
Ukongeza iikoma kwifayile ye-CSV, sinokuthembela kwilayibrari ye-Pandas, eyenza inkqubo yokukhohlisa ye-CSV ikhawuleze, icoceke, kwaye isebenze kakuhle. Inyathelo lokuqala kukufaka iPandas ukuba awunayo, enokwenziwa ngokuqhuba lo myalelo ulandelayo kwi-terminal yakho:
pip install pandas
Emva kokufaka iPandas, lixesha lokulayisha ifayile yakho ye-CSV, yongeza iikoma njengoko kuyimfuneko, kwaye wenze ifayile entsha ye-CSV enedatha ehlaziyiweyo.
Inkcazo yenyathelo ngenyathelo lekhowudi
1. Qala ngokungenisa ngaphandle ithala leencwadi lePandas:
import pandas as pd
2. Layisha ifayile yakho ye-CSV usebenzisa i pd.read_csv() umsebenzi. Qiniseka ukuba ubuyisela u-"input_file.csv" ngeyona ndlela eya kwifayile yakho.
csv_data = pd.read_csv("input_file.csv")
3. Ngoku ukuba ulayishe ifayile ye-CSV kwi-Pandas DataFrame into, ungayilawula njengoko kufuneka. Kulo mzekelo, ufuna ukongeza iikoma ukwahlula imihlaba yedatha. Oku kunokwenziwa ngokusebenzisa i ukuya_csv() umsebenzi, okuvumela ukuba ukhankanye umdimiter wefayile ye CSV.
csv_data.to_csv("output_file.csv", sep=",", index=False)
4. Ekugqibeleni, ifayile ye-CSV ehlaziyiweyo iya kugcinwa njenge "output_file.csv" kunye neekoma ezichanekileyo zongezwe.
Ngoku, makhe singene kwezinye iikhonsepthi ezinxulumeneyo, amathala eencwadi, kunye nemisebenzi.
IiPandas: Ithala leencwadi lePowerhouse lokuLawula iDatha
I-pandas yinto Vula Umnikezi ilayibrari ebonelela ngokuguqulwa kwedatha kunye nezixhobo zokuhlalutya zePython. Yenzelwe ngokukodwa ukusebenza ngedatha yetheyibhile, inikezela ngezakhiwo zedatha njengeSeries kunye neDathaFrame yokuphatha idatha ngokufanelekileyo. I-Pandas yakhiwe phezulu kwamanye amathala eencwadi ePython anamandla kwaye asebenzayo afana neNumPy, kwaye inika ujongano oluphezulu lokusebenzisana nemithombo yedatha efana ne-CSV, Excel, kunye ne-SQL yolwazi.
- I-Pandas DataFrame: I-DataFrame yi-2-dimensional ebhaliweyo yesakhiwo sedatha kunye neekholamu ezinokuba neentlobo ezahlukeneyo. Yeyona sixhobo siphambili sokukhohlisa idatha esibonelelwa yiPandas kwaye yenzelwe ukujongana neentlobo ezahlukeneyo zeefomathi zedatha.
- IiPandas Series: Uthotho luluhlu olubhalwe macala onke olukwaziyo ukubamba naluphi na uhlobo lwedatha. Yenzelwe ukuphatha iikholamu enye yedatha kwaye isetyenziswa njengebhloko yokwakha yeDathaFrame.
Imodyuli yePython CSV: Enye indlela kwiiPanda
Ngelixa iPandas ikwenza kube lula ukusebenza ngeefayile ze-CSV kwimisebenzi entsonkothileyo, iPython ibonelela ngemodyuli eyakhelwe-ngaphakathi ebizwa. csv ebonelela ngomsebenzi wokufunda nokubhala kwiifayile ze-CSV.
Iiklasi eziphambili onokuthi usebenze nazo kwimodyuli ye-csv zezi:
- csv.reader: Olu didi lufunda ifayile ye-CSV kwaye ibuyisela i-iterator ukuvelisa umqolo ngamnye njengoluhlu lweentambo.
- csv.writer: Olu didi lubonelela ngeendlela zokubhala imiqolo kwifayile ye CSV.
Nangona ingenawo amandla njengePandas, imodyuli ye-csv inokuba yenye efanelekileyo kwimisebenzi elula engadingi kuqhelwa kwedatha ephezulu okanye ukuba awufuni ukusebenzisa ukuxhomekeka kwiprojekthi yakho.
Ukuqukumbela, ukongeza iikoma kwifayile ye-CSV ngumsebenzi obalulekileyo xa ujongene nokukhohlisa kunye nohlalutyo lwedatha. Ukusebenzisa ilayibrari yePython enamandla njengePandas iyenza lula le nkqubo, iyenze iqonde kwaye isebenze kakuhle. IiPandas zibonelela ngobuninzi beempawu kunye neendlela ezikuvumela ukuba ulawule idatha ngokufanelekileyo nangokungenamthungo. Ngaphandle koko, kwimisebenzi elula, imodyuli ye-csv eyakhelwe-ngaphakathi ye-Python ingasetyenziselwa, ukubonelela ngezixhobo eziyimfuneko zokusebenza kunye neefayile ze-CSV. Kungakhathaliseki ukuba yeyiphi indlela ekhethiweyo, ukusebenza kunye nedatha eyakhiwe kakuhle ngundoqo ekuhlalutyweni kwedatha eyimpumelelo kunye nokukhwabanisa.
