Cleaned and prepared a healthcare dataset containing 55,501 records using SQL. I created a stagin...Cleaned and prepared a healthcare dataset containing 55,501 records using SQL. I created a stagin...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Cleaned and prepared a healthcare dataset containing 55,501 records using SQL. I created a stagingtable to preserve the original dataset before making changes. I performed data-quality checks, identified and removed 534 duplicates using a CTE, standardized inconsistent patient names , and checked for nulls and blank values. I also cleaned hospital names by removing trailing commas and unnecessary characters, changed the date column format from text to Time,and created an Age columnusing CASE statement to help with the analysis. The cleaned dataset was then prepared for further analysis.
Post image
Post image
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started