search

ittshuang / phil-lisa-work

Repo for recording RP work for Phil and Lisa
0 stars 0 forks source link

Matching stats #3

Open ittshuang opened 1 month ago

ittshuang commented 1 month ago

image

ittshuang commented 3 weeks ago

Matching type stats

Matched by SIC2D

At segment-level


  match_type |      Freq.     Percent        Cum.
-------------+-----------------------------------
many-to-many |     14,963       51.25       51.25
 many-to-one |      3,144       10.77       62.02
 one-to-many |      7,389       25.31       87.33
  one-to-one |      3,698       12.67      100.00
-------------+-----------------------------------
       Total |     29,194      100.00

Matched by SIC1D

At segment-level

  match_type |      Freq.     Percent        Cum.
-------------+-----------------------------------
many-to-many |     20,187       61.97       61.97
 many-to-one |      3,184        9.77       71.75
 one-to-many |      6,462       19.84       91.59
  one-to-one |      2,741        8.41      100.00
-------------+-----------------------------------
       Total |     32,574      100.00
ittshuang commented 3 weeks ago

has_match stats

Matched by SIC2D

unique gvkey if has_match==1
Number of unique values of gvkey is  2344
Number of records is  29194

Matched by SIC1D

unique gvkey if has_match==1
Number of unique values of gvkey is  2475
Number of records is  32574
ittshuang commented 3 weeks ago

Matching rate within HH dataset

        has_match  total_gvkey  has_match_proportion
fyear
2001.0         1807.0             2081              0.868333
2002.0         1738.0             1997              0.870305
2003.0         1728.0             1948              0.887064
2004.0         1919.0             2140              0.896729
2005.0         1831.0             2055              0.890998
2006.0         1733.0             1945              0.891003
2007.0         1605.0             1817              0.883324
2008.0         1514.0             1722              0.879210