Data Science

R Shiny Server connection with Cassandra on Google Maps

It was a project involving R and Cassandra to represent the customers on Google Maps.   ================================================================ --// Full...

SSRS - Report Mobile SQL 2016 - Sample Layout

This is a Report Mobile SQL 2016  Sample Layout:  

SSRS - Pie charts with Standard Deviation layout and design

It's an example of layout / template created in SSRS:  

R Studio - SQL Database Connection

This is a database connection sample:    library(RODBC) dbhandle <- odbcDriverConnect('driver={SQL Server};server=SERVERNAME;database=DW;trusted_connection=true')  res <- sqlQuery(dbhandle, 'select * from DW.DBO.Vehicle ')   head(res)    

My first R code embedded in SQL 2019

My first R code embedded in  SQL 2019   EXECUTE sp_execute_external_script @language = N'R', @script = N' a <- 1 b <- 2 c <- a/b d <- a*b print(c, d)'   EXECUTE sp_execute_external_script @language = N'R', @script = N' a <- 1 b...

K-Means in SQL with Cluster in R and visualization in Tableau

========================= SQL R =========================   USE [DW] GO   SET ANSI_NULLS ON GO   SET QUOTED_IDENTIFIER ON GO /*   CREATE TABLE [dbo].[data_1024_kMeans]( [Driver_ID] [varchar](50) NULL, [Distance_Feature] [varchar](50)...

K-Means in Python based on a CSV Source

    import matplotlib.pyplot as plt import pandas as pd import numpy as np from sklearn.cluster import KMeans from sklearn.datasets.samples_generator import make_blobs import seaborn as sns; sns.set() df = pd.read_csv("data_1024_kMeans.csv",...

Loading A CSV Into pandas in Python

  import modules import pandas as pd import numpy as np Create dataframe (that we will be importing) raw_data = {'first_name': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'], 'last_name': ['Miller', 'Jacobson', ".", 'Milner', 'Cooze'], 'age': [42, 52, 36, 24, 73], ...

Azure Machine Learning - Normalizing and Cleaning Up a Dataset

Normalizing We can specify the fields to be normalized, choosing the Transformation Method that suits the dataset:     Cleaning UP  it's necessary in case of the missing value is greater than "0":     The dataset I'm using is very clean, the reason why it's "0". If it had...

Linear Regression in R

First of all, I had installed RStudio, this is the link for download: https://leandro26.webnode.com/products/download-r-for-windows/   Once we have installed RStudio, load the script below:     --=============================================== --// R...

1 | 2 | 3 | 4 | 5 >>

Crie um site com

  • Totalmente GRÁTIS
  • Centenas de templates
  • Todo em português

Este site foi criado com Webnode. Crie um grátis para você também!