Instructions
pip3 install pandas
python3 merge_csv.py [yourfilename].csv
the output.csv file will have the new columns added to your spreadsheet, and it will be ready for you to edit further.
Windows Instructions
install python 3 visit https://www.python.org/ftp/python/3.8.0/python-3.8.0-amd64-webinstall.exe follow instructions, be sure to allow "pip" to be installed
open git bash or windows command prompt
type:
py --version
pip install pandas
cd spreadsheet_script_IMI/
ls
[lists files in the directory]
py merge_csv.py [input file path].csv
[uses input file name to write local spreadsheet]