Skip to content

Instantly share code, notes, and snippets.

View jilleb's full-sized avatar
🚀
Create the future

Chillout jilleb

🚀
Create the future
  • the Netherlands
View GitHub Profile
@jilleb
jilleb / excel_compare_output_csv.py
Created July 24, 2023 14:59
Compare a column of 1 excel file with another column in an excel file and write the contents to a .csv
import pandas as pd
import argparse
def compare_excels(excel_file1, column_index1, excel_file2, column_index2, output_file):
try:
# Read the Excel files into pandas DataFrames
df1 = pd.read_excel(excel_file1)
df2 = pd.read_excel(excel_file2)
# Extract the values from the specified columns in Excel 1 and Excel 2
@jilleb
jilleb / excel_compare.py
Created July 24, 2023 14:32
Compare columns of 2 Excel files.
import pandas as pd
import argparse
def compare_excels(excel_file1, column_index1, excel_file2, column_index2):
try:
# Read the Excel files into pandas DataFrames
df1 = pd.read_excel(excel_file1)
df2 = pd.read_excel(excel_file2)
@jilleb
jilleb / crc32adlatus.py
Created December 16, 2021 11:01
CRC32_ADLATUS calculator
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# ---------------------------------------------------------------------------
# Created By : Jille
# This is meant specifically for calculating CRC32_ADLATUS for a file
import sys
import crcmod
import argparse
@jilleb
jilleb / ambientcolors.VCPScript
Created November 7, 2021 18:40
VCPscript for ambient color palettes
begin
ConnectToEcuUDS('09') ;
IF ISCONNECTEDTOECU THEN
BEGIN
WRITELN('CONNECTED') ;
if dologin(31347) then writeln ('login OK') else writeln ('login nok') ;
WRITELN('Writing Ambient color list');
if WriteDataByID(2600,'201923fffffffcff5d7dfc000ec434228c688ad8e8235b5429bdab3998f5') then writeln('adaptation 1 ok') else writeln('adaptation nok') ;
WRITELN('Writing LIN Ambient color list');
@jilleb
jilleb / gist:a94b30868f1e1933319415ebb8f5632d
Last active February 28, 2021 22:59
010 editor coloring
// This code will give each byte (or short or long) a color, which represents the value.
// 010 editor will display a color in the hex view, which can help to identify
// some logical structure inside a binary file.
local int i;
local int color=0;
while (!FEof()){
FSeek(i);
if (size == 0){