{"id":80536,"date":"2020-05-07T01:42:20","date_gmt":"2020-05-06T23:42:20","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs"},"modified":"2020-05-07T01:42:20","modified_gmt":"2020-05-06T23:42:20","slug":"yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs","title":{"rendered":"R keel Exceli kasutajatele (tasuta videokursus)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Karantii ajal veedavad paljud n\u00fc\u00fcd enamasti kodus aega, ja seda aega v\u00f5ib ja isegi tuleks kasutada kasulikult.<\/p>\n<p><\/p>\n<p>Karantini alguses otsustasin viimistleda m\u00f5ned projektid, millega olin paar kuud varem algust teinud. \u00dcks neist projektidest oli videokursus \"R keel Exceli kasutajatele\". Selle kursusega tahtsin madaldada R-i \u00f5ppimise k\u00fcnnist ja veidi t\u00e4ita olemasolevat defitsiiti haridusmaterjalidest sellel teemal eesti keeles. <\/p>\n<p><\/p>\n<p>Kui kogu andmet\u00f6\u00f6tlus ettev\u00f5ttes, kus te t\u00f6\u00f6tate, toimub endiselt Excelis, siis soovitan tutvuda moodsama ja samal ajal t\u00e4iesti tasuta andmeanal\u00fc\u00fcsi t\u00f6\u00f6riistaga.<\/p>\n<p>\n<img decoding=\"async\" alt=\"R keel Exceli kasutajatele (tasuta videokursus)\" src=\"\/wp-content\/uploads\/2020\/05\/5f3e2481af318c51953c5e4fe7e06ad8.png\" style=\"display:block;margin: 0 auto;\" \/><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h1 id=\"soderzhanie\">Sisu<\/h1>\n<p><\/p>\n<p><em>Kui teid huvitab andmeanal\u00fc\u00fcs, siis v\u00f5ivad teile huvi pakkuda minu <noindex><a rel=\"nofollow\" href=\"https:\/\/t.me\/R4marketing\">telegram<\/a><\/noindex> ja <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">youtube<\/a><\/noindex> kanalid, mille suurem osa sisust on p\u00fchendatud R keelele.<\/em><\/p>\n<p><\/p>\n<ol>\n<li><noindex><a rel=\"nofollow\" href=\"#ssylki\">Lingid<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#o-kurse\">Kursuse kohta<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#dlya-kogo-etot-kurs\">Kellele see kursus on<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#programma-kursa\">Kursuse programm<\/a><\/noindex><br \/>\n4.1. <noindex><a rel=\"nofollow\" href=\"#urok-1-ustanovka-yazyka-r-i-sredy-razrabotki-rstudio\">Tund 1: R keele ja arenduskeskkonna RStudio paigaldamine<\/a><\/noindex><br \/>\n4.2. <noindex><a rel=\"nofollow\" href=\"#urok-2-osnovnye-struktury-dannyh-v-r\">Tund 2: R keeles andmestruktuurid<\/a><\/noindex><br \/>\n4.3. <noindex><a rel=\"nofollow\" href=\"#urok-3-chtenie-dannyh-iz-tsv-csv-excel-faylov-i-google-tablic\">Tund 3: Andmete lugemine TSV, CSV, Exceli failidest ja Google'i tabelitest<\/a><\/noindex><br \/>\n4.4. <noindex><a rel=\"nofollow\" href=\"#urok-4-filtraciya-strok-vybor-i-pereimenovanie-stolbcov-payplany-v-r\">Tund 4: R keeles ridade filtreerimine, veergude valimine ja \u00fcmbernimetamine, torud<\/a><\/noindex><br \/>\n4.5. <noindex><a rel=\"nofollow\" href=\"#urok-5-dobavlenie-vychislyaemyh-stolbcov-v-tablicu-na-yazyke-r\">Tund 5: Veergude lisamine R keeles arvutatutega<\/a><\/noindex><br \/>\n4.6. <noindex><a rel=\"nofollow\" href=\"#urok-6-gruppirovka-i-agregaciya-dannyh-na-yazyke-r\">Tund 6: Andmete r\u00fchmitamine ja agregatsioon R keeles<\/a><\/noindex><br \/>\n4.7. <noindex><a rel=\"nofollow\" href=\"#urok-7-vertikalnoe-i-gorizontalnoe-obedinenie-tablic-na-yazyke-r\">Tund 7: Tabelite vertikaalne ja horisontaalne \u00fchendamine R keeles<\/a><\/noindex><br \/>\n4.8. <noindex><a rel=\"nofollow\" href=\"#urok-8-okonnye-funkcii-v-r\">Tund 8: Akna funktsioonid R keeles<\/a><\/noindex><br \/>\n4.9. <noindex><a rel=\"nofollow\" href=\"#urok-9-vraschenie-tablic-ili-analog-svodnyh-tablic-v-r\">Tund 9: Tabelite p\u00f6\u00f6ramine v\u00f5i analoogsete p\u00f6\u00f6ratud tabelite kasutamine R-is<\/a><\/noindex><br \/>\n4.10. <noindex><a rel=\"nofollow\" href=\"#urok-10-zagruzka-json-faylov-v-r-i-preobrazovanie-spiskov-v-tablicy\">Tund 10: JSON-failide laadimine R-i ja loendite muutmine tabeliteks<\/a><\/noindex><br \/>\n4.11. <noindex><a rel=\"nofollow\" href=\"#urok-11-bystroe-postroenie-grafikov-s-pomoschyu-funkcii-qplot\">Tund 11: Kiire graafikute loomine funktsiooni qplot() abil<\/a><\/noindex><br \/>\n4.12. <noindex><a rel=\"nofollow\" href=\"#urok-12-postroenie-grafikov-sloy-za-sloem-s-pomoschyu-paketa-ggplot2\">Tund 12: Graafikute koostamine kihiti ggplot2 paketi abil<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#zaklyuchenie\">Kokkuv\u00f5te<\/a><\/noindex><\/li>\n<\/ol>\n<p><\/p>\n<h1 id=\"ssylki\">Lingid<\/h1>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">Telli YouTube'i kanal<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/playlist?list=PLD2LDq8edf4pgGg16wYMobvIYy_0MI0kF\">Kursuse m\u00e4ngurnik YouTube'is<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/\">Materjalide hoidla<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/selesnow.github.io\/r4excel_users\">Kursuse leht<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<h1 id=\"o-kurse\">Kursuse kohta<\/h1>\n<p><\/p>\n<p>Kursus on \u00fcles ehitatud arhitektuuri <code>tidyverse<\/code>, ning sisaldab j\u00e4rgmisi pakette: <code>readr<\/code>, <code>vroom<\/code>, <code>dplyr<\/code>, <code>tidyr<\/code>, <code>ggplot2<\/code>. Loomulikult on R-is ka teisi h\u00e4id pakette, mis selliseid toiminguid teevad, n\u00e4iteks <code>data.table<\/code>, aga s\u00fcntaks <code>tidyverse<\/code> on intuitiivselt arusaadav, seda on lihtne lugeda isegi ettevalmistamata kasutajale, seet\u00f5ttu arvan, et R-i keele \u00f5ppimist on parem alustada just <code>tidyverse<\/code>. <\/p>\n<p><\/p>\n<p>Kursus viib teid l\u00e4bi k\u00f5ik andmeanal\u00fc\u00fcsi toimingud, alates laadimisest kuni l\u00f5pptulemuse visualiseerimiseni.<\/p>\n<p><\/p>\n<p>Miks just R-keel, mitte Python? Sest R on funktsionaalne keel, Exceli kasutajatel on sellel kergem liikuda, kuna ei ole vaja s\u00fcveneda traditsioonilisse objekti-orienteeritud programmeerimisse.<\/p>\n<p><\/p>\n<p>Praegu on planeeritud 12 videotundi, iga\u00fche kestus on 5 kuni 20 minutit.<\/p>\n<p><\/p>\n<p>Tunnid avatakse j\u00e4rk-j\u00e4rgult. Iga esmasp\u00e4ev avatakse minu juures ligip\u00e4\u00e4s uuele tunnile <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">YouTube'i kanali<\/a><\/noindex> eraldi playlistis.<\/p>\n<p><\/p>\n<h1 id=\"dlya-kogo-etot-kurs\">Kellele see kursus on<\/h1>\n<p><\/p>\n<p>Arvan, et see on nimekirjast arusaadav, kuid vaatamata sellele kirjeldan seda detallisemalt. <\/p>\n<p><\/p>\n<p>Kursus on suunatud neile, kes kasutavad Microsoft Excelit oma t\u00f6\u00f6s ja teevad seal ka kogu andmet\u00f6\u00f6tluse. \u00dcldiselt, kui avate Microsoft Exceli v\u00e4hemalt korra n\u00e4dalas, sobib kursus teile.<\/p>\n<p><\/p>\n<p>Programmeerimisoskusi ei n\u00f5uta, kuna kursus on suunatud algajatele.<\/p>\n<p><\/p>\n<p>Kuid alates 4. tunnist v\u00f5ib leiduda materjale, mis huvitavad ka aktiivseid R kasutajaid, kuna selliste pakettide p\u00f5hifunktsioone nagu <code>dplyr<\/code> ja <code>tidyr<\/code> ka k\u00e4sitletakse piisavalt detailselt.<\/p>\n<p><\/p>\n<h1 id=\"programma-kursa\">Kursuse programm<\/h1>\n<h3 id=\"urok-1-ustanovka-yazyka-r-i-sredy-razrabotki-rstudio\">Tund 1: R keele ja arenduskeskkonna RStudio paigaldamine<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 23. m\u00e4rts 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=wFUoaeGEMmY&amp;list=PLD2LDq8edf4pgGg16wYMobvIYy_0MI0kF&amp;index=2&amp;t=0s\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/cran.r-project.org\/\">Laadi alla R keel<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/rstudio.com\/products\/rstudio\/download\/\">Laadi alla RStudio<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"wFUoaeGEMmY\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/wFUoaeGEMmY\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nSissejuhatav tund, mille k\u00e4igus laeme alla ja installime vajaliku tarkvara ning vaatame veidi RStudio arenduskeskkonna v\u00f5imalusi ja liidest.<\/p>\n<h3 id=\"urok-2-osnovnye-struktury-dannyh-v-r\">Tund 2: R keeles andmestruktuurid<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 30. m\u00e4rts 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/GwqoGHa8wjQ\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_2\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"GwqoGHa8wjQ\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/GwqoGHa8wjQ\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nSee tund aitab teil m\u00f5ista, millised andmestruktuurid on R keeles. Me k\u00e4sitleme p\u00f5hjalikult vektoreid, andmeraame ja nimekirju. \u00d5pime neid looma ja nende \u00fcksikutele elementidele juurde p\u00e4\u00e4sema.<\/p>\n<h3 id=\"urok-3-chtenie-dannyh-iz-tsv-csv-excel-faylov-i-google-tablic\">Tund 3: Andmete lugemine TSV, CSV, Exceli failidest ja Google'i tabelitest<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 6. aprill 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/vVFFtgcBp-w\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_3\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"vVFFtgcBp-w\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/vVFFtgcBp-w\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nAndmetega t\u00f6\u00f6tamine, s\u00f5ltumata t\u00f6\u00f6riistast, algab nende hankimisest. Tunni jooksul kasutatakse pakette <code>vroom<\/code>, <code>readxl<\/code>, <code>googlesheets4<\/code> andmete laadimiseks R keskkonda csv, tsv, Exceli failidest ja Google'i tabelitest.<\/p>\n<h3 id=\"urok-4-filtraciya-strok-vybor-i-pereimenovanie-stolbcov-payplany-v-r\">Tund 4: R keeles ridade filtreerimine, veergude valimine ja \u00fcmbernimetamine, torud<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 13. aprill 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/uI0fc3foQQE\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_4\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"uI0fc3foQQE\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/uI0fc3foQQE\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nSee tund on p\u00fchendatud paketile <code>dplyr<\/code>. K\u00e4sitleme, kuidas filtreerida andmeraame, valida vajalikud veerud ja neid \u00fcmber nimetada.<\/p>\n<p><\/p>\n<p>Samuti saame teada, mis on torujooned ja kuidas need aitavad muuta teie R keeles kirjutatud koodi arusaadavamaks.<\/p>\n<h3 id=\"urok-5-dobavlenie-vychislyaemyh-stolbcov-v-tablicu-na-yazyke-r\">Tund 5: Veergude lisamine R keeles arvutatutega<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 20. aprill 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/lYYOKPcJ6Gc\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_5\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"lYYOKPcJ6Gc\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/lYYOKPcJ6Gc\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nSelles videos j\u00e4tkame tutvumist raamatukoguga <code>tidyverse<\/code> ja paketiga <code>dplyr<\/code>.<br \/>\nK\u00e4sitleme funktsioonide perekonda <code>mutate()<\/code>, ja \u00f5pime nende abil lisama tabelisse uusi arvutatud veerge.<\/p>\n<h3 id=\"urok-6-gruppirovka-i-agregaciya-dannyh-na-yazyke-r\">Tund 6: Andmete r\u00fchmitamine ja agregatsioon R keeles<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 27. aprill 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/7zyL5apWm1M\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_6\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"7zyL5apWm1M\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/7zyL5apWm1M\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nSee tund on p\u00fchendatud \u00fchele p\u00f5hitoimingule andmete anal\u00fc\u00fcsimisel, r\u00fchmitamisele ja aggregeerimisele. Tunni jooksul kasutame paketti <code>dplyr<\/code> ja funktsioone <code>group_by()<\/code> ja <code>summarise()<\/code>.<\/p>\n<p><\/p>\n<p>K\u00e4sitleme k\u00f5iki funktsioonide perekondi <code>summarise()<\/code>, st. <code>summarise()<\/code>, <code>summarise_if()<\/code> ja <code>summarise_at()<\/code>. <\/p>\n<h3 id=\"urok-7-vertikalnoe-i-gorizontalnoe-obedinenie-tablic-na-yazyke-r\">Tund 7: Tabelite vertikaalne ja horisontaalne \u00fchendamine R keeles<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 4. mai 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/oCU30z-_qUQ\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_7\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Video:<\/strong><\/p>\n<p>\n<center><div class=\"youtube-placeholder\" data-id=\"oCU30z-_qUQ\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/oCU30z-_qUQ\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nSee tund aitab teil m\u00f5ista tabelite vertikaalse ja horisontaalse \u00fchendamise operatsioone. <\/p>\n<p><\/p>\n<p>Vertikaalne \u00fchendamine on sarnane UNION operatsioonile SQL p\u00e4ringute keeles. <\/p>\n<p><\/p>\n<p>Horisontaalset \u00fchendamist tunnevad Exceli kasutajad paremini VLOOKUP funktsiooni kaudu; SQLis teostatakse selliseid operatsioone JOIN operaatori abil.<\/p>\n<p><\/p>\n<p>Tunni jooksul lahendame praktilise \u00fclesande, milles kasutame pakette <code>dplyr<\/code>, <code>readxl<\/code>, <code>tidyr<\/code> ja <code>stringr<\/code>.<\/p>\n<p><\/p>\n<p>Peamised funktsioonid, mida me k\u00e4sitleme:<\/p>\n<p><\/p>\n<ul>\n<li><code>bind_rows()<\/code> \u2014 tabelite vertikaalne \u00fchendamine<\/li>\n<li><code>left_join()<\/code> \u2014 tabelite horisontaalne \u00fchendamine<\/li>\n<li><code>semi_join()<\/code> \u2014 kaasav tabelite \u00fchendamine<\/li>\n<li><code>anti_join()<\/code> \u2014 v\u00e4listav tabelite \u00fchendamine<\/li>\n<\/ul>\n<h3 id=\"urok-8-okonnye-funkcii-v-r\">Tund 8: Akna funktsioonid R keeles<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 11. mai 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_8\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nAkenfunktsioonid on m\u00f5tteliselt sarnased agregeerivatele funktsioonidele, nad v\u00f5tavad samuti sisendina v\u00e4\u00e4rtuste massi ja viivad l\u00e4bi aritmeetilisi tehteid, kuid ei muuda algset ridade arvu v\u00e4ljatulemus.<\/p>\n<p><\/p>\n<p>Selles tunnis j\u00e4tkame paketi <code>dplyr<\/code>, ja funktsioonide <code>group_by()<\/code>, <code>mutate()<\/code>, samuti uusi <code>cumsum()<\/code>, <code>lag()<\/code>, <code>lead()<\/code> ja <code>arrange()<\/code>.<\/p>\n<h3 id=\"urok-9-vraschenie-tablic-ili-analog-svodnyh-tablic-v-r\">Tund 9: Tabelite p\u00f6\u00f6ramine v\u00f5i analoogsete p\u00f6\u00f6ratud tabelite kasutamine R-is<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 18. mai 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_9\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nEnamik Exceli kasutajatest kasutab p\u00f6\u00f6ratavaid tabeleid, mis on mugav t\u00f6\u00f6riist, mis v\u00f5imaldab teil m\u00f5ne sekundi jooksul muuta toormaterjali lugemiseks sobivateks aruanneteks.<\/p>\n<p><\/p>\n<p>Selles \u0443\u0440\u043e\u043ae uurime, kuidas tabeleid R-is p\u00f6\u00f6rata ja muuta neid laiale formaadist pikaks ja tagasi.<\/p>\n<p><\/p>\n<p>Suurem osa \u0443\u0440\u043e\u043aist keskendub paketile <code>tidyr<\/code> ja funktsioonidele <code>pivot_longer()<\/code> ja <code>pivot_wider()<\/code>.<\/p>\n<h3 id=\"urok-10-zagruzka-json-faylov-v-r-i-preobrazovanie-spiskov-v-tablicy\">Tund 10: JSON-failide laadimine R-i ja loendite muutmine tabeliteks<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 25. mai 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_10\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nJSON ja XML on \u00e4\u00e4rmiselt populaarsed andmehoidmise ja vahetamise formaadid, t\u00e4nu oma kompaktsetele omadustele.<\/p>\n<p><\/p>\n<p>Kuid andmete anal\u00fc\u00fcsimine nendes formaatides on keeruline, seet\u00f5ttu tuleks need enne anal\u00fc\u00fcsi teisendada tabeli kujule, just seda me selles videos \u00f5pime.<\/p>\n<p><\/p>\n<p>\u041a\u0443\u0440\u0441 keskendub paketile <code>tidyr<\/code>, mis kuulub p\u00f5hiraamatukogusse <code>tidyverse<\/code>, ja funktsioonidele <code>unnest_longer()<\/code>, <code>unnest_wider()<\/code> ja <code>hoist()<\/code>.<\/p>\n<h3 id=\"urok-11-bystroe-postroenie-grafikov-s-pomoschyu-funkcii-qplot\">Tund 11: Kiire graafikute loomine funktsiooni qplot() abil<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 1. juuni 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_11\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\nPakett <code>ggplot2<\/code> on \u00fcks populaarsemaid andmevisualiseerimise t\u00f6\u00f6riistu mitte ainult R-is. <\/p>\n<p><\/p>\n<p>Selles \u0443\u0440\u043e\u043ae \u00f5pime, kuidas koostada lihtsamaid diagramme funktsiooni abil <code>qplot()<\/code>, ja vaatame k\u00f5iki selle argumente.<\/p>\n<h3 id=\"urok-12-postroenie-grafikov-sloy-za-sloem-s-pomoschyu-paketa-ggplot2\">Tund 12: Graafikute koostamine kihiti ggplot2 paketi abil<\/h3>\n<p><\/p>\n<p><strong>Avaldamise kuup\u00e4ev:<\/strong> 8. juuni 2020<\/p>\n<p><\/p>\n<p><strong>Lingid:<\/strong><\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#\">Video<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/tree\/master\/lesson_12\">Materjalid<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>Kirjeldus:<\/strong><br \/>\n\u0423\u0440\u043e\u043aes on n\u00e4idatud kogu v\u00f5imekus paketi <code>ggplot2<\/code> ja selle sisse ehitatud graafikute kihiti koostamise grammi.<\/p>\n<p><\/p>\n<p>K\u00e4ime l\u00e4bi peamised geomeetriad, mis paketis on, ja \u00f5pime kihte rakendama graafiku koostamiseks.<\/p>\n<h1 id=\"zaklyuchenie\">Kokkuv\u00f5te<\/h1>\n<p><\/p>\n<p>Olen p\u00fc\u00fcdnud kursuse programmi koostada v\u00f5imalikult l\u00fchidalt, eristades ainult k\u00f5ige vajalikumat teavet, mis aitab teil astuda esimesed sammud andmeanal\u00fc\u00fcsi v\u00f5imsa t\u00f6\u00f6riista, R keele, \u00f5ppimisel.<\/p>\n<p><\/p>\n<p>Kursus ei ole ammendav juhend R keele abil andmeanal\u00fc\u00fcsiks, kuid aitab teil m\u00f5ista k\u00f5iki vajalikke tehnikaid.<\/p>\n<p><\/p>\n<p>Praegune kursuse programm on ette n\u00e4htud 12 n\u00e4dalaks, igal n\u00e4dalal, esmasp\u00e4eviti avan uusi \u00f5ppetunde, seet\u00f5ttu soovitan <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">liituda<\/a><\/noindex> YouTube'i kanaliga, et mitte j\u00e4\u00e4da ilma uue \u00f5ppetunni avaldamisest.<\/p>\n<p>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/495438\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u043e\u043c \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0435\u0439\u0447\u0430\u0441 \u043b\u044c\u0432\u0438\u043d\u0443\u044e \u0434\u043e\u043b\u044e \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043f\u0440\u043e\u0432\u043e\u0434\u044f\u0442 \u0434\u043e\u043c\u0430, \u0438 \u044d\u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043c\u043e\u0436\u043d\u043e, \u0438 \u0434\u0430\u0436\u0435 \u043d\u0443\u0436\u043d\u043e \u043f\u0440\u043e\u0432\u0435\u0441\u0442\u0438 \u0441 \u043f\u043e\u043b\u044c\u0437\u043e\u0439. \u0412 \u043d\u0430\u0447\u0430\u043b\u0435 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u0430 \u044f \u0440\u0435\u0448\u0438\u043b \u0434\u043e\u0432\u0435\u0441\u0442\u0438 \u0434\u043e \u0443\u043c\u0430 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u044b \u043d\u0430\u0447\u0430\u0442\u044b\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043c\u0435\u0441\u044f\u0446\u0435\u0432 \u043d\u0430\u0437\u0430\u0434. \u041e\u0434\u043d\u0438\u043c \u0438\u0437 \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u0431\u044b\u043b \u0432\u0438\u0434\u0435\u043e \u043a\u0443\u0440\u0441 &quot;\u042f\u0437\u044b\u043a R \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 Excel&quot;. \u042d\u0442\u0438\u043c \u043a\u0443\u0440\u0441\u043e\u043c \u044f \u0445\u043e\u0442\u0435\u043b \u0441\u043d\u0438\u0437\u0438\u0442\u044c \u043f\u043e\u0440\u043e\u0433 \u0432\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0432 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":80537,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-80536","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u043e\u043c \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0435\u0439\u0447\u0430\u0441 \u043b\u044c\u0432\u0438\u043d\u0443\u044e \u0434\u043e\u043b\u044e \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043f\u0440\u043e\u0432\u043e\u0434\u044f\u0442 \u0434\u043e\u043c\u0430, \u0438 \u044d\u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043c\u043e\u0436\u043d\u043e, \u0438 \u0434\u0430\u0436\u0435 \u043d\u0443\u0436\u043d\u043e \u043f\u0440\u043e\u0432\u0435\u0441\u0442\u0438 \u0441 \u043f\u043e\u043b\u044c\u0437\u043e\u0439. \u0412 \u043d\u0430\u0447\u0430\u043b\u0435 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u0430 \u044f \u0440\u0435\u0448\u0438\u043b \u0434\u043e\u0432\u0435\u0441\u0442\u0438 \u0434\u043e \u0443\u043c\u0430 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u044b \u043d\u0430\u0447\u0430\u0442\u044b\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043c\u0435\u0441\u044f\u0446\u0435\u0432 \u043d\u0430\u0437\u0430\u0434. \u041e\u0434\u043d\u0438\u043c \u0438\u0437 \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u0431\u044b\u043b \u0432\u0438\u0434\u0435\u043e \u043a\u0443\u0440\u0441 &quot;\u042f\u0437\u044b\u043a R \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 Excel&quot;. \u042d\u0442\u0438\u043c \u043a\u0443\u0440\u0441\u043e\u043c \u044f \u0445\u043e\u0442\u0435\u043b \u0441\u043d\u0438\u0437\u0438\u0442\u044c \u043f\u043e\u0440\u043e\u0433 \u0432\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0432\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u042f\u0437\u044b\u043a R \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 Excel (\u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0439 \u0432\u0438\u0434\u0435\u043e \u043a\u0443\u0440\u0441) | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u043e\u043c \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0435\u0439\u0447\u0430\u0441 \u043b\u044c\u0432\u0438\u043d\u0443\u044e \u0434\u043e\u043b\u044e \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043f\u0440\u043e\u0432\u043e\u0434\u044f\u0442 \u0434\u043e\u043c\u0430, \u0438 \u044d\u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043c\u043e\u0436\u043d\u043e, \u0438 \u0434\u0430\u0436\u0435 \u043d\u0443\u0436\u043d\u043e \u043f\u0440\u043e\u0432\u0435\u0441\u0442\u0438 \u0441 \u043f\u043e\u043b\u044c\u0437\u043e\u0439. \u0412 \u043d\u0430\u0447\u0430\u043b\u0435 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u0430 \u044f \u0440\u0435\u0448\u0438\u043b \u0434\u043e\u0432\u0435\u0441\u0442\u0438 \u0434\u043e \u0443\u043c\u0430 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u044b \u043d\u0430\u0447\u0430\u0442\u044b\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043c\u0435\u0441\u044f\u0446\u0435\u0432 \u043d\u0430\u0437\u0430\u0434. \u041e\u0434\u043d\u0438\u043c \u0438\u0437 \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u0431\u044b\u043b \u0432\u0438\u0434\u0435\u043e \u043a\u0443\u0440\u0441 &quot;\u042f\u0437\u044b\u043a R \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 Excel&quot;. \u042d\u0442\u0438\u043c \u043a\u0443\u0440\u0441\u043e\u043c \u044f \u0445\u043e\u0442\u0435\u043b \u0441\u043d\u0438\u0437\u0438\u0442\u044c \u043f\u043e\u0440\u043e\u0433 \u0432\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0432\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-05-06T23:42:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-05-06T23:42:20+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47R keel Exceli kasutajatele (tasuta videokursus) | ProHoster","description":"Kuna karantiin, veedavad paljud n\u00fc\u00fcd enamiku ajast kodus, ja selle aja v\u00f5ib ja isegi tuleks veeta kasulikult. Karantiini alguses otsustasin viimistleda m\u00f5ned projekti, mille olin alustanud m\u00f5ned kuud tagasi. \u00dcks selline projekt oli videokursus \"R keel Exceli kasutajatele\". Selle kursusega tahtsin ma madaldada sisenemise k\u00fcnnist","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u042f\u0437\u044b\u043a R \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 Excel (\u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0439 \u0432\u0438\u0434\u0435\u043e \u043a\u0443\u0440\u0441) | ProHoster","og:description":"\u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u043e\u043c \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0435\u0439\u0447\u0430\u0441 \u043b\u044c\u0432\u0438\u043d\u0443\u044e \u0434\u043e\u043b\u044e \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043f\u0440\u043e\u0432\u043e\u0434\u044f\u0442 \u0434\u043e\u043c\u0430, \u0438 \u044d\u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043c\u043e\u0436\u043d\u043e, \u0438 \u0434\u0430\u0436\u0435 \u043d\u0443\u0436\u043d\u043e \u043f\u0440\u043e\u0432\u0435\u0441\u0442\u0438 \u0441 \u043f\u043e\u043b\u044c\u0437\u043e\u0439. \u0412 \u043d\u0430\u0447\u0430\u043b\u0435 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d\u0430 \u044f \u0440\u0435\u0448\u0438\u043b \u0434\u043e\u0432\u0435\u0441\u0442\u0438 \u0434\u043e \u0443\u043c\u0430 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u044b \u043d\u0430\u0447\u0430\u0442\u044b\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043c\u0435\u0441\u044f\u0446\u0435\u0432 \u043d\u0430\u0437\u0430\u0434. \u041e\u0434\u043d\u0438\u043c \u0438\u0437 \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u0431\u044b\u043b \u0432\u0438\u0434\u0435\u043e \u043a\u0443\u0440\u0441 &quot;\u042f\u0437\u044b\u043a R \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 Excel&quot;. \u042d\u0442\u0438\u043c \u043a\u0443\u0440\u0441\u043e\u043c \u044f \u0445\u043e\u0442\u0435\u043b \u0441\u043d\u0438\u0437\u0438\u0442\u044c \u043f\u043e\u0440\u043e\u0433 \u0432\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0432","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-05-06T23:42:20+00:00","article:modified_time":"2020-05-06T23:42:20+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"80536","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 16:16:27","updated":"2022-10-01 03:35:57"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/80536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=80536"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/80536\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/80537"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=80536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=80536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=80536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}