Publications by Nguyen Ngoc Thieu
READMISSION RATE ANALYSIS USING SQL
READMISSION RATE ANALYSIS USING SQLThe readmission rate is an important KPI to measure the percentage of patients who are admitted to hospitals again after a specific time duration such as 30 days. This metrics helps to assess the quality of care, patient outcomes and the effectiveness of post-discharge follow-up.I use the simulated hospital data...
678 sym 5 img
READMISSION RATE ANALYSIS USING SQL
READMISSION RATE ANALYSIS USING SQLThe readmission rate is an important KPI to measure the percentage of patients who are admitted to hospitals again after a specific time duration such as 30 days. This metrics helps to assess the quality of care, patient outcomes and the effectiveness of post-discharge follow-up.-I use the simulated hospital dat...
673 sym 5 img
FINDING TIME POINTS AT WHICH PATIENT WAIT TIME IS HIGHEST OR LOWEST USING SQL
FINDING TIME POINTS AT WHICH PATIENT WAIT TIME IS HIGHEST OR LOWEST USING SQLI use a data table called ‘Hospital ER’ having columns such as ‘date’, ‘patient_waittime’ to find time points at which patient wait time is highest or lowest. It is useful for HR to reallocate staff to reduce patient wait time.SQL codes as following:- -The o...
513 sym 4 img
WORLD DEATHS AND CAUSES
WORLD DEATHS AND CAUSESI get dataset ‘World Deaths and Causes’ from www.kaggle.com to analyze and make charts.The dataset looks like this in Tableau Public.- -Now I convert the dateset into pivot form in order to analyze easily by hight-light all columns of causes of deaths then right-click and choose ‘Pivot’. The table now looks like...
656 sym 5 img
MEDICATIONS COSTS USING SQL
MEDICATIONS COSTS USING SQLI use medication data from a simulated hospital database on the Sythea website for analyzing in this post. The medications table have columns such as ‘start date’, ‘stop date’, ‘patientid’, ‘encounterid', ‘descriptions’, ‘base_cost’, ‘dispense’, ‘total cost’. Another table called ‘encounter...
1415 sym 8 img
COVID19 VACCINE SHOTS ANALYSIS USING SQL
COVID19 VACCINE SHOTS ANALYSIS USING SQLIn this post, I use a simulated hospital database from Synthea to extract covid19 data using SQL.In this table, data of covid shots is among other shots like flu, hepa.. I select covid data and merge the table with patient data from Patients table as follow:Many patients have two shots apart a couple of weeks...
1257 sym 6 img
COVID19 VACCINE SHOTS ANALYSIS USING SQL
COVID19 VACCINE SHOTS ANALYSIS USING SQLIn this post, I use a simulated hospital database from Synthea to extract covid19 data using SQL.In this table, data of covid shots is among other shots like flu, hepa.. I select covid data and merge the table with patient data from Patients table as follow:Many patients have two shots apart a couple of weeks...
1259 sym 6 img
Fixing Errors When Importing csv Tables into pgadmin4
Fixing Errors When Importing csv Tables into pgadmin4¶ Create a table in pgadmin4¶ At first, create a table in pgadmin4 that has matched columns with the table in my local directory that I want to import to. Right-click on the table in pgadmin4, then click 'Import/Export data' to copy data into pgadmin4. If two tables not matching columns on na...
2308 sym
Survival Analysis Using Python
Survival Analysis Using Python¶ Loading data¶ Dataset here is about cancer survival time among patients with and without chemotherapy, hormonal therapy, amputation ... In [ ]: import pandas as pd import numpy as np import seaborn as sns import matplotlib.pyplot as plt from lifelines import KaplanMeierFitter from lifelines.statistics import ...
912 sym 2 img 4 tbl
Event Detection With Time Series Data Using Python
Event Detection With Time Series Data Using Python¶ Classification models with time series data having target variable to predict medical events from data got from EHR. Timesia, eventdetector_ts are packages used to analyze. In this post, I use SLTM models, decision tree models to predict events. Link: https://pypi.org/project/eventdetector-ts/...
1268 sym 1 img