Skip to main content


Showing posts from September, 2021

My attempt (5) at learning a coding language (SQL) in my mid 30s

I read through my previous page and did my exercises. It really drives the point to make notes while learning something. Many times I will be watching the video and copying down the examples but you only know how the code works if you try it out at the exercises. I know if I have to replay the video to find out the codes example again, I will be very frustrated so luckily I had done so in my notes. I take down the definition and examples shown by the speaker. Another way I use this is as a recap resource since I learn the code every few days and obviously, I would have forgotten how the code works. Hope it will be useful to you if you found it. Here on to the next page of syntax. 1) Aggregate functions - take in multiple inputs and return a single output.  AVG() -returns average value as a float (with decimal places) COUNT() - returns the number of values MAX() - returns the maximum value MIN() - returns minimum value SUM() - returns the sum of all values ROUND() - returns a rounded va

My attempt (4) at learning a coding language (SQL) in my mid 30s

This attempt will be learning on SQL learning. I bought a course on udemy previously and decided it is time to complete it.  The video informed me to keep track of the passwords during the installing of postgresql and then pgadmin4 which is the visual interface... I forget about them and ended up had to reinstall and install again... sigh To create a database, right click at database then "Create". To restore a database, right click on the "new database name" then "Restore". Find the correct .tar file, remember to check on the restore options tab if there are anything that need to be checked.  Check on the tables in the database by clicking on the "new database name" >> "Schema" >> "Tables" >> (it will show the tables available). Look further into the table by >> "table name", it will show the column titles.  Syntax: 1) SELECT - allow us to retrieve information from a table.  eg SELECT column_

There are more than just doctors and nurses in the healthcare sector!

Recently a close friend of mine was not in good health and had to stay in the hospital. Despite the suddenness of the stay, she remained optimistic and began to observe the personnel attending to her. The educator in her observed that there are many different roles working in a hospital and we remarked how true that we are not as aware of the other roles other than the nurses and doctors. So I decided to find out more and there are so many specializations created to understand more about our body. After reading the site, a doctor is a very general term as there are very specific names for the different specialization.  For this post, I will explore the  Allied Health Professionals. They play vital roles in the different aspects of investigative work and therapeutic care for patients. (Taken from  Allied Health Professionals - SingHealth ). I decided to group the roles based on the over-arching nature of the jobs however this is only my own form of interpretation.  IAEA Imagebank Techno

My attempt (3) at learning a coding language in my mid 30s

The job of a data analyst involves data cleaning such as filling in null values and removal of outliers that may skew the trend if we computed the data without thinking. The learning videos told me this is rubbish in and rubbish out. >_<  To select certain rows, we can do slicing using the ":" symbol .  series[start_index:end_index] with the  end_index not included. (Using the df from my previous post.) series[start_index:end_index:no to jump]. eg [::-1] returns the elements in the series in opposite direction. eg1.  df['Month'][0:2] This will return me the first two rows of data in a series. eg2.  df[['Month']][0:2] This will return me the first two rows of data in a df.  We can also select columns by m aking use of .loc attribute. eg3. df.loc[:, 'Month'] This will return a series for all the data in 'Month' column instead of a dataframe in df.loc[:, ['Month']].   Both works the same way however one uses the index location for sl