Ukuhlunga idatha kuspredishithi kusho ukusetha izimo ukuze idatha ethile kuphela iboniswe. Kwenziwe ukwenza kube lula ukugxila kolwazi oluthile kwi dataset enkulu noma ithebula yedatha. Ukuhlunga akukhiphi noma kushintshe idatha; ivele iguqule ukuthi yimiphi imigqa noma amakholomu avela esikhwameni sokusebenza se-Excel.
Ukuhlunga amarekhodi wedatha
Izihlungi zisebenza ngamarekhodi noma imigqa yedatha ekhasini lokusebenzela.Izimo ezibekiwe zifaniswa nenye eyodwa noma ngaphezulu emasimini . Uma izimo zifinyelelwe, irekhodi iboniswa. Uma ngabe izimo zingagciniwe, irekhodi lihlungwa ukuze lingaboniswa namanye amarekhodi wedatha.
Ukuhlunga idatha kulandela izindlela ezimbili ezihlukene kuye ngokuthi uhlobo lwedatha lube lucwecwe-lombhalo noma idatha yombhalo.
Ukuhlunga idatha ye-Numeric
Idatha yezinombolo ingahlungwa ngokusekelwe ku:
- kungakhathaliseki ukuthi idatha ilingana nenombolo ethile
- kungakhathaliseki ukuthi idatha idlula noma ingaphansi kwenani elithile
- idatha ingaphezulu noma ngaphansi kwenani elilinganiselwe ledatha lonke
Ukuhlunga idatha yombhalo
Idatha yombhalo ingahlungwa ngokusekelwe ku:
- kungakhathaliseki ukuthi idatha idinga igama elithile
- kungakhathaliseki ukuthi idatha iyigama eliqukethe eyodwa noma ngaphezulu
- kungakhathaliseki ukuthi idatha iyinkulumo eqala noma ephelile ngenye incwadi yezinhlamvu
Ukukopisha Amarekhodi Ahlungiwe
Ngaphandle kwamarekhodi okufihla okwesikhashana, i-Excel ikunikeza ongakhetha ukukopisha idatha oyifunayo endaweni ehlukile yephepha lokusebenzela . Ngokuvamile le nqubo yenziwa uma ikhophi ehlala njalo yohlu oluhlungiwe ihlangabezana nemfuneko ethile yebhizinisi.
Izindlela Ezinhle Zokuhlunga
Zisindise ukuhlukunyezwa ngokulandela imihlahlandlela engcono kakhulu yokusebenzisa ukusebenza nedatha ehlungiwe:
- Ngaphandle kokuthi kube nesizathu esihle salokho, ungahlungi ispredishithi esabelwe ngokuhlunga okusebenzayo. Abanye abasebenzisi bangase bangaqapheli ukuthi ifayela lihlungiwe.
- Nakuba ungahlunga ngamakholomu amaningana ngesikhathi esifanayo, lezi zihlungi zinezela, hhayi okukhethekile. Ngamanye amazwi, ukuhlunga uhlu lokuxhumana ukuze ubonise wonke umuntu ku-State of California futhi asebekhulile kuneminyaka engama-60 kuzokunika wonke umuntu oneminyaka engaphezulu kuka-60 eCalifornia. Isihlungi esinjalo ngeke sikubonise oneminyaka engu-60 ubudala noma abaseCalifornia.
- Izihlungi zombhalo eziyinkimbinkimbi zisebenza kanye nedatha esisekelo izovumela. Idatha "ye-Messy" izoholela emiphumeleni ehlungiwe engase idukise noma ingalungile. Isibonelo, ukuhlunga kubantu abahlala e-Illinois ngeke babambe abantu abahlala ku-"IL" noma abahlala "i-Ilinois" noma "i-Illenois."
- Qaphela lapho uhlela idatha ehlungiwe. Ukuhlunga idatha ehlungiwe kancane kuyoholela ekusetshenzisweni kabusha kwefayela lemininingwane-isimo esivame ukugwema. Uma kufanele uhlele i-dataset ehlungiwe, kopisha idatha ehlungiwe ephepheni elisha lomsebenzi bese ulihlunga.