top of page
The Technical Blog
Apr 25, 20220 min read
Apr 24, 20220 min read
Python - Stock Analysis -Visualize
FUNTERN Associate: Junyu Fang · Description Stock Analysis 02 is based on former Stock Analysis which aims at the visualization of...
Apr 23, 20222 min read
Apr 23, 20220 min read
Apr 22, 20220 min read
Apr 21, 20220 min read
Apr 20, 20220 min read
Apr 19, 20220 min read
Python & SQL - Stock Analysis
Description ‘stock-profile-funtern.csv’ is FUNTERN's stock archive data sample. In this dataset, we have basic information about codes of...
Apr 17, 20221 min read
Apr 17, 20220 min read
Apr 17, 20220 min read
R Studio - Cost Management Analysis Report
Description CostManagement.csv is a database of Funtern’s cloud team’s MS Azure Usage from February 3rd, 2022 to March 15th, 2022...
Apr 8, 20222 min read
Python - Securities Analysis
Let's explore Funtern's master securities data sample. 1. Import the data 2. Conduct descriptive analysis. How many ticker ids are there? ...
Apr 6, 20222 min read
Python - Cost Management Analysis
Refer to the cost analysis data from Funtern's cloud team's MS Azure usage since February. Use Python to do below: Import the data...
Apr 5, 20222 min read
Excel VBA - Multiple If Conditions
Here is an example: When the income < 15,000, the marginal tax rate is 0%. When income is between 15,000 and 50,000 , the marginal tax...
Mar 24, 20222 min read
Excel Multiple IF Conditions - VLOOKUP
When we need to solve some problems that involve in many “IF Conditions” (generally more than 4 “IF Conditions”), it is more convenient...
Mar 12, 20221 min read
Python If Conditions
The case below is a typical “IF conditions”: Write an input function that takes the traffic light as the input. When the light is green,...
Mar 6, 20222 min read
Excel If Conditions
There is a simple example: if the exam mark is greater than or equal to 90, then students can get an A, if the mark is lower than 90,...
Mar 3, 20222 min read
bottom of page