Skip to content

Instantly share code, notes, and snippets.

View tiagodavi70's full-sized avatar

Tiago Araújo tiagodavi70

29 followers · 3 following
View GitHub Profile
@tiagodavi70
tiagodavi70 / bairros.json
Last active October 10, 2020 04:05
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@tiagodavi70
tiagodavi70 / dados.csv
Created December 14, 2020 14:15
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 19 columns, instead of 13. in line 2.
Cidade,Data,Precipitação,Pressão Atmosférica ao nível da estação,Pressão Atmosférica máxima,Pressão Atmosférica mínima,Radiação Global,Temperatura do ar - bulbo seco,Temperatura do ponto de orvalho,Temperatura máxima,Temperatura mínima,Temperatura orvalho máxima,Temperatura orvalho mínima,Umidade Relativa máxima,Umidade Relativa mínima,Umidade Relativa do Ar,Direção Horária do Vento,Rajada Máxima de Vento,Velocidade Horária do Vento
Altamira,2019-01-06 00:00:00+00:00,0.28055555555555567,989.9652777777779,990.2743055555558,989.6479166666666,894.125641025641,25.822916666666664,22.869444444444454,26.330555555555556,25.337500000000002,23.331944444444442,22.501388888888897,87.41666666666667,82.00694444444444,84.63194444444444,110.17361111111111,3.6340277777777783,1.0138888888888893
Altamira,2019-01-13 00:00:00+00:00,0.6047619047619048,990.2136904761908,990.4922619047621,989.9273809523814,823.9164835164838,24.428571428571416,22.095833333333314,24.861904761904746,24.01607142857143,22.498214285714283,21.7166666666666
@tiagodavi70
tiagodavi70 / weekly_prices_petrol_diesel.csv
Last active December 23, 2020 14:36
Date Pump price ULSP (p/litre) Diff on previous WEEK ULSP (p/litre) Diff on previous YEAR ULSP (p/litre) Duty rate ULSP (p/litre) VAT (% rate) ULSP Pump price ULSD (p/litre) Diff on previous WEEK ULSD (p/litre) Diff on previous YEAR ULSD (p/litre) Duty rate ULSD (p/litre) VAT (% rate) ULSD
09/06/2003 74.59 45.82 17.50 76.77 45.82 17.50
16/06/2003 74.47 -0.1 45.82 17.50 76.69 -0.1 45.82 17.50
23/06/2003 74.42 0.0 45.82 17.50 76.62 -0.1 45.82 17.50
30/06/2003 74.35 -0.1 45.82 17.50 76.51 -0.1 45.82 17.50
07/07/2003 74.28 -0.1 45.82 17.50 76.46 0.0 45.82 17.50
14/07/2003 74.21 -0.1 45.82 17.50 76.41 0.0 45.82 17.50
21/07/2003 75.07 0.9 45.82 17.50 76.90 0.5 45.82 17.50
28/07/2003 75.10 0.0 45.82 17.50 76.86 0.0 45.82 17.50
04/08/2003 75.12 0.0 45.82 17.50 76.81 0.0 45.82 17.50
@tiagodavi70
tiagodavi70 / wine_cleyton.csv
Created January 17, 2021 21:55
fixed_acidity volatile_acidity citric_acid residual_sugar chlorides free_sulfur_dioxide total_sulfur_dioxide density pH sulphates alcohol quality style
7.4 0.7 0 1.9 0.076 11 34 0.9978 3.51 0.56 9.4 5 red
7.8 0.88 0 2.6 0.098 25 67 0.9968 3.2 0.68 9.8 5 red
7.8 0.76 0.04 2.3 0.092 15 54 0.997 3.26 0.65 9.8 5 red
11.2 0.28 0.56 1.9 0.075 17 60 0.998 3.16 0.58 9.8 6 red
7.4 0.7 0 1.9 0.076 11 34 0.9978 3.51 0.56 9.4 5 red
7.4 0.66 0 1.8 0.075 13 40 0.9978 3.51 0.56 9.4 5 red
7.9 0.6 0.06 1.6 0.069 15 59 0.9964 3.3 0.46 9.4 5 red
7.3 0.65 0 1.2 0.065 15 21 0.9946 3.39 0.47 10 7 red
7.8 0.58 0.02 2 0.073 9 18 0.9968 3.36 0.57 9.5 7 red
@tiagodavi70
tiagodavi70 / catalog.csv
Created March 26, 2021 22:59
id date time continent_code country_name country_code state/province population city/town distance location_description latitude longitude geolocation hazard_type landslide_type landslide_size trigger storm_name injuries fatalities source_name source_link
34 3/2/07 Night NA United States US Virginia 16000 Cherry Hill 3.40765 Unknown 38.6009 -77.2682 (38.600900000000003, -77.268199999999993) Landslide Landslide Small Rain NBC 4 news http://www.nbc4.com/news/11186871/detail.html
42 3/22/07 NA United States US Ohio 17288 New Philadelphia 3.33522 40.5175 -81.4305 (40.517499999999998, -81.430499999999995) Landslide Landslide Small Rain Canton Rep.com http://www.cantonrep.com/index.php?ID=345054&Category=9&subCategoryID=0
56 4/6/07 NA United States US Pennsylvania 15930 Wilkinsburg 2.91977 Urban area 40.4377 -79.916 (40.4377, -79.915999999999997) Landslide Landslide Small Rain The Pittsburgh Channel.com https://web.archive.org/web/20080423132842/http://www.thepittsburghchannel.com/news/11846833/de
@tiagodavi70
tiagodavi70 / wine_sample.csv
Last active May 2, 2021 22:50
We can't make this file beautiful and searchable because it's too large.
id,country,description,designation,points,price,province,region_1,region_2,taster_name,taster_twitter_handle,title,variety,winery
10177,France,"Shows a bit of struck match character on the nose, but nothing that a quick splash decanting won't solve. Once past that, this 50-50 blend of Grenache and Syrah displays a lively mix of herbs and cherries, supple tannins and a long, easygoing finish.",Le Domaine,87,17.0,Rhône Valley,Ventoux,,Joe Czerwinski,@JoeCz,Le Grand Vallat 2009 Le Domaine Red (Ventoux),Rhône-style Red Blend,Le Grand Vallat
41284,Germany,"Representing a bit of a chink in von Kesselstatt's impressive array of 2009s, this wine features slightly restrained notes of pineapple and green apple in a slightly uneasy alliance of sweet and sour. Drink up.",Piesporter Goldtröpfchen Kabinett,86,30.0,Mosel,,,Joe Czerwinski,@JoeCz,Reichsgraf von Kesselstatt 2009 Piesporter Goldtröpfchen Kabinett Riesling (Mosel),Riesling,Reichsgraf von Kesselstatt
23997,Spain,"This five-grape blend is harmonious, with aromas o
@tiagodavi70
tiagodavi70 / geocode.js
Created June 12, 2021 19:16
// address é o endereço na coluna location, geoData é o mapa de Abila (Abila.geojson) carregado com a função d3.json
let extractFename = st => st.split(" ")[st.split(" ").length - 2];
let streetExtent = p => d3.extent([p.FRADDL, p.FRADDR, p.TOADDL, p.TOADDR])
function geocode(address, geoData) {
let isCorner = address.split("/").length > 1;
let coords = [];
if (isCorner) {
@tiagodavi70
tiagodavi70 / blocks_access
Last active September 30, 2021 22:04
conda create --name blocks_scenario
conda activate blocks_scenario
pip install streamlit seaborn numpy pandas pillow altair scikit-learn
streamlit run blocks_mlvis.py
@tiagodavi70
tiagodavi70 / dataset_bio.tsv
Created December 3, 2021 03:00
We can't make this file beautiful and searchable because it's too large.
"NOME" "C01_S4_1" "C02_S5_1" "C03_S6_1" "I01_S1_1" "I02_S2_1" "I03_S3_1"
"ENSMUSG00000000001" 82.8432383442686 84.9002088260196 80.8664436582151 70.9206916033172 68.8805244725524 62.6006763918104
"ENSMUSG00000000028" 7.66591889112366 8.42759570639327 8.91798049586242 9.79733762566968 8.39027177118474 9.75755585558136
"ENSMUSG00000000056" 10.4169040158921 10.808933456664 11.2464290746733 5.17913382963293 5.57760576977128 5.74609503670831
"ENSMUSG00000000078" 62.8510507997901 65.7516049332479 69.3151639538751 48.6043806961205 51.5131460686186 50.7281895300392
"ENSMUSG00000000085" 3.9591803833633 3.73257223259342 3.91717839838259 3.52318912058602 3.58421232236757 3.51552766333079
"ENSMUSG00000000088" 25.8241672691109 20.6091326469676 16.8634583308576 14.0642905969364 14.2161251295217 18.13815035481
"ENSMUSG00000000127" 6.08333906633526 7.20533885411204 7.6865845032139 5.47053124949799 5.12710684221283 5.20795988300157
"ENSMUSG00000000131" 6.14071646924213 5.81562760319105 5.99153136858192 6.3130965235046 6.09383
@tiagodavi70
tiagodavi70 / banco_schema_aula3.sql
Created July 29, 2022 20:52
CREATE DATABASE banco;
USE banco;
CREATE TABLE agencia(
numero VARCHAR(5) NOT NULL PRIMARY KEY
);
CREATE TABLE conta(
numero VARCHAR(7) NOT NULL,
numero_agencia VARCHAR(5),