Data Science

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...

Relevant Process Monitoring - Database Loading and Business Rules

It's a monitoring to check if it has any relevant jobs, tasks, database loading or business rules  "stopped".   Currently, we are monitoring if it has any issues, but not if it's stopped.   Considering the company has a monitor to show up the monitoring from...

Flash the Window Application if the Monitoring Data is achieving the Threshold in C#

It shows only the method to flash the Windows:     ===================================================== Calling the Class: ===================================================== // One this to note with this example usage code, is the "this" keyword is referring to // the...

Developing a Windows Service for Data Extraction

This solution was built to supply a third party application developed in a legacy solution called PFX.   That simple Windows application, runs every day, calling a command line that exports the PFX application to Text...

SQL Server Disk Monitoring in Power BI

I'd decided to build that monitoring to prevent any disk space issues, it's the complement from my Power BY Dashboard monitoring I have been enhancing, also, that has been very useful for my daily chores. This is the mobile interface:     My SQL Dashboard...

Developing an ETL in SSIS with C# and Python to Load a Call Centre Data in a complex Excel File

I've decided to build the ETL using Python because of the complexity to read an Excel Spreadsheet with different levels, also, due to the simple way to develop the code.     This is the complex Excel file I need to load every month:   I sorted it out building that Python...

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!