Published in Towards Data Science·PinnedMember-onlyBuilding A Real-time Dashboard Using Python Plotly Library And Web ServiceNote from the editors: Towards Data Science is a Medium publication primarily based on the study of data science and machine learning. We are not health professionals or epidemiologists, and the opinions of this article should not be interpreted as professional advice. To learn more about the coronavirus pandemic, you…Python10 min read
Jun 11You do some of the best explanations of your code on Medium.11BENJAMIN JOHNSONThanks for your comments.Thanks for your comments. It's a great encouragement to me as well. Wish you the best on your learning journey.1 min readThanks for your comments. It's a great encouragement to me as well. Wish you the best on your learning journey.----
Published in DS Notes·May 23Member-onlyHands-On Data Visualization in Python — Seaborn Scatter PlotScatter plot is a graph that shows the relationship between two sets of continuous numerical data. For example, the relationship between a group of people's weight and height or their salary and years of working experience. In this tutorial we are going to look at the way to use Python…Python4 min read
Published in The Handbook of Coding in Finance·May 7Member-onlyHow to Get Cryptocurrency Prices in Excel — Codeless ApproachOn June 5th 2019, Microsoft released a new feature to Office 365 that allows Excel users to pull real-time stock prices into their spreadsheets. In this article, we are going to look at the way to pull cryptocurrency prices in Microsoft Excel. This can be done just by using an…Excel7 min read
Published in The Handbook of Coding in Finance·Mar 26Member-onlyBuilding a Simple Trading Strategy in Python — Trend FollowingTrading strategy is essential in any investment. Python offers us a fantastic opportunity to test and implement our trading idea based on historical data and observe the result. This helps us to evaluate the feasibility of our trading strategy before we adopt it in the real market. In this article…Python5 min read
Published in The Handbook of Coding in Finance·Feb 13Member-onlyHow to Build a Real-time Stock Alert Messaging System in PythonA stock alert messaging tool can be valuable for us to keep up to date with the most recent changes of the stock market and enable us to make a prompt trading decision. …Python8 min read
Published in The Handbook of Coding in Finance·Feb 8Member-onlyHow to use Python to Generate Stock Report from ExcelXlwings is an especially useful Python library that enables us to directly control Excel via Python script. Through xlwings, we can make use of Python as a backend analytic engine and render the result in Excel. This can result in many interesting use cases in financial analysis. In this article…Python4 min read
Published in The Handbook of Coding in Finance·Feb 5Member-onlyHow to use Python to Create Financial Chart in ExcelBoth Python and Excel are useful tools in financial data analysis and visualization. Xlwings, on another hand, offers us the best of both worlds by integrating Python analysis and visualization features with Excel. …Python5 min read
Published in DS Notes·Jan 1Member-onlyLearning Pandas in Minutes (Part 4— Introducing Most Frequently Used Statistical Methods)As a software library for data analysis, Pandas offers a lot of useful statistical methods that permit us to gain statistical info from our dataset with only a one-liner code. All these statistical methods are very intuitive and can work seamlessly with Pandas Dataframe. In this article, I will demonstrate…Python5 min read
Published in DS Notes·Dec 26, 2021Member-onlyLearning Pandas in Minutes (Part 3 — Apply Function to Columns)Pandas allows us to apply our custom Python function to one or more columns. This can be particularly useful whenever we need to transform our data or engineer new features from the existing columns. In this tutorial, I am going to cover two main approaches to apply a function on…Python5 min read
