R Programming-Find Mean, Complete Cases, And Correlation of Pollutants in File Data

In this post, I am going to show functions that l have written to work on a data in files which contain observation of pollutants monitored at different locations. The data is a .csv file and there are 332 monitors which are set up at different locations. Sample of data looks like below “Date”,”sulfate”,”nitrate”,”ID” “2003-01-01”,NA,NA,1 […]

Read More

Find The End Of Month In SQL Server

SQL Server 2012 has introduced a nice function EOMONTH which gives end of month for a given date.  How do you know how many days are in a month in real life? Well, for me, l still use the childhood song “30 days has September, April, June and November. All the rest has 31 except […]

Read More