Fluttering in the World
For the guide of the tool, please check this link and please use a desktop for a better user experience. Thanks! *The article only provides suggestions. You need to take all responsibility for the investment behavior by yourself. *The data is from The Taiwan Stock Exchange Inc. & Taipei Exchange. and quantmod(R package).The stock mining …
Continue reading “Mining Valuable Company in Taiwan – the Tool”
Nowadays, There’re two major investment strategies in the stock market. One is technical analysis and another one is fundamental analysis. Technical analysis relies on price, volume and different kinds of the index such as KD, MACD, MA, etc. Fundamental analysis is based on the company’s operation performance which can be known from the financial statement …
Continue reading “Mining Valuable Company in Taiwan – the Guide”
Yesterday is Valentine’s day, maybe a normal gift such as a flower, a cake can’t give a surprise to your partner too much nowadays. Because I’m studying Streamlit recently. So, I’m thinking why not do a fun quiz for surprising. Before I show how to create an easy and fun Streamlit quiz website, let me …
Continue reading “Make a Fun Quiz for Your Partner on Valentine’s Day by Streamlit”
In this post, I’ll demonstrate how to set up a virtual environment in python. It’s quite important to set up a virtual environment when you’ve developing different projects. The package and python version may be different according to the practical request. In the virtual environment, you can install what you need and it won’t influence …
The easiest way to prove your skill is to obtain a certification. So, I’ll share the process of how I obtained the certification including preparation, registration and getting the certification. Registration Why do I put the registration before tableau preparation? Because you should register the tableau exam before starting preparation. It can make you start …
Continue reading “Getting a Tableau Certification – Tableau Certified Data Analyst”
As a data scientist or analyst, you must use python to manipulate data quite often. And using the pandas and numpy package is the popular way to do it. However, as a beginner or intermediate level python user, you must be confused about how to get the data from a DataFrame and try to google …
Continue reading “Key Concept of Selecting Data from DataFrame in Python”
The efficiency of data queries influences the user experience extremely. When you’re creating a report by loading the data from the database, you must feel frustrated if it is very slow. I know that feeling and it is the daily life of analytics. In this post, I’ll summarize four simple methods to improve HiveQL efficiency. …
When I was a student, I learned the concept of the p-value. But I didn’t quite understand what is that. In the course material, it said “The p-value is the smallest level of significance at which H0 would be rejected when a specified test procedure is used on a given data set. Once the p-value …
In this post, I’ll show the return of equity of 0050 and 0056 ETF in Taiwan. I’ll use R to wrangle the data and Tableau to visualize the result. Two scenarios are below: Buy in the beggining of a year and sell in the end of a year Buy in the beggining in 2016 and …
We always hear the marriage rate is decreasing in recent years. Is it true? Because I live in Taoyuan city, I’ll use the data from my hometown to verify whether it’s a true phenomenon or not here. First, we need to get the data. Where is the data? We can go to the open data …