Petr Vankat VankatPetr

## ExcelCompare.py
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

## DynamicSQL.ipynb

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                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.
      
          Viewer requires iframe.
	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