Replace Excel with Python/Pandas to process a csv file

I have an excel file that processes the data pulled in from a cvs file. I want to completely replace excel with python/pandas. The script needs to pull in the csv (I'd like to be able to select the csv using a windows UI file chooser) and using the roughly 47 columns in the csv, create about 26 new custom columns using very simple logic, e.g. if column 7 = "True" then take the value in column 3 otherwise set the custom column to 0. The output would be the sum of the separate custom columns into an output csv, e.g Column 0 = 240, Column 1 = 10, etc.

I've attached the csv to be processed and the excel file that processes the csv. Note: I'm only including the excel file so that you can see the logic for the custom columns.