Today I got hands on my first data analytics project which was a healthcare dataset.
First I got the dataset and then I did the following steps.
I understood the data first as It was a healthcare data there was given name of patients,number of patients,their disease,their medication,their blood groups etc.
2.Then I uploaded the data in the power query to clean the data in power query I found in the gender category there was 3 options given as male,female and m where I replaced value m as male.In the bloodtype feature I found very inconsistency where there was O- and O-ve both were present even every blood type was like that so I replaced the value O-ve to O- and I did the same process for all blood types.I also corrected the alphabetical writing of medical condition by transforming them to capitalize each word cause I found alphabetical inconsitency in them,then in billing amount I found an error in the data where I remember the number it was written as 6452O which I replaced it with 64520 cause O is an alphabet.Even in the admission type there was two same like options which was emergency and emer then I replaced the values emer with emergency.Even I added an conditional column which was an age bucket column where the condition was if the person is below 30 consider him/her as young and if below 60 consider as middle and if these two conditions are not fulfilling then consider as senior.And then my data got cleaned and prepared.
