Identify Important Variables and Document Missing Values, Variable Types, Key Values, and Patterns - Githubissues

xyzhang9 / Industry_Pollution

0 stars 0 forks source link

Identify Important Variables and Document Missing Values, Variable Types, Key Values, and Patterns #1

Open xyzhang9 opened 7 months ago

xyzhang9 commented 7 months ago

Goal

Check whether the data is panel
Use the Annual Manufacturing Survey data to
- identify variables on the location of the firm, production, sales, number of employment, pollution, energy and water usage, pollution control device
- Create a table which summarizes the number of missing values, variable type (numerical or character), key values, etc
- Make plots show some patterns in the data

Chui99 commented 6 months ago

Summary of missing values

Clarifications

One of the tables with suffix "total" collates all the data from 1998 to 2014 simply by adding them up and without other processing, such as combining data from the same company.
The table with suffix "annual" collates data from each year.
The 5 "key value" variables are in the form of "value (number of occurrences)".

Tables You can find the tables mentions above here. Codes You can find the R scripts here.