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

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.