Vim muaj kev cais tawm, ntau tus tam sim no siv tus tsov ntxhuav feem ntawm lawv lub sijhawm nyob hauv tsev, thiab lub sijhawm no tuaj yeem, thiab txawm tias yuav tsum tau siv kom zoo.
Thaum pib ntawm kev cais tawm, kuv txiav txim siab ua kom tiav qee qhov haujlwm uas kuv tau pib ob peb lub hlis dhau los. Ib qho ntawm cov haujlwm no yog chav kawm video "R Language rau cov neeg siv Excel". Nrog rau qhov kev kawm no, kuv xav txo qis qhov cuam tshuam rau kev nkag mus rau R, thiab me ntsis ua rau qhov tsis txaus ntawm cov ntaub ntawv qhia txog cov ncauj lus no hauv Lavxias.
Yog tias txhua yam ua haujlwm nrog cov ntaub ntawv hauv lub tuam txhab koj ua haujlwm tseem ua tiav hauv Excel, tom qab ntawd kuv xav kom koj paub nrog cov niaj hnub ntau dua, thiab tib lub sijhawm pub dawb, cov cuab yeej tsom xam cov ntaub ntawv.
Txheem
Yog tias koj txaus siab rau cov ntaub ntawv tsom xam, tej zaum koj yuav txaus siab rau kuv ΠΈ cov channel. Cov ntsiab lus feem ntau yog mob siab rau R hom lus.
4.1.
4.2.
4.3.
4.4.
4.5.
4.6.
4.7.
4.8.
4.9.
4.10.
4.11.
4.12.
ua tim khawv
Hais txog chav kawm
Chav kawm yog tsim nyob ib ncig ntawm architecture tidyverse, thiab cov pob khoom suav nrog hauv nws: readr, vroom, dplyr, tidyr, ggplot2. Tau kawg, muaj lwm cov pob khoom zoo hauv R uas ua haujlwm zoo sib xws, piv txwv li data.table, tab sis cov syntax tidyverse intuitive, yooj yim nyeem txawm rau cov neeg siv tsis tau kawm, yog li kuv xav tias nws yog qhov zoo dua los pib kawm cov lus R nrog tidyverse.
Hoob no yuav qhia koj txog txhua yam kev txheeb xyuas cov ntaub ntawv, los ntawm kev thauj khoom mus rau pom qhov ua tiav.
Vim li cas R thiab tsis Python? Vim tias R yog hom lus ua haujlwm, nws yooj yim dua rau cov neeg siv Excel hloov mus rau nws, vim tsis tas yuav delve rau hauv cov khoom siv-oriented programming.
Tam sim no, 12 cov lus qhia video tau npaj, kav ntev li 5 txog 20 feeb txhua.
Cov lus qhia yuav qhib maj mam. Txhua hnub Monday kuv yuav qhib nkag mus rau ib zaj lus qhia tshiab ntawm kuv lub vev xaib. nyob rau hauv ib tug cais playlist.
Hoob no yog leej twg?
Kuv xav tias qhov no yog qhov tseeb ntawm lub npe, txawm li cas los xij, kuv yuav piav qhia ntau ntxiv.
Cov chav kawm yog tsom rau cov neeg uas nquag siv Microsoft Excel hauv lawv txoj haujlwm thiab siv tag nrho lawv txoj haujlwm nrog cov ntaub ntawv nyob ntawd. Feem ntau, yog tias koj qhib Microsoft Excel daim ntawv thov tsawg kawg ib zaug hauv ib lub lis piam, ces chav kawm yog tsim nyog rau koj.
Koj tsis tas yuav muaj kev txawj programming kom tiav cov chav kawm, vim tias ... Cov chav kawm yog tsom rau cov pib tshiab.
Tab sis, tej zaum, pib ntawm zaj lus qhia 4, yuav muaj cov ntaub ntawv nthuav dav rau cov neeg siv R nquag, ib yam nkaus, vim ... lub ntsiab functionality ntawm tej pob khoom xws li dplyr ΠΈ tidyr yuav tau tham nyob rau hauv ib co nthuav dav.
Qhov kev pab cuam
Zaj Lus Qhia 1: Txhim kho R hom lus thiab RStudio txhim kho ib puag ncig
Hnub tshaj tawm: Lub peb hlis ntuj 23 2020
Links:
Yees duab:
Kev piav qhia:
Ib zaj lus qhia thaum lub sij hawm uas peb yuav rub tawm thiab nruab cov software tsim nyog, thiab tshawb xyuas luv luv ntawm lub peev xwm thiab kev cuam tshuam ntawm RStudio kev txhim kho ib puag ncig.
Zaj Lus Qhia 2: Basic Data Structures in R
Hnub tshaj tawm: Lub peb hlis ntuj 30 2020
Links:
Yees duab:
Kev piav qhia:
Zaj lus qhia no yuav pab koj nkag siab txog cov ntaub ntawv dab tsi muaj nyob hauv R hom lus. Cia peb kawm yuav ua li cas los tsim lawv thiab nkag mus rau lawv tus kheej cov ntsiab lus.
Zaj 3: Nyeem cov ntaub ntawv los ntawm TSV, CSV, Excel cov ntaub ntawv thiab Google Sheets
Hnub tshaj tawm: Plaub Hlis Ntuj 6 2020
Links:
Yees duab:
Kev piav qhia:
Ua hauj lwm nrog cov ntaub ntawv, tsis hais lub cuab tam, pib nrog nws cov extraction. Cov pob khoom siv thaum lub sijhawm kawm vroom, readxl, googlesheets4 rau kev thauj cov ntaub ntawv mus rau R ib puag ncig los ntawm csv, tsv, Excel cov ntaub ntawv thiab Google Sheets.
Zaj Lus Qhia 4: Lim kab, xaiv thiab hloov npe kab, cov kav dej hauv R
Hnub tshaj tawm: Plaub Hlis Ntuj 13 2020
Links:
Yees duab:
Kev piav qhia:
Zaj lus qhia no yog hais txog lub pob dplyr. Hauv nws peb yuav txheeb xyuas seb yuav lim cov ntaub ntawv li cas, xaiv cov kab tsim nyog thiab hloov npe rau lawv.
Peb kuj tseem yuav kawm seb cov kav dej yog dab tsi thiab lawv pab ua kom koj R code nyeem tau ntau dua.
Zaj Lus Qhia 5: Ntxiv cov lej suav rau ib lub rooj hauv R
Hnub tshaj tawm: Plaub Hlis Ntuj 20 2020
Links:
Yees duab:
Kev piav qhia:
Hauv daim vis dis aus no peb txuas ntxiv peb cov kev paub nrog lub tsev qiv ntawv tidyverse thiab pob dplyr.
Wb saib tsev neeg ntawm kev ua haujlwm mutate(), thiab peb yuav kawm paub siv lawv ntxiv cov lej suav tshiab rau lub rooj.
Zaj Lus Qhia 6: Kev sib faib thiab sib sau cov ntaub ntawv hauv R
Hnub tshaj tawm: Plaub Hlis Ntuj 27 2020
Links:
Yees duab:
Kev piav qhia:
Zaj lus qhia no yog mob siab rau ib qho ntawm cov haujlwm tseem ceeb ntawm kev txheeb xyuas cov ntaub ntawv, kev ua pab pawg thiab kev sib sau ua ke. Nyob rau hauv zaj lus qhia peb yuav siv lub pob dplyr thiab nta group_by() ΠΈ summarise().
Peb yuav saib tag nrho tsev neeg ntawm kev ua haujlwm summarise(), i.e. summarise(), summarise_if() ΠΈ summarise_at().
Zaj Lus Qhia 7: Kev sib koom ua ke ntsug thiab kab rov tav ntawm rooj hauv R
Hnub tshaj tawm: 4 Tej zaum 2020
Links:
Yees duab:
Kev piav qhia:
Zaj lus qhia no yuav pab koj nkag siab txog kev ua haujlwm ntawm kev sib koom ua ke ntawm ntsug thiab kab rov tav.
Lub koomhaum ntsug yog qhov sib npaug ntawm UNION kev ua haujlwm hauv SQL lus nug.
Kab rov tav koom yog paub zoo dua rau cov neeg siv Excel ua tsaug rau VLOOKUP muaj nuj nqi; hauv SQL, cov haujlwm no tau ua los ntawm JOIN tus neeg teb xov tooj.
Thaum lub sij hawm zaj lus qhia peb yuav daws tau qhov teeb meem uas peb yuav siv tej pob khoom dplyr, readxl, tidyr ΠΈ stringr.
Lub luag haujlwm tseem ceeb uas peb yuav xav txog:
bind_rows()- ntsug koom ntawm roojleft_join()- kab rov tav koom ntawm roojsemi_join()- suav nrog cov rooj sib thamanti_join()- tshwj xeeb rooj koom
Zaj Lus Qhia 8: Qhov rai Functions hauv R
Hnub tshaj tawm: 11 Tej zaum 2020
Links:
Kev piav qhia:
Lub qhov rais ua haujlwm zoo ib yam hauv lub ntsiab lus rau kev sib sau ua ke; lawv kuj siv cov array ntawm qhov tseem ceeb raws li cov tswv yim thiab ua cov lej lej ntawm lawv, tab sis tsis txhob hloov cov naj npawb ntawm cov kab hauv cov txiaj ntsig tso tawm.
Nyob rau hauv no nyeem peb txuas ntxiv mus kawm lub pob dplyr, thiab functions group_by(), mutate(), zoo li tshiab cumsum(), lag(), lead() ΠΈ arrange().
Zaj Lus Qhia 9: Kev sib hloov cov lus los yog ib qho piv txwv ntawm cov lus pivot hauv R
Hnub tshaj tawm: 18 Tej zaum 2020
Links:
Kev piav qhia:
Cov neeg siv Excel feem ntau siv cov lus pivot; qhov no yog ib qho cuab yeej yooj yim uas koj tuaj yeem tig cov ntaub ntawv nyoos rau hauv cov ntaub ntawv nyeem tau hauv ib lub vib nas this.
Nyob rau hauv no nyeem peb yuav saib yuav ua li cas tig lub rooj nyob rau hauv R, thiab hloov lawv los ntawm dav mus rau ntev hom thiab vice versa.
Feem ntau ntawm cov lus qhia yog mob siab rau lub pob tidyr thiab ua haujlwm pivot_longer() ΠΈ pivot_wider().
Zaj Lus Qhia 10: Loading JSON Files in R and Converting Lists to Tables
Hnub tshaj tawm: 25 Tej zaum 2020
Links:
Kev piav qhia:
JSON thiab XML yog cov qauv nrov heev rau khaws cia thiab sib pauv cov ntaub ntawv, feem ntau yog vim lawv cov compactness.
Tab sis nws yog ib qho nyuaj rau kev txheeb xyuas cov ntaub ntawv uas tau nthuav tawm hauv cov qauv zoo li no, yog li ua ntej kev tshuaj xyuas nws yog ib qho tsim nyog yuav tsum coj nws mus rau hauv daim ntawv tabular, uas yog raws nraim li peb yuav kawm hauv video no.
Zaj lus qhia yog mob siab rau lub pob tidyr, suav nrog lub hauv paus ntawm lub tsev qiv ntawv tidyverse, thiab functions unnest_longer(), unnest_wider() ΠΈ hoist().
Zaj Lus Qhia 11: Plotting Quickly Using the qplot() Function
Hnub tshaj tawm: 1 2020 Lub rau hli ntuj
Links:
Kev piav qhia:
Pob ggplot2 yog ib qho ntawm cov ntaub ntawv nrov tshaj plaws pom cov cuab yeej tsis yog hauv R.
Hauv zaj lus qhia no peb yuav kawm yuav ua li cas los tsim cov duab yooj yim siv cov haujlwm qplot(), thiab cia peb txheeb xyuas tag nrho nws cov lus sib cav.
Zaj Lus Qhia 12: Plotting Layer by Layer Plots Siv ggplot2 Pob
Hnub tshaj tawm: 8 2020 Lub rau hli ntuj
Links:
Kev piav qhia:
Zaj lus qhia qhia txog lub zog tag nrho ntawm lub pob ggplot2 thiab cov qauv sau ntawv ntawm lub tsev graphs hauv cov khaubncaws sab nraud povtseg hauv nws.
Peb yuav txheeb xyuas cov geometries tseem ceeb uas muaj nyob rau hauv pob thiab kawm yuav ua li cas siv cov khaubncaws sab nraud povtseg los tsim ib daim duab.
xaus
Kuv sim mus kom ze rau qhov tsim ntawm cov kev pab cuam raws li concisely li sai tau, los qhia tsuas yog cov ntaub ntawv tsim nyog tshaj plaws uas koj yuav xav tau nyob rau hauv thiaj li yuav ua thawj kauj ruam nyob rau hauv kev kawm xws li ib tug haib cov ntaub ntawv tsom xam cov cuab yeej raws li cov lus R.
Hoob no tsis yog phau ntawv qhia tag nrho rau kev txheeb xyuas cov ntaub ntawv siv R hom lus, tab sis nws yuav pab koj nkag siab txhua yam kev tsim nyog rau qhov no.
Thaum cov chav kawm yog tsim los rau 12 lub lis piam, txhua lub lim tiam rau hnub Mondays kuv yuav qhib nkag mus rau cov lus qhia tshiab, yog li kuv pom zoo. ntawm YouTube channel kom tsis txhob nco kev tshaj tawm cov lus qhia tshiab.
Tau qhov twg los: www.hab.com