Welcome to the world of sine and cosine! These two functions are the backbone of trigonometry, and they’re much simpler than they seem. In this article, we will explore the unit circle, the home of sine and cosine, and learn …
Sine and Cosine – A friendly guide to the unit circle Read more »
The sine function is one of the most fundamental concepts in mathematics, connecting geometry, trigonometry, and real-world applications. In its simplest form, sine is defined in a right triangle as the ratio of the length of the side opposite an …
The Rule of 114 is a quick way to estimate how long it will take to triple your money with compound interest. The idea is simple: divide 114 by the annual interest rate (in %), and you will get an …
Ever heard of the Rule of 72? It’s a classic finance shortcut that tells you how many years it takes for an investment to double at a given interest rate—without reaching for a calculator! Pretty much, if you want to …
Imagine that you want to have all the important historical financial information of yahoo finance on your PC. Well, in that case you would probably go there and check it. Anyway, if you are a person, who wants to create …
Python – Stock Dashboard with Streamlit and YFinance Read more »
Automated stock diagrams with Python is actually a rather useful idea, if you want to see how your portfolio is distributed. Just by using 2 columnes – “Ticker” and “Shares” in a CSV file, you can obtain a lot of …
The field of geometry offers tools that have withstood the test of time, empowering us to understand and solve a variety of triangular problems. Among these, the Pythagorean Theorem and the Law of Cosines are cornerstone concepts. This article provides …
If you remember some advanced math problems with triangles, where you have some cevians and medians, that split a triangle’s side into a 4:3 ration and you have to find the ratio of the split of the two cevian itself, …
Solving Triangle Medians and Cevians with Python Read more »
Ever wondered how people can say with 100% security where a circle intersects a line? No? Me too, but still I have decided to try to show how this is done. With Python it looks like a piece of cake. …
Have you ever had a feeling you need to solve an inequality like this one ((x+6)^3)/(7-x)^5>0 and you did not know how to start? In the video at the bottom of the page I am showing the few steps needed, …
Getting a list of all folders within a given folder is actually a single line command. Writing it to Excel is usually another line. Getting all files, within these folders is not a lot as well. However, having a tool …
Python – Getting an Excel List of all Folders and Files in them Read more »
Ok, currently the BTC is 68 491,28 USD and instead of feeling bad for not buying it, you can try to simulate it the mining process with Python just for fun. It is an interesting way to have fun, but …
Python – Simulating the Bitcoin Mining Process – YouTube video Read more »
There is something interesting about linear regression. I have just noticed, that I have actually quite some articles on it some years ago, but today I wanted to make a YouTube video as well. Well, what is the difference this …
So, what exactly is standard deviation? In simple terms, it’s a measure of how spread out the numbers in a dataset are from the mean or average. If the numbers are close to the mean, the standard deviation is small. …
Here is an explanation of the Central Limit Theorem (CLT) in a few simple points: Explanation: The Central Limit Theorem states that the distribution of the sample means (averages) of a large number of samples from any population will be …
Object oriented programming (OOP) in general is a huge topic, but I have decided to make a 30 minute video, based on the book Math for Programmers, as I liked the way it was explained there: Generally, in the video, …
Object Oriented Programming with Python – YouTube video Read more »
Talking about dot products in linear algebra can be really a subject of hours, but long story short this is probably the minimal knowledge you can live with: The dot product (inner product) is an operation on 2 vectors that …
Excel with VBA is really a powerful tool. There should be some 5 more years, until Python really becomes a standard for the Excel people and I am not sure that it would actually happen that quickly. Anyway, working with …
Plotting 2d and 3d vectors into a 3d space can be actually fun. Using mainly the code from Math for Programmers, I am presenting in this video an example of plotting 2d into 3d and back, using identity matrix and …
Linear Algebra – Drawing with Vectors – 3d and 2d Read more »
In the last weeks, I have noted that one of my answers in StackOverflow has received some upvotes. Which was somehow strange, as people keep on telling me that #VBA is going to die and it is a “funny scripting …
Working with Python and Excel is actually quite handy, especially if you are into it. In this article, you can see how to create Excel files, write data and formulas into them and read these. Pretty much simple CRUD methods. …
Simplifying Excel Tasks with Python: Data Handling and Testing Tutorial Read more »
In the previous article, the post and get API methods were presented. In this one, Put and Delete are coming. 🙂 Well, nothing that fancy, this is how these two methods look like: # Update item by id @app.route(‘/api/items/<int:item_id>’, methods=[‘PUT’]) …
Python API With Flask And Postman – Put and Delete Methods Read more »
This is the second video for the “Python API with Flask” series, showing how to make POST and GET commands towards a dummy database, which is a python list in our case. We are using only CREATE and READ commands …
Python API With Flask And Postman – Post and Get Methods Read more »
Flask is actually really a powerful tool for making an API. In the video below, you would see how quickly I am building an API, that does four really simple functions. The functions are – saying “Hello”, multiplying a number by …
Python – Make a simple API with Flask and Postman Read more »
In the attached video below, I am simply showing the following 3 pieces of code with Jupyter Notebook: Remove spaces in dataframe columns. Remove none values from dataframe rows. Filter dataframes, based on values. E.g. – put all rows with …
Python – Remove spaces and None from pandas dataframe Read more »
Have you ever dreamt about coding classes like a pro? No? You had “normal” dreams? Anyway, in the video below, I am solving 3 exercises with a lot of debugging and some basic tests. Exercises are from the book Python …
Python OOP – Classes, Methods, Attribures, Composition, Inheritance Read more »
Some time ago, I wrote an article about defaultdict in Python here – vitoshacademy.com/python-defaultdict-object-or-how-to-avoid-the-key-error. Now, I have decided to make a video about it and increase the scope with standard dictionary functions and an advanced class, that checks whether the …
Python Dictionary – Advanced. With YouTube video. Read more »
Finally! Microsoft did it! Put python in MS Excel! And I was able to install it and test it on my machine! The video of my attempts is here below: The “code” is that one: def factorial(a): print(a) if (a …
Python allows decent built-in logging. As I am going to explain in the video below, the built-in logging is actually rather neat – it allows everyone to log into a file or into the console within minutes – just the …
Python – Logging into a file and into the console Read more »
This is probably a python “feature” that every junior developer has bumped into – once you make an empty list as a default argument in Python, it works as expected only for the first object of the class. For the second object – not exactly. Don’t worry, everyone has hit that bug, even it they are not willing to admit it.