Skip to content

Instantly share code, notes, and snippets.

View fcojperez's full-sized avatar

Francisco Perez fcojperez

2 followers · 14 following
View GitHub Profile
@fcojperez
fcojperez / generatingDictionaryFromDF.py
Created September 20, 2017 21:37
Generating a dictionary from DataFrame string dictionary key column with values key joined by token and DataFrame string value column
##################################
# Script for generating a Dictionary splitting DataFrame values
##################################
# Programador: Francisco Perez
# Date: 9/20/2017 (MM/DD/YYYY)
# Mail: fcojperez@gmail.com
import pandas as pd
@fcojperez
fcojperez / stopScreenSaver.vbs
Created September 15, 2017 12:34
A visual basic script for stopping screen saver because you cannot manage screen saver options due a Directory Active policy
'***********************************************************
'Script for sending inputs and avoiding start screen saver
'***********************************************************
'Developer: Francisco Perez
'mail: fcojperez@gmail.com
'Date: 9/13/2017 (MM/DD/YYYY)
Option Explicit
Dim finishTime
@fcojperez
fcojperez / plusMinus.py
Last active July 3, 2017 18:43
#!/bin/python3
'''
Given an array of integers, calculate which fraction of its elements are positive, which fraction of its elements are negative, and which fraction of its elements are zeroes, respectively. Print the decimal value of each fraction on a new line.
Note: This challenge introduces precision problems. The test cases are scaled to six decimal places, though answers with absolute error of up to are acceptable.
https://www.hackerrank.com/challenges/plus-minus
'''
import sys
@fcojperez
fcojperez / TraceTitleFunction.qvs
Created January 24, 2017 07:41
/*
* Función para Imprimir título en Qlickvies scripts
* 24/01/2017, Francisco Perez, fcojperez@gmail.com
*/
sub TitleTrace(title)
LET vTitle.len = len(title);
LET vLine1 = Repeat('*', $(vTitle.len) + 4);
TRACE $(vLine1);
@fcojperez
fcojperez / Logging.cs
Created December 29, 2016 16:10
namespace Utilites
{
/// <summary>
/// Basic Logging class for tracking execution programas
/// </summary>
/// <remarks>
/// Developer: Francisco Perez
/// Mail: fcojperez@gmail.com
/// Date: 29/12/2016
/// </remarks>
@fcojperez
fcojperez / PROCEDURES_FREE_SPACE.SQL
Created November 10, 2015 17:05
CREATE PROCEDURE getFreeSpaceDrive
@drive varchar(1),
@MB_Free INT OUTPUT
AS
BEGIN
/*
* PROCEDURE FOR GETTING FREE SPACE IN A DRIVE @drive
* RETURN @MB_Free
* FOR TESTING PROCEDURE EXECUTE THESE LINES
* DECLARE @MB INT = 0;
@fcojperez
fcojperez / ConvertDateToEpoch.cs
Created November 3, 2015 12:23
C# how to convert Date to Epoch
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConvertDateTimeEpoch
{
class ConvertDateToEpoch
{
static void Main(string[] args)
@fcojperez
fcojperez / CassandraGettingStarted.cs
Created September 30, 2015 07:54
A proof of concept about how to connect to Cassandra with C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Cassandra;
/*
* 30/09/2015
*
@fcojperez
fcojperez / DateDiff.cs
Created September 28, 2015 09:42
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
/*
* 28/09/2015, Calculo de en milisegundos entre la fecha actual y 1970/01/01
* Francisco Pérez, fcojperez@gmail.com
*/
@fcojperez
fcojperez / random_date.py
Created September 8, 2015 06:04
# Snippet para calcular fechas aleatorias en un periodo definido por los parametros StartDate y EndDate
# 07/09/2015
# Francisco Pérez, fcojperez@gmail.com
import datetime
import random
#Comienzo del periodo el 01/01/2015 a las 0:00
sDate = datetime.datetime(2014,1,1,0,0)
#Fin del periodo el 31/12/2015 a las 23:59