Ngenxa yokuhlukaniswa, abaningi manje bachitha ingxenye yengonyama yesikhathi sabo ekhaya, futhi lesi sikhathi singakwazi, futhi kufanele, sisetshenziswe ngendlela ewusizo.
Ekuqaleni kokuvalelwa, nginqume ukuqeda amaphrojekthi engiwaqale ezinyangeni ezimbalwa ezedlule. Enye yale phrojekthi kwakuyisifundo sevidiyo esithi βR Language for Excel Usersβ. Ngalesi sifundo, bengifuna ukwehlisa isithiyo sokungena ku-R, futhi ngigcwalise kancane ukushoda okukhona kwezinto zokuqeqesha kulesi sihloko ngesiRashiya.
Uma wonke umsebenzi ngedatha enkampanini oyisebenzelayo usakwenziwa ku-Excel, khona-ke ngiphakamisa ukuthi ujwayelane nesimanjemanje, futhi ngesikhathi esifanayo mahhala ngokuphelele, ithuluzi lokuhlaziya idatha.
Okuqukethwe
Uma uthanda ukuhlaziya idatha, ungase ube nentshisekelo yami ΠΈ iziteshi. Iningi lokuqukethwe linikezelwe olimini lwe-R.
4.1.
4.2.
4.3.
4.4.
4.5.
4.6.
4.7.
4.8.
4.9.
4.10.
4.11.
4.12.
izithenjwa
Mayelana nesifundo
Isifundo sakhiwe ngokuzungeza izakhiwo tidyverse, namaphakheji afakwe kuyo: readr, vroom, dplyr, tidyr, ggplot2. Yiqiniso, kukhona amanye amaphakheji amahle ku-R enza imisebenzi efanayo, isibonelo data.table, kodwa i-syntax tidyverse inembile, ifundeka kalula ngisho nakumsebenzisi ongaqeqeshiwe, ngakho-ke ngicabanga ukuthi kungcono ukuqala ukufunda ulimi lwesi-R tidyverse.
Isifundo sizokuqondisa kukho konke ukuhlaziya idatha, kusukela ekulayisheni kuya ekuboneni ngeso lengqondo umphumela ophelile.
Kungani i-R hhayi iPython? Ngenxa yokuthi u-R uwulimi olusebenzayo, kulula kubasebenzisi be-Excel ukushintshela kulo, ngoba asikho isidingo sokungena ohlelweni lwendabuko olugxile entweni.
Okwamanje, kuhlelwa izifundo zevidiyo eziyi-12, ezithatha imizuzu emi-5 kuye kwengama-20 ngasinye.
Izifundo zizovuleka kancane kancane. Njalo ngoMsombuluko ngizovula ukufinyelela esifundweni esisha kuwebhusayithi yami. ohlwini lwadlalwayo oluhlukile.
Ngokabani lesi sifundo?
Ngicabanga ukuthi lokhu kucacile esihlokweni, noma kunjalo, ngizokuchaza ngokuningiliziwe.
Isifundo sihloselwe labo abasebenzisa i-Microsoft Excel ngenkuthalo emsebenzini wabo futhi basebenzise wonke umsebenzi wabo ngedatha lapho. Ngokuvamile, uma uvula uhlelo lwe-Microsoft Excel okungenani kanye ngesonto, khona-ke isifundo sikulungele.
Akudingekile ukuthi ube namakhono wokuhlela ukuze uqedele isifundo, ngoba... Isifundo sihloselwe abasaqalayo.
Kodwa, mhlawumbe, kusukela esifundweni sesi-4, kuzoba nezinto ezithokozisayo zabasebenzisi be-R abasebenzayo, futhi, ngoba... ukusebenza okuyinhloko kwamaphakheji anjalo njenge dplyr ΠΈ tidyr kuzoxoxwa ngayo ngokuningiliziwe.
Uhlelo lwezifundo
Isifundo 1: Ukufaka ulimi lwe-R kanye nemvelo yokuthuthukisa i-RStudio
Idethi yokushicilela: Mashi 23 2020
Izinkomba:
Ividiyo:
Incazelo:
Isifundo esiyisingeniso lapho sizodawuniloda futhi sifake isofthiwe edingekayo, futhi sihlole kafushane amakhono nokuxhumana kwendawo yokuthuthukiswa kwe-RStudio.
Isifundo 2: Izakhiwo Zedatha Eyisisekelo ku-R
Idethi yokushicilela: Mashi 30 2020
Izinkomba:
Ividiyo:
Incazelo:
Lesi sifundo sizokusiza uqonde ukuthi yiziphi izakhiwo zedatha ezitholakala ngolimi R. Sizobheka ngokuningiliziwe ama-vectors, amafreyimu wezinsuku kanye nohlu. Masifunde ukuthi zingawadala kanjani futhi sifinyelele izakhi zawo ngazinye.
Isifundo 3: Ukufunda idatha ku-TSV, CSV, Excel amafayela kanye ne-Google AmaSpredishithi
Idethi yokushicilela: Apreli 6 2020
Izinkomba:
Ividiyo:
Incazelo:
Ukusebenza ngedatha, kungakhathaliseki ithuluzi, kuqala ngokukhipha kwayo. Amaphakheji asetshenziswa phakathi nesifundo vroom, readxl, googlesheets4 ukuze kulayishwe idatha endaweni engu-R isuka ku-csv, tsv, amafayela e-Excel kanye ne-Google AmaSpredishithi.
Isifundo 4: Ukuhlunga imigqa, ukukhetha nokuqamba kabusha amakholomu, amapayipi ku-R
Idethi yokushicilela: Apreli 13 2020
Izinkomba:
Ividiyo:
Incazelo:
Lesi sifundo simayelana nephakheji dplyr. Kuyo sizobona indlela yokuhlunga ama-dataframes, khetha amakholomu adingekayo bese uwaqamba kabusha.
Sizofunda futhi ukuthi ayini amapayipi nokuthi asiza kanjani ukwenza ikhodi yakho engu-R ifundeke kakhudlwana.
Isifundo 5: Ukwengeza Amakholomu Abaliwe Kuthebula Eliku-R
Idethi yokushicilela: Apreli 20 2020
Izinkomba:
Ividiyo:
Incazelo:
Kule vidiyo siqhubeka nokujwayelana nomtapo wolwazi tidyverse kanye nephakheji dplyr.
Ake sibheke umndeni wemisebenzi mutate(), futhi sizofunda ukuthi zisetshenziswa kanjani ukuze sengeze amakholomu amasha abaliwe etafuleni.
Isifundo 6: Ukuhlanganisa kanye Nokuhlanganisa Idatha ku-R
Idethi yokushicilela: Apreli 27 2020
Izinkomba:
Ividiyo:
Incazelo:
Lesi sifundo sinikezelwe komunye wemisebenzi eyinhloko yokuhlaziya idatha, ukuqoqa nokuhlanganisa. Phakathi nesifundo sizosebenzisa iphakheji dplyr kanye nezici group_by() ΠΈ summarise().
Sizobheka wonke umndeni wemisebenzi summarise(), i.e. summarise(), summarise_if() ΠΈ summarise_at().
Isifundo 7: Ukuhlanganiswa Okuqondile Nokuvundlile Kwamathebula ku-R
Idethi yokushicilela: 4 Meyi 2020
Izinkomba:
Ividiyo:
Incazelo:
Lesi sifundo sizokusiza uqonde ukusebenza kokujoyina okuqondile nokuvundlile kwamathebula.
Inyunyana eqondile ilingana nomsebenzi we-UNION ngolimi lombuzo lwe-SQL.
Ukujoyina okuvundlile kwaziwa kangcono kubasebenzisi be-Excel ngenxa yomsebenzi we-VLOOKUP; ku-SQL, imisebenzi enjalo yenziwa ngu-opharetha we-JOIN.
Phakathi nesifundo sizoxazulula inkinga engokoqobo lapho sizosebenzisa amaphakheji dplyr, readxl, tidyr ΠΈ stringr.
Imisebenzi esemqoka esizoyicabangela:
bind_rows()- Ukuhlanganisa mpo kwamathebulaleft_join()- ukuhlangana kwamathebula okuvundlilesemi_join()- kufaka phakathi amatafula wokuhlanganisaanti_join()- ukujoyina ithebula okukhethekile
Isifundo 8: Iwindi Imisebenzi ku-R
Idethi yokushicilela: 11 Meyi 2020
Izinkomba:
Incazelo:
Imisebenzi yamawindi iyafana ngencazelo naleyo yokuhlanganisa; futhi ithatha amanani afanayo njengokufakwayo futhi yenze imisebenzi ye-arithmetic kuwo, kodwa ayishintshi inani lemigqa kumphumela wokukhiphayo.
Kulesi sifundo siqhubeka nokufunda iphakheji dplyr, kanye nemisebenzi group_by(), mutate(), kanye nokusha cumsum(), lag(), lead() ΠΈ arrange().
Isifundo 9: Amathebula azungezisayo noma i-analogue yamathebula e-pivot ku-R
Idethi yokushicilela: 18 Meyi 2020
Izinkomba:
Incazelo:
Abasebenzisi abaningi be-Excel basebenzisa amathebula e-pivot; leli ithuluzi elikahle ongashintsha ngalo idatha engahluziwe ibe yimibiko efundekayo esikhathini esingangemizuzwana.
Kulesi sifundo sizobheka indlela yokuzungezisa amatafula ku-R, futhi uwaguqule ukusuka kububanzi ukuya kufomethi ende futhi ngokuphambene nalokho.
Iningi lesifundo linikezelwe kuphakheji tidyr kanye nemisebenzi pivot_longer() ΠΈ pivot_wider().
Isifundo 10: Ilayisha Amafayela e-JSON ku-R kanye Nokuguqula Uhlu lube Amathebula
Idethi yokushicilela: 25 Meyi 2020
Izinkomba:
Incazelo:
I-JSON ne-XML zingamafomethi adume kakhulu okugcina kanye nokwabelana ngolwazi, ngokuvamile ngenxa yokuhlangana kwawo.
Kodwa kunzima ukuhlaziya idatha evezwe ngamafomethi anjalo, ngakho-ke ngaphambi kokuhlaziywa kuyadingeka ukuyiletha efomini lethebula, okuyilokho kanye esizokufunda kule vidiyo.
Isifundo sinikezelwe kuphakheji tidyr, kufakwe phakathi komtapo wolwazi tidyverse, kanye nemisebenzi unnest_longer(), unnest_wider() ΠΈ hoist().
Isifundo 11: Ukuhlela Ngokushesha Ukusebenzisa Umsebenzi we-qplot()
Idethi yokushicilela: 1 2020 Juni
Izinkomba:
Incazelo:
Iphakheji ggplot2 ingelinye lamathuluzi okubona idatha aziwa kakhulu hhayi kuphela ku-R.
Kulesi sifundo sizofunda indlela yokwakha amagrafu alula sisebenzisa umsebenzi qplot(), futhi ake sihlaziye zonke izimpikiswano zakhe.
Isifundo 12: Isendlalelo Sokuceba Ngeziqephu Zendlalelo Ukusebenzisa Iphakheji ye-ggplot2
Idethi yokushicilela: 8 2020 Juni
Izinkomba:
Incazelo:
Isifundo sibonisa amandla aphelele ephakheji ggplot2 kanye nohlelo lolimi lwamagrafu okwakha ngezingqimba ezishumekwe kuwo.
Sizohlaziya amajiyometri amakhulu akhona kuphakheji futhi sifunde ukuthi zisetshenziswa kanjani izendlalelo ukuze kwakhiwe igrafu.
isiphetho
Ngizamile ukusondela ekwakhiweni kohlelo lwezifundo kafushane ngangokunokwenzeka, ukugqamisa kuphela ulwazi oludingekayo kakhulu ozoludinga ukuze uthathe izinyathelo zokuqala zokufunda ithuluzi elinamandla lokuhlaziya idatha njengolimi lwe-R.
Isifundo asiwona umhlahlandlela ophelele wokuhlaziya idatha usebenzisa ulimi lwe-R, kodwa sizokusiza uqonde wonke amasu adingekayo alokhu.
Ngenkathi uhlelo lwezifundo lwenzelwe amasonto ayi-12, isonto ngalinye ngeMisombuluko ngizovula ukufinyelela ezifundweni ezintsha, ngakho-ke ngincoma esiteshini se-YouTube ukuze ungaphuthelwa ukushicilelwa kwesifundo esisha.
Source: www.habr.com