Kev teev cov ntaub ntawv nyob rau hauv ib qho kev tshaj tawm qhia tias tsim cov kev mob nkeeg thiaj li tsuas yog cov ntaub ntawv tso tawm xwb. Nws yog ua kom yooj yim los ua kom pom tseeb ntawm cov ntaub ntawv hauv ib qho loj dataset lossis cov lus ntawm cov ntaub ntawv. Filtering tsis tshem lossis hloov cov ntaub ntawv; nws tsuas hloov cov kab uas sawv los yog txhua kab tshwm nyob rau hauv cov ntawv sau Excel.
Kev Sau Cov Ntaub Ntawv Cov Ntaub Ntawv
Cov lim dej ua hauj lwm nrog cov ntaub ntawv los yog kab ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm. Cov xwm txheej uas tau teev muaj nrog rau ib los yog ntau dua cov hauj lwm hauv cov ntaub ntawv. Yog tias cov xwm txheej tau ntsib, cov ntaub ntawv teev lus pom zoo. Yog tias cov xwm txheej tsis tau ntsib, cov ntaub ntawv khaws cia ua kom tawm tau kom nws tsis pom muaj nrog cov ntaub ntawv khaws tseg.
Cov ntaub ntawv lim kev ua raws li ob qho kev sib txawv nyob ntawm seb cov ntaub ntawv tau lim-numeric los yog ntawv cov ntaub ntawv.
Filtering Numeric Data
Cov ntawv qhia cov zauv muaj peev xwm yuav lim tau raws li:
- seb cov ntaub ntawv sib npaug ntawm ib tug xov tooj
- seb cov ntaub ntawv muaj ntau dua los tsawg tshaj ib tus zauv
- cov ntaub ntawv yog siab tshaj los yog qis dua qhov nruab nrab tus nqi ntawm cov ntaub ntawv raws li tag nrho
Filtering Data Cov Ntaub Ntawv
Cov ntaub ntawv sau cia tau lim tau raws li:
- seb cov ntaub ntawv puas dhos ib lo lus
- seb cov ntaub ntawv yog lo lus uas muaj ib los yog ntau dua cov ntawv
- seb cov ntaub ntawv yog cov lus uas pib lossis xaus nrog ib tsab ntawv ntawm cov niam ntawv
Kev Luam Cov Ntaub Ntawv
Ntxiv nrog rau cov ntaub ntawv khaws cia ib ntus, Excel muab cov kev xaiv rau koj luam koj cov ntaub ntawv yam ntaub ntawv rau ib qho chaw ntawm daim ntawv ua haujlwm . Feem ntau cov txheej txheem no yog ua tiav thaum daim ntawv teev npe ntawm daim ntawv teev npe ua kom tau raws li qee yam kev ua lag luam.
Qhov Zoo Tshaj Plaws rau Qhov Kev Ntsuas
Txuag koj tus kheej qee qhov kev hassle ua raws li cov kev coj ua zoo tshaj plaws rau kev ua haujlwm nrog cov ntaub ntawv lim:
- Tshwj tsis yog muaj qhov laj thawj zoo rau nws, tsis txhob xev xo daim ntawv khom nqi nrog cov lim dej kom zoo. Lwm cov neeg siv yuav tsis pom tias cov ntaub ntawv no tau lim.
- Txawm hais tias koj tuaj yeem lim rau ob peb kab ib zaug, cov ntxaij lim dej no muaj qhov sib ntxiv, tsis yog qhov tshwj xeeb. Hauv lwm cov lus, sau cov npe hu rau txhua tus neeg hauv lub Xeev California thiab cov laus dua 60 xyoo rau txhua tus neeg uas muaj 60 xyoo hauv California. Qhov kev lim dej no yuav tsis qhia koj rau cov muaj hnub nyoog 60 xyoo lossis cov neeg Kalifonias.
- Cov ntawv nyeem cov ntxaij lim dej ua tiav nrog rau cov ntaub ntawv hauv qab no. Cov ntaub ntawv "Lo lus" yuav ua rau cov txiaj ntsig tau ntxig uas tej zaum yuav raug yuam kev lossis tsis yog. Piv txwv, cov neeg uas nyob hauv Illinois yuav tsis ntes cov neeg uas nyob hauv "IL" lossis nyob hauv "Ilinois" lossis "Illenois."
- Ce ceev faj thaum faib cov ntaub ntawv lim. Kev hloov cov ntaub ntawv ntawm cov ntaub ntawv yuav ua rau muaj kev hloov dua tshiab ntawm cov ntaub ntawv-qhov teeb meem no feem ntau zoo tshaj plaws zam. Yog tias koj yuav tsum txheeb cov zauv hauv cov ntaub ntawv lim tawm, luam cov ntaub ntawv tawm mus rau ib daim ntawv tshiab thiab mam li txheeb nws.