Skip to content

Instantly share code, notes, and snippets.

@jeanbaptisteb

jeanbaptisteb/ISCO_08_to_ISEI.py

Last active December 3, 2024 20:24
Show Gist options
  • Save jeanbaptisteb/80d08dee798518b9563ccaf3ee08e5b8 to your computer and use it in GitHub Desktop.
Save jeanbaptisteb/80d08dee798518b9563ccaf3ee08e5b8 to your computer and use it in GitHub Desktop.
Download ZIP
Python dictionary to convert ISCO-08 codes to International Socio-Economic Index of occupational status (ISEI) values.
Raw
ISCO_08_to_ISEI.py
'''
Python dictionaries to convert ISCO-08 occupation codes to International Socio-Economic Index of occupational status (ISEI) values.
'isco_08_to_isei' is adapted from isqoisei08.sps from H. Ganzeboom's website.
'isco_08_to_isei_PISA' is an amended version of isco_08_to_isei, based on PISA 2018 technical report,
with 3 additional pseudo ISCO codes for stay-at-home people (9701), students (9702), and retired or unemployed people (9703).
References:
* “International Stratification and Mobility File: Conversion Tools.” Amsterdam: Department of Social Research Methodology, http://www.harryganzeboom.nl/ismf/index.htm. <Last revised: 2019/10/05> <Consulted on 24th April 2023>.
* OECD. (2018). Chapter 16 : Scaling procedures and construct validation of context questionnaire data. In PISA 2018 Technical Report. OECD Publishing. https://www.oecd.org/pisa/data/pisa2018technicalreport/PISA2018_Technical-Report-Chapter-16-Background-Questionnaires.pdf
'''
isco_08_to_isei = {
"0000":51.25,
"0100":60.92,
"0110":60.92,
"0200":51.63,
"0210":51.63,
"0300":29.18,
"0310":29.18,
"1000":65.12,
"1100":71.72,
"1110":74.5,
"1111":68.77,
"1112":78.76,
"1113":64.98,
"1114":71.29,
"1120":70.34,
"1200":72.94,
"1210":72.24,
"1211":73.38,
"1212":74.79,
"1213":70.57,
"1219":68.54,
"1220":73.71,
"1221":71.39,
"1222":75.25,
"1223":81.92,
"1300":65.25,
"1310":49.48,
"1311":49.48,
"1312":49.48,
"1320":61.57,
"1321":65.42,
"1322":61.57,
"1323":59.89,
"1324":58.07,
"1330":78.86,
"1340":65.01,
"1341":65.01,
"1342":65.01,
"1343":65.01,
"1344":65.01,
"1345":65.01,
"1346":65.01,
"1349":65.01,
"1400":51.01,
"1410":43.85,
"1411":43.85,
"1412":43.85,
"1420":51.56,
"1430":51.01,
"1431":51.01,
"1439":51.01,
"2000":76.24,
"2100":79.49,
"2110":84.16,
"2111":84.61,
"2112":84.61,
"2113":83.5,
"2114":86.81,
"2120":81.78,
"2130":80.46,
"2131":80.46,
"2132":78.17,
"2133":80.46,
"2140":79.05,
"2141":79.05,
"2142":81.4,
"2143":79.05,
"2144":77.1,
"2145":82.31,
"2146":79.31,
"2149":78.69,
"2150":80.75,
"2151":80.78,
"2152":80.75,
"2153":80.75,
"2160":79.74,
"2161":79.74,
"2162":79.74,
"2163":79.74,
"2164":79.74,
"2165":72.96,
"2166":79.74,
"2200":76.98,
"2210":88.7,
"2211":88.7,
"2212":81.92,
"2220":68.7,
"2221":68.7,
"2222":68.7,
"2230":76.98,
"2240":76.98,
"2250":84.14,
"2260":75.43,
"2261":88.31,
"2262":81.13,
"2263":75.43,
"2264":67.94,
"2265":65.23,
"2266":75.43,
"2267":75.43,
"2269":75.43,
"2300":75.54,
"2310":85.41,
"2320":72.3,
"2330":82.41,
"2340":71.45,
"2341":76.49,
"2342":58.77,
"2350":68.88,
"2351":77.88,
"2352":70.89,
"2353":68.88,
"2354":68.88,
"2355":68.88,
"2356":68.88,
"2359":66.42,
"2400":73.91,
"2410":75.5,
"2411":76.65,
"2412":75.5,
"2413":75.5,
"2420":70.09,
"2421":70.09,
"2422":72.94,
"2423":68.55,
"2424":70.09,
"2430":73.91,
"2431":73.91,
"2432":73.91,
"2433":73.91,
"2434":73.91,
"2500":75.13,
"2510":74.66,
"2511":74.66,
"2512":74.66,
"2513":74.66,
"2514":74.66,
"2519":74.7,
"2520":75.13,
"2521":75.13,
"2522":75.13,
"2523":75.13,
"2529":75.13,
"2600":75.67,
"2610":85.13,
"2611":86.72,
"2612":88.96,
"2619":81.05,
"2620":71.55,
"2621":77.19,
"2622":70.4,
"2630":77.24,
"2631":80.92,
"2632":83.09,
"2633":83.81,
"2634":85.85,
"2635":70.5,
"2636":71.55,
"2640":72.83,
"2641":72.83,
"2642":72.83,
"2643":80.92,
"2650":63.31,
"2651":61.82,
"2652":64.44,
"2653":61.82,
"2654":63.31,
"2655":70.1,
"2656":54.0,
"2659":37.59,
"3000":56.03,
"3100":52.4,
"3110":53.6,
"3111":55.03,
"3112":59.35,
"3113":51.92,
"3114":56.38,
"3115":53.77,
"3116":59.45,
"3117":62.79,
"3118":50.73,
"3119":51.35,
"3120":38.18,
"3121":37.83,
"3122":40.54,
"3123":37.83,
"3130":33.66,
"3131":46.73,
"3132":37.22,
"3133":33.66,
"3134":33.66,
"3135":33.66,
"3139":31.46,
"3140":54.86,
"3141":54.86,
"3142":58.05,
"3143":54.86,
"3150":63.29,
"3151":56.41,
"3152":52.7,
"3153":73.71,
"3154":69.24,
"3155":67.04,
"3200":55.4,
"3210":54.92,
"3211":57.04,
"3212":57.37,
"3213":48.66,
"3214":54.92,
"3220":56.98,
"3221":56.0,
"3222":51.93,
"3230":51.57,
"3240":24.79,
"3250":53.15,
"3251":47.83,
"3252":53.15,
"3253":53.15,
"3254":59.85,
"3255":53.15,
"3256":44.92,
"3257":57.25,
"3258":53.15,
"3259":61.91,
"3300":57.64,
"3310":57.13,
"3311":72.27,
"3312":59.76,
"3313":55.25,
"3314":69.76,
"3315":57.68,
"3320":57.97,
"3321":60.29,
"3322":57.03,
"3323":56.35,
"3324":61.18,
"3330":56.64,
"3331":54.62,
"3332":56.64,
"3333":60.44,
"3334":62.39,
"3339":59.89,
"3340":57.99,
"3341":62.13,
"3342":57.99,
"3343":54.55,
"3344":57.99,
"3350":61.6,
"3351":65.64,
"3352":67.11,
"3353":54.27,
"3354":59.18,
"3355":63.03,
"3359":64.4,
"3400":52.57,
"3410":54.35,
"3411":57.0,
"3412":52.72,
"3413":54.54,
"3420":50.9,
"3421":50.9,
"3422":50.9,
"3423":50.9,
"3430":50.15,
"3431":50.15,
"3432":57.64,
"3433":50.15,
"3434":50.15,
"3435":50.15,
"3500":60.93,
"3510":62.45,
"3511":61.07,
"3512":62.45,
"3513":62.45,
"3514":62.45,
"3520":56.5,
"3521":56.57,
"3522":56.5,
"4000":43.51,
"4100":43.33,
"4110":43.33,
"4120":44.94,
"4130":44.87,
"4131":48.27,
"4132":40.56,
"4200":41.22,
"4210":43.06,
"4211":48.1,
"4212":48.82,
"4213":50.05,
"4214":50.05,
"4220":39.02,
"4221":49.3,
"4222":39.02,
"4223":38.58,
"4224":39.02,
"4225":39.02,
"4226":39.02,
"4227":39.02,
"4229":39.02,
"4300":44.08,
"4310":50.57,
"4311":50.37,
"4312":57.38,
"4313":50.57,
"4320":36.1,
"4321":32.5,
"4322":41.63,
"4323":41.27,
"4400":42.3,
"4410":42.3,
"4411":42.3,
"4412":27.52,
"4413":51.77,
"4414":54.67,
"4415":42.3,
"4416":42.3,
"4419":44.72,
"5000":29.32,
"5100":27.57,
"5110":45.46,
"5111":46.76,
"5112":38.44,
"5113":47.42,
"5120":24.53,
"5130":25.04,
"5131":25.04,
"5132":25.04,
"5140":31.08,
"5141":31.08,
"5142":31.08,
"5150":25.46,
"5151":25.2,
"5152":32.2,
"5153":21.82,
"5160":30.59,
"5161":32.75,
"5162":24.07,
"5163":34.25,
"5164":30.59,
"5165":30.59,
"5169":32.75,
"5200":29.73,
"5210":26.64,
"5211":28.84,
"5212":23.53,
"5220":29.47,
"5221":35.34,
"5222":44.14,
"5223":28.48,
"5230":30.9,
"5240":39.04,
"5241":39.73,
"5242":39.04,
"5243":39.04,
"5244":38.88,
"5245":39.04,
"5246":39.04,
"5249":39.04,
"5300":25.09,
"5310":24.98,
"5311":24.98,
"5312":24.98,
"5320":26.64,
"5321":26.64,
"5322":21.64,
"5329":26.64,
"5400":36.86,
"5410":36.86,
"5411":46.38,
"5412":51.5,
"5413":48.13,
"5414":23.8,
"5419":33.83,
"6000":19.2,
"6100":19.41,
"6110":16.34,
"6111":11.56,
"6112":18.95,
"6113":20.91,
"6114":12.87,
"6120":22.21,
"6121":21.13,
"6122":19.83,
"6123":28.04,
"6129":28.04,
"6130":17.79,
"6200":18.29,
"6210":19.78,
"6220":16.33,
"6221":17.0,
"6222":13.35,
"6223":20.69,
"6224":11.01,
"6300":11.01,
"6310":11.01,
"6320":11.01,
"6330":11.01,
"6340":11.01,
"7000":28.53,
"7100":25.39,
"7110":25.94,
"7111":33.76,
"7112":22.57,
"7113":23.96,
"7114":21.96,
"7115":26.62,
"7119":26.92,
"7120":25.26,
"7121":22.16,
"7122":22.75,
"7123":18.02,
"7124":27.81,
"7125":24.09,
"7126":29.16,
"7127":25.26,
"7130":23.63,
"7131":22.77,
"7132":24.49,
"7133":30.47,
"7200":29.81,
"7210":27.61,
"7211":28.03,
"7212":28.52,
"7213":25.51,
"7214":26.6,
"7215":28.6,
"7220":29.84,
"7221":25.63,
"7222":33.16,
"7223":28.7,
"7224":33.9,
"7230":31.15,
"7231":30.78,
"7232":47.74,
"7233":31.72,
"7234":31.15,
"7300":31.0,
"7310":30.35,
"7311":35.7,
"7312":35.66,
"7313":28.12,
"7314":24.43,
"7315":25.78,
"7316":30.14,
"7317":28.95,
"7318":28.97,
"7319":30.35,
"7320":31.5,
"7321":35.33,
"7322":30.49,
"7323":28.24,
"7400":37.34,
"7410":36.97,
"7411":36.35,
"7412":36.92,
"7413":39.45,
"7420":41.68,
"7421":43.76,
"7422":36.92,
"7500":23.97,
"7510":23.46,
"7511":20.95,
"7512":23.57,
"7513":27.3,
"7514":22.79,
"7515":34.12,
"7516":26.96,
"7520":23.65,
"7521":21.81,
"7522":25.23,
"7523":20.78,
"7530":22.03,
"7531":23.47,
"7532":24.88,
"7533":21.24,
"7534":22.25,
"7535":28.08,
"7536":18.07,
"7540":43.19,
"7541":27.3,
"7542":27.3,
"7543":43.19,
"7544":55.96,
"7549":43.19,
"8000":25.45,
"8100":23.41,
"8110":31.44,
"8111":35.07,
"8112":25.11,
"8113":35.82,
"8114":26.13,
"8120":25.91,
"8121":30.32,
"8122":22.36,
"8130":29.3,
"8131":29.14,
"8132":31.34,
"8140":25.49,
"8141":23.09,
"8142":24.85,
"8143":32.67,
"8150":16.8,
"8151":17.85,
"8152":18.03,
"8153":13.24,
"8154":16.08,
"8155":20.35,
"8156":20.35,
"8157":16.8,
"8159":21.2,
"8160":18.13,
"8170":22.4,
"8171":27.25,
"8172":19.08,
"8180":24.15,
"8181":21.13,
"8182":23.19,
"8183":24.15,
"8189":24.16,
"8200":24.93,
"8210":24.93,
"8211":27.91,
"8212":23.88,
"8219":24.68,
"8300":26.8,
"8310":38.8,
"8311":45.76,
"8312":29.8,
"8320":30.11,
"8321":28.48,
"8322":30.34,
"8330":25.71,
"8331":26.85,
"8332":25.95,
"8340":21.08,
"8341":13.34,
"8342":24.45,
"8343":24.8,
"8344":18.08,
"8350":37.92,
"9000":16.5,
"9100":14.64,
"9110":14.64,
"9111":16.38,
"9112":14.21,
"9120":14.57,
"9121":14.82,
"9122":14.57,
"9123":14.57,
"9129":14.57,
"9200":11.87,
"9210":11.74,
"9211":11.74,
"9212":11.74,
"9213":11.74,
"9214":11.74,
"9215":12.01,
"9216":12.34,
"9300":17.53,
"9310":16.39,
"9311":15.35,
"9312":17.56,
"9313":15.35,
"9320":17.55,
"9321":17.55,
"9329":16.36,
"9330":19.66,
"9331":20.27,
"9332":16.89,
"9333":17.69,
"9334":19.66,
"9400":16.5,
"9410":16.5,
"9411":16.5,
"9412":16.5,
"9500":23.43,
"9510":13.72,
"9520":25.2,
"9600":24.07,
"9610":14.39,
"9611":14.39,
"9612":14.39,
"9613":13.87,
"9620":27.91,
"9621":25.06,
"9622":27.91,
"9623":30.99,
"9624":27.91,
"9629":27.91,
}
#adding pseudo ISCO code used in PISA. Reference: PISA technical report 2018, chapter 16, section "Highest occupational status of parents" p. 12 https://www.oecd.org/pisa/data/pisa2018technicalreport/PISA2018_Technical-Report-Chapter-16-Background-Questionnaires.pdf
isco_08_to_isei_PISA = isco_08_to_isei.copy()
#“Doing housework, bringing up children”
isco_08_to_isei_PISA["9701"] = 17
#“Learning, studying”
isco_08_to_isei_PISA["9702"] = 17
#Retired, pensioner, on unemployment benefits”
isco_08_to_isei_PISA["9703"] = 17
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment