Petr Vankat VankatPetr

VankatPetr / ExcelCompare.py

Created July 28, 2019 20:57

Compare 2 Excel files and create an Excel diff using Python

	import pandas as pd
	from pathlib import Path

	#define parameters
	#path to files
	path_old=Path(r'C:\Users\owner\Documents\old.xlsx')
	path_new=Path(r'C:\Users\owner\Documents\new.xlsx')
	#list of key column(s)
	key=['id']
	#sheets to read in

VankatPetr / DynamicSQL.ipynb

Created April 13, 2019 12:52

Dynamic SQL using Python

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.