R Basic querry

While learning R (from scratch) I fall on kaggle. It propose some competition between user to find the best model of prediction.

It's my first Big Data Experience, then I am a little bit lost. Then First  I have to admit that I follow "How To"

I will post here all my generic basic R data manipulation.



Create a list of value

unusual_title<-c('Dona', 'Lady', 'the Countess','Capt', 'Col', 'Don', 
                 'Dr', 'Major', 'Rev', 'Sir', 'Jonkheer')

Update the value Title by "unusual Title" if the title is in the liste previously created

titanic$title[titanic$title %in% unusual_title]<-'Unusual Title'

Sapply is a function that apply on each item of a dataSet.
on each name of the DataSet we apply a Split on the first ,or , and keep the first part
this part go in surnamecolum,

titanic$surname<-sapply(titanic$Name, function(x) strsplit(x,split='[,.]')[[1]][1])

Give the value "single" to fsizeD if the column famsize == 1

titanic$fsizeD[titanic$famsize == 1] <- 'single'

titanic$fsizeD[titanic$famsize < 5 & titanic$famsize> 1] <- 'small'

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

CRM dynamics V9 wait Async web API to contiue code

hello here is how to do an async call from v9 here is the structur of a call function azerty () {   Xrm.WebApi.retrieveMultipleRecords("teams", "?$select=name,teamid&$filter="+clause).then(       function success(result)         {     / /Your COde here part A                 },         function (error)         {             Xrm.Navigation.openAlertDialog(error.message);         }     );  //other code here; part b //Yuou want this code to be executed after part A because the webapi call is assync the part B would be executed before part A } then if you want to execute part B after part A here is how to do In green what is change to make it work async function azerty () { //Some code await myPartAcode(); partBcode; } function myPartAcode() { return new Promise(resolve => { { resolve(   Xrm.WebApi.retrieveMultipleRecords("teams", "?$select=name,teamid&$filter="+clause).then(       func
Lire la suite

promise example

 the promise async function getrecord (recordtype,recordid) {     return new Promise(resolve => {{             resolve(Xrm.WebApi.retrieveRecord(recordtype, recordid ).then(                     function success(result)                     {                      // perform operations on record retrieval                         if (result)                         {                             return result;                         }                     },                     function (error)                     {                         Xrm.Navigation.openAlertDialog(error.message);                     }                 )   ); }}); the function that call the promise async function onChange_regarding(executionContext) {     var formContext = executionContext.getFormContext();     var regarding = formContext.getAttribute("regardingobjectid").getValue();          var mycurrentSubject = formContext.getAttribute("subject").getValue();     if (regarding != null)     {   
Lire la suite

Decode/render HTML from a field in crm dynamics

In email entity the Hmtl is well decode. but if you want to decode it in other entity, it will not work you will just see the tag everywhere then I propose you to create a webressource and to apply this code. as you can see the field to to decode is hard coded but you can also give it as a webressource parameter. in a old post I explain how to pass value here is the html + javascript <html><head><meta></head> <body onload="onLoad()" onfocusout="parent.setEmailRange();" style="overflow-wrap: break-word;"> <script > function onLoad() { debugger; var para = document.createElement("decodedDescription"); var descriptionHtml = window.parent.Xrm.Page.getAttribute("description").getValue(); para.innerHTML = descriptionHtml; document.getElementById("decodedDescription").appendChild(para); }   </script > <div id="decodedDescription"> </div> </body></ht
Lire la suite