Meta tags:
description=Posts about R written by erpcoder;

Headings (most frequently used words):

in, power, bi, diagram, using, to, data, model, dynamic, colored, earthtone, sql, 2016, calculate, the, distance, between, cities, how, develop, dll, for, visual, studio, 2015, earthtones, boxplot, prerequisites, script, project, erpcoder, tag, cloud,

Text of the page (most frequently used words):
the (82), and (38), for (17), this (14), city (13), #visual (11), from (11), cities (11), dll (10), row (9), color (9), example (8), used (8), longitude (8), latitude (8), dynamics (7), result (7), like (7), double (7), project (7), include (7), are (7), studio (7), 2016 (7), power (7), data (7), real (7), diagram (7), dataset (7), file (6), sql (6), script (6), library (6), two (6), zoom (6), earthtones (6), view (5), com (5), with (5), output (5), microsoft (5), more (5), there (5), distance (5), geo (5), green (5), colors (5), blue (5), erpcoder (4), powerbi (4), 365 (4), development (4), foo (4), input (4), value (4), function (4), add (4), new (4), solution (4), contains (4), open (4), following (4), looks (4), takes (4), between (4), dbo (4), distancetable (4), coordinates (4), int (4), key (4), name (4), model (4), can (4), one (4), selected (4), group (4), earthtone (4), join (3), tagged (3), filed (3), under (3), look (3), which (3), folder (3), not (3), out (3), windows (3), header (3), files (3), https (3), analysis (3), server (3), how (3), fromlat (3), tolat (3), journalid (3), fromcity (3), cityid (3), another (3), table (3), column (3), calculate (3), perform (3), using (3), schema (3), brown (3), formatted (3), boxplot (3), revenue (3), item (3), red (3), simple (3), log (2), sign (2), wordpress (2), office (2), methodology (2), finance (2), operations (2), covid (2), cloud (2), aif (2), admin (2), value_in (2), value_out (2), variable (2), load (2), your (2), already (2), build (2), x64 (2), where (2), void (2), implementation (2), stdafx (2), that (2), but (2), create (2), community (2), www (2), visualstudio (2), aspx (2), tools (2), language (2), business (2), source (2), many (2), use (2), comments (2), select (2), fromlon (2), tolon (2), distanceviewlonlat (2), sqlvalues (2), getdistkm (2), geosphere (2), record (2), inner (2), tocity (2), both (2), foreign (2), primary (2), datatype (2), install (2), sophisticated (2), was (2), also (2), leave (2), comment (2), local (2), gets (2), dark (2), numcities (2), get_earthtones (2), number_of_colors (2), shall (2), than (2), distinct (2), number (2), very (2), package (2), collapse, bar, report, content, manage, subscriptions, site, reader, privacy, have, account, now, other, subscribers, subscribed, subscribe, blog, upgrade, uncategorized, mobile, enterprise, portal, azure, machine, learning, net, tag, should, declare, variables, assign, values, default, call, dyn, path_to, directory, interactive, window, resulting, will, outputed, debug, would, make, sure, change, architecture, before, building, cpp, extern, __declspec, dllexport, __cdecl, export, symbols, specify, naming, conventions, define, win32_lean_and_mean, exclude, rarely, stuff, headers, targetver, pragma, once, standard, system, specific, frequently, changed, infrequently, definition, created, application, dialog, choose, empty, win32, edition, products, features, rtvs, mran, download, programming, great, statistics, becoming, relevant, has, integrated, offers, integration, tutorials, interop, most, them, linux, walkthrough, all, june, develop, 2015, outputdataset, frame, input_data_1, sets, fromlng, tolng, null, apply, distgeo, 1000, exec, sp_execute_external_script, matrix, inputdataset, calculates, points, rounds, meter, kilometer, added, referenced, entry, austrian, linz, vienna, nvarchar, 128, tables, while, references, toctiy, services, need, installed, order, execute, scripts, within, required, procedure, additional, packages, documented, msdn, prerequisites, since, statements, calculations, facing, although, ways, solve, tasks, exact, calculation, september, fits, buildings, plants, along, nile, desert, sand, light, cairo, fit, sea, bay, seen, space, gray, san, francisco, preis, gruppe, col, ylab, xlab, length, unique, stadt, else, lat, lon, map, false, only, gather, format, loads, names, set, otherwise, get, typical, price, visualize, slicer, filter, columns, sources, linked, excel, sheets, optimal, level, per, 045, 422, found, description, donwload, easy, get_earththones, parameters, extract, steyr, github, integrates, complex, visualization, screenshot, google, maps, certain, coordinate, extracts, landscape, diagrams, based, october, dynamic, colored, posts, code, about, home, search, management, enthusiast,

