Skip to content

Instantly share code, notes, and snippets.

View miguelvb's full-sized avatar

Miguel Vazquez-Prada miguelvb

View GitHub Profile
@miguelvb
miguelvb / claude script companies merge.md
Created January 8, 2025 15:44
claude script to merge companies

Question

write a python script using pandas dataframes that reads a csv file that contains information on a set of companies and detects duplicates. Once the duplicates are detected you must merge the information of the duplicates in a way that you retain the maximum amount of data. Duplicates are defined by having the same name, country and city fields. For example if two companies are called 'yey' and are in city 'paris' and country 'france' they are considered duplicates and have to be merged. If company 1 has data on its 'url' field and the other does not, we will use for the merge the value of the 'url' field corresponding to the company 1. If both companies have a field that is not empty, choose the field which has more characters in it. Example of csv content: ''' id,name,country,city,data_source,player_address,player_url 1A1B1E3I2L2T2Y_USA_EQZSO2668H,&yet,USA,Richland,crunchbase,140 Gage Blvd Suite 100,http://andyet.com 1E1T1Y_United States_VXYGE2509U,&yet,USA,Richland,dealroom,https://andyet.c

@miguelvb
miguelvb / curso_apnea_safeties.md
Last active March 16, 2023 19:46
curso apnea safeties

Curso Safety FAS (15-03-2022)


( Ver aquí el resumen del curso de jueces (2022) )

Dos organizaciones de competiciones: AIDA - CMAS CMAS << FEDAS

Safety: sin ellos no hay competición, responsables de la seguridad de los competidores mientras compiten. CMAS - indoor :

@miguelvb
miguelvb / digital Physics Chat GPT.md
Created February 26, 2023 21:14
digital Physics, Chat GPT.

what should I start learning about from topic {topic} topic = 'digital physics' If you're interested in learning about digital physics, here are some topics you could start with:

Information theory: Digital physics is based on the idea that the universe is a giant computer, and information is the fundamental building block of the universe. Information theory is the mathematical study of the properties of information, and is an important foundation for digital physics.

Computational complexity theory: Digital physics involves studying the computational complexity of physical systems. This involves analyzing how much computation is required to simulate physical phenomena, and how that computation scales with the size and complexity of the system.

Cellular automata: Cellular automata are simple computational models that operate on a grid of cells, with each cell following a set of rules based on its neighbors. Digital physics often uses cellular automata as a way of modeling physical systems.

@miguelvb
miguelvb / musicana_inspiraciones.md
Last active January 27, 2023 07:52
Musicana> Inspiraciones
@miguelvb
miguelvb / chatGPT_examples_1.md
Last active December 9, 2022 15:29
chatGPT examples

Shrodinger's Cat and Einstein

Question:

make a short screenplay in the style of Monthy pyton about the encounter between schrodinger's cat and Einstein

Answer:

INT. LABORATORY - DAY

We see a large, cluttered laboratory filled with all sorts of scientific equipment and beakers of bubbling liquids. In the center of the room, a large metal box sits on a table.

@miguelvb
miguelvb / music links.md
Last active January 27, 2023 23:00
Music Links
@miguelvb
miguelvb / python_codes_from_GTP3.md
Last active December 5, 2022 12:44
python codes from GTP3
@miguelvb
miguelvb / youtube_dowload_python.py
Created October 18, 2022 07:08
Youtube download python
# TAKEN FROM https://dev.to/stokry/download-youtube-video-to-mp3-with-python-26p
# run first pip3 install youtube_dl in your env...
import youtube_dl
def run():
video_url = input("please enter youtube video url:")
video_info = youtube_dl.YoutubeDL().extract_info(
url = video_url,download=False
)
filename = f"{video_info['title']}.mp3"
@miguelvb
miguelvb / apnea_sevilla_cacharreo.md
Last active September 2, 2022 10:55
Comité cientifico Apnea Sevilla: Cacharreo