Skip to main content

My Python Journey: Blog #1

It has been a while since my last blog entry. Today, I want to document my thought process on how I created a Python program that would generate a step-by-step solution to Statistics worded problems.


It started with a why: "Why should I automate the writing of solutions to Statistics problems?" My first reason was that I encounter certain problems in the tutoring platform that are frequently recurring. Only the givens in the problem changes but the steps are all the same. This means that every time I encounter these problems, I have to re-type the procedure with all the LaTeX formatting involved in certain formulas. And, that is somewhat frustrating. Time is gold has never been this real to me. And the time I spend on one problem means a delay in solving other problems. The delay means decreased revenue on my part since I can solve only a limited number of problems within a day. 

Because of this frustration, I thought of an idea. "What if I create an MS Excel or Word Document template that I will just copy and paste and then input the associated given in the problem?" This way I will be more efficient. I proceeded to make an MS Excel document. Here is an example of a probability calculator when given a contingency table.




While this is convenient and I will only input the given values in the contingency table for the next related problem, this is not efficient since I still have to write the step-by-step procedure and also the associated formulas. In other words, it minimized the calculation part but the problem with spending so much time writing the procedure on how to solve the problem was still there.


What I did next is to create a template so that writing the procedure would be minimized, and all I need to do is insert the associated tables/pictures within the procedure. Here is an example of the template for linear regression analysis.



The next challenge for me was to make the template adaptive. What I mean by this is, whenever a related problem comes along how fast can the template generate the step-by-step solutions for me. Currently, it was not so fast. At least, not in the way I intended it to be. There are still times when I struggle to use the template which makes it a little non-user friendly. I am the one who made the template so how much more if I teach this template to others. If I am struggling, it follows that they will also struggle. There are still a significant number of manual inputs involved.


There's no other way. I have to muster the courage to journey into the unknown. I have to learn how to code. I have already encountered this on Youtube before but I just let it slide since I don't have much use to it back then. I mean my job does not involve programming so there is no urgent need to learn it. But it did give me a spark for the possibility of learning something new.


And so, I dedicated minutes and hours each day trying to learn this. I remember spending at least a minimum of 20 minutes every day. 20 minutes trying to understand the theory of the lesson and applying the knowledge I learned on some practical exercises on the video. 20 minutes since sometimes I get drained by the information that was presented to me. And each day, for 20 minutes or more, the possibility and opportunity became more and more evident. I can do this!

Comments

Popular posts from this blog

Privacy Policy of ShinStats: descriptives calc

Privacy Policy Shin Nix built the ShinStats app as an Ad Supported app. This SERVICE is provided by Shin Nix at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which are accessible at ShinStats unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I request will be retaine...

SQL Journey: Blog#10

So far, we are only "reading" from a given database or table using the SELECT command of SQL. In today's lesson, we will now start "writing" into a given database using the UPDATE and DELETE commands. Challenge: Dynamic Documents Given data: CREATE table documents (     id INTEGER PRIMARY KEY AUTOINCREMENT,     title TEXT,     content TEXT,     author TEXT);      INSERT INTO documents (author, title, content)     VALUES ("Puff T.M. Dragon", "Fancy Stuff", "Ceiling wax, dragon wings, etc."); INSERT INTO documents (author, title, content)     VALUES ("Puff T.M. Dragon", "Living Things", "They're located in the left ear, you know."); INSERT INTO documents (author, title, content)     VALUES ("Jackie Paper", "Pirate Recipes", "Cherry pie, apple pie, blueberry pie."); INSERT INTO documents (author, title, content)     VALUES ("Jackie Paper", "Boat Supplies...

SQL Journey: Blog #14

I am now on what Alex the Analyst would call the advanced SQL queries. First off, the Common Table Expression or CTEs. Based on what I understood in the video, CTEs is similar to a function or class in Python which you can call out. It is just how I felt when I first encountered this expression. Now, in this particular case, I tried to replicate what Alex is doing but also not copying the codes that he is using. I am just simply trying to understand what the expression that was used (which starts with WITH) and then observe how he used the said expression. This was my code. Now this code, resulted in the following error. Msg 8156, Level 16, State 1, Line 84 The column 'EmployeeID' was specified multiple times for 'CTE_Employee'. What does someone do in this day and age if we encounter something that bogs us down? We go to the internet especially to AI tools to aid us out. And, apparently, these tools will really come in handy. It stated that the error occurred because I...