Juan Quintana jmquintana79

💭

I may be slow to respond.

Caelum certe patet, ibimus illi.

jmquintana79 / clean_memory.py

Created November 20, 2025 07:10

	import gc

	## --> here script content or loop-iteration
	# clean memory
	gc.collect()

jmquintana79 / files_scrapper.py

Last active July 9, 2025 07:43

	import os
	import pandas as pd
	import logging

	def list_files_recursive(folder_input:str, file_format:str = '') -> pd.DataFrame:
	"""Collect a table of files in a given input folder with a selected format

	Arguments:
	folder_input {str} -- Input folder to be analized.

jmquintana79 / choice_continue_or_stop.py

Last active July 28, 2025 11:44

	# pause and allow the selection between continue or stop
	while True:
	answer = input("Would you like to continue (C) or stop (S)? ").strip().lower()
	if answer == 'c':
	print("Continue...")
	break
	elif answer == 's':
	print("Stop.")
	exit()
	else:

jmquintana79 / ratio_of_proportions_with_uncertainty.py

Last active May 21, 2025 10:32

	def ratio_lossed_gained_uncertainty(num_lossed:int,
	num_gained:int,
	alpha:float = 0.01,
	verbose:bool = False) -> tuple[float, float]:
	"""Estimate ratio lossed / gained with statistical uncertainty

	Using confidence interval (CI) estimation for binomal estimation (loss, gain).
	NOTE> In this case lossed is win and gained is loss, that is, ratio = lossed / gained.

	Arguments:

jmquintana79 / append_path.py

Created April 8, 2025 14:09

	## for example, append src folder from a module

	# when this command does not work
	sys.path.append("../")
	# replace by
	src_path = os.path.abspath(os.path.join(os.path.dirname(__file__), '../'))
	sys.path.append(src_path)

jmquintana79 / linear_regression_analysis.py

Last active March 10, 2025 09:18

	import pandas as pd
	import statsmodels.api as sm

	def analysis_lr(df:pd.DataFrame, l_columns_X:list, column_Y:str, alpha:float = .01)->pd.DataFrame:
	# validate arguments
	assert isinstance(df, pd.DataFrame) and len(df) > 0
	for c in l_columns_X + [column_Y]:
	assert c in df.columns.tolist()
	# data preparation
	X = df[l_columns_X]

jmquintana79 / clean.py

Last active March 14, 2025 10:49

	import os
	import shutil

	def clean(path:str = '.')->None:
	"""
	Clean files and folders generated by Python: *.pyc y __pycache__.
	"""
	# initialize folders to be omited
	exclude_dirs = ["venv"]
	# loop of paths

jmquintana79 / create_pivot_table.py

Last active January 20, 2025 08:02

	def create_agg_pivot_table_by_references(df:pd.DataFrame,
	col_values:str,
	col_var_ref_1:str,
	col_var_ref_2:str,
	sagg:str = 'median')->pd.DataFrame:
	"""Create a pivot table by a given references and aggregator

	Arguments:
	df {pd.DataFrame} -- Data to be used.
	col_values {str} -- Name of column values to be used.

jmquintana79 / remove_frozen_values.py

Last active July 23, 2025 12:04

	import pandas as pd
	import numpy as np
	import copy
	import logging

	def counter_consecutive_frozen_values(df:pd.DataFrame, column:str)->pd.DataFrame:
	"""Count consecutive frozen values

	It is added a new column 'counter' with counting values.

jmquintana79 / df_local_to_utc.py

Last active January 8, 2025 13:16

	# validate dt column exits
	assert "dt_local" in df.columns.tolist()
	# make sure is a dt column
	df["dt_local"] = pd.to_datetime(df["dt_local"])
	# set to local time (Europe/Madrid)
	s_local_time = "Europe/Madrid"
	df["local"] = df["dt_local"].dt.tz_localize(s_local_time, ambiguous=True)
	# conversion local to UTC
	df["dt_utc"] = df["local"].dt.tz_convert("UTC")
	# to dt