Text of the page (random words):
r erpcoder erpcoder microsoft dynamics 365 business management solution enthusiast search home about source code x and more posts comments admin development dynamics ax dynamics 365 finance and operations aif office bi powerbi covid 19 methodology dynamic colored r diagram in power bi using earthtone 4 october 2016 leave a comment power bi integrates r to perform complex analysis and sophisticated visualization earthtones is an r library which takes a screenshot from google maps of certain geo coordinate and extracts the landscape colors earthtones can be used to color diagrams based on the local color schema earthtones the package can be found on github there is also a description how to donwload and install the package using earthtones is easy the function get_earththones takes the parameters longitude and latitude zoom and the number of colors to extract the earthtones for steyr look like this get_earthtones latitude 48 045 longitude 14 422 zoom 15 number_of_colors 8 power bi data model the data model in this example is very simple there are two excel sheets one for the revenue by city and item group another for the geo coordinates longitude latitude and optimal zoom level per city the power bi model is very simple both data sources are linked by the city name r boxplot diagram in power bi in this example a simple boxplot is used to visualize the revenue by item group a data slicer for the column city is used to filter the data the r diagram takes the following columns as input longitude latitude zoom city price group if only one city is selected the r script shall gather the cities earthtone colors and format the diagram if more than one city is selected the diagram shall be formatted in red blue and green the following script loads the earthtone library and gets the distinct number of city names from the dataset if there is more than 1 distinct name in the dataset the color variable is set to red blue green otherwise earthtone is used to get the city typical color schema library earthtones numcities length unique dataset stadt if numcities 1 color c red blue green else color get_earthtones latitude dataset lat 1 longitude dataset lon 1 zoom dataset zoom 1 number_of_colors 3 include map false boxplot preis gruppe dataset col color ylab revenue xlab item group the r script in power bi looks like this if a city is selected for example san francisco the diagram is formatted in the colors blue gray and brown the colors fit the blue sea the bay and the city seen from space if another city for example cairo is selected the diagram gets formatted in dark green dark and light brown that fits the cities local color schema the brown buildings the green plants along the nile and the desert sand filed under bi powerbi r tagged with dynamics color powerbi r using r in sql 2016 to calculate the distance between cities 6 september 2016 leave a comment since sql server 2016 r can be used in t sql statements to perform sophisticated calculations one example i was facing was to calculate the distance between two cities although there are many ways to solve this tasks r can also be used to perform a exact calculation prerequisites r services need to be installed in order to execute r scripts within t sql to calculate the distance between two geo coordinates the geosphere library is required the procedure to install additional packages is documented at msdn data model this example contains 2 tables cities and distancetable the cities table contains the name and geo coordinates of a city while the distancetable contains two references fromcity and toctiy to the cities table column datatype cityid int primary key name nvarchar 128 longitude real latitude real column datatype journalid int primary key fromcity int foreign key tocity int foreign key for example the two austrian cities linz and vienna look like this an entry in the distance table looks like this i ve added another view to output the geo coordinates from both cities which are referenced in the distancetable create view dbo distanceviewlonlat as select dt journalid fc longitude as fromlon fc latitude as fromlat tc longitude as tolon tc latitude as tolat from dbo distancetable as dt inner join dbo cities as fc on dt fromcity fc cityid inner join dbo cities as tc on dt tocity tc cityid go a record from the view looks like this r script the following r script takes a record from the view as input and calculates the distance between two points and rounds the result from meter to kilometer exec sp_execute_external_script language n r script n library sp library geosphere sqlvalues as matrix inputdataset getdistkm function row p1 c row 1 row 2 p2 c row 3 row 4 d distgeo p1 p2 1000 c row 1 row 2 row 3 row 4 d km apply sqlvalues 1 getdistkm km t km outputdataset as data frame km input_data_1 n select fromlon fromlat tolon tolat from distanceviewlonlat where journalid 1 with result sets fromlng real fromlat real tolng real tolat real km real not null go the result looks like this filed under development r tagged with r sql server 2016 how to develop a c dll for r in visual studio 2015 15 june 2016 4 comments the programming language r is great for statistics and analysis r is becoming more and more relevant for business analysis microsoft has already integrated r in sql server 2016 power bi and offers an open source r implementation and visual studio integration there are many tutorials for c interop with r but most of them use linux tools and not visual c this is a walkthrough how to build a c dll and use it in r all in visual studio microsoft r open https mran microsoft com download microsoft visual studio r tools https www visualstudio com en us features rtvs vs aspx visual studio community edition https www visualstudio com en us products visual studio community vs aspx visual c create a new empty solution in visual studio add a new visual c win32 project in the c application dialog choose a dll a new c project is created include a header file and a c file open the stdafx h file and add the definition for function foo in the header file stdafx h include file for standard system include files or project specific include files that are used frequently but are changed infrequently pragma once include targetver h define win32_lean_and_mean exclude rarely used stuff from windows headers windows header files include windows h export symbols for dll and specify c naming conventions extern c __declspec dllexport void __cdecl foo double in double out open the cpp file and add the following implementation void foo double in double out double value in 0 2 out 0 value make sure to change the architecture to x64 before building build the solution the resulting dll will be outputed in the x64 folder in the project folder not in the debug folder where a c dll would be r project add a new r project to the solution which already contains the c project go to the r interactive window load the dll from your output directory dyn load c path_to your dll declare 2 variables for input and output and assign values for example input value 21 and a default value 0 for the output variable call the dll function and output the result value_in 21 value_out 0 c foo as double value_in result as double value_out result the result should look like this filed under development r tagged with dll r visual c tag cloud net admin ai and machine learning aif azure bi cloud covid 19 development dynamics 365 ce dynamics 365 finance and operations dynamics ax enterprise portal methodology mobile office powerbi r uncategorized upgrade blog at wordpress com subscribe subscribed erpcoder join 46 other subscribers sign me up have a wordpress com account log in now privacy erpcoder view site in reader manage subscriptions sign up log in report this content collapse this bar