Data Statistics

1. Dataset Shape

Rows	Columns
222,642	551

2. Files & Years

year	rows
1991	12272
1993	16296
1995	10904
1997	16263
1999	15349
2001	13601
2003	15214
2005	13917
2007	14041
2011	15425
2013	13583
2017	14765
2019	13677
2021	17232
2023	20103

3. Missing Values

column	missing_count	missing_percent
SITE	222642	100
col_211_211	222119	99.77
col_222_222	219616	98.64
col_216_216	219558	98.61
col_213_213	219316	98.51
col_364_364	219198	98.45
col_365_365	219153	98.43
col_239_239	219153	98.43
QNSHPARG	219105	98.41
col_238_238	218733	98.24
QNOTHH	218188	98
col_271_271	217150	97.53
col_126_126	213511	95.9
RACEORIG	212726	95.55
QNIUDIMP	212548	95.47
col_282_282	212059	95.25
col_136_136	212059	95.25
col_129_129	211854	95.15
col_138_138	211847	95.15
col_284_284	211847	95.15
col_135_135	211792	95.13
col_281_281	211792	95.13
QNSPDRK3	211754	95.11
col_385_385	211717	95.09
col_283_283	211696	95.08

4. Numeric Variables

column	count	mean	std	min	25%	50%	75%	max
year	222642	2007.030569	10.384386	1991	1997	2005	2017	2023
Q1	201865	5.103777	1.243429	1	4	5	6	7
Q7	210300	32.700481	35.218022	1	1	4	63.5	180.99
Q38	211784	1.504944	1.234843	1	1	1	1	7
Q45	203077	2.045323	1.858696	1	1	1	2	8
PSU	220993	227508.118	222704.8756	1	37153	160050	371830	921211

5. Categorical Variables

Q1

value	count
5	51555
6	51323
4	46293
7	30584
3	21452
NaN	20776
1	371
2	287

Q2

value	count
1	93503
2	91077
NaN	38062

Q3

value	count
4	46371
3	46302
1	45831
2	45740
NaN	38121
5	277

Q4

value	count
2	67966
1	41242
NaN	39512
3	28507
6	26343
4	14054
7	2385
8	1647
5	986

Q5

value	count
E	58300
C	19353
4	15900
NaN	12426
3	12027
2	9784
5	9319
1	7803
1.68	5566
B	4964

Q6

value	count
1	24558
NaN	22291
2	8056
4	7989
5	7904
1.68	7686
1.63	7486
1.7	7481
1.73	7044
1.6	6954

Q7

value	count
1	65002
2	23944
3	13398
NaN	9219
54.43	4428
58.97	4389
63.5	3965
68.04	3872
61.24	3613
56.7	3482

Q8

value	count
1	69609
2	58867
NaN	47023
5	20049
4	11023
3	10223
6	5848

Q9

value	count
1	47229
5	45914
2	42503
NaN	40759
4	26813
3	18591
6	833