Skip to content
We are working on our new AI Platform. Contact info@kentecode.ai for more info
  • Home
  • General
  • SQL Server
  • Data Analytics
We are working on our new AI Platform. Contact info@kentecode.ai for more info
  • Home
  • General
  • SQL Server
  • Data Analytics

About:vincentamedekah@gmail.com

Posts by vincentamedekah@gmail.com :

R Programming to rank best or worst hospital for heart attack, heart failure and pneumonia for each state in the United States.

Posted on May 19, 2016 by Vincent Kofi Amedekah

In this post, I am building on the code I wrote in a previous post where l try to find the best hospital in a state given a condition such as heart attack, heart failure or pneumonia. The upgrade code is to find either the best or the worst for each of the state and […]

Read More

R Programming code to compare hospitals in a state and determine the best in a given condition.

Posted on May 18, 2016 by Vincent Kofi Amedekah

This is a data analysis scenario given that you have lot of data on hospitals across the United States and you want to perform a simple analysis to easily determine which hospital has lower deaths in a given state for a given condition. The data originally used for the analysis was from https://www.medicare.gov/ but l just want […]

Read More

R Programming- Grouping and Chaining with dplyr

Posted on February 21, 2016 by Vincent Kofi Amedekah

In this lesson, l will continue discussion on the dplyr package. I had started introducing basic data manipulations using dplyr in a previous post which can be found here. To continue the discussion, we will go through how we can group data by one or more variables in our data set. We are going to work […]

Read More

R Programming- hands on with dplyr package

Posted on February 18, 2016 by Vincent Kofi Amedekah

In this post, l will briefly go over the dplyr package which can make data manipulation very easy in R. First install the package from CRAN by issuing install.packages(“dplyr”). After installing load the package by issuing the command library(dplyr). This tutorial is on dplyr version 0.4.0 or later so check to make sure the requirement […]

Read More

  • «
  • 1
  • …
  • 12
  • 13
  • 14
  • 15
  • 16
  • …
  • 78
  • »
Vincent Kofi Amedekah

  • SQL Interview prep quiz 2 : Explain the difference between CTE and a subquery and give some advantages of using one over the other in OLAP vs OLTP systems
  • SQL interview prep quiz 1: Write sql code to print the letters of the English alphabet in upper case without explicitly writing the letters.
  • Predicting the future price of Bitcon using time series analysis
  • Supply Chain Big Data Analysis To Predict Late Delivery Risk Of Customer Orders
  • Differences between aggregation and composition in Python Class
  • How to use analytic functions First_value and Last_value introduced in SQL Server 2012
  • How to use SQL Server extension ROLLUP to summarize data
  • Data profiling using SQL Server Integration Services – SSIS
  • Restore database in sql server
  • Back up database in SQL Server.
  • Ping database in sql server.
  • Shrink database in sql Server.
  • Next word prediction application- Data Science Capstone
  • SQL Script to populate Date Dimension table in the Data warehouse.
  • Machine Learning predicting quality of exercise performed using smart wearable device data.
  • Comparing accuracy of prediction of Alzheimer’s diagnosis by Machine Learning Algorithms Random Forest, Boosted Trees and Linear Discriminant Analysis to a stack prediction of all the three Algorithms.
  • Brief introduction to the R package caret for Machine Learning.
  • Notes on SDLC Models
  • SQL Procedure to allow registration of only employees of your company for your site.
  • ETL Process in Data Warehouse
  1. Home
  2. Articles Posted by Vincent Kofi Amedekah
  3. (Page 14)
©2025 All Rights Reserved. KenteCode.ai