Skip to content

Instantly share code, notes, and snippets.

View rogernogueira's full-sized avatar
💭
Só chamar

Rogério Nogueira rogernogueira

💭
Só chamar
11 followers · 3 following
View GitHub Profile
@rogernogueira
rogernogueira / engajamento_alunos.json
Created June 2, 2026 22:18
engajamento_alunos
This file has been truncated, but you can view the full file.
[
{
"cpf_aluno": "607.578.984-75",
"mes_referencia": "2024-01",
"tickets_suporte": 5,
"nps_score": 4
},
{
"cpf_aluno": "607.578.984-75",
"mes_referencia": "2024-02",
@rogernogueira
rogernogueira / engajanento.json
Created May 27, 2026 00:34
Engajamento
[
{
"cpf_aluno": "424.218.379-53",
"horas_assistidas_mes": 40.9,
"tickets_suporte_abertos": 1,
"nps_score": 6
},
{
"cpf_aluno": "582.530.606-95",
"horas_assistidas_mes": 97.2,
@rogernogueira
rogernogueira / vendas_clientes.csv
Last active May 27, 2026 00:32
vendas_clientes
id_transacao data_transacao cpf_aluno nome_aluno plano_adquirido cep_cobranca valor_brl
TX-50001 2024-10-13 424.218.379-53 Aluno_Tech_1 Básico 30140071 49.9
TX-50002 2024-10-31 582.530.606-95 Aluno_Tech_2 Premium 80010010 99.9
TX-50003 2023-09-02 486.644.831-63 Aluno_Tech_3 Básico 60060440 49.9
TX-50004 2024-02-28 207.625.799-74 Aluno_Tech_4 Premium 04538133 99.9
TX-50005 2024-05-07 396.648.204-38 Aluno_Tech_5 Premium 01001000 99.9
TX-50006 2023-05-10 187.117.841-45 Aluno_Tech_6 Premium 04538133 99.9
TX-50007 2023-03-06 959.932.415-98 Aluno_Tech_7 Premium 30140071 99.9
TX-50008 2023-01-22 721.128.976-40 Aluno_Tech_8 Básico 69010000 49.9
TX-50009 2024-05-14 255.866.595-72 Aluno_Tech_9 Premium 20031050 99.9
@rogernogueira
rogernogueira / pyspark.md
Created April 28, 2026 21:32
Cluster PySpark com Raspberry Pi

Passo a passo — Cluster PySpark com Raspberry Pi

Visão geral da infraestrutura

  • Master: 192.168.0.159
  • Worker1: 192.168.0.160
  • Worker2: 192.168.0.161

Arquitetura adotada:

@rogernogueira
rogernogueira / vendas_cursos_ia.csv
Last active March 17, 2026 22:38
Vendas de Cursos de IA
id_cliente idade sexo data_adesao plano status valor_mensal suporte_tickets feedback_score meses_ativo total_gasto
1 F 2022-11-05 Basico Ativo 49.9 2 6.0 18 898.1999999999999
2 46.0 M 2022-08-15 Gratuito Ativo 0.0 3 8.0 9 0.0
3 32.0 F 2022-12-18 Premium Ativo 99.9 1 9.0 2 199.8
4 60.0 M 2023-05-21 Premium Ativo 99.9 3 6.0 2 199.8
5 25.0 Nao_Informado 2022-10-22 Basico Cancelado 49.9 3 1.0 3 149.7
6 38.0 M 2023-10-25 Gratuito Cancelado 0.0 5 3.0 16 0.0
7 56.0 M 2022-04-30 Premium Ativo 99.9 3 6.0 19 1898.1000000000001
8 36.0 M 2022-01-11 Basico Ativo 49.9 2 8.0 4 199.6
9 40.0 Nao_Informado 2022-06-15 Premium Ativo 99.9 2 10.0 23 2297.7000000000003
@rogernogueira
rogernogueira / celular.csv
Created August 29, 2025 23:13
We can't make this file beautiful and searchable because it's too large.
ID_DELEGACIA;NOME_DEPARTAMENTO;NOME_SECCIONAL;NOME_DELEGACIA;NOME_MUNICIPIO;ANO_BO;NUM_BO;VERSAO;NOME_DEPARTAMENTO_CIRC;NOME_SECCIONAL_CIRC;NOME_DELEGACIA_CIRC;NOME_MUNICIPIO_CIRC;DATA_OCORRENCIA_BO;HORA_OCORRENCIA;DESCRICAO_APRESENTACAO;DATAHORA_REGISTRO_BO;DATA_COMUNICACAO_BO;DATAHORA_IMPRESSAO_BO;DESCR_PERIODO;AUTORIA_BO;FLAG_INTOLERANCIA;TIPO_INTOLERANCIA;FLAG_FLAGRANTE;FLAG_STATUS;DESC_LEI;FLAG_ATO_INFRACIONAL;RUBRICA;DESCR_CONDUTA;DESDOBRAMENTO;CIRCUNSTANCIA;DESCR_TIPOLOCAL;DESCR_SUBTIPOLOCAL;CIDADE;BAIRRO;CEP;LOGRADOURO_VERSAO;LOGRADOURO;NUMERO_LOGRADOURO;LATITUDE;LONGITUDE;CONT_OBJETO;DESCR_MODO_OBJETO;DESCR_TIPO_OBJETO;DESCR_SUBTIPO_OBJETO;DESCR_UNIDADE;QUANTIDADE_OBJETO;MARCA_OBJETO;FLAG_BLOQUEIO;FLAG_DESBLOQUEIO;MES;ANO;;;
900020;DIPOL - DEPTO DE INTELIGENCIA;DELEGACIA ELETRONICA;DELEGACIA ELETRONICA;S.PAULO;2024;AH3021;2;DECAP;DEL.SEC.2º SUL;35º D.P. JABAQUARA;S.PAULO;07/01/2024;18:04:00;Pela Parte Interessada;07/01/2024;07/01/2024;08/01/2024;NULL;D;N;NULL;N;CONSUMADO;Código Penal;N;Roubo (art. 15
@rogernogueira
rogernogueira / housing.csv
Created April 15, 2025 13:06
housing
price area bedrooms bathrooms stories mainroad guestroom basement hotwaterheating airconditioning parking prefarea furnishingstatus
13300000 7420 4 2 3 yes no no no yes 2 yes furnished
12250000 8960 4 4 4 yes no no no yes 3 no furnished
12250000 9960 3 2 2 yes no yes no no 2 yes semi-furnished
12215000 7500 4 2 2 yes no yes no yes 3 yes furnished
11410000 7420 4 1 2 yes yes yes no yes 2 no furnished
10850000 7500 3 3 1 yes no yes no yes 2 yes semi-furnished
10150000 8580 4 3 4 yes no no no yes 2 yes semi-furnished
10150000 16200 5 3 2 yes no no no no 0 no unfurnished
9870000 8100 4 1 2 yes yes yes no yes 2 yes furnished
@rogernogueira
rogernogueira / topama_2018_2021_2022.csv
Created April 8, 2025 00:25
topama_2018_2021_2022
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 20 columns, instead of 13 in line 8.
,UF,IBGE,MUNICÍPIO,ANO,IND_01_ALCANCE_META,IND_02_ALCANCE_META,IND_03_ALCANCE_META,IND_04_ALCANCE_META,IND_05_ALCANCE_META,IND_06_ALCANCE_META,IND_07_ALCANCE_META,IND_08_ALCANCE_META,IND_09_ALCANCE_META,IND_10_ALCANCE_META,IND_11_ALCANCE_META,IND_12_ALCANCE_META,IND_13_ALCANCE_META,IND_14_ALCANCE_META,QTD_METAS
0,PA,150157,Bom Jesus do Tocantins,2018,1.0,1.0,1.0,0.0,0.0,1.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,11.0
1,PA,150175,Brejo Grande do Araguaia,2018,0.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,9.0
2,PA,150293,Dom Eliseu,2018,0.0,1.0,1.0,1.0,0.0,0.0,0.0,1.0,1.0,1.0,0.0,1.0,1.0,1.0,9.0
3,PA,150370,Itupiranga,2018,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,10.0
4,PA,150420,Marabá,2018,1.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,5.0
5,PA,150618,Rondon do Pará,2018,0.0,0.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,0.0,1.0,1.0,1.0,1.0,7.0
6,PA,150715,São Domingos do Araguaia,2018,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,1.0,0.0,1.0,6.0
7,TO,170100,Ananás,2018,0.0,1.0,1.0,0.0,0.0,1.0,1.0,
@rogernogueira
rogernogueira / dengue_2024.csv
Created June 19, 2024 12:19
dengue_2024.csv
We can't make this file beautiful and searchable because it's too large.
TP_NOT,ID_AGRAVO,DT_NOTIFIC,SEM_NOT,NU_ANO,SG_UF_NOT,ID_MUNICIP,ID_REGIONA,ID_UNIDADE,DT_SIN_PRI,SEM_PRI,ANO_NASC,NU_IDADE_N,CS_SEXO,CS_GESTANT,CS_RACA,CS_ESCOL_N,SG_UF,ID_MN_RESI,ID_RG_RESI,ID_PAIS,DT_INVEST,ID_OCUPA_N,FEBRE,MIALGIA,CEFALEIA,EXANTEMA,VOMITO,NAUSEA,DOR_COSTAS,CONJUNTVIT,ARTRITE,ARTRALGIA,PETEQUIA_N,LEUCOPENIA,LACO,DOR_RETRO,DIABETES,HEMATOLOG,HEPATOPAT,RENAL,HIPERTENSA,ACIDO_PEPT,AUTO_IMUNE,DT_CHIK_S1,DT_CHIK_S2,DT_PRNT,RES_CHIKS1,RES_CHIKS2,RESUL_PRNT,DT_SORO,RESUL_SORO,DT_NS1,RESUL_NS1,DT_VIRAL,RESUL_VI_N,DT_PCR,RESUL_PCR_,SOROTIPO,HISTOPA_N,IMUNOH_N,HOSPITALIZ,DT_INTERNA,UF,MUNICIPIO,TPAUTOCTO,COUFINF,COPAISINF,COMUNINF,CLASSI_FIN,CRITERIO,DOENCA_TRA,CLINC_CHIK,EVOLUCAO,DT_OBITO,DT_ENCERRA,ALRM_HIPOT,ALRM_PLAQ,ALRM_VOM,ALRM_SANG,ALRM_HEMAT,ALRM_ABDOM,ALRM_LETAR,ALRM_HEPAT,ALRM_LIQ,DT_ALRM,GRAV_PULSO,GRAV_CONV,GRAV_ENCH,GRAV_INSUF,GRAV_TAQUI,GRAV_EXTRE,GRAV_HIPOT,GRAV_HEMAT,GRAV_MELEN,GRAV_METRO,GRAV_SANG,GRAV_AST,GRAV_MIOC,GRAV_CONSC,GRAV_ORGAO,DT_GRAV,MANI_HEMOR,EPISTAXE,GENGIVO,METRO,PET
@rogernogueira
rogernogueira / dados_topama_2018.csv
Created June 5, 2024 10:37
PQAVS - Dados TOPAMA
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 18 columns, instead of 3 in line 9.
UF,IBGE,MUNICÍPIO,ANO,IND_01_ALCANCE_META,IND_02_ALCANCE_META,IND_03_ALCANCE_META,IND_04_ALCANCE_META,IND_05_ALCANCE_META,IND_06_ALCANCE_META,IND_07_ALCANCE_META,IND_08_ALCANCE_META,IND_09_ALCANCE_META,IND_10_ALCANCE_META,IND_11_ALCANCE_META,IND_12_ALCANCE_META,IND_13_ALCANCE_META,IND_14_ALCANCE_META
PA,150157.0,Bom Jesus do Tocantins,2018,1.0,1.0,1.0,0.0,0.0,1.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0
PA,150175.0,Brejo Grande do Araguaia,2018,0.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0
PA,150293.0,Dom Eliseu,2018,0.0,1.0,1.0,1.0,0.0,0.0,0.0,1.0,1.0,1.0,0.0,1.0,1.0,1.0
PA,150370.0,Itupiranga,2018,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0
PA,150420.0,Marabá,2018,1.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0
PA,150618.0,Rondon do Pará,2018,0.0,0.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,0.0,1.0,1.0,1.0,1.0
PA,150715.0,São Domingos do Araguaia,2018,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,1.0,0.0,1.0
TO,170100.0,Ananás,2018,0.0,1.0,1.0,0.0,0.0,1.0,1.0,1.0,0.0,1.0,0.0,1.0,1.0,1.0
TO,170105.0,An