Chifukwa chakukhala kwaokha, ambiri amathera nthawi yochulukirapo kunyumba, ndipo nthawi ino atha kugwiritsidwa ntchito moyenera.
Kumayambiriro kwa kukhala kwaokha, ndinaganiza zomaliza ntchito zina zomwe ndinayambitsa miyezi ingapo yapitayo. Chimodzi mwazinthuzi chinali maphunziro a kanema "R Language for Excel Users". Ndi maphunzirowa, ndimafuna kuchepetsa chotchinga cholowera mu R, ndikudzaza pang'ono kuchepa kwa zida zophunzitsira pamutuwu mu Chirasha.
Ngati zonse zimagwira ntchito ndi deta mu kampani yomwe mumagwirira ntchito ikuchitikabe ku Excel, ndiye ndikupangira kuti mudziwe zambiri zamakono, komanso nthawi yomweyo zaulere, chida chosanthula deta.
Zamkatimu
Ngati mukufuna kusanthula deta, mungakhale ndi chidwi changa ΠΈ njira. Zambiri mwazomwe zimaperekedwa ku chilankhulo cha 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.
powatsimikizira
Za maphunziro
Maphunzirowa amapangidwa mozungulira zomangamanga tidyverse, ndi mapaketi omwe ali mmenemo: readr, vroom, dplyr, tidyr, ggplot2. Zachidziwikire, pali ma phukusi ena abwino mu R omwe amachita ntchito zofananira, mwachitsanzo data.table, koma syntax tidyverse zachidziwitso, zosavuta kuwerenga ngakhale kwa wogwiritsa ntchito wosaphunzitsidwa, kotero ndikuganiza kuti ndibwino kuyamba kuphunzira chinenero cha R tidyverse.
Maphunzirowa adzakuwongolerani pazochita zonse zosanthula deta, kuyambira pakutsitsa mpaka kuwona zotsatira zomalizidwa.
Chifukwa chiyani R osati Python? Chifukwa R ndi chilankhulo chogwira ntchito, ndizosavuta kuti ogwiritsa ntchito a Excel asinthe, chifukwa palibe chifukwa cholowera muzinthu zachikhalidwe zotsata zinthu.
Pakadali pano, maphunziro a kanema 12 akukonzekera, kuyambira mphindi 5 mpaka 20 iliyonse.
Maphunziro adzatsegulidwa pang'onopang'ono. Lolemba lililonse ndimatsegula mwayi wopeza phunziro latsopano patsamba langa. mu playlist osiyana.
Kodi maphunzirowa ndi andani?
Ndikuganiza kuti izi zikuwonekera bwino pamutuwu, komabe, ndikufotokozera mwatsatanetsatane.
Maphunzirowa amaperekedwa kwa iwo omwe amagwiritsa ntchito Microsoft Excel mwachangu pantchito yawo ndikukhazikitsa ntchito yawo yonse ndi data pamenepo. Nthawi zambiri, ngati mutsegula pulogalamu ya Microsoft Excel kamodzi pa sabata, ndiye kuti maphunzirowa ndi abwino kwa inu.
Simukuyenera kukhala ndi luso lokonzekera kuti mumalize maphunzirowo, chifukwa ... Maphunzirowa cholinga chake ndi oyamba kumene.
Koma, mwina, kuyambira pa phunziro 4, padzakhala zinthu zosangalatsa kwa ogwiritsa ntchito R, nawonso, chifukwa ... ntchito yaikulu ya phukusi monga dplyr ΠΈ tidyr idzakambidwa mwatsatanetsatane.
Pulogalamu yamaphunziro
Phunziro 1: Kuyika chilankhulo cha R ndi malo otukuka a RStudio
Tsiku lofalitsidwa: March 23 2020
Zolemba:
Video:
Kufotokozera:
Phunziro loyambira pomwe tidzatsitsa ndikuyika pulogalamu yofunikira, ndikuwunikanso mwachidule kuthekera ndi mawonekedwe a chitukuko cha RStudio.
Phunziro 2: Basic Data Structures mu R
Tsiku lofalitsidwa: March 30 2020
Zolemba:
Video:
Kufotokozera:
Phunziroli likuthandizani kumvetsetsa kuti ndi mitundu iti ya data yomwe ikupezeka muchilankhulo cha R. Tiwona mwatsatanetsatane ma vekta, mafelemu amasiku ndi mindandanda. Tiyeni tiphunzire m'mene tingawalenge ndi kupeza zinthu zawo.
Phunziro 3: Kuwerenga zambiri kuchokera ku TSV, CSV, Excel mafayilo ndi Mapepala a Google
Tsiku lofalitsidwa: April 6 2020
Zolemba:
Video:
Kufotokozera:
Kugwira ntchito ndi deta, mosasamala kanthu za chida, kumayamba ndi kuchotsa kwake. Maphukusi amagwiritsidwa ntchito panthawi ya phunziro vroom, readxl, googlesheets4 potsitsa deta mu R chilengedwe kuchokera ku csv, tsv, mafayilo a Excel ndi Mapepala a Google.
Phunziro 4: Kusefa mizere, kusankha ndikusinthanso mizati, mapaipi mu R
Tsiku lofalitsidwa: April 13 2020
Zolemba:
Video:
Kufotokozera:
Phunziro ili ndi la phukusi dplyr. M'menemo tiwona momwe tingasefe ma dataframes, sankhani mizati yofunikira ndikuyitcha dzina.
Tiphunziranso kuti mapaipi ndi chiyani komanso momwe angathandizire kuti R code yanu ikhale yowerengeka.
Phunziro 5: Kuwonjeza Mizati Yowerengeredwa patebulo mu R
Tsiku lofalitsidwa: April 20 2020
Zolemba:
Video:
Kufotokozera:
Muvidiyoyi tikupitiriza kudziwana ndi laibulale tidyverse ndi paketi dplyr.
Tiyeni tione banja la ntchito mutate(), ndipo tiphunzira momwe tingawagwiritsire ntchito kuwonjezera zipilala zatsopano zowerengedwa patebulo.
Phunziro 6: Kuyika m'magulu ndi kusonkhanitsa deta mu R
Tsiku lofalitsidwa: April 27 2020
Zolemba:
Video:
Kufotokozera:
Phunziroli limaperekedwa ku imodzi mwazochita zazikulu pakusanthula deta, kupanga magulu ndi kuphatikiza. Pa phunziro tidzagwiritsa ntchito phukusi dplyr ndi mawonekedwe group_by() ΠΈ summarise().
Tidzawona banja lonse la ntchito summarise(), i.e. summarise(), summarise_if() ΠΈ summarise_at().
Phunziro 7: Kulumikizana Moyima ndi Kopingasa kwa Matebulo mu R
Tsiku lofalitsidwa: 4 May 2020
Zolemba:
Video:
Kufotokozera:
Phunziroli likuthandizani kumvetsetsa kagwiridwe ka ntchito ka kujowina koyima ndi kopingasa kwa matebulo.
Mgwirizano woyimirira ndi wofanana ndi ntchito ya UNION muchilankhulo cha SQL.
Kujowina kopingasa kumadziwika bwino kwa ogwiritsa ntchito a Excel chifukwa cha ntchito ya VLOOKUP; mu SQL, machitidwe otere amachitidwa ndi JOIN.
Pa phunziro tidzathetsa vuto lothandiza lomwe tidzagwiritsa ntchito phukusi dplyr, readxl, tidyr ΠΈ stringr.
Ntchito zazikulu zomwe tikambirana:
bind_rows()- Matebulo oyimaleft_join()- yopingasa kujowina matebulosemi_join()- kuphatikizapo kujowina matebuloanti_join()- kujowina kwa tebulo lapadera
Phunziro 8: Ntchito Zawindo mu R
Tsiku lofalitsidwa: 11 May 2020
Zolemba:
Kufotokozera:
Ntchito zamawindo ndizofanana ndi zomwe zikuphatikiza; amatenganso zinthu zingapo monga zolowetsa ndikuchita masamu pa iwo, koma osasintha kuchuluka kwa mizere pazotsatira.
Mu phunziro ili tikupitiriza kuphunzira phukusi dplyr, ndi ntchito group_by(), mutate(), komanso zatsopano cumsum(), lag(), lead() ΠΈ arrange().
Phunziro 9: Matebulo ozungulira kapena analogi ya ma pivot tables mu R
Tsiku lofalitsidwa: 18 May 2020
Zolemba:
Kufotokozera:
Ogwiritsa ntchito ambiri a Excel amagwiritsa ntchito ma pivot tables; ichi ndi chida chosavuta chomwe mungasinthe mndandanda wazinthu zosasinthika kukhala malipoti owerengeka pakangopita masekondi.
Mu phunziro ili tiwona momwe mungasinthire matebulo mu R, ndikuwatembenuza kuchokera kumitundu yonse kupita ku mawonekedwe aatali ndi mosemphanitsa.
Maphunziro ambiri amaperekedwa ku phukusi tidyr ndi ntchito pivot_longer() ΠΈ pivot_wider().
Phunziro 10: Kuyika Mafayilo a JSON mu R ndi Kusintha Mindandanda kukhala Matebulo
Tsiku lofalitsidwa: 25 May 2020
Zolemba:
Kufotokozera:
JSON ndi XML ndi mitundu yotchuka kwambiri yosungira ndikusinthana zambiri, nthawi zambiri chifukwa chophatikizana.
Koma n'zovuta kusanthula deta yoperekedwa m'mawonekedwe oterowo, kotero kuti tisanafufuze m'pofunika kubweretsa mu mawonekedwe a tabular, zomwe ndizomwe tidzaphunzire muvidiyoyi.
Phunziroli limaperekedwa ku phukusi tidyr, yophatikizidwa pakatikati pa laibulale tidyverse, ndi ntchito unnest_longer(), unnest_wider() ΠΈ hoist().
Phunziro 11: Kukonzekera Mwachangu Pogwiritsa Ntchito qplot() Ntchito
Tsiku lofalitsidwa: 1 2020 June
Zolemba:
Kufotokozera:
Phukusi ggplot2 ndi chimodzi mwazida zodziwika bwino zowonera deta osati mu R.
Mu phunziro ili tiphunzira momwe tingapangire ma graph osavuta pogwiritsa ntchito ntchitoyi qplot(), ndipo tiyeni tipende mfundo zake zonse.
PHUNZIRO 12: Kupanga chiwembu ndi magawo osanjikiza pogwiritsa ntchito phukusi la ggplot2
Tsiku lofalitsidwa: 8 2020 June
Zolemba:
Kufotokozera:
Phunziroli likuwonetsa mphamvu zonse za phukusi ggplot2 ndi galamala ya ma graph omanga m'magulu ophatikizidwamo.
Tisanthula ma geometries omwe alipo mu phukusi ndikuphunzira momwe angagwiritsire ntchito zigawo kuti apange graph.
Pomaliza
Ndinayesera kuyandikira kupangidwa kwa pulogalamu ya maphunzirowa mwachidule momwe ndingathere, kuti ndiwonetsere zofunikira zokhazokha zomwe mungafunike kuti mutengepo kanthu pophunzira chida champhamvu chowunikira deta monga R chinenero.
Maphunzirowa si kalozera wokwanira pakusanthula deta pogwiritsa ntchito chilankhulo cha R, koma adzakuthandizani kumvetsetsa njira zonse zofunika pa izi.
Pomwe pulogalamu yamaphunziroyi idapangidwira milungu 12, sabata iliyonse Lolemba ndimatsegula mwayi wopeza maphunziro atsopano, chifukwa chake ndimalimbikitsa pa njira ya YouTube kuti musaphonye kufalitsidwa kwa phunziro latsopano.
Source: www.habr.com