ISSS608 2016-17 T1 Assign2 XI QIUYUN
Abstract
We all know that US stock market is one of the biggest markets in the world. In that market, there are many companies, of course, it will have better companies and terrible companies. So we can observe these listed companies from their financial index or fundamental value. Based on these data, analyse these data, find some interesting things and finally we can have some conclusions about US listed companies.
Problem
- What’s the most important or common indicators of a company?
- What’s the correlation between those common indicators?
- How the values of common indicators changed in different years?
- What’s the difference among companies with the same indicators?
- Are there existing some unique companies?
Approaches
Data preparation
Split
Through splitting the original table, I split “indicators” row to columns by every year. Then calculate the number of indicators of every company in each year.
At last, combine these table into a table which have the total number of indicators of each company by year.
Stack
Another change is stacking. After sorting important indicators, I stack years to observe time series variable.
