Reading financial data from the internet is sometimes challenging. In this short article with two python snippets, I will show how to read it from Wikipedia and from and from API, delivering in JSON format: Reading the data from the…
Tag: Python
Python – Data Wrangling with Excel and Pandas
Data wrangling with Excel and Pandas is actually quite useful tool in the belt of any Excel professional, financial professional, data analyst or a developer. Really, everyonecan benefit from the well defined libraries that ease people’s lifes. These are the…
Tagged with: combine reports, dataframes, Excel, export, filtering, fix, import, mergining, missing values, Pandas, Python
Automate Stock Analysis with Python and Yfinance: Generate Excel Reports
In this article, we will explore how to analyze stocks using Python and Excel. We will fetch historical data for three popular stocks—Realty Income (O), McDonald’s (MCD), and Johnson & Johnson (JNJ) — calculate returns, factor in dividends, and visualize…
Sine and Cosine – A friendly guide to the unit circle
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…
Rule of 72
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…
Python – Stock Dashboard with Streamlit and YFinance
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…
Automated Stock Diagrams with Python
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…
From Pythagoras to Law of Cosines
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…
Tagged with: explanation, law of cosines, plotting triangle, pythagorean theorem, Python, Video, youtube
Solving Triangle Medians and Cevians with Python
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,…
Python – Intersecting Line With Circle
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.…
Python – Getting an Excel List of all Folders and Files in them
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 – Simulating the Bitcoin Mining Process – YouTube video
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 – Central Limit Theorem
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 with Python – YouTube video
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,…
Tagged with: ABC, classes, inheritance, manning, math, object oriented programming, oop, orland, Python
Dot Product in 2D with Python
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…
Linear Algebra – Drawing with Vectors – 3d and 2d
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…
Simplifying Excel Tasks with Python: Data Handling and Testing Tutorial
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.…
Tagged with: Coding Tutorial, DataAnalysis, DataScience, ExcelAutomation, Openpyxl, Pandas, Python, UnitTesting
Python API With Flask And Postman – Put and Delete Methods
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
# Update item by id @app.route('/api/items/<int:item_id>', methods=['PUT']) def update_item(item_id): data = request.get_json() updated_data = data.get('item') # Get the nested 'item' data if not updated_data: return jsonify({'error': 'No data provided'}), 400 item = next((item for item in items if item['id'] == item_id), None) if item is None: return jsonify({'error': f'Item #{item_id} not found!'}) # Update fields in the item (dummy db) for key, value in updated_data.items(): if key in item: item[key] = value return jsonify({'message': 'Item updated successfully', 'item':item}), 200 # Delete item by id @app.route('/api/items/<int:item_id>', methods=['DELETE']) def delete_item(item_id): item_to_delete = next((item for item in items if item['id'] == item_id), None) if item_to_delete is None: return jsonify({'error': f'Item {item_id} not found!'}), 404 items.remove(item_to_delete) return jsonify({'message': f'Item: {item_to_delete} has been deleted successfully!'}), 200 |
And, of course tests are a…
Python API With Flask And Postman – Post and Get Methods
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 – Make a simple API with Flask and Postman
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 – Remove spaces and None from pandas dataframe
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 OOP – Classes, Methods, Attribures, Composition, Inheritance
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 In Excel – with YouTube video!
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:
|
1 2 3 4 5 6 7 |
def factorial(a): print(a) if (a == 0) or (a == 1): return 1 return a * factorial(a - 1) factorial(5) |
Enjoy it!
Python – Logging into a file and into the console
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…
Tagged with: levels of logging, log, logging, logging to a file, logging to console, Python, stream handler
Python – Reading and Writing Files – With YouTube Video
Another YouTube video for Python – this time, about reading and writing to files. It is a bit interesting, if these are your first steps with Python, for me it was a nice reminder of how the “things” used to…
Python – Lambda Expressions – With YouTube Video
As one of the acknoledged reviewers of the Manning book Python How-To, I have decided to make a YouTube video, based on a part of the book, mentioning Lambda Expressions. The video is here, and the code I have used…
Python – Cramer’s Rule for Linear Equations – With YouTube Video
Creamer’s rule for a solution of linear equations states pretty much the following: Using this interesting picture from the German Wikipedia, I have created the following video, explaining a bit the Rule of Mr. Cramer: The video goes through the…
Tagged with: cramers rule, Excel, Jupyter, Jupyter Notebook, linear equations, Python, solution of a system
Azure – Quickstart: Deploy a Pyton Flask web app to Azure App Service – With YouTube Video
Following the step-by-step original tutorial here, I have created a simple Azure video tutorial, explaining how to deploy a python flask web app with local git. The idea to have something on your own PC and then simply using this…
Python – Split worksheet to worksheets, save Excel worksheets to csv
Same article, but for VBA is here – https://www.vitoshacademy.com/vba-split-worksheet-to-worksheets-save-excel-worksheets-to-csv/ This article does 2 things: Splits one worksheet to multiple worksheets Then goes through the worksheets and saves them as *.CSV files So what is the idea? Having this excel file,…
Python – Filtering values from a Pandas DataFrame
Some time ago, probably yesterday or the day before, I had to filter a pandas dataframe and somehow it did not come intuitively into my mind how to do it. As I did not have an article about it, I…
Top