{"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\/sq\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs","title":{"rendered":"Gjuha R p\u00ebr p\u00ebrdoruesit e Excel (kurs video falas)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u00ebr shkak t\u00eb karantin\u00ebs, shum\u00eb njer\u00ebz tani kalojn\u00eb shumic\u00ebn e koh\u00ebs n\u00eb sht\u00ebpi, dhe kjo koh\u00eb mund dhe duhet shfryt\u00ebzuar me dobi.<\/p>\n<p><\/p>\n<p>N\u00eb fillim t\u00eb karantin\u00ebs, vendosa t\u00eb zakonshmizoja disa projekte q\u00eb kisha nisur disa muaj m\u00eb par\u00eb. Nj\u00eb nga k\u00ebto projekte ishte kursi video \"Gjuha R p\u00ebr p\u00ebrdoruesit e Excel\". Me k\u00ebt\u00eb kurs doja t\u00eb ulja pragun e hyrjes n\u00eb R dhe pak t\u00eb mbulohesha munges\u00ebs s\u00eb materialeve edukative p\u00ebr k\u00ebt\u00eb tem\u00eb n\u00eb gjuh\u00ebn shqipe. <\/p>\n<p><\/p>\n<p>N\u00ebse e gjith\u00eb puna me t\u00eb dh\u00ebnat n\u00eb kompanin\u00eb ku punoni, ende b\u00ebhet n\u00eb Excel, ju sugjeroj t\u00eb njiheni me nj\u00eb mjet m\u00eb modern dhe n\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb plot\u00ebsisht falas p\u00ebr analiz\u00ebn e t\u00eb dh\u00ebnave.<\/p>\n<p>\n<img decoding=\"async\" alt=\"Gjuha R p\u00ebr p\u00ebrdoruesit e Excel (kurs video falas)\" 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\">P\u00ebrmbajtja<\/h1>\n<p><\/p>\n<p><em>N\u00ebse jeni t\u00eb interesuar p\u00ebr analiz\u00ebn e t\u00eb dh\u00ebnave, ndoshta do t'ju interesojn\u00eb kanalet e mia <noindex><a rel=\"nofollow\" href=\"https:\/\/t.me\/R4marketing\">telegram<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">youtube<\/a><\/noindex> n\u00eb t\u00eb cilat shumica e p\u00ebrmbajtjes \u00ebsht\u00eb e kushtuar gjuh\u00ebs R.<\/em><\/p>\n<p><\/p>\n<ol>\n<li><noindex><a rel=\"nofollow\" href=\"#ssylki\">Linke<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#o-kurse\">P\u00ebr kursin<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#dlya-kogo-etot-kurs\">P\u00ebr k\u00eb \u00ebsht\u00eb ky kurs<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#programma-kursa\">Programi i kursit<\/a><\/noindex><br \/>\n4.1. <noindex><a rel=\"nofollow\" href=\"#urok-1-ustanovka-yazyka-r-i-sredy-razrabotki-rstudio\">M\u00ebsimi 1: Instalimi i gjuh\u00ebs R dhe mjedisi i zhvillimit RStudio<\/a><\/noindex><br \/>\n4.2. <noindex><a rel=\"nofollow\" href=\"#urok-2-osnovnye-struktury-dannyh-v-r\">M\u00ebsimi 2: Strukturat kryesore t\u00eb t\u00eb dh\u00ebnave n\u00eb R<\/a><\/noindex><br \/>\n4.3. <noindex><a rel=\"nofollow\" href=\"#urok-3-chtenie-dannyh-iz-tsv-csv-excel-faylov-i-google-tablic\">M\u00ebsimi 3: Leximi i t\u00eb dh\u00ebnave nga skedaret TSV, CSV, Excel dhe Google Sheets<\/a><\/noindex><br \/>\n4.4. <noindex><a rel=\"nofollow\" href=\"#urok-4-filtraciya-strok-vybor-i-pereimenovanie-stolbcov-payplany-v-r\">M\u00ebsimi 4: Filtrimi i rreshtave, p\u00ebrzgjedhja dhe rinovimi i kolonave, pipelinat n\u00eb R<\/a><\/noindex><br \/>\n4.5. <noindex><a rel=\"nofollow\" href=\"#urok-5-dobavlenie-vychislyaemyh-stolbcov-v-tablicu-na-yazyke-r\">M\u00ebsimi 5: Shtimi i kolonave t\u00eb llogaritura n\u00eb tabel\u00eb n\u00eb gjuh\u00ebn R<\/a><\/noindex><br \/>\n4.6. <noindex><a rel=\"nofollow\" href=\"#urok-6-gruppirovka-i-agregaciya-dannyh-na-yazyke-r\">M\u00ebsimi 6: Grumbullimi dhe agregimi i t\u00eb dh\u00ebnave n\u00eb gjuh\u00ebn R<\/a><\/noindex><br \/>\n4.7. <noindex><a rel=\"nofollow\" href=\"#urok-7-vertikalnoe-i-gorizontalnoe-obedinenie-tablic-na-yazyke-r\">M\u00ebsimi 7: Bashkimi vertikal dhe horizontal i tabelave n\u00eb gjuh\u00ebn R<\/a><\/noindex><br \/>\n4.8. <noindex><a rel=\"nofollow\" href=\"#urok-8-okonnye-funkcii-v-r\">M\u00ebsimi 8: Funksionet dymensionale n\u00eb R<\/a><\/noindex><br \/>\n4.9. <noindex><a rel=\"nofollow\" href=\"#urok-9-vraschenie-tablic-ili-analog-svodnyh-tablic-v-r\">M\u00ebsimi 9: Rrotullimi i tabelave ose ekuivalenti i tabelave p\u00ebrmbledh\u00ebse n\u00eb R<\/a><\/noindex><br \/>\n4.10. <noindex><a rel=\"nofollow\" href=\"#urok-10-zagruzka-json-faylov-v-r-i-preobrazovanie-spiskov-v-tablicy\">M\u00ebsimi 10: Ngarkimi i skedareve JSON n\u00eb R dhe shnd\u00ebrrimi i listave n\u00eb tabela<\/a><\/noindex><br \/>\n4.11. <noindex><a rel=\"nofollow\" href=\"#urok-11-bystroe-postroenie-grafikov-s-pomoschyu-funkcii-qplot\">M\u00ebsimi 11: Nd\u00ebrto grafika shpejt me funksionin qplot()<\/a><\/noindex><br \/>\n4.12. <noindex><a rel=\"nofollow\" href=\"#urok-12-postroenie-grafikov-sloy-za-sloem-s-pomoschyu-paketa-ggplot2\">M\u00ebsimi 12: Nd\u00ebrto grafika hapat-hap pas hapi me paket\u00ebn ggplot2<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#zaklyuchenie\">P\u00ebrfundimi<\/a><\/noindex><\/li>\n<\/ol>\n<p><\/p>\n<h1 id=\"ssylki\">Linke<\/h1>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">Abonohu n\u00eb kanalin YouTube<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/playlist?list=PLD2LDq8edf4pgGg16wYMobvIYy_0MI0kF\">Lista e loj\u00ebrave t\u00eb kursit n\u00eb YouTube<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/selesnow\/r4excel_users\/\">Repo me materialet<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/selesnow.github.io\/r4excel_users\">Faqja e kursit<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<h1 id=\"o-kurse\">P\u00ebr kursin<\/h1>\n<p><\/p>\n<p>Kursi \u00ebsht\u00eb nd\u00ebrtuar rreth arkitektur\u00ebs <code>tidyverse<\/code>, dhe paketeve t\u00eb p\u00ebrfshira p\u00ebrbrenda saj: <code>readr<\/code>, <code>vroom<\/code>, <code>dplyr<\/code>, <code>tidyr<\/code>, <code>ggplot2<\/code>. Sigurisht, n\u00eb R ka edhe paketa t\u00eb tjera t\u00eb mira q\u00eb kryejn\u00eb operacione t\u00eb ngjashme, p\u00ebr shembull <code>data.table<\/code>, por sintaksa <code>tidyverse<\/code> \u00ebsht\u00eb intuitivisht e kuptueshme, leht\u00eb lexohen madje edhe nga p\u00ebrdoruesit e pazakont\u00eb, prandaj mendoj se \u00ebsht\u00eb m\u00eb mir\u00eb t\u00eb filloni m\u00ebsimin e gjuh\u00ebs R pik\u00ebrisht me <code>tidyverse<\/code>. <\/p>\n<p><\/p>\n<p>Kursi do t'ju udh\u00ebheq\u00eb p\u00ebrmes t\u00eb gjitha operacioneve t\u00eb analiz\u00ebs s\u00eb t\u00eb dh\u00ebnave, nga ngarkimi deri n\u00eb vizualizimin e rezultatit p\u00ebrfundimtar.<\/p>\n<p><\/p>\n<p>Pse gjuh\u00ebn R dhe jo Python? Sepse R \u00ebsht\u00eb nj\u00eb gjuh\u00eb funksionale, t\u00eb cil\u00ebn p\u00ebrdoruesit e Excel e kalojn\u00eb m\u00eb leht\u00eb, sepse nuk kan\u00eb nevoj\u00eb t\u00eb kuptojn\u00eb programimin tradicional t\u00eb orientuar nga objektet.<\/p>\n<p><\/p>\n<p>Aktualisht, jan\u00eb planifikuar 12 m\u00ebsime video me gjat\u00ebsi nga 5 deri n\u00eb 20 minuta secila.<\/p>\n<p><\/p>\n<p>M\u00ebsimet do t\u00eb hapen gradualisht. \u00c7do t\u00eb h\u00ebn\u00eb do t\u00eb hap \u00e7do her\u00eb nj\u00eb m\u00ebsim t\u00eb ri n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">kanalin ton\u00eb t\u00eb YouTube<\/a><\/noindex> n\u00eb nj\u00eb list\u00eb t\u00eb ve\u00e7ant\u00eb.<\/p>\n<p><\/p>\n<h1 id=\"dlya-kogo-etot-kurs\">P\u00ebr k\u00eb \u00ebsht\u00eb ky kurs<\/h1>\n<p><\/p>\n<p>Mendoj se kjo \u00ebsht\u00eb e qart\u00eb nga emri, megjithat\u00eb do ta p\u00ebrshkruaj m\u00eb holl\u00ebsisht. <\/p>\n<p><\/p>\n<p>Kursi \u00ebsht\u00eb i orientuar p\u00ebr ata q\u00eb aktivisht p\u00ebrdorin Microsoft Excel n\u00eb pun\u00ebn e tyre dhe gjithashtu atje realizojn\u00eb t\u00eb gjitha pun\u00ebt me t\u00eb dh\u00ebnat. N\u00eb p\u00ebrgjith\u00ebsi, n\u00ebse hapni aplikacionin Microsoft Excel t\u00eb pakt\u00ebn nj\u00eb her\u00eb n\u00eb jav\u00eb, at\u00ebher\u00eb ky kurs \u00ebsht\u00eb p\u00ebr ju.<\/p>\n<p><\/p>\n<p>Aft\u00ebsi programimi nuk k\u00ebrkohen p\u00ebr t\u00eb kaluar kursin, sepse kursi \u00ebsht\u00eb i orientuar p\u00ebr fillestar\u00ebt.<\/p>\n<p><\/p>\n<p>Megjithat\u00eb, ndoshta duke filluar nga m\u00ebsimi i 4, do t\u00eb ket\u00eb materiale interesante edhe p\u00ebr p\u00ebrdoruesit aktiv\u00eb t\u00eb R, pasi funksionaliteti kryesor i paketave si <code>dplyr<\/code> dhe <code>tidyr<\/code> do t\u00eb shqyrtohet mjaft n\u00eb detaje.<\/p>\n<p><\/p>\n<h1 id=\"programma-kursa\">Programi i kursit<\/h1>\n<h3 id=\"urok-1-ustanovka-yazyka-r-i-sredy-razrabotki-rstudio\">M\u00ebsimi 1: Instalimi i gjuh\u00ebs R dhe mjedisi i zhvillimit RStudio<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 23 mars 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\/\">Shkarko gjuh\u00ebn R<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/rstudio.com\/products\/rstudio\/download\/\">Shkarko 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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nM\u00ebsimi hyr\u00ebs gjat\u00eb t\u00eb cilit ne do t\u00eb shkarkojm\u00eb dhe instalojm\u00eb softuerin e nevojsh\u00ebm dhe do t\u00eb shqyrtojm\u00eb pak mund\u00ebsit\u00eb dhe nd\u00ebrfaqen e mjedisit t\u00eb zhvillimit RStudio.<\/p>\n<h3 id=\"urok-2-osnovnye-struktury-dannyh-v-r\">M\u00ebsimi 2: Strukturat kryesore t\u00eb t\u00eb dh\u00ebnave n\u00eb R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 30 mars 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nKy m\u00ebsim do t'ju ndihmoj\u00eb t\u00eb kuptoni se \u00e7far\u00eb strukturash t\u00eb dh\u00ebnash ekzistojn\u00eb n\u00eb gjuh\u00ebn R. Ne do t\u00eb shqyrtojm\u00eb n\u00eb detaje vektor\u00ebt, data frame-t\u00eb dhe listat. Do t\u00eb m\u00ebsojm\u00eb si t'i krijojm\u00eb dhe si t\u00eb qasemi n\u00eb elementet e tyre t\u00eb ve\u00e7anta.<\/p>\n<h3 id=\"urok-3-chtenie-dannyh-iz-tsv-csv-excel-faylov-i-google-tablic\">M\u00ebsimi 3: Leximi i t\u00eb dh\u00ebnave nga skedaret TSV, CSV, Excel dhe Google Sheets<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 6 prill 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nPuna me t\u00eb dh\u00ebnat, pavar\u00ebsisht nga mjeti, fillon me nxjerrjen e tyre. Gjat\u00eb m\u00ebsimit p\u00ebrdoren paketat <code>vroom<\/code>, <code>readxl<\/code>, <code>googlesheets4<\/code> p\u00ebr t\u00eb ngarkuar t\u00eb dh\u00ebnat n\u00eb ambientin R nga skedar\u00ebt csv, tsv, Excel dhe Google Sheets.<\/p>\n<h3 id=\"urok-4-filtraciya-strok-vybor-i-pereimenovanie-stolbcov-payplany-v-r\">M\u00ebsimi 4: Filtrimi i rreshtave, p\u00ebrzgjedhja dhe rinovimi i kolonave, pipelinat n\u00eb R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 13 prill 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nKy m\u00ebsim i kushtohet paket\u00ebs <code>dplyr<\/code>. N\u00eb t\u00eb do t\u00eb shqyrtojm\u00eb se si t\u00eb filtrojm\u00eb data frame-t\u00eb, t\u00eb zgjidhim kolonat e nevojshme dhe t'i rinovojm\u00eb ato.<\/p>\n<p><\/p>\n<p>Gjithashtu do t\u00eb m\u00ebsojm\u00eb se \u00e7far\u00eb jan\u00eb pipelinat dhe si ndihmojn\u00eb n\u00eb p\u00ebrmir\u00ebsimin e lexueshm\u00ebris\u00eb s\u00eb kodit tuaj n\u00eb gjuh\u00ebn R.<\/p>\n<h3 id=\"urok-5-dobavlenie-vychislyaemyh-stolbcov-v-tablicu-na-yazyke-r\">M\u00ebsimi 5: Shtimi i kolonave t\u00eb llogaritura n\u00eb tabel\u00eb n\u00eb gjuh\u00ebn R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 20 prill 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nN\u00eb k\u00ebt\u00eb video vazhdojm\u00eb njohjen me bibliotek\u00ebn <code>tidyverse<\/code> dhe paket\u00ebn <code>dplyr<\/code>.<br \/>\nDo t\u00eb shqyrtojm\u00eb familjen e funksioneve <code>mutate()<\/code>, dhe do t\u00eb m\u00ebsojm\u00eb si t\u00eb shtojm\u00eb kolona t\u00eb reja t\u00eb llogaritura n\u00eb tabel\u00eb me ndihm\u00ebn e tyre.<\/p>\n<h3 id=\"urok-6-gruppirovka-i-agregaciya-dannyh-na-yazyke-r\">M\u00ebsimi 6: Grumbullimi dhe agregimi i t\u00eb dh\u00ebnave n\u00eb gjuh\u00ebn R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 27 prill 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nKy m\u00ebsim i kushtohet nj\u00eb prej operacioneve kryesore t\u00eb analiz\u00ebs s\u00eb t\u00eb dh\u00ebnave, grumbullimit dhe agregimit. Gjat\u00eb m\u00ebsimit do t\u00eb p\u00ebrdorim paket\u00ebn <code>dplyr<\/code> dhe funksionet <code>group_by()<\/code> dhe <code>summarise()<\/code>.<\/p>\n<p><\/p>\n<p>Ne do t\u00eb shqyrtojm\u00eb t\u00eb gjith\u00eb familjen e funksioneve <code>summarise()<\/code>, pra, <code>summarise()<\/code>, <code>summarise_if()<\/code> dhe <code>summarise_at()<\/code>. <\/p>\n<h3 id=\"urok-7-vertikalnoe-i-gorizontalnoe-obedinenie-tablic-na-yazyke-r\">M\u00ebsimi 7: Bashkimi vertikal dhe horizontal i tabelave n\u00eb gjuh\u00ebn R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 4 maj 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/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=\"Luaj videon\" 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>P\u00ebrshkrimi:<\/strong><br \/>\nKy m\u00ebsim do t'ju ndihmoj\u00eb t\u00eb kuptoni operacionet e bashkimit vertikal dhe horizontal t\u00eb tabelave. <\/p>\n<p><\/p>\n<p>Bashkimi vertikal \u00ebsht\u00eb ekuivalenti i operacionit UNION n\u00eb gjuh\u00ebn e pyetjeve SQL. <\/p>\n<p><\/p>\n<p>Bashkimi horizontal, p\u00ebrdoruesve t\u00eb Excel u \u00ebsht\u00eb m\u00eb i njohur fal\u00eb funksionit VLOOKUP, n\u00eb SQL k\u00ebto operacione realizohen me \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440in JOIN.<\/p>\n<p><\/p>\n<p>Gjat\u00eb m\u00ebsimit do t\u00eb zgjidhim nj\u00eb detyr\u00eb praktike, gjat\u00eb s\u00eb cil\u00ebs do t\u00eb p\u00ebrdorim paketat <code>dplyr<\/code>, <code>readxl<\/code>, <code>tidyr<\/code> dhe <code>stringr<\/code>.<\/p>\n<p><\/p>\n<p>Funksionet kryesore q\u00eb do t\u00eb shqyrtojm\u00eb:<\/p>\n<p><\/p>\n<ul>\n<li><code>bind_rows()<\/code> \u2014 bashkimi vertical i tabelave<\/li>\n<li><code>left_join()<\/code> \u2014 bashkimi horizontal i tabelave<\/li>\n<li><code>semi_join()<\/code> \u2014 bashkimi p\u00ebrfshir\u00ebs i tabelave<\/li>\n<li><code>anti_join()<\/code> \u2014 bashkimi p\u00ebrjashtues i tabelave<\/li>\n<\/ul>\n<h3 id=\"urok-8-okonnye-funkcii-v-r\">M\u00ebsimi 8: Funksionet dymensionale n\u00eb R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 11 maj 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>P\u00ebrshkrimi:<\/strong><br \/>\nFunksionet dritare jan\u00eb ngjash\u00ebm me ato agreguese, ato gjithashtu marrin nj\u00eb array vlerash dhe kryejn\u00eb operacione aritmetike mbi to, por nuk ndryshojn\u00eb numrin e rreshtave n\u00eb rezultatin p\u00ebrfundimtar.<\/p>\n<p><\/p>\n<p>N\u00eb k\u00ebt\u00eb m\u00ebsim vazhdojm\u00eb studimin e paket\u00ebs <code>dplyr<\/code>, dhe funksioneve <code>group_by()<\/code>, <code>mutate()<\/code>, si dhe t\u00eb reja <code>cumsum()<\/code>, <code>lag()<\/code>, <code>lead()<\/code> dhe <code>arrange()<\/code>.<\/p>\n<h3 id=\"urok-9-vraschenie-tablic-ili-analog-svodnyh-tablic-v-r\">M\u00ebsimi 9: Rrotullimi i tabelave ose ekuivalenti i tabelave p\u00ebrmbledh\u00ebse n\u00eb R<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 18 maj 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>P\u00ebrshkrimi:<\/strong><br \/>\nShumica e p\u00ebrdoruesve t\u00eb Excel-it i p\u00ebrdorin tabelat e pivot-it, kjo \u00ebsht\u00eb nj\u00eb mjet i p\u00ebrshtatsh\u00ebm me t\u00eb cilin mund t\u00eb shnd\u00ebrroni nj\u00eb mori t\u00eb dh\u00ebnash t\u00eb pap\u00ebrpunuara n\u00eb raporte t\u00eb lexueshme n\u00eb sekonda.<\/p>\n<p><\/p>\n<p>N\u00eb k\u00ebt\u00eb m\u00ebsim do t\u00eb shqyrtojm\u00eb se si t\u00eb rrotullojm\u00eb tabelat n\u00eb R dhe t\u2019i kthejm\u00eb ato nga formati i gjer\u00eb n\u00eb at\u00eb t\u00eb gjat\u00eb dhe anasjelltas.<\/p>\n<p><\/p>\n<p>Shumica e m\u00ebsimit i kushtohet paket\u00ebs <code>tidyr<\/code> dhe funksioneve <code>pivot_longer()<\/code> dhe <code>pivot_wider()<\/code>.<\/p>\n<h3 id=\"urok-10-zagruzka-json-faylov-v-r-i-preobrazovanie-spiskov-v-tablicy\">M\u00ebsimi 10: Ngarkimi i skedareve JSON n\u00eb R dhe shnd\u00ebrrimi i listave n\u00eb tabela<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 25 maj 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>P\u00ebrshkrimi:<\/strong><br \/>\nJSON dhe XML jan\u00eb formate jasht\u00ebzakonisht t\u00eb njohura p\u00ebr ruajtjen dhe shk\u00ebmbimin e informacionit, zakonisht p\u00ebr shkak t\u00eb kompakt\u00ebsis\u00eb s\u00eb tyre.<\/p>\n<p><\/p>\n<p>Por analizimi i t\u00eb dh\u00ebnave t\u00eb paraqitura n\u00eb k\u00ebto formate \u00ebsht\u00eb i v\u00ebshtir\u00eb, prandaj ato duhet t\u00eb konvertohen n\u00eb nj\u00eb format tabelar para analiz\u00ebs, pik\u00ebrisht k\u00ebt\u00eb do t\u00eb m\u00ebsojm\u00eb n\u00eb k\u00ebt\u00eb video.<\/p>\n<p><\/p>\n<p>M\u00ebsimi i dedikohet paket\u00ebs <code>tidyr<\/code>, e cila \u00ebsht\u00eb pjes\u00eb e b\u00ebrtham\u00ebs s\u00eb bibliotek\u00ebs <code>tidyverse<\/code>, dhe funksioneve <code>unnest_longer()<\/code>, <code>unnest_wider()<\/code> dhe <code>hoist()<\/code>.<\/p>\n<h3 id=\"urok-11-bystroe-postroenie-grafikov-s-pomoschyu-funkcii-qplot\">M\u00ebsimi 11: Nd\u00ebrto grafika shpejt me funksionin qplot()<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 1 qershor 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>P\u00ebrshkrimi:<\/strong><br \/>\nPaketa <code>ggplot2<\/code> \u00ebsht\u00eb nj\u00eb nga mjetet m\u00eb t\u00eb njohura p\u00ebr vizualizimin e t\u00eb dh\u00ebnave jo vet\u00ebm n\u00eb R. <\/p>\n<p><\/p>\n<p>N\u00eb k\u00ebt\u00eb m\u00ebsim do t\u00eb m\u00ebsojm\u00eb si t\u00eb nd\u00ebrtojm\u00eb grafika t\u00eb thjeshta duke p\u00ebrdorur funksionin <code>qplot()<\/code>, dhe do t\u00eb shqyrtojm\u00eb t\u00eb gjith\u00eb argumentet e saj.<\/p>\n<h3 id=\"urok-12-postroenie-grafikov-sloy-za-sloem-s-pomoschyu-paketa-ggplot2\">M\u00ebsimi 12: Nd\u00ebrto grafika hapat-hap pas hapi me paket\u00ebn ggplot2<\/h3>\n<p><\/p>\n<p><strong>Data e publikimit:<\/strong> 8 qershor 2020<\/p>\n<p><\/p>\n<p><strong>Linket:<\/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\">Materialet<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<p><strong>P\u00ebrshkrimi:<\/strong><br \/>\nN\u00eb m\u00ebsim demonstrohet t\u00eb gjith\u00eb fuqia e paket\u00ebs <code>ggplot2<\/code> dhe gramatik\u00ebs s\u00eb nd\u00ebrtimit t\u00eb grafik\u00ebve me shtresa.<\/p>\n<p><\/p>\n<p>Ne do t\u00eb shqyrtojm\u00eb gjeometrin\u00eb kryesore q\u00eb ndodhen n\u00eb paket\u00eb dhe do t\u00eb m\u00ebsojm\u00eb si t\u00eb vendosim shtresa p\u00ebr t\u00eb nd\u00ebrtuar nj\u00eb grafik.<\/p>\n<h1 id=\"zaklyuchenie\">P\u00ebrfundimi<\/h1>\n<p><\/p>\n<p>Kam p\u00ebrpiqur t\u00eb qoj programin e kursit n\u00eb m\u00ebnyr\u00ebn m\u00eb t\u00eb qart\u00eb t\u00eb mundshme, duke nisur vet\u00ebm informacionin m\u00eb t\u00eb nevojsh\u00ebm q\u00eb do t'ju nevojitet p\u00ebr t\u00eb b\u00ebr\u00eb hapat e par\u00eb n\u00eb studimin e nj\u00eb instrumenti t\u00eb fuqish\u00ebm p\u00ebr analiz\u00ebn e t\u00eb dh\u00ebnave si gjuha R.<\/p>\n<p><\/p>\n<p>Kursi nuk \u00ebsht\u00eb nj\u00eb udh\u00ebzues gjithp\u00ebrfshir\u00ebs p\u00ebr analiz\u00ebn e t\u00eb dh\u00ebnave me gjuh\u00ebn R, por do t'ju ndihmoj\u00eb t\u00eb kuptoni t\u00eb gjitha teknikat e nevojshme p\u00ebr k\u00ebt\u00eb.<\/p>\n<p><\/p>\n<p>N\u00eb momentin kursi \u00ebsht\u00eb planifikuar p\u00ebr 12 jav\u00eb, \u00e7do jav\u00eb, \u00e7do t\u00eb h\u00ebn\u00eb do t\u00eb hap portalin p\u00ebr q\u00eb t\u00eb keni qasje n\u00eb m\u00ebsime t\u00eb reja, prandaj rekomandoj <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/R4marketing\/?sub_confirmation=1\">aboni<\/a><\/noindex> kanalin YouTube, p\u00ebr t\u00eb mos humbur publikimin e m\u00ebsimit t\u00eb ri.<\/p>\n<p>Burimi: <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 5.0.0.1 - 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.\" \/>\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\/sq\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/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\udd47Gjuha R p\u00ebr p\u00ebrdoruesit e Excel-it (kurs video falas) | ProHoster","description":"N\u00eb lidhje me karantin\u00ebn, shum\u00eb njer\u00ebz tani kalojn\u00eb shumic\u00ebn e koh\u00ebs n\u00eb sht\u00ebpi, dhe k\u00ebt\u00eb koh\u00eb mund ta kaloni, madje duhet ta kaloni me dobi. N\u00eb fillim t\u00eb karantin\u00ebs, un\u00eb vendosa t\u00eb p\u00ebrfundoj disa projekte q\u00eb i kisha nisur disa koh\u00eb m\u00eb par\u00eb.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/yazyk-r-dlya-polzovatelej-excel-besplatnyj-video-kurs","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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.","og:url":"https:\/\/prohoster.info\/sq\/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","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/80536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=80536"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/80536\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/80537"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=80536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=80536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=80536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}