Saboda keɓancewa, da yawa yanzu suna kashe kaso mafi tsoka na lokacinsu a gida, kuma wannan lokacin yana iya, har ma ya kamata, a yi amfani da shi mai amfani.
A farkon keɓewar, na yanke shawarar gama wasu ayyukan da na fara watanni kaɗan da suka gabata. Ɗaya daga cikin waɗannan ayyukan shine tsarin bidiyo "R Language for Excel Users". Tare da wannan kwas, Ina so in rage shingen shiga cikin R, kuma dan kadan cika ƙarancin kayan horo a kan wannan batu a cikin harshen Rashanci.
Idan duk aiki tare da bayanai a cikin kamfanin da kuke aiki da shi har yanzu ana yin su a cikin Excel, to ina ba da shawarar ku saba da mafi zamani, kuma a lokaci guda cikakkiyar kyauta, kayan aikin bincike na bayanai.
Abubuwa
Idan kuna sha'awar nazarin bayanai, kuna iya sha'awar nawa и tashoshi. Yawancin abun ciki an sadaukar da shi ga yaren 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.
nassoshi
Game da hanya
An tsara kwas ɗin a kusa da gine-gine tidyverse, da fakitin da ke cikinsa: readr, vroom, dplyr, tidyr, ggplot2. Tabbas, akwai wasu fakiti masu kyau a cikin R waɗanda ke yin irin wannan ayyuka, alal misali data.table, amma syntax tidyverse m, mai sauƙin karantawa har ma ga mai amfani da ba a horar da shi ba, don haka ina ganin yana da kyau a fara koyon yaren R da tidyverse.
Kwas ɗin zai jagorance ku ta duk ayyukan nazarin bayanai, daga lodawa zuwa ganin sakamakon da aka gama.
Me yasa R kuma ba Python ba? Saboda R harshe ne mai aiki, yana da sauƙi ga masu amfani da Excel su canza zuwa gare shi, saboda babu buƙatar zurfafa cikin shirye-shirye na al'ada na al'ada.
A halin yanzu, ana shirin darussan bidiyo 12, wanda zai kasance daga mintuna 5 zuwa 20 kowanne.
Darussan za su buɗe a hankali. Kowace Litinin zan buɗe damar samun sabon darasi akan gidan yanar gizona. a cikin jerin waƙa daban.
Wanene wannan kwas ɗin?
Ina tsammanin wannan ya fito fili daga taken, duk da haka, zan kwatanta shi dalla-dalla.
Wannan kwas ɗin yana nufin waɗanda ke amfani da Microsoft Excel sosai a cikin aikinsu kuma suna aiwatar da duk ayyukansu tare da bayanai a can. Gabaɗaya, idan kun buɗe aikace-aikacen Microsoft Excel aƙalla sau ɗaya a mako, to kwas ɗin ya dace da ku.
Ba a buƙatar ku sami ƙwarewar shirye-shiryen don kammala karatun ba, saboda ... Kos din yana nufin masu farawa ne.
Amma, watakila, farawa daga darasi na 4, za a sami abubuwa masu ban sha'awa ga masu amfani da R masu aiki, suma, saboda ... babban aikin irin waɗannan fakitin kamar dplyr и tidyr za a tattauna dalla-dalla.
Shirin kwas
Darasi 1: Shigar da yaren R da yanayin ci gaban RStudio
Kwanan watan bugawa: Maris 23 2020
Tunani:
Video:
description:
Darasi na gabatarwa wanda a lokacin za mu zazzagewa da shigar da software da ake buƙata, kuma a taƙaice bincika iyawa da mu'amalar yanayin ci gaban RStudio.
Darasi na 2: Tushen Tsarukan Bayanai a cikin R
Kwanan watan bugawa: Maris 30 2020
Tunani:
Video:
description:
Wannan darasi zai taimake ka ka fahimci abin da tsarin bayanai ke samuwa a cikin harshen R. Za mu duba dalla-dalla game da vectors, firam ɗin kwanan wata da lissafin. Bari mu koyi yadda za mu ƙirƙira su kuma mu sami damar abubuwan da suka dace.
Darasi na 3: Karanta bayanai daga TSV, CSV, Excel files da Google Sheets
Kwanan watan bugawa: Afrilu 6 2020
Tunani:
Video:
description:
Yin aiki tare da bayanai, ba tare da la'akari da kayan aiki ba, yana farawa tare da cirewa. Ana amfani da fakiti yayin darasi vroom, readxl, googlesheets4 don loda bayanai a cikin yanayin R daga csv, tsv, fayilolin Excel da Google Sheets.
Darasi na 4: Tace layuka, zabar da sake suna, bututun cikin R
Kwanan watan bugawa: Afrilu 13 2020
Tunani:
Video:
description:
Wannan darasi game da kunshin ne dplyr. A ciki za mu gano yadda ake tace bayanai, zaɓi ginshiƙan da suka dace kuma a sake suna.
Za mu kuma koyi menene bututun mai da kuma yadda suke taimakawa wajen sanya lambar R ɗin ku ta zama abin karantawa.
Darasi na 5: Haɗa Ƙididdigar ginshiƙai zuwa Tebur a cikin R
Kwanan watan bugawa: Afrilu 20 2020
Tunani:
Video:
description:
A cikin wannan bidiyo muna ci gaba da sanin mu da ɗakin karatu tidyverse da kunshin dplyr.
Bari mu dubi dangin ayyuka mutate(), kuma za mu koyi yadda ake amfani da su don ƙara sababbin ginshiƙan ƙididdiga zuwa tebur.
Darasi na 6: Haɗawa da Haɗa Bayanai a cikin R
Kwanan watan bugawa: Afrilu 27 2020
Tunani:
Video:
description:
Wannan darasi an keɓe shi ne ga ɗaya daga cikin manyan ayyuka na nazarin bayanai, tarawa da tarawa. A lokacin darasi za mu yi amfani da kunshin dplyr da fasali group_by() и summarise().
Za mu dubi dukan iyali ayyuka summarise(), i.e. summarise(), summarise_if() и summarise_at().
Darasi na 7: Haɗin Tebura a Tsaye da Tsaye a cikin R
Kwanan watan bugawa: 4 May 2020
Tunani:
Video:
description:
Wannan darasi zai taimaka muku fahimtar ayyukan haɗin tebur a tsaye da a kwance.
Ƙungiya ta tsaye tana daidai da aikin UNION a cikin harshen tambaya na SQL.
Horizontal join an fi sanin masu amfani da Excel godiya ga aikin VLOOKUP; a cikin SQL, ma'aikacin JOIN yana yin irin waɗannan ayyukan.
A yayin darasin za mu magance wata matsala mai amfani wacce za mu yi amfani da fakiti dplyr, readxl, tidyr и stringr.
Babban ayyuka da za mu yi la'akari da su:
bind_rows()- haɗin tebur na tsayeleft_join()- a kwance haɗin tebursemi_join()- gami da shiga teburanti_join()- m tebur shiga
Darasi na 8: Ayyukan Taga a cikin R
Kwanan watan bugawa: 11 May 2020
Tunani:
description:
Ayyukan taga suna kama da ma'anar tarawa; suna kuma ɗaukar ƙima iri-iri azaman shigarwa kuma suna aiwatar da ayyukan lissafi akan su, amma ba sa canza adadin layuka a cikin sakamakon fitarwa.
A cikin wannan koyawa za mu ci gaba da nazarin kunshin dplyr, da ayyuka group_by(), mutate(), da kuma sababbi cumsum(), lag(), lead() и arrange().
Darasi na 9: Tebura masu jujjuyawa ko analogue na tebur pivot a cikin R
Kwanan watan bugawa: 18 May 2020
Tunani:
description:
Yawancin masu amfani da Excel suna amfani da allunan pivot; wannan kayan aiki ne mai dacewa wanda zaku iya jujjuya ɗimbin albarkatun ɗanyen bayanai zuwa rahotannin da za'a iya karantawa cikin daƙiƙa guda.
A cikin wannan koyawa za mu dubi yadda ake juya tebur a cikin R, kuma mu canza su daga fadi zuwa dogon tsari da kuma akasin haka.
Yawancin darasi an sadaukar da shi ga kunshin tidyr da ayyuka pivot_longer() и pivot_wider().
Darasi na 10: Load da fayilolin JSON a cikin R da Mayar da Lissafi zuwa Tables
Kwanan watan bugawa: 25 May 2020
Tunani:
description:
JSON da XML shahararru ne na tsari don adanawa da musayar bayanai, yawanci saboda ƙaƙƙarfan su.
Amma yana da wuya a yi la'akari da bayanan da aka gabatar a cikin irin waɗannan nau'ikan, don haka kafin bincike ya zama dole a kawo su cikin tsari na tabular, wanda shine ainihin abin da za mu koya a wannan bidiyon.
An sadaukar da darasi ga kunshin tidyr, wanda aka haɗa a cikin ainihin ɗakin karatu tidyverse, da ayyuka unnest_longer(), unnest_wider() и hoist().
Darasi na 11: Yin Makirci cikin Sauri Amfani da aikin qplot().
Kwanan watan bugawa: 1 2020 Yuni
Tunani:
description:
Kunshin ggplot2 yana ɗaya daga cikin shahararrun kayan aikin gani na bayanai ba kawai a cikin R.
A cikin wannan darasi za mu koyi yadda ake gina hotuna masu sauƙi ta amfani da aikin qplot(), kuma bari mu yi nazarin duk hujjojinta.
Darasi na 12: Ƙirƙirar makirci ta hanyar shimfidar wuri ta amfani da kunshin ggplot2
Kwanan watan bugawa: 8 2020 Yuni
Tunani:
description:
Darasi yana nuna cikakken ikon kunshin ggplot2 da nahawu na zane-zanen gini a cikin yadudduka da aka saka a ciki.
Za mu yi nazarin manyan geometries waɗanda ke cikin kunshin kuma mu koyi yadda ake amfani da yadudduka don gina jadawali.
ƙarshe
Na yi ƙoƙari na kusanci ƙirƙirar shirin kwas ɗin a takaice kamar yadda zai yiwu, don haskaka kawai mafi mahimmancin bayanan da za ku buƙaci don ɗaukar matakan farko na koyan irin wannan kayan aikin bincike mai ƙarfi kamar harshen R.
Kwas ɗin ba cikakken jagora ba ne don nazarin bayanai ta amfani da harshen R, amma zai taimaka muku fahimtar duk dabarun da suka dace don wannan.
Yayin da ake tsara kwasa-kwasan na tsawon makonni 12, duk mako a ranar Litinin zan buɗe damar samun sabbin darussa, don haka ina ba da shawarar. a tashar YouTube domin kada a rasa fitowar wani sabon darasi.
source: www.habr.com