Skip to content

Instantly share code, notes, and snippets.

View disouzam's full-sized avatar
🚲

Dickson Souza disouzam

🚲
View GitHub Profile
@disouzam
disouzam / servidores_nivel_superior.sql
Created April 11, 2025 18:03 — forked from fernandobarbalho/servidores_nivel_superior.sql
Busca a proporção de servidores com nível superior para os municípios brasileiros usando dados da RAIS
# Os dados estão presentes no repositório big query da base dos dados
SELECT id_municipio,
count(*) as quantidade_nivel_superior,
( select count(*)
from `basedosdados.br_me_rais.microdados_vinculos` vinc_sub
where vinc_sub.id_municipio = vinc.id_municipio and
ano = 2023 and
vinculo_ativo_3112 ="1" and
natureza_juridica = "1244") as total_servidores_municipio, #1244= município
from collections import defaultdict
from graphlib import TopologicalSorter
from heapq import heappush, heappop, heapify
def topo_lex(pairs):
deps = defaultdict(set) # node -> set(dependencies)
for a, b in pairs:
deps.setdefault(a, set())
deps[b].add(a)
@disouzam
disouzam / bash_strict_mode.md
Created December 11, 2025 10:41 — forked from mohanpedala/bash_strict_mode.md
set -e, -u, -o, -x pipefail explanation