Festus NyarandiTime window queries and aggregatesThis is a continuation of my previous post on analyzing time series data. In case you missed it, you can find it hereJul 30, 2022Jul 30, 2022
Festus NyarandiStatistics Basics for Data AnalysisData-driven decision making and data analysis has all become an important part of the business acumen. As we navigate our world of…Jul 24, 2022Jul 24, 2022
Festus NyarandiPairwise ModelA wide range of real-world prediction problems require modeling a pairwise relation between a potentially large set of objects.Jun 2, 2022Jun 2, 2022
Festus NyarandiUsing Sqlite with PythonRelational databases are the most widely used type of database, storing information as tables containing a number of rows. Python uses a…May 31, 2022May 31, 2022
Festus NyarandiWorking with dates on SQL — Practice Example 1 (Self Join)Question: Calculate each user’s average session time. A session is defined as the time difference between a page_load and page_exit. For…Apr 24, 2022Apr 24, 2022
Festus NyarandiPython Algorithms Every Programmer Should Know — Part 1What is an algorithm?Apr 22, 2022Apr 22, 2022