Humberto BM Junior jrhumberto
jrhumberto
/ servidores_nivel_superior.sql
Created
April 12, 2025 00:01
— 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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 |
jrhumberto
/ api_etl_w_pyspark.ipynb
Created
February 6, 2025 22:16
— forked from calilisantos/api_etl_w_pyspark.ipynb
API ETL with Pyspark
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
jrhumberto
/ postgresql_is_enough.md
Created
January 17, 2025 22:41
— forked from cpursley/postgresql_is_enough.md
Postgres is Enough
jrhumberto
/ gist:e107790ba030f7d9e0dd274ea490c5be
Created
January 16, 2025 22:44
— forked from fernandobarbalho/gist:42606ed603a7f284aef8d117a536c41e
Função para consumo de web-service de despesa do governo do estado de São Paulo
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ####Aqui a função | |
| processa_ws_sp_chamada<- function(ano, | |
| codOrgao = "Detalhado", #Consolidado/Detalhado/<Código> | |
| CodFonte = "Detalhado", #Consolidado/Detalhado/<Código> | |
| CodFuncao="Detalhado", #Consolidado/Detalhado/<Código> | |
| CodGrupo="Todos", #Todos/<Código> | |
| CodModalidade = "Todos")#Todos/<Código> | |
| { | |
| # Carregar o pacote necessário |
jrhumberto
/ apple.R
Created
November 5, 2024 14:15
— forked from moodymudskipper/apple.R
computer use
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| apple_screenshot <- function(file = tempfile(fileext = ".png")) { | |
| cmd <- sprintf("screencapture -xC %s", file) | |
| system(cmd) | |
| invisible(file) | |
| } | |
| apple_keystroke <- function(x) { | |
| cmd <- sprintf( | |
| "osascript -e 'tell application \"System Events\" to keystroke \"%s\"'", | |
| x |
jrhumberto
/ free-database-hosting.md
Created
November 5, 2024 00:51
— forked from bmaupin/free-database-hosting.md
Free database hosting
See also:
| Service | Type | Storage | Limitations |
|---|---|---|---|
| Amazon DynamoDB | 25 GB | ||
| Amazon RDS | |||
| Azure SQL Database | MS SQL Server | ||
| 👉 Clever Cloud | PostgreSQL, MySQL, MongoDB, Redis | 256 MB (PostgreSQL) | Max 5 connections (PostgreSQL) |
jrhumberto
/ gradientaccumulation-for-continual-pretraining.ipynb
Created
August 18, 2024 08:34
— forked from Arunprakash-A/gradientaccumulation-for-continual-pretraining.ipynb
GradientAccumulation-for-continual-pretraining.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
jrhumberto
/ calcula_numeros_indices_componentes_ipca.r
Created
August 8, 2024 11:17
— forked from fernandobarbalho/calcula_numeros_indices_componentes_ipca.r
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(ipeadatar) | |
| library(tidyverse) | |
| library(readxl) | |
| series_disponiveis<- | |
| ipeadatar::available_series() | |
| codigos<- | |
| ((series_disponiveis %>% |
jrhumberto
/ cloud-access-to-hdf5.ipynb
Created
August 5, 2024 04:07
— forked from ajelenak/cloud-access-to-hdf5.ipynb
Access HDF5 Files in S3
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
jrhumberto
/ Github 2FA to Brazil via SMS.md
Created
March 13, 2024 04:15
— forked from fdaciuk/Github 2FA to Brazil via SMS.md
The Github doesn't provide country code for Brazil (+55). To add this option, just run the code below in your console. The option Brazil +55 will be the first on the list, already selected:
🇧🇷 [pt-BR]
NewerOlder