This Github repository is made for the course project of ECE143 (Group 8). The team members are:
- Yuhao Huang
- Zhiyan Zhu
- Xi Yang
- Yusuf Morsi
- Siddharth Satyam
The presentation slides are available as ECE 143 group 8 submiting version.pdf
Table of Contents
The dataset is obtained from a Quarterly Census of Employment and Wages (OCEW) from the past decade (2004-2021). It can be found here: Quarterly Census of Employment and Wages (OCEW)
The data is structured as:
| Area Type | Area Name | Quarter | Ownership | NAICS Code | Industry Name | Establishments | Average Monthly Employment | 1st Month Emp | 2nd Month Emp | 3rd Month Emp | Total Wages | Average Weekly Wages |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
The Repository has seperate directories for each team member. Each Directory contains Jupyter Notebook Files along with Python files and readme files to describe how they should be run. There is also a master Jupyter Notebook in the parent directory which combines work of all team members. The work is distributed as:
- Yuhao Huang -> Analysis of relationship between employment and wages.
- Zhiyan Zhu -> Analysis of establishments and correlation between establishents, wages and average monthly employment.
- Xi Yang -> Analysis of the ownership’s property
- Yusuf Morsi -> Analysis of average weekly wages & monthly employment, comparision of California vs. counties vs. USA.
- Siddharth Satyam -> Time series Analysis and prediction