{"id":818,"date":"2020-06-18T07:15:00","date_gmt":"2020-06-18T00:15:00","guid":{"rendered":"http:\/\/www.gis2me.com\/geospatial\/?p=818"},"modified":"2025-04-30T09:25:15","modified_gmt":"2025-04-30T02:25:15","slug":"r-studio-ep11-%e0%b8%82%e0%b9%89%e0%b8%ad%e0%b8%a1%e0%b8%b9%e0%b8%a5-excel-%e0%b8%88%e0%b8%b8%e0%b8%94%e0%b8%a7%e0%b8%b1%e0%b8%94%e0%b8%99%e0%b9%89%e0%b8%b3%e0%b8%9d%e0%b8%99-rainfall-data","status":"publish","type":"post","link":"http:\/\/www.gis2me.com\/geospatial\/?p=818","title":{"rendered":"R-studio : ( EP#11 ) \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 Excel \u0e08\u0e38\u0e14\u0e27\u0e31\u0e14\u0e19\u0e49\u0e33\u0e1d\u0e19 Rainfall Data \u0e19\u0e33\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07 Leaflet Map \u0e14\u0e49\u0e27\u0e22\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 R"},"content":{"rendered":"<p>R-studio : ( EP#11 )\u00a0 \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 Excel \u0e08\u0e38\u0e14\u0e27\u0e31\u0e14\u0e19\u0e49\u0e33\u0e1d\u0e19 Rainfall Data \u0e19\u0e33\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07 Leaflet Map \u0e14\u0e49\u0e27\u0e22\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 R\u00a0<br \/>\u0e43\u0e19\u0e15\u0e2d\u0e19 <strong data-start=\"6\" data-end=\"26\">R-Studio (EP#11)<\/strong> \u0e19\u0e35\u0e49 \u0e40\u0e23\u0e32\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23 <strong data-start=\"48\" data-end=\"88\">\u0e19\u0e33\u0e40\u0e02\u0e49\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e38\u0e14\u0e27\u0e31\u0e14\u0e19\u0e49\u0e33\u0e1d\u0e19\u0e08\u0e32\u0e01\u0e44\u0e1f\u0e25\u0e4c Excel<\/strong> \u0e41\u0e25\u0e30 <strong data-start=\"93\" data-end=\"136\">\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48\u0e40\u0e0a\u0e34\u0e07\u0e42\u0e15\u0e49\u0e15\u0e2d\u0e1a (Interactive Map)<\/strong> \u0e14\u0e49\u0e27\u0e22 <strong data-start=\"142\" data-end=\"153\">Leaflet<\/strong> \u0e1a\u0e19\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 R \u0e42\u0e14\u0e22\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e15\u0e01\u0e41\u0e15\u0e48\u0e07\u0e2a\u0e31\u0e0d\u0e25\u0e31\u0e01\u0e29\u0e13\u0e4c\u0e43\u0e2b\u0e49\u0e41\u0e2a\u0e14\u0e07\u0e23\u0e30\u0e14\u0e31\u0e1a <strong data-start=\"203\" data-end=\"239\">\u0e1b\u0e23\u0e34\u0e21\u0e32\u0e13\u0e19\u0e49\u0e33\u0e1d\u0e19 (Rainfall Intensity)<\/strong> \u0e41\u0e25\u0e30\u0e2a\u0e38\u0e14\u0e17\u0e49\u0e32\u0e22 <strong data-start=\"251\" data-end=\"270\">\u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 HTML<\/strong> \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e43\u0e0a\u0e49\u0e41\u0e2a\u0e14\u0e07\u0e1a\u0e19\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c \u0e2b\u0e23\u0e37\u0e2d Dashboard \u0e44\u0e14\u0e49<\/p>\n<p>\u0e40\u0e15\u0e23\u0e35\u0e22\u0e21\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1b\u0e23\u0e34\u0e21\u0e32\u0e13\u0e19\u0e49\u0e33\u0e1d\u0e19\u0e43\u0e19 Excel \u0e41\u0e25\u0e49\u0e27\u0e14\u0e36\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e40\u0e1b\u0e47\u0e19 Points \u0e1a\u0e19\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48 Leaflet <br \/>\u0e41\u0e25\u0e30\u0e15\u0e01\u0e41\u0e15\u0e48\u0e07\u0e15\u0e32\u0e21\u0e04\u0e48\u0e32\u0e1b\u0e23\u0e34\u0e21\u0e32\u0e13\u0e19\u0e49\u0e33\u0e1d\u0e19 \u0e44\u0e14\u0e49\u0e1e\u0e2d\u0e43\u0e08\u0e41\u0e25\u0e49\u0e27 \u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 HTML \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e19\u0e33\u0e44\u0e1b\u0e41\u0e2a\u0e14\u0e07\u0e1c\u0e25\u0e07\u0e32\u0e19\u0e44\u0e14\u0e49\u0e15\u0e48\u0e2d\u0e44\u0e1b<\/p>\n<p>\u00a0<\/p>\n<p>\u0e41\u0e2b\u0e25\u0e48\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 R markdown script <a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSedJs13_-7w6WRTssHnNMk2QCTwUdn5RI-h02xa0T8v-CATXQ\/viewform\">https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSedJs13_-7w6WRTssHnNMk2QCTwUdn5RI-h02xa0T8v-CATXQ\/viewform<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/GjSumOoI0H4\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfaf \u0e27\u0e31\u0e15\u0e16\u0e38\u0e1b\u0e23\u0e30\u0e2a\u0e07\u0e04\u0e4c<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48 Leaflet \u0e41\u0e2a\u0e14\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1d\u0e19\u0e08\u0e32\u0e01 Excel<\/li>\n\n\n\n<li>\u0e41\u0e2a\u0e14\u0e07\u0e04\u0e48\u0e32 <strong>latitude<\/strong>, <strong>longitude<\/strong>, \u0e41\u0e25\u0e30 <strong>rainfall<\/strong> \u0e40\u0e1b\u0e47\u0e19 point \u0e1a\u0e19\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48<\/li>\n\n\n\n<li>\u0e1b\u0e23\u0e31\u0e1a\u0e02\u0e19\u0e32\u0e14\/\u0e2a\u0e35\u0e02\u0e2d\u0e07 marker \u0e15\u0e32\u0e21\u0e1b\u0e23\u0e34\u0e21\u0e32\u0e13\u0e19\u0e49\u0e33\u0e1d\u0e19<\/li>\n\n\n\n<li>\u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 HTML \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a embed \u0e2b\u0e23\u0e37\u0e2d\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udce5 \u0e14\u0e32\u0e27\u0e19\u0e4c\u0e42\u0e2b\u0e25\u0e14\u0e0a\u0e38\u0e14\u0e2a\u0e04\u0e23\u0e34\u0e1b\u0e15\u0e4c\u0e41\u0e25\u0e30\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udd17 \u0e41\u0e1a\u0e1a\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e25\u0e07\u0e17\u0e30\u0e40\u0e1a\u0e35\u0e22\u0e19\u0e23\u0e31\u0e1a <strong>R markdown script<\/strong>:<br>\ud83d\udc49 <a class=\"\" href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSedJs13_-7w6WRTssHnNMk2QCTwUdn5RI-h02xa0T8v-CATXQ\/viewform\">EP#11 \u2013 Rainfall Leaflet Map Script<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddea \u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 R Script (Leaflet + Rainfall Visualization)<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">rCopyEdit<code># \u0e15\u0e34\u0e14\u0e15\u0e31\u0e49\u0e07\u0e41\u0e1e\u0e47\u0e01\u0e40\u0e01\u0e08\u0e17\u0e35\u0e48\u0e08\u0e33\u0e40\u0e1b\u0e47\u0e19\ninstall.packages(c(\"readxl\", \"leaflet\", \"htmlwidgets\"))\n\n# \u0e42\u0e2b\u0e25\u0e14\u0e41\u0e1e\u0e47\u0e01\u0e40\u0e01\u0e08\nlibrary(readxl)\nlibrary(leaflet)\nlibrary(htmlwidgets)\n\n# \u0e42\u0e2b\u0e25\u0e14\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01 Excel\nrain_data &lt;- read_excel(\"rainfall_data.xlsx\")\n\n# \u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\nhead(rain_data)\n\n# \u0e2a\u0e23\u0e49\u0e32\u0e07\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48 Leaflet\nrain_map &lt;- leaflet(data = rain_data) %&gt;%\n  addTiles() %&gt;%\n  addCircleMarkers(\n    lng = ~longitude,\n    lat = ~latitude,\n    radius = ~sqrt(rainfall),  # \u0e1b\u0e23\u0e31\u0e1a\u0e02\u0e19\u0e32\u0e14\u0e15\u0e32\u0e21\u0e1b\u0e23\u0e34\u0e21\u0e32\u0e13\u0e1d\u0e19\n    color = ~ifelse(rainfall &gt; 100, \"red\", ifelse(rainfall &gt; 50, \"orange\", \"blue\")),\n    label = ~paste(\"Rainfall:\", rainfall, \"mm\"),\n    popup = ~paste(\"\u0e2a\u0e16\u0e32\u0e19\u0e35:\", station_name, \"&lt;br&gt;\u0e1b\u0e23\u0e34\u0e21\u0e32\u0e13\u0e19\u0e49\u0e33\u0e1d\u0e19:\", rainfall, \"mm\")\n  )\n\n# \u0e41\u0e2a\u0e14\u0e07\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48\nrain_map\n\n# \u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 HTML\nsaveWidget(rain_map, \"RainfallMap.html\", selfcontained = TRUE)\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfa8 \u0e40\u0e17\u0e04\u0e19\u0e34\u0e04\u0e01\u0e32\u0e23\u0e15\u0e01\u0e41\u0e15\u0e48\u0e07\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e15\u0e34\u0e21<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u0e1b\u0e23\u0e31\u0e1a\u0e41\u0e15\u0e48\u0e07<\/th><th>\u0e04\u0e33\u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22<\/th><\/tr><\/thead><tbody><tr><td><code>radius = ~log(rainfall)<\/code><\/td><td>\u0e43\u0e0a\u0e49 log scale \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e01\u0e23\u0e30\u0e08\u0e32\u0e22\u0e01\u0e27\u0e49\u0e32\u0e07<\/td><\/tr><tr><td><code>color = colorNumeric(\"Blues\", domain = rainfall)<\/code><\/td><td>\u0e43\u0e0a\u0e49 color scale \u0e2d\u0e31\u0e15\u0e42\u0e19\u0e21\u0e31\u0e15\u0e34<\/td><\/tr><tr><td><code>clusterOptions = markerClusterOptions()<\/code><\/td><td>\u0e23\u0e27\u0e21\u0e08\u0e38\u0e14\u0e41\u0e2a\u0e14\u0e07\u0e41\u0e1a\u0e1a\u0e01\u0e25\u0e38\u0e48\u0e21<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 \u0e01\u0e32\u0e23\u0e1b\u0e23\u0e30\u0e22\u0e38\u0e01\u0e15\u0e4c\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0e15\u0e34\u0e14\u0e15\u0e32\u0e21\u0e2a\u0e16\u0e32\u0e19\u0e01\u0e32\u0e23\u0e13\u0e4c\u0e19\u0e49\u0e33\u0e1d\u0e19\u0e20\u0e32\u0e04\u0e2a\u0e19\u0e32\u0e21<\/strong> \u0e41\u0e1a\u0e1a\u0e27\u0e31\u0e19\u0e15\u0e48\u0e2d\u0e27\u0e31\u0e19<\/li>\n\n\n\n<li>\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d\u0e01\u0e31\u0e1a Google Sheets \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e17\u0e33\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48\u0e41\u0e1a\u0e1a <strong>Real-time<\/strong><\/li>\n\n\n\n<li>\u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48\u0e44\u0e1b\u0e1d\u0e31\u0e07\u0e43\u0e19\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e02\u0e2d\u0e07\u0e42\u0e04\u0e23\u0e07\u0e01\u0e32\u0e23 \u0e2b\u0e23\u0e37\u0e2d Dashboard \u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e1c\u0e39\u0e49\u0e1a\u0e23\u0e34\u0e2b\u0e32\u0e23<\/li>\n\n\n\n<li>\u0e43\u0e0a\u0e49\u0e23\u0e48\u0e27\u0e21\u0e01\u0e31\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 DEM \u0e2b\u0e23\u0e37\u0e2d Flood Risk Layer \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e27\u0e34\u0e40\u0e04\u0e23\u0e32\u0e30\u0e2b\u0e4c\u0e40\u0e0a\u0e34\u0e07\u0e1e\u0e37\u0e49\u0e19\u0e17\u0e35\u0e48<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>R-studio : ( EP#11 )\u00a0 \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 Excel \u0e08\u0e38\u0e14\u0e27\u0e31\u0e14\u0e19\u0e49\u0e33\u0e1d\u0e19 Rainfall [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[20,21],"tags":[440,534,539,536,541,439,533,535,537,538,540,542],"class_list":["post-818","post","type-post","status-publish","format-standard","hentry","category--excel","category--r-studio","tag-gis--r","tag-interactive-map-r","tag-leaflet-html-r","tag-leaflet-map-r","tag-r-markdown-map","tag-r-studio","tag-r--excel","tag-rainfall-map","tag-rainfall-visualization","tag-538","tag--excel","tag-542"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=818"}],"version-history":[{"count":1,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/818\/revisions"}],"predecessor-version":[{"id":819,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/818\/revisions\/819"}],"wp:attachment":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=818"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}