Skip to content

Instantly share code, notes, and snippets.

Luis Sevillano LuisSevillano

Block or report user

Report or block LuisSevillano

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@LuisSevillano
LuisSevillano / .block
Last active Aug 19, 2019
New composite border in es-atlas
View .block
border:none
height:696
license:MIT
View autonomous_regions.json
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@LuisSevillano
LuisSevillano / .block
Last active Sep 13, 2019
d3-composite-projections test
View .block
border:none
height:700
@LuisSevillano
LuisSevillano / combineHeaders.R
Last active Aug 8, 2019
A R function to deal with datasets with a double header
View combineHeaders.R
library(tidyverse)
library(ggplot2)
library(janitor)
library(readxl)
filePath <- "data/4247.xlsx"
csv <- read_xlsx(filePath, skip = 6)
# This function fills empty cells with previous values to the right and then combine them with the row above
@LuisSevillano
LuisSevillano / .block
Last active May 23, 2019
Rivers of Spain
View .block
border: none
height: 650
@LuisSevillano
LuisSevillano / query.sql
Created Feb 28, 2019
Add new column in PostgreSQL with a subquery and set a NOT NULL constraint
View query.sql
BEGIN;
ALTER TABLE table1 ADD COLUMN exp_id text;
UPDATE table1
SET exp_id = temp_query.exp_id
FROM (
SELECT t2.exp_id FROM table2 t2 JOIN table1 t1 on t2.gid = t1.gid
) AS temp_query;
@LuisSevillano
LuisSevillano / script.sh
Created Jan 21, 2019
Bash script to process frames and convert then to a video format with ffmpeg
View script.sh
#!/usr/bin/env bash
# https://askubuntu.com/questions/610903/how-can-i-create-a-video-file-from-a-set-of-jpg-images
ffmpeg -framerate 30 -i \
path_to_file_%04d.jpeg \
-c:v libx264 \
-profile:v high \
-crf 18 \
-pix_fmt yuv420p \
output.mp4
@LuisSevillano
LuisSevillano / close.sql
Created Dec 6, 2018
Close all connections from a Postgres database
View close.sql
SELECT *, pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database';
@LuisSevillano
LuisSevillano / catastro_data.csv
Created Jul 12, 2018
Cadastre Data from http://www.sedecatastro.gob.es/. It contains the year of construction of each building in the ciry of A Coruña, Spain
View catastro_data.csv
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
year_int
1985
1986
1996
1994
1996
1997
2000
1992
1996
View google_stock_data.csv
Date Open High Low Close Volume Adj Close
8/19/2014 585.002622 587.342658 584.002627 586.862643 978600 586.862643
8/18/2014 576.11258 584.512631 576.002598 582.162619 1284100 582.162619
8/15/2014 577.862619 579.382595 570.522603 573.482626 1519100 573.482626
8/14/2014 576.182596 577.902645 570.882599 574.652582 985400 574.652582
8/13/2014 567.312567 575.002602 565.752564 574.782577 1439200 574.782577
8/12/2014 564.522567 565.902572 560.882518 562.732562 1542000 562.732562
8/11/2014 569.992585 570.492553 566.002578 567.882551 1214700 567.882551
8/8/2014 563.562536 570.252576 560.352561 568.772565 1494700 568.772565
8/7/2014 568.00257 569.89258 561.102543 563.362525 1110900 563.362525
You can’t perform that action at this time.