←

I-CSV / JSON Cleaning kanye ne-Field Mapper

Ilinde idatha yokufaka.ilinde okokufaka

Ukufunda i-CSV

0%
0 / 00%isikhathi 00:00Isilinganiso esisele --:--0 rows/silinde okokufaka

I-100% isho kuphela ukuthi inani seliqediwe; impumelelo izoboniswa kuphela ngemva kokuphasiswa nokuqinisekisa.

Ngenisa futhi uhlaziye

Ngenisa i-CSV ye-UTF-8 noma uhlu lwezinto ze-JSON. Ifayela licutshungulwa enkumbulweni yale divayisi kuphela. Khetha ngokucacile ifomethi yokufaka kuqala.

Imithetho yokudweba ikholomu neyokuhlanza

Sebenzisa izinombolo ezizinzile kukholomu ngayinye; noma yiziphi izinguquko zizophelelwa yisikhathi imiphumela emidala.

Ngemva kokuhlaziya i-CSV, imithetho yokwenza imephu neyokuhlanza yekholomu ngayinye iboniswa lapha.

Hlola futhi uthumele

Izinguquko, izinkinga, nokulandwayo kufanele kuvele kumphumela ofanayo oyifinyezo.

umugqa wedatha0
ikholomu yokuphumayo0
Lungisa0
umbuzo0

Ngemva kokusebenzisa lo mthetho, isifinyezo somehluko, izinkinga, nokuthekelisa kuboniswa lapha.

Isifinyezo sokugcina sokuthekelisa

Igama lefayela: cleaned-data.csv

indlela yokwelashwa kwengozi yefomula

Akukho ukungcoliswa komhlaba wonke okungabhubhisi okuzosebenzela wonke amaspredishithi namasistimu angezansi komfula; khetha ngokusekelwe ekusebenziseni okungokoqobo.

Okwangempela vs. Ukuhlola kuqala inani elihlanziwe0 / 0
Ibonisa imigqa efika ku-100; amaphuzu avelele abonisa ukuguqulwa noma izinkinga

Ngenisa noma namathisela i-UTF-8 CSV, qinisekisa izilungiselelo zesakhiwo, lungiselela imithetho yenkambu, sebenzisa futhi ubuyekeze umehluko. Inkinobho yokudawuniloda inikwa amandla kuphela uma isakhiwo nohlobo lokuhlola kudlula, imiphumela ingaphelelwa yisikhathi, futhi ubungozi befomula kubhekwana nabo ngokusobala.

Izindlela zokuhlanza nokuhlanza

Umhlaziyi uhlukanisa phakathi kwesiqalo senkambu, inkambu engacashuniwe, inkambu ecashuniwe, nezingcaphuno ezivaliwe, futhi uphatha ama-delimiters, izingcaphuno ezimbili, imigqa emisha eshumekiwe, ne-CRLF. Ukuhlanza kugcina, ukuqamba kabusha, ukusika, ukungenzi lutho, uhlobo nokuphindaphinda ngokulandelana kwekholomu.

I-JSON yamukela kuphela uhlu lwezinto. Amanani kufanele abe umbhalo, izinombolo, i-Boolean noma null; izinto noma uhlu ngaphakathi kwezinye akusekelwa. Indlela yokuqala yokubhala izinombolo iyagcinwa futhi wonke amaseli aba umbhalo. null, izinkambu ezingekho nochungechunge lwezinhlamvu olungenalutho kuba amaseli angenalutho; izinhlobo zokuqala azikwazi ukubuyiselwa. Okukhiphayo kwe-CSV kuhlala kusebenzisa ukhefana ne-CRLF; wonke amanani okukhiphayo kwe-JSON awuchungechunge lwezinhlamvu.

Isibonelo esiqinisekisekayo

Isibonelo sokufundisa siqukethe imigqa emibili yedatha, izikhala eziholayo nezilandelanayo, kanye nengozi yefomula =2+3. Ngemva kokusebenzisa imithetho ezenzakalelayo, kufanele uthole imigqa emibili namakholomu amathathu, ukulungisa okubili kokusika, futhi ugcine ukulanda kuvimbile kuze kube yilapho kukhethwe inqubomgomo yefomula.

Umkhawulo

Isekela i-UTF-8 kuphela; umkhawulo kasayizi wefayela 10 MiB, 100,000 amarekhodi edatha, amakholomu angu-500, inkambu eyodwa 1 MiB. Ukuhlola kuqala kunikeza imigqa efika kweyi-100. Ukuhlola uhlobo kuwukuhlola kwe-syntax futhi akuthathi indawo yokuqinisekiswa kwebhizinisi.

Imikhawulo ehlanganisiwe: amaseli afinyelela ku-1000000 kuhlanganise nomugqa wesihloko; usayizi wokukhiphayo ufinyelela ku-32 MiB. Usayizi wokufaka ufinyelela ku-10 MiB, amarekhodi afinyelela ku-100000, amakholomu afinyelela ku-500, nosayizi wenkambu ngayinye ufinyelela ku-1 MiB. Akunakwenzeka ukufinyelela kuyo yonke imikhawulo ngesikhathi esisodwa. Ukubuka kuqala kubonisa amarekhodi okuqala angu-100 kuphela nezinhlamvu ezifika ku-1000 enkambini ngayinye. Ukukopisha nokulanda akufinyezi okuqukethwe.

Ubumfihlo kanye nokululama

Okuqukethwe kwefayela kugcinwa kuphela kumemori yekhasi lamanje futhi akulayishwa noma kubhalwe ku-LocalStore. Ukuvuselela kuzosula idatha. Ukukhansela umsebenzi omude akulondolozi ingxenye yemiphumela futhi kubuyisela isifinyezo sokugcina esigcwele.

I-CSV / JSON Cleaning kanye ne-Field Mapper

Ngenisa noma namathisela i-UTF-8 CSV, qinisekisa izilungiselelo zesakhiwo, lungiselela imithetho yenkambu, sebenzisa futhi ubuyekeze umehluko. Inkinobho yokudawuniloda inikwa amandla kuphela uma isakhiwo nohlobo lokuhlola kudlula, imiphumela ingaphelelwa yisikhathi, futhi ubungozi befomula kubhekwana nabo ngokusobala.

misa