PinnedRedHairedGirlHow to install StatCan’s SLICEmyPDF on Windows?With the prevalence of PDF files, there is a huge demand to convert the tables in these files into CSV/Excel for easy extraction of the…Apr 9, 20221Apr 9, 20221
RedHairedGirlHow to Read in 1 or All Excel Sheets into a Pandas DF Using Xlwings?One of the advantages of using Xlwings to read in Excel data into Pandas dataframe is that numeric columns that should be stored as string…Jul 111Jul 111
RedHairedGirlPython Equivalent of SAS Proc TransposeAs Python does not have readily available functions that is exactly identical to SAS Proc Transpose, this article provides a created…Jul 4Jul 4
RedHairedGirlDecoding SAS: A Guide to Python EquivalentsAs more people migrate from SAS to free open-source languages like Python, there could be a need to re-code SAS programs into the…Jun 24Jun 24
RedHairedGirlPython Equivalent of SAS MergeWhile Python offers several merge options like pandas.merge, pandas.concat, and join; none of them can replicate the exact same output of…Jun 24Jun 24
RedHairedGirlPython Equivalent of SAS Proc SummaryWhile Python is a power language, it may not have ready-to-use functions that replicates SAS procedure exactly. This article provides a…Jun 20Jun 20
RedHairedGirlRegular Expression (Regex) for Common SituationsProviding a couple of regex examples for commonly encountered situationsJun 1, 20222Jun 1, 20222
RedHairedGirlA Comparison of Major Composite Indices by NSOs/Govt & Non-Govt Agencies Throughout the WorldRead this to learn the key characteristics of major compositie indices (defunct & existing):May 30, 2022May 30, 2022
RedHairedGirlVBA Cheat Sheet: A Summary of the Various Ways to Reference Common ObjectsThis cheat sheet (in images) provides a handy guide of the different ways to reference sheets, rows, etc in your code. The pdf version of…May 29, 2022May 29, 2022
RedHairedGirlSeasonal Adjustment Outlier ThresholdsA good summary of the seasonal adjustment thresholds for outliers adopted by various organisations:May 28, 2022May 28, 2